Ch 9 Flexible budgets Requirement 2: Revise the data in your worksheet to reflec

Question

Ch 9 Flexible budgets

Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: Chapter 9: Applying Excel 3 Data 4 Revenue 5 Cost of ingredients 6 Wages and salaries 7 Utilities 8 Rent 9 Miscellaneous $16.50 q $6.25 q $0.20 q $0.80 q $10,400 $800 + $2,200 $600 + 11 Actual results: 12 Revenue 13 Cost of ingredients 14 Wages and salaries 15 Utilities 16 Rent 17 Miscellaneous 18 $29,930 $11,545 $10,405 $1,210 $2,200 $2,020 meals served 19 Planning budget activity 1,700 20 Actual activity 1,800 meals served 21

Explanation / Answer

Actual Flexible budget Cost of ingredients 11545 11250 Wages and salaries 10405 10400 Utilities 1210 1160 Rent 2200 2200 Miscellaneous 2020 2040 Total expense 27380 27050 Spending variance for total expense = 27380-27050 = 330 U

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---