Question

In: Accounting

Information need from Case 3 for the year end December 31, 2007 need for this question....

Information need from Case 3 for the year end December 31, 2007 need for this question.

Total sales revenue: $639,111

Food operations sales revenue: $458,602 and Beverage operations sales revenue: $180,509

Average check for food and beverages: $9.59 Average check for food: $6.88 Average check for beverages: $2.71

In the case at the end of Chapter 3, you calculated the average food and beverage check for the 4C Company’s 84-seat restaurant in Year 2004. The restaurant was open for 52 weeks, 6 days a week for lunch, and 5 days a week for dinner. An analysis of sales checks indicated that the average turnover was 1.5 times for lunch and 1.25 times for dinner. Lunch contributes about 45 percent of total sales revenue and dinner, 55 percent. Total beverage sales revenue is 20 percent at lunch and 80 percent at dinner. a. Calculate the average lunch and average dinner checks for food and beverages.

This is how I think you solve the question. Is this correct?

Ave Lunch Check = (45% * $639,111) / (84 seats * 1.5 * 312days) = $7.3158 then of this $7.3158, 20% is from beverage sales and 80% is from food sales therefore:

Average lunch beverage check = $7.3158 * .2 = $1.46

Average lunch food check = $7.3158 * .8 = $5.85

Ave Dinner check = (55% * $639,111) / (84 seats * 1.25 * 260days) = $12.87586 then of this $12.87586, 80% is from beverage sales and 20% is from food sales therefore:

Average dinner beverage check = $12.87586 * .8 = $10.30

Average lunch food check = $12.87586 * .2 = $2.57

Solutions

Expert Solution

The ask is to find following :

  • Average Check for Food at LUNCH
  • Average Check for Food at DINNER
  • Average Check for Beverages at LUNCH
  • Average Check for Beverages at DINNER

To arrive at the above the formula will be as tabulated hereunder :

Total Sales Revenue = 639111 out of which

Lunch Revenue = 45% = 639111*45% = 287600

Dinner Revenue = 55%= 639111*55% = 351511

Working (A)

Total Beverage Revenue split between Lunch and Dinner is 20% and 80% meaning

Beverage Revenue at Lunch = 180509 * 20% = 36102

Beverage Revenue at Dinner = 180509 * 80% = 144407

Working-(B)

Total Revenue from Lunch = Lunch Revenue from Food + Lunch Revenue from Beverage or , 287600 = Lunch Food Rev + 36102 or Lunch Food Rev =  287600 - 36102 = 251498

Working-(C)

Therefore Food Revenue at Dinner = Total Foods Revenue - Food revenue at Lunch = 458602-251498=207104

Working - (D)

Total Lunches = 52 * 6 * 84 * 1.5 = 39312

Total Dinners = 52 * 5 * 84 * 1.25 = 27300

Therefore the desired rates are as hereunder :

Average Check at LUNCH (F&B combined) = (251498+36101)/(39312) = 7.32

Average Check at DINNER (F&B combined) = (207104+144407)/(27300) = 12.88


Related Solutions

