Anaplan Helps - NHS: Pathology Planning & Hospital Reporting

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. We have 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

  • The Anaplan NHS Pathology Planning & Hospital Reporting model supports hospitals to plan for their pathology services both locally and as part of the new networks. The model also supports hospitals to view their performance in the same way as the NHS Improvement Model Hospital as well as automate the collection of data required for Model Hospital data submissions.

Who Benefits

  • Hospitals, non-profits, support centers, first responders and any other organizations requiring a real-time staffing model

 

 

Business Functions       Finance
Size       7.75 GB
Languages       English
Modules       45
Roles       2
Formulas 255
Reports 24
Complexity Intermediate


Watch this video to get an overview of the Anaplan NHS Pathology Planning & Model Hospital Model. 
Note : The data seen within this application is not real data.

 

1. Model Hospital Metrics.png
The Model Hospital Dashboard provides Key Performance Indicators e.g. Cost per Test, Test per WTE and Pay-Cost per WTE aggregated from bottom-up data enabling drill down into further detail.

 

2. Substantive Staff Model Hospital .png
The rolled up Model Hospital figures can be exported at the touch of a button for easier submission of data to NHSi.

 

3. Activity and Income Forecasting .png
Activity forecasting is applied at test, specialty and customer level for each financial period. The forecast methodology accounts for differences in number of working days between like for like periods.

 

4. Activity Overlay Dashboard.png
Baseline forecasts can be adjusted for planned changes in service, such as the addition of a new customer, using overlays.

 

5. Activity Price List.png
Test level price lists can be imported into the application. Price lists are applied to customers per period to enable mid-year changes.

6. Workforce Forecast.png
The model contains functionality for Workforce & Non-Pay similar to that of Activity

 

7. Landing Page.png
Senior management can access a consolidated view of Income & Expenditure actuals and forecasts at any level of the organisation. The application supports Pathology services and Pathology Networks.

 

Features

Model Hospital
  • View Model Hospital Key Performance Indicators (actual and forecast)
  • View and export data in the format required for data submissions
  • Monthly, quarterly and annual trends
  • Apportion indirect costs and overheads to specialties
  • Functionality to easily remove or add activity and costs to allow for any differences between local hospital and Model Hospital reporting requirement
Consolidated income & expenditure
  • View income and expenditure plans and actuals at specialty level
  • Monthly, quarterly and annual trend analysis
Activity and income
  • Import data from Laboratory Information Management system
  • Statistical based forecasting for each combination of specialty, test and requesting organisation
  • Overlay specific adjustments with a full audit trail
  • Calculate income by assigning prices to activity for each combination of Trust, specialty, test and requesting organisation
  • Differentiate between chargeable and non-chargeable tests
  • Analyse trends of actuals and forecasts in activity and income at any combination of specialty, test and requesting organisation
  • Capture other income sources by organisation and category to allow for a comprehensive view of all income
Workforce
  • Import data from ESR (substantive and bank) and purchase ledger (agency)
  • Position level forecasting
  • Vacancy forecasting
  • Overlay other forecast assumptions with a full audit trail
  • Analyse trends of actuals and forecasts at any combination of Trust, specialty, occupational group, band and position
  • Calculate the cost of forecast WTEs using historical cost per WTE
Procurement
  • Import data from purchase ledger and general ledger
  • Use historic trends in invoice payments and activities to automatically account for accruals and stock
  • Generate forecast reagent and consumables costs using the activity forecast and applying historic unit costs
  • Overlay other non-pay assumptions with a full audit trail
  • Analyse trends of actuals and forecasts at any combination of Trust, specialty and procurement category
Data hub
  • Cleanse and reconcile data imported from ESR, purchase ledger, sales ledger and general ledger
  • Manage prepayments at purchase invoice transaction level
  • Map tests to specialties
0 Kudos

Rate this app:

Rate this article:
(1)
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
COVID-19
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
COVID-19
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
COVID-19
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
COVID-19

App Rating:

Rate this article:
(1)

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
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
Perhaps no industry has experienced the ups and downs of the pandemic as much as higher education. But, even in this environment, there is a way that colleges and universities can be more agile. 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