Case Study
Wendy's Waffles is preparing their 2016 budget. They want to prepare a flexible budget for use each month. They estimate sales will be between 200,000 and 300,000 boxes of frozen pancakes per month.
Question 1: Prepare a flexible budget in Excel for Wendy's Waffles.
Show the flexible budget based on 200,000 units (boxes) produced.
Show the flexible budget based on 300,000 units (boxes) produced.
Show the flexible budget cost formulas for Wendy's Waffles.
Explain the benefit of flexible budgets and when they should be used.
Question 2: The months of January and February are complete, and Wendy's Waffles wants to compare their budget to their actual results.
Show the flexible budget based on actual units produced for each month.
Compare actual results to budgeted results (Favorable or Unfavorable) for each month.
Provide possible explanations for the favorable and unfavorable variances. Was net operating income better or worse than budget? Provide recommendations for Wendy's Waffles.
Calculations and backup should be completed and submitted in Excel. Use proper Income Statement formatting. Analysis can either be typed into cells in Excel (formatted to be easily legible) or typed into a text box in Excel. Students are expected to work independently.