Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Good evening, I only need help with Question 2 please. The document is attached. Thank you! MBA 6100 Case Study #2 Wanda's Waffles is preparing
Good evening,
I only need help with Question 2 please. The document is attached.
Thank you!
MBA 6100 Case Study #2 Wanda's Waffles is preparing their 2016 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 300,000 and 400,000 boxes of frozen waffles per month. Question 1: Prepare a flexible budget in Excel for Wanda's Waffles. a) Show the flexible budget based on 300,000 units (boxes) produced. b) Show the flexible budget based on 400,000 units (boxes) produced. c) Show the flexible budget cost formulas for Wanda's Waffles. d) Explain the benefit of flexible budgets and when they should be used. Question 2: The months of January and February are complete, and Wanda's Waffles wants to compare their budget to their actual results. Actual results are shown in the table above. a) Show the flexible budget based on actual units produced for each month. b) Compare actual results to budgeted results (Favorable or Unfavorable) for each month. c) Provide possible explanations for the favorable and unfavorable variances. Was net operating income better or worse than budget? Provide recommendations for Wanda'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 independentlyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started