Question 1 Bee Clean Corp. has a year-end of December 31. Using the information and the...
Question 1 Bee Clean Corp. has a year-end of December 31. Using the information and the template for journal entries below, prepare the adjusting journal entries required at December 31, 2020 for the following transactions. No explanations are required. 1) On January 1, 2020, the company purchased and recorded a 5 year insurance policy for $10,000 in the Prepaid Insurance Account. 2) The company prepaid and recorded $9,000 for 3 months rent on November 1, 2020 in the Prepaid Rent...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company.     Advertising expense $ 26,000 Direct labor $ 675,900 Depreciation expense—Office equipment 11,700 Income taxes expense 238,500 Depreciation expense—Selling equipment 9,800 Indirect labor 55,700 Depreciation expense—Factory equipment 39,800 Miscellaneous production costs 10,300 Factory supervision 137,000 Office salaries expense 67,000 Factory supplies used 8,200 Raw materials purchases 971,000 Factory utilities 42,000 Rent expense—Office space 21,000 Inventories Rent expense—Selling space 28,600...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company.     Advertising expense $ 29,200 Direct labor $ 694,600 Depreciation expense—Office equipment 11,600 Income taxes expense 295,300 Depreciation expense—Selling equipment 10,300 Indirect labor 57,100 Depreciation expense—Factory equipment 33,400 Miscellaneous production costs 10,500 Factory supervision 126,900 Office salaries expense 62,000 Factory supplies used 9,200 Raw materials purchases 929,000 Factory utilities 40,000 Rent expense—Office space 29,000 Inventories Rent expense—Selling space 27,100...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company. Advertising expense $ 34,600 Direct labor $ 679,900 Depreciation expense—Office equipment 8,300 Income taxes expense 242,200 Depreciation expense—Selling equipment 10,900 Indirect labor 60,000 Depreciation expense—Factory equipment 30,800 Miscellaneous production costs 10,200 Factory supervision 100,300 Office salaries expense 72,000 Factory supplies used 9,000 Raw materials purchases 971,000 Factory utilities 31,000 Rent expense—Office space 21,000 Inventories Rent expense—Selling space 27,600 Raw...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company. Advertising expense $ 32,900 Direct labor $ 677,400 Depreciation expense—Office equipment 11,500 Income taxes expense 257,800 Depreciation expense—Selling equipment 9,900 Indirect labor 56,700 Depreciation expense—Factory equipment 38,500 Miscellaneous production costs 11,300 Factory supervision 131,000 Office salaries expense 68,000 Factory supplies used 8,700 Raw materials purchases 996,000 Factory utilities 43,000 Rent expense—Office space 29,000 Inventories Rent expense—Selling space 26,000 Raw...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company. Advertising expense $ 31,000 Depreciation expense—Office equipment 9,500 Depreciation expense—Selling equipment 11,900 Depreciation expense—Factory equipment 37,150 Factory supervision 103,860 Factory supplies used (indirect materials) 8,600 Factory utilities 34,200 Direct labor 678,000 Indirect labor 61,800 Miscellaneous production costs 8,425 Office salaries expense 69,050 Raw materials purchases (direct) 927,500 Rent expense—Office space 23,800 Rent expense—Selling space 27,000 Rent expense—Factory building 81,600...
    The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance...
    The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company.     Advertising expense $ 25,400 Direct labor $ 671,600 Depreciation expense—Office equipment 8,400 Income taxes expense 286,600 Depreciation expense—Selling equipment 11,000 Indirect labor 55,100 Depreciation expense—Factory equipment 33,400 Miscellaneous production costs 9,900 Factory supervision 133,300 Office salaries expense 72,000 Factory supplies used 7,900 Raw materials purchases 952,000 Factory utilities 38,000 Rent expense—Office space 22,000 Inventories Rent expense—Selling space...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company. Advertising expense $ 29,500 Depreciation expense—Office equipment 8,250 Depreciation expense—Selling equipment 10,900 Depreciation expense—Factory equipment 38,150 Factory supervision 104,460 Factory supplies used 11,350 Factory utilities 35,700 Direct labor 708,000 Indirect labor 64,800 Miscellaneous production costs 8,875 Office salaries expense 67,950 Raw materials purchases* 985,000 Rent expense—Office space 23,800 Rent expense—Selling space 27,000 Rent expense—Factory building 79,600 Maintenance expense—Factory equipment...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company. Advertising expense $ 28,750 Direct labor $ 675,480 Depreciation expense—Office equipment 7,250 Income taxes expense 233,725 Depreciation expense—Selling equipment 8,600 Indirect labor 56,875 Depreciation expense—Factory equipment 33,550 Miscellaneous production costs 8,425 Factory supervision 102,600 Office salaries expense 63,000 Factory supplies used 7,350 Raw materials purchases 925,000 Factory utilities 33,000 Rent expense—Office space 22,000 Inventories Rent expense—Selling space 26,100 Raw...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company. Advertising expense $ 32,700 Direct labor $ 690,400 Depreciation expense—Office equipment 11,500 Income taxes expense 286,200 Depreciation expense—Selling equipment 10,700 Indirect labor 57,500 Depreciation expense—Factory equipment 32,800 Miscellaneous production costs 9,400 Factory supervision 112,700 Office salaries expense 63,000 Factory supplies used 8,300 Raw materials purchases 965,000 Factory utilities 31,000 Rent expense—Office space 20,000 Inventories Rent expense—Selling space 26,800 Raw...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT