Revise the data in your worksheet to reflect the results for the subsequent peri

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 21

Explanation / Answer

d) Spending variance

Particulars Planned Budget Actual result Variance Units Cost Amount Amount Cost of Ingredients 1,700 6.25 10,625 11,295 - 670 wages and salaries 10,400 10,255 145 utilites 800 1,700 0.20 340 1,180 - 40 Rent 2,200 2,200 0 Miscellaneous 600 1,700 0.80 1,360 2,070 -110 Total Expenses 26,325 27,000 - 675

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.