Centage Case Studies Streamlined Data Entry and Simplified Scenario Planning Saves Time and Adds Value to Decision Makers

Edit This Case Study Record

	Streamlined Data Entry and Simplified Scenario Planning Saves Time and Adds Value to Decision Makers Centage

Streamlined Data Entry and Simplified Scenario Planning Saves Time and Adds Value to Decision Makers

Centage

Technology Category	Analytics & Modeling - Predictive Analytics
Applicable Industries	Healthcare & Hospitals
Applicable Functions	Business Operation
Use Cases	Predictive Replenishment
Services	Training
Challenge	Mountain View Hospital, a healthcare facility in Idaho Falls, Idaho, was facing challenges with its budgeting and forecasting process. The hospital, which has over 1,000 employees and more than 60 departments and cost centers, was using Excel for these processes. However, as the hospital continued to grow, Excel became increasingly difficult to use, especially when adding new acquisitions or modifying projections. Simple modifications posed significant risk of errors due to the necessary changes in formulas and formats. The hospital's expansive budget spreadsheet had grown to over 40 tabs, making it impossible to perform meaningful what-if scenarios or analyze the data in a detailed manner. If the hospital continued to use Excel and continued to grow, it would likely have needed additional staff. Read More
About Customer	Mountain View Hospital is a healthcare facility located in Idaho Falls, Idaho. Founded in 2002, the hospital has grown to encompass a wide array of specialty practices and services in addition to its 43-inpatient-bed hospital. The hospital offers several healthcare services to the region, including an on-site urgent-care service, speech and language therapy, advanced wound care, an infusion center, and a health and fitness academy. The hospital is also actively involved in the community, sponsoring dozens of charities each year with events ranging from summer concerts to toy drives. Recently, Mountain View surpassed the 1,000-employee mark and currently budgets for just over 60 departments and cost centers. Read More
Solution	Mountain View Hospital began evaluating several budgeting and forecasting solutions. They were initially attracted to an industry-specific option, but quickly shifted their interest to Centage after seeing what it had to offer. Centage's clean, user-friendly interface and comprehensive what-if scenario planning would enable the hospital to uncover options and considerations that likely would have gone unnoticed before. Additionally, Centage's robust analytics capabilities would provide the necessary metrics and the ability to mold report presentations to the format that the management team was accustomed to, easing the adoption process. The budget was loaded into the solution along with several prior year actuals, providing immediate value by giving access to variance analyses and reporting capabilities that they weren’t able to capture before. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Applicable Industries

Healthcare & Hospitals

Applicable Functions

Business Operation

Use Cases

Predictive Replenishment

Services

Training

Challenge

Mountain View Hospital, a healthcare facility in Idaho Falls, Idaho, was facing challenges with its budgeting and forecasting process. The hospital, which has over 1,000 employees and more than 60 departments and cost centers, was using Excel for these processes. However, as the hospital continued to grow, Excel became increasingly difficult to use, especially when adding new acquisitions or modifying projections. Simple modifications posed significant risk of errors due to the necessary changes in formulas and formats. The hospital's expansive budget spreadsheet had grown to over 40 tabs, making it impossible to perform meaningful what-if scenarios or analyze the data in a detailed manner. If the hospital continued to use Excel and continued to grow, it would likely have needed additional staff.

About Customer

Mountain View Hospital is a healthcare facility located in Idaho Falls, Idaho. Founded in 2002, the hospital has grown to encompass a wide array of specialty practices and services in addition to its 43-inpatient-bed hospital. The hospital offers several healthcare services to the region, including an on-site urgent-care service, speech and language therapy, advanced wound care, an infusion center, and a health and fitness academy. The hospital is also actively involved in the community, sponsoring dozens of charities each year with events ranging from summer concerts to toy drives. Recently, Mountain View surpassed the 1,000-employee mark and currently budgets for just over 60 departments and cost centers.

Solution

Mountain View Hospital began evaluating several budgeting and forecasting solutions. They were initially attracted to an industry-specific option, but quickly shifted their interest to Centage after seeing what it had to offer. Centage's clean, user-friendly interface and comprehensive what-if scenario planning would enable the hospital to uncover options and considerations that likely would have gone unnoticed before. Additionally, Centage's robust analytics capabilities would provide the necessary metrics and the ability to mold report presentations to the format that the management team was accustomed to, easing the adoption process. The budget was loaded into the solution along with several prior year actuals, providing immediate value by giving access to variance analyses and reporting capabilities that they weren’t able to capture before.

Impact #1	The budgeting and forecasting process at Mountain View Hospital has been streamlined, cutting out a layer of data entry and giving users instant feedback while eliminating the time and error-potential of rekeying the data.
Impact #2	Cost center managers were trained to understand how drivers, sales volume, and the data all interact to create more accurate budget and forecast reports.
Impact #3	The two- to three-day data entry process is now completely eliminated.

Impact #1

The budgeting and forecasting process at Mountain View Hospital has been streamlined, cutting out a layer of data entry and giving users instant feedback while eliminating the time and error-potential of rekeying the data.

Impact #2

Cost center managers were trained to understand how drivers, sales volume, and the data all interact to create more accurate budget and forecast reports.

Impact #3

The two- to three-day data entry process is now completely eliminated.

Benefit #1	The solution saves a complete day’s work each month and is performed in just half an hour.
Benefit #2	The hospital has saved significant time each budgeting season by using the report templates and drivers provided by the solution.

Benefit #1

The solution saves a complete day’s work each month and is performed in just half an hour.

Benefit #2

The hospital has saved significant time each budgeting season by using the report templates and drivers provided by the solution.

Download PDF Version

Overview

Streamlined Data Entry and Simplified Scenario Planning Saves Time and Adds Value to Decision Makers

Operational Impact

Quantitative Benefit