Question

In: Accounting

Exercise 17-25 Sales Mix and Quantity Variances (LO 17-3) The restaurant at the Hotel Galaxy offers...

Exercise 17-25 Sales Mix and Quantity Variances (LO 17-3)

The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an a la carte option, where diners can order from the menu. The buffet option has a budgeted meal price of $47. The a la carte option has a budgeted average price of $36 for a meal. The restaurant manager expects that 40 percent of its diners will order the buffet option. The buffet option has a budgeted variable cost of $27 and the a la carte option averages $20 per meal in budgeted variable cost. The manager estimates that 2,100 people will order a meal in any month.

For July, the restaurant served a total of 1,900 meals, including 640 buffet options. Total revenues were $30,720 for buffet meals and $49,140 for the a la carte meals.

Required:

a. Compute the activity variance for the restaurant for July. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)

b. Compute the mix and quantity variances for July. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)

Solutions

Expert Solution

1. Activity Variance= Budgeted Sales - Acutual Sales

Budgeted Sales= Buffet sales + La Carte Sales

= Budgetd Buffet price* No. of buffet inner + Budgeted La Carte Price* No of La Carte Dinner

= 47*840 + 36*1260 = 39480 + 45360 = 84840

Actual Sales = Actual Buffer Sales + Actual La Carte Sales

= 30720 +49140 = 79860

Activity Variance = 84840 - 79860 = 4980 (Unfavourable as actual sales are less than budgetted sales)

2. Mix Variance: Budgeted Price *( Revised Budgeted Quantity - Actual Quantity)

Here Revised Budgeted Quantity = Budgeted Quqntity / Total Budgeted Quantity * Total Actual Quantity

For Buffet Dinner = 47 * ( 760 - 640) = 5640 (Unfavourable as actual quantity less than revised budgeted qty.)

For La Carte Dinner= 36* ( 1140- 1260 ) = 4320 (Favouable as actual quantity is more than revised budgeted qty.

Mix Variance = 5640 (U) + 4320 (F) = 1320 (U)

3. Quantity Variance = Budgeted Sales - Revised Budgeted Sales

For Buffet Dineer = 840 - 760 = 80 (Unfavorable as revised budgeted sales less than actual budgeted sales)

For La Carte Dinner = 1260 - 1260 = 0

Quantity Variance = 80 (U) + 0 = 80 (U)


Related Solutions

Exercise 17-25 Sales Mix and Quantity Variances (LO 17-3) The restaurant at the Hotel Galaxy offers...
Exercise 17-25 Sales Mix and Quantity Variances (LO 17-3) The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an a la carte option, where diners can order from the menu. The buffet option has a budgeted meal price of $47. The a la carte option has a budgeted average price of $36 for a meal. The restaurant manager expects that 40 percent of its diners will order the buffet option. The buffet option has...
Exercise 17-26 Sales Mix and Quantity Variances (LO 17-3) Chow-4-Hounds (C4H) makes pet food for sale...
Exercise 17-26 Sales Mix and Quantity Variances (LO 17-3) Chow-4-Hounds (C4H) makes pet food for sale in supermarkets. C4H produces two general types: Branded and Generic. The two differ primarily in the ingredients used. At budget, Branded sells for $14 per case and has a variable cost to produce of $7 per case. Generic sells for a budgeted $11 per case and has a budgeted variable cost to produce of $6 per case. C4H expects to sell 20 percent Branded...
Exercise 17-29 (Algo) Sales Mix and Quantity Variances (LO 17-4) Chow-4-Hounds (C4H) makes pet food for...
Exercise 17-29 (Algo) Sales Mix and Quantity Variances (LO 17-4) Chow-4-Hounds (C4H) makes pet food for sale in supermarkets. C4H produces two general types: Branded and Generic. The two differ primarily in the ingredients used. At budget, Branded sells for $14 per case and has a variable cost to produce of $7 per case. Generic sells for a budgeted $11 per case and has a budgeted variable cost to produce of $6 per case. C4H expects to sell 20 percent...
The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an...
The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an a la carte option, where diners can order from the menu. The buffet option has a budgeted meal price of $44. The a la carte option has a budgeted average price of $33 for a meal. The restaurant manager expects that 40 percent of its diners will order the buffet option. The buffet option has a budgeted variable cost of $24 and the a...
The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an...
The restaurant at the Hotel Galaxy offers two choices for breakfast: an all-you-can-eat buffet and an a la carte option, where diners can order from the menu. The buffet option has a budgeted meal price of $45. The a la carte option has a budgeted average price of $34 for a meal. The restaurant manager expects that 40 percent of its diners will order the buffet option. The buffet option has a budgeted variable cost of $25 and the a...
Problem 17-45 Labor Mix and Yield Variances (LO 17-4) Matthews & Bros. is a local landscape...
Problem 17-45 Labor Mix and Yield Variances (LO 17-4) Matthews & Bros. is a local landscape construction company. In analyzing financial performance, the cost accountant compares actual results with a flexible budget. The standard direct labor rates used in the flexible budget are established each year at the time the annual plan is formulated and held constant for the entire year. The standard direct labor rates in effect for the current fiscal year and the standard hours allowed for the...
TASK 3 - PC 4.3 Calculate sales mix and quantity variances (20 marks) Ghaya LLC a...
TASK 3 - PC 4.3 Calculate sales mix and quantity variances Ghaya LLC a producer of personal hygiene items for medical facilities has the following information relating to its sales: Units Price Actual Product A 14,900 6.20 Actual Product B 7,800 12.10 Actual 22,700 Budgeted Product A 13,000 5.90 Budgeted Product B 7,000 10.50 Budgeted 20,000 Required: Use the Actual and Budgeted Information to answer the following: a)Calculate the Budgeted Product “A” Sales Mix in Percentage b)Calculate the Budgeted Product...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales $ 441,811 $ 292,590 $ 239,828 $ 168,300 $ 127,500 Cost of goods sold 232,292 153,697 128,061 89,366 66,300 Accounts receivable 21,339 17,146 16,428 9,829 8,708
Price ($) Quantity Demanded Quantity Supplied 0 25 0 1 21 1 2 17 3 3...
Price ($) Quantity Demanded Quantity Supplied 0 25 0 1 21 1 2 17 3 3 13 6 4 9 9 5 5 12 6 1 15 7 0 18 Question: Suppose the government sets a price in this market at $2. a. Is this a price floor or a price ceiling? b. Does this create a shortage or surplus? c. What is the difference in quantity demanded at this $2 price relative to the market price? d. What is...
Sales Mix and Quantity Variances Chow-4-Hounds (C4H) makes pet food for sale in supermarkets. C4H produces...
Sales Mix and Quantity Variances Chow-4-Hounds (C4H) makes pet food for sale in supermarkets. C4H produces two general types: Branded and Generic. The two differ primarily in the ingredients used. At budget, Branded sells for $12 per case and has a variable cost to produce $5 per case. Generic sells for a budgeted $9 per case and has a budgeted variable cost to produce $4 per case. C4H expects to sell 30 percent Branded and 70 percent Generic regardless of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT