Anaplan Helps - ESCoRT - Emergency Supply Chain Response Tracker

App Hub Terms and Conditions

Please review the App Hub Terms and Conditions prior to installation. The content in this article and App has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation. Please consult your internal administrators prior to applying any of the ideas or steps in this article.

Anaplan understands that many non-profits, government agencies, health care providers, pharmaceutical companies, and academic institutions need a solution to plan against the ever-changing variables that impact their businesses due to the COVID-19 pandemic. Our community of master anaplanners has created some pre-built applications to help you as you work in the Anaplan Platform. This should give you tips and tricks as well as ideas you can apply to your business.

Highlights of App

What is it

    • Health care providers, local, and state governments aren’t competing over resources and bidding up prices unnecessarily
    • Just in time procurement
    • Centrally managed and allocated
    • Ability to backhaul equipment
    • Scenario Planning
    • Top-Down / Bottom Up Reconciliation
    • Daily Plans

This application will consolidate various health care facilities together in a connected planning environment that allows them to centrally manage vital equipment, supplies, and personnel during a widespread health-related emergency.



  • This application was inspired by Governor Phil Murphy of New Jersey and Governor Andrew Cuomo of New York as they described their vision for how health care sites can organize and collaborate with each other on moving reusable inventory during the 2019-2020 Coronavirus COVID-19 pandemic.


    Model Limitations:

    Please be aware this model only contains the scaffolding to enable this process.

    • The statistical modeling required for epidemiology is quite complicated and should be implemented by the intended user of this application. We have introduced a placeholder forecasting method. We have also left the demand curve editable if the user wants to cut/paste their demand forecasts.
    • The top-down planning currently only shows the aggregate demand. The intention is that the aggregate modeling can be applied to reconcile the bottom-up plans.
    The supply chain section is left open (editable). Ideally, logic should be added to determine the product type to determine the type of replenishment that is needed. For example, beds are reusable not consumed. Masks are consumed and need to be replenished.


  • Here’s how it works:

    1. Health care providers log into Anaplan and enter their baselines like the region they serve, the number of beds, etc..
    2. Each provider then goes through a scenario planning exercise to determine the most likely demand in their facility.
    3. The forecasts are then sent to a centralized planning team, presumably the State (or Federal). The bottom-up plans are reconciled and balanced to an aggregate plan.
    Inventory is distributed based on demand. As peak demand diminishes, inventory is then repurposed and sent back to the distribution center for other facilities to use.

Who Benefits

  • Health Care, Local, State, and Federal Government

Model Builders

  • Name : Jared Dolich  @JaredDolich 
  • Title: Principal Consultant
  • Company: Columbus Consulting


  • Name : David Edwards @DavidEdwards 
  • Title: Founder and Principal Consultant
  • Company: David Edwards Consulting


  • Name : Tim Mark @Tim_Mark 
  • Title: Principal Consultant
  • Company: Columbus Consulting


Number of roles

There are four roles:

  • Admin – For modeling and data integration
  • Central Procurement – Top-Down Planning, Allocation
  • Health Care Planner – Scenario Planning and Baseline
  • Health Care HR - Personnel
Size    2 

Base Application is 100-200MB

This does not include the size of the data hub

App Photos:


ESCoRT-Demand Projections.png

ESCoRT-Demand Tracking.png

ESCoRT-Home Page.png

ESCoRT-How It Works2.png

ESCoRT-Inventory Demand.png

ESCoRT-Scenario Planning.png

ESCoRT-Top Down Planning.png


0 Kudos

Rate this app:

Rate this article:

The model downloaded from the 'Get App' not same as screenshots. Please check if the correct model is tagged.

Featured Apps
Anaplan Helps - NHS: Pathology Planning & Hospital Reporting
NHS pathology services in England are provided by 105 hospitals who carry out 1.12 billion tests per year at a cost of £2.2 billion.Under proposals from NHS Improvement, the 105 hospitals will join-u... 
Anaplan App
Anaplan Helps - Planning, Budgeting, & Forecasting for Governments
Local and State government organizations are expected to deliver better outcomes through quality services under tighter budgets and growing complexity. This requires improving the way government orga... 
Anaplan App
Anaplan Helps - Workforce Planning for Support Centers
Using Anaplan’s Erlang functionality, we can create a staffing model to help hospitals, non-profits, and support centers better staff through these uncertain times
Anaplan App
Anaplan Helps - Staffing Model for Health Care Providers & Non-Profits
Headcount is expensive. It comprises as much as 80 percent of annual company expenses, so getting the headcount budget right is important. Anaplan takes the headcount and payroll planning process out... 
Anaplan App

App Rating:

Rate this article:

App Hub Terms and Conditions

Best Practices
In Part 4 of the series, find an example of how to use CloudWorks APIs in a practical situation.  Read Full Article
Dynamic Cell Access (DCA) controls the access levels for line items within modules. It is simple to implement and provides modelers with a flexible way of controlling user inputs. Here are a few...  Read Full Article
Community Blog
As Black History Month comes to a close, we turn to Anaplan’s newly appointed Senior Vice President of Connected Planning Victor Barnes for insight on diversity in the tech industry. Read Full Article
Have you heard about unmoderated testing? More flexible and on-demand, it enables you to give feedback to Anaplan about design prototypes. Some Anaplanners have already tried it out and loved it! Read Full Article
Trending Articles in Community
In Part 4 of the series, find an example of how to use CloudWorks APIs in a practical situation.  Read Full Article
Dynamic Cell Access (DCA) controls the access levels for line items within modules. It is simple to implement and provides modelers with a flexible way of controlling user inputs. Here are a few...  Read Full Article
This article will demonstrate exactly how dynamic version analysis can be accomplished by utilizing a line item subset (LISS). Read Full Article
Learn more about the Copy Branch Workaround for the User Experience. Read Full Article
We have successfully made platform enhancements on Saturday, February 13th, 2021, from 1 p.m. to 5 p.m. PST. You've got some great new features to try out, including order a list by date or time...  Read Full Article