Case Study Chapter 9 2022 (3)

School: California College San Diego - Course: ACC 213 - Subject: Accounting

Insert formulas and cell references into the "gold" cells below. Quarter Total (April, May, June) BudgetedActual Sales Quantities (boxes of muesli)915,000910,000 Sales Revenues€ 7,777,500€ 7,689,500 Variable Manufacturing Costs€ 4,986,750€ 4,968,600 Gross Margin€ 2,790,750€ 2,720,900 Variable Selling & Admin€ 183,000€ 182,000 Fixed Direct Labor€ 240,000€ 242,000 Fixed Manufacturing Overhead€ 202,500€ 202,000 Questions: [5] No, the sales manager should not be braggining about the cost of materials for the quarter bec [6] The loss in revenue may be due to lower sales or lower actual prices than assumed in the budg [4] No, the sales manager is not justified in stating that the company did "just fine" because they l [7] The management team should review the unfavorable instances from the activity varianes and where many of the problems occur. Additionally, the sales manager should be held accountable foBudgetedActualFlexible Budget [1] € 0 € 1,000,000 € 2,000,000 € 3,000,000 € 4,000,000 € 5,000,000 € 6,000,000 € 7,000,000 € 8,000,000 € 9,000,000 Flexible Budgeting at Muesli AG

Flexible Budget [1]U/FU/FTotal Variance 910,0005,000 U € 7,735,000(€ 42,500)U(€ 45,500)U(€ 88,000) € 4,959,500(€ 27,250)F€ 9,100U(€ 18,150) € 2,775,500(€ 15,250)U(€ 54,600)U(€ 69,850) € 182,000(€ 1,000)F€ 0 N/A(€ 1,000) € 240,000€ 0 N/A€ 2,000 U€ 2,000 € 202,500€ 0 N/A(€ 500)F(€ 500) Totals:(€ 14,250)U(€ 56,100)U(€ 69,350) cause he exceeded the budget by €27,250. get. The exceed in budget may be due to higher materials costs, which could be due to price or efficiency Activity Variances[2]Revenue & Spending Variances [3]lost €42,500 in revenue. d figure out solutions to make them favorable, as this is most likely or the loss in revenue and overspending.€ 0 € 50,000 € 100,000 € 150,000 € 200,000 € 250,000 € 300,000 Variable Manufacturing CostsVariable Selling & AdminFixed Direct LaborFixe (€ 30,000) (€ 25,000) (€ 20,000) (€ 15,000) (€ 10,000) (€ 5,000) € 0 € 5,000 € 10,000 € 15,000 Budgeting Variances