Question: 1 A Chapter 9: Applying Excel B D E 2 3 Data 4 Revenue 5 Cost of ingredients $ 16.50 q $ 6.25 6 Wages
1 A Chapter 9: Applying Excel B D E 2 3 Data 4 Revenue 5 Cost of ingredients $ 16.50 q $ 6.25 6 Wages and salaries $ 10,400 7 Utilities $ 800 + $ 0.20 8 Rent 9 Miscellaneous 10 11 Actual results: 12 Revenue $ 2,200 $ 600 + $ 0.80 q $ 29,350 13 Cost of ingredients $ 11,205 14 Wages and salaries $ 10,555 15 Utilities $ 1,135 16 Rent $ 2,200 17 Miscellaneous $ 2,060 18 19 Planning budget activity 20 Actual activity meals 1,700 served meals 1,800 served b. What is the spending variance for the cost of ingredients? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). Answer is complete but not entirely correct. The amount of the spending variance for the cost of ingredients $ 65 F c. What is spending variance for wages and salaries? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). Answer is complete but not entirely correct. The amount of the spending variance for wages and $ 140 U salaries d. What is spending variance for total expenses? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). Answer is complete but not entirely correct. The amount of the spending variance for total $ 220 U expenses
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
