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