Question: Please help with Part2B Budget Variances.. Please include formulas on how you got the answer. Thank you! Part 2b: Budget Variances Assume the following were
Part 2b: Budget Variances Assume the following were the actual results for June, calculate the revenue variances for all three meal periods and the cost of sales variance for all three meal periods. Use the formulas discussed in the lectures and show all your work. Use an Excel Worksheet to do so. Revenue Guests Cost of Sales Meal Period Breakfast $150,000 10,000 $22,500 Lunch $56,000 3,500 $11,200 Dinner $186,300 8,100 $52,164 CE English Ged States Foc MacBook Air 546 80 888 $ 4 % 5 & 7 3 8 9 0 E R T Y U D F H J K L
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
