Budget Monitoring & Variance Analysis in Foodservice Operations

 


Develop the ability to interpret financial data, identify root causes of budget variances, and propose evidence-based, sustainable solutions.
The final version of the assignment will include a variance report with analysis and a memo about your findings to hospital leadership (see format below) about your findings. Follow along with the questions below to work through the assessment of finances  and use the information to write your variance report and memo. Please keep in mind that you are the Director of Foodservice speaking to the Chief Financial Officer of the hospital. Be professional, detailed, and solution-driven in your writing.
Defining the Scenario
You are the Foodservice Manager at Sacred Heart Medical Center, a 250-bed nonprofit hospital in a mid-sized city. You are now six months into the fiscal year, and your department’s actual expenses have exceeded projections by 7%—a significant overage.
The projected mid-year operating budget was $880,000, but your current actual spending is $941,600, creating a $61,600 unfavorable variance. The CFO has asked for a detailed variance analysis report and a proposed corrective action plan by the end of the week.
You must analyze the causes, consider budget-neutral factors, and present an action plan and communication strategy.

Background Information

Below is a listing of the projected and actual costs of foodservice at Sacred Heart over the last 6 months.

Add the following to the table:
● Category Variance - difference between projected and actual cost
● Percent Variance -  the variance divided by the projected cost x 100%

Budget Breakdown (Mid-Year, Projected vs. Actual):

Expense Category Projected (6 months) Actual (6 months) Variance % Variance
Food Costs $270,000 $315,000  
Labor (Wages + OT) $430,000 $442,000  
Supplies & Disposables $75,000 $72,500  
Equipment Repairs $20,000 $30,500  
Utilities $35,000 $35,100  
Training & Development $10,000 $8,500  
TOTAL $880,000 $941,600  

Additional Considerations
As you gather information to explain these variances, you determine the following:
● The hospital implemented new dietary guidelines requiring higher-quality protein options and low-sodium items, leading to increased ingredient costs.
● There was a temporary food supply shortage in Q2 that led to emergency purchases from non-contracted vendors.
● Two major pieces of kitchen equipment broke down, requiring immediate repairs.
● There has been a 10% increase in patient census, leading to increased tray production—but your revenue from foodservices is capped.
● Overtime increased slightly due to unanticipated short-staffing from seasonal illnesses.
● Staff training was under budget because a scheduled team development workshop was postponed.
● Your contract with vendors remained the same and didn’t include a clause for inflation adjustments.
Hints for Success
● Don't just “cut costs”—think about improving efficiency, negotiating better contracts, or restructuring work flows.
● Remember: this is not just a math exercise—it's a leadership scenario.

________________________________________
Writing a Variance Report Analysis

This section describes your findings. It can be a bulleted list but be detailed enough for the reader to understand your ideas. The information will be used to create your final memo.
A. Identify at least three major causes contributing to the budget variance.
● Use the data and context to pinpoint where and why overages occurred.
● Integrate both quantitative and qualitative reasoning.
● Identify at least one budget-neutral item to show you can isolate actual cost drivers.
B. Propose targeted corrective actions for each cause.
● Your actions should address the root issue (not just the symptom).
● Use real-world best practices (e.g., menu engineering, FTE management, contract renegotiation).
● Prioritize sustainable and ethical strategies (e.g., not compromising patient nutrition).

This is the single largest contributor to the unfavorable variance.

Quantitative Reasoning: The overage is $45,000, representing over two-thirds (73%) of the total negative variance.

Qualitative Reasoning (Two-Fold Root Cause):

Mandated Menu Change: The implementation of new dietary guidelines requiring higher-quality protein and low-sodium items permanently increased the base price of core ingredients. This is a structural increase not accounted for in the original budget.

Supply Chain Disruptions: The temporary food supply shortage in Q2 necessitated high-cost, emergency purchases from non-contracted vendors. These spot-market purchases lacked the volume discounts negotiated with primary vendors, significantly inflating the cost of goods sold for that period.

 

2. Root Cause: Equipment Repairs (-$10,500 / -52.50%)

 

Quantitative Reasoning: While a smaller dollar amount, this category exceeded its budget by over 52%, indicating poor forecasting or an unexpected event.

Qualitative Reasoning: The expense was caused by two major, unanticipated equipment breakdowns requiring immediate, non-scheduled repairs. This highlights a likely failure in the preventative maintenance (PM) program. Relying on reactive, emergency repairs is inherently more expensive (e.g., rushed service fees, overtime for repair crews) than planned maintenance.

Sample Answer

 

 

 

 

 

 

 

 

Budget Breakdown and Variance Analysis

 

The table below calculates the Category Variance (difference between Projected and Actual Cost) and the Percent Variance.

Expense CategoryProjected (6 months)Actual (6 months)Category Variance% Variance
Food Costs$270,000$315,000-$45,000-16.67%
Labor (Wages + OT)$430,000$442,000-$12,000-2.79%
Supplies & Disposables$75,000$72,500+$2,500+3.33%
Equipment Repairs$20,000$30,500-$10,500-52.50%
Utilities$35,000$35,100-$100-0.29%
Training & Development$10,000$8,500+$1,500+15.00%
TOTAL$880,000$941,600-$61,600-7.00%

Note: A negative variance indicates an unfavorable variance (actual cost is higher than projected). A positive variance indicates a favorable variance (actual cost is lower than projected).

 

📝 Variance Report Analysis

 

 

A. Major Causes Contributing to the Budget Variance

 

The total unfavorable variance of $61,600 is primarily driven by three critical areas: Food Costs, Equipment Repairs, and Labor.

 

1. Root Cause: Food Costs (-$45,000 / -16.6