Revise the data in your worksheet to reflect the results for the subsequent peri
ID: 2416034 • Letter: R
Question
Revise the data in your worksheet to reflect the results for the subsequent period as shown below:
1 Chapter 9: Applying Excel 2 3Data 4Revenue 5Cost of ingredients 6 Wages and salaries 7 Utilities 8 Rent 9 Miscellaneou $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 Miscellaneou 18 $29,330 $11,295 $10,255 $1,180 $2,200 $2,070 1,700 meals served 19 Planning budget activity 1,800 meals served 20 Actual activity 21Explanation / Answer
Answer:
Amount in $
a Activity variance for revneue = SR*Actual activity - SR* Plan activity = 16.50*1800 - 16.50*1700 = 29,700 - 28,050 = 1,650 F b Spending variance for cost of ingredients = SR* Actual Activity - Actual Expenditure = 6.25*1800 - 11,295 = 11,250 - 11,295 = 45 U c Spending variance for wages and salaries = Planned expenditure for actual activity - Actual Expenditure = 10,400 - 10,255 = 10,400 - 10,255 = 145 F d Spending variance for total expenses = Planned expenditure for actual activity - Actual Expenditure = = (6.25*1,800)+10,400+800+(.20*1,800)+2,200+600+(.80*1,800) - =11,295+10,255+1,180+2,200+2,070 = 27,050 - 27,000 = 50 FRelated Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.