Chapter 9 Applying Excel Student Formads R 4 File Home Inse

Chapter 9 Applying Excel Student Formads R ?? 4-; File Home Insert Draw Page Layout Formulas Dsta Review View Help QuickBooks Tel E31 Chapter 9: Applying Excel 3 Data 4 Revenue $1650 q 5 Cost of ingredients 6 Wages and salaries 7 Utilties 8 Rent 56 25 q S800S0.20 q S0 80 q $10,400 S2,200 5600 + Miscelaneous 10 Actual resultrs: 12 Revenue 13 Cost of ingredients 14 Wages and salaries 15 Utlities 16 Rent $27,920 $11, 110 $10,130 1,080 S2 200 Miscellaneous 18 Planning budget activty 1.800 meals served 1,700 meals served 19 20 Actual actmty Enter a formula into 23 Review Problem: Variance Analysis Using a Flexible Budget 22 Enter a formula anto each of the cells marked with a ? beloww Construct a flexible budget performance report and Actual Spending Results VanariceS Fiexible Activity Budge! Varances Budget 0 Meals served 1.800 1,700 Chapter 9 Form Ready Type here to search

Solution

FLEXIBLE BUDGET PERFORMANCE REPORT Actual Results Revenue and spending variances Flexible budget Activity Variances Planing budget Meals served 1700 1700 1800 Revenue 27920 130 U 28050 1650 F 29700 Expenses    Cost of ingredients 11110 485 U 10625 625 F 11250    Wages ans salaries 10130 270 F 10400 0 10400    Utilities 1080 60 F 1140 20 F 1160    Rent 2200 0 2200 0 2200    Miscellaneous Items 2240 280 U 1960 80 F 2040    Total Expenses 26760 26325 27050 Net operating income 1160 565 U 1725 925 U 2650 FLEXIBLE BUDGET Activity 1700 Variable Fixed Per unit Total Revenue 16.5 28050 28050 Costs: Cost of ingredients 6.25 10625 10625 Wages and salaries 10400 10400 Utilities 0.2 340 800 1140 Rent 2200 2200 Miscellaneous 0.8 1360 600 1960 PLANNING BUDGET Activity 1800 Variable Fixed Per unit Total Revenue 16.5 29700 29700 Costs: Cost of ingredients 6.25 11250 11250 Wages and salaries 10400 10400 Utilities 0.2 360 800 1160 Rent 2200 2200 Miscellaneous 0.8 1440 600 2040