Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The General Manager asked for a forecast for the next quarter based on the following information: 8% decrease in the number of covers Food suppliers

The General Manager asked for a forecast for the next quarter based on the following information:

  • 8% decrease in the number of covers
  • Food suppliers raise their prices by 2%
  • Beverage suppliers raise their prices by 1%
  • Increase of food selling prices by 4%
  • Increase of beverage selling prices by 3%
  • 5% decrease in Total Labor (Labor costs are 100% fixed)
  • Operating Expenses are 85% variable

Calculate the forecasted F&B Department's profit for the next quarter

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Quarter Total (October, November, and December) Food & Beverage Actual $ Actual Ratio % Last Year % for the Quarter Last Year $ Ratio for the Budget $ Budget % for the Department Quarter Quarter Operating Expenses Direct Operating Expenses 1,049,970.00 4.58% 1,000,370.00 4.47% 1,005,540.00 4.26% Chinaware, Silverware, Glassware 374,050.00 1.63% 362,330.00 1.62% 368,460.00 1.56% Cleaning & Dishwashing Supplies 567, 130.00 2.47% 545,310.00 2.44% 529,200.00 2.24% Decorations & Flowers 157,500.00 0.69% 143,930.00 0.64% 153,950.00 0.65% Subscriptions (Reservations Platform) 46,010.00 0.20% 43,500.00 0. 19% 46,520.00 0.20% Entertainment in House 145,430.00 0.63% 143,520.00 0.64% 148,360.00 0.63% Food Safety & Hygiene 178,070.00 0.78% 173,380.00 0.78% 183,620.00 0.78% Kitchen Small Wares 133, 110.00 0.58% 128,350.00 0.57% 132,260.00 0.56% Laundry and Dry Cleaning 258,060.00 1.13% 240,830.00 1.08% 244,800.00 1.04% Linen Cleaning 353,810.00 1.54% 345,670.00 1.55% 353, 700.00 1.50% Operating Supplies 435,020.00 1.90% 445, 140.00 1.99% 446,820.00 1.89% Printing Menus and Beverage Lists 147,520.00 0.64% 146,050.00 0.65% 152,500.00 0.65% Uniform Laundry 461,660.00 2.01% 448, 170.00 2.00% 448,350.00 1.90% Total Operating Expenses 4,307,340.00 23.48% 4,166,550.00 24.02% 4,214,080.00 24.15% Total Expenses 18,348,559.00 80.00% 17,346,031.00 77.57% 17,450,896.00 73.90% Departmental Profit (or Loss) 4,587,326.00 20.00% 5,015,534.00 22.43% 6, 164,814.00 26.10%Quarter Total (October, November, and December) Food & Beverage Actual Ratio % Last Year % Budget % for the Department Actual $ for the Quarter Last Year $ Ratio for the Budget $ Quarter Quarter Labor Cost Quattro - Service 1,554,635.00 6.78% 1,574,504.00 7.04% 1,432,623.00 6.07% Quattro - Kitchen 606,050.00 2.64% 592,429.00 2.65% 592,722.00 2.51% Quattro - Stewarding 201,653.00 0.88% 195,716.00 0.88% 199,092.00 0.84% Azzera - Service 887,450.00 3.87% 914, 160.00 4.09% 903,000.00 3.82% Azzera - Kitchen 504,725.00 2.20% 471,362.00 2.11% 470,951.00 1.99% Azzera - Stewarding 163,575.00 0.71% 152,290.00 0.68% 158,024.00 0.67% Inara - Service 1,203, 130.00 5.25% 1, 140,480.00 5.10% 1, 166,386.00 4.94% Inara - Kitchen 513,925.00 2.24% 515,475.00 2.31% 514,965.00 2.18% Inara - Stewarding 124,551.00 0.54% 103,244.00 0.46% 114,610.00 0.49% Wages - Extra staff - Quattro 398,000.00 1.74% 337,656.00 1.51% 329,970.00 1.40% Wages - Extra staff - Azzera 272,715.00 1.19% 226,274.00 1.01% 192,570.00 0.82% Wages - Extra staff - Inara 153,200.00 0.67% 104,286.00 0.47% 90,878.00 0.38% Total Labor Costs 6,583,609.00 35.88% 6,327,876.00 36.48% 6,165,791.00 35.33% Prime Cost 14,041,219.00 76.52% 13,179,481.00 75.98% 13,236,816.00 75.85%December 2021 Quarter Total (October, November, and December) Quattro Actual Last Year Variance to Last Budget Variance to Actual Actual Last Year Variance to Last Budget Variance to Ratio % $ or Amount Year % $ or Amount Budget % $ or Amount Ratio % $ or Amount Year % $ or Amount Budget % Total In-house Customer 6,561 -4.94% 6,723 7.23% 18,021 18,738 -3.83% 19,108 5.69% Total Walk-in Customer 3,800 1.32% 3,825 1.96% 10,300 10,630 3.10% 10,815 4.76% Total Customer 10,361 -3.61% 10,548 -5.32% 28,321 29,368 3.57% 29,923 5.35% Total Average Food Check 402.40 4.83% 121.44 0.09% 414 398.00 3.94% 433.78 4.64% Total Average Beverage Check 74.95 21.66% 79.42 14.80% 83 71.50 15.87% 79.07 4.78% Total Average F&B Check 477.35 7.47% 500.86 2.43% 497 469.50 5.76% 512.85 3.18% Total Food Revenue 82.23% 4, 169,270.00 1.05% 4,445,320.00 5.23% 1,715,560 83.31% 1 1,688,395.00 0.23% 12,285,045.00 4.64% Total Beverage Revenue 17.77% 776,550.00 7.26% 837,760.00 8.70% 2,346,520 16.69% 2,099,925.00 1.74% 2,239,385.00 4.78% Total F&B Revenue 100.00% 4,945,820.00 3.59% 5,283,080.00 -3.02% 14,062,080 100.00% 13,788,320.00 1.99% 14,524,430.00 -3.18%Quarter Total (October, November, and December) Food & Beverage Actual $ Actual Ratio % Last Year % Last Year $ for the Quarter Ratio for the Budget $ Budget % for the Department Quarter Quarter Revenue Mix by Type Food Revenue 18,231,640.00 79.490% 17,991,595.00 80.458% 18,951,085.00 80.248% Beverage Revenue 4,704,245.00 20.510% 4,369,970.00 19.542% 4,664,625.00 19.752% Total Revenue 22,935,885.00 100.000% 22,361,565.00 100.000% 23,615,710.00 100.000% Revenue per Outlet Quattro 14,062,080.00 61.31% 13,788,320.00 61.661% 14,524,430.00 61.503% Azzera 3,593,635.00 15.67% 3,610,055.00 16.144% 3,823, 170.00 16.189% Inara 5,280, 170.00 23.02% 4,963, 190.00 22.195% 5,268, 110.00 22.308% Total Revenue 22,935,885.00 100.00% 22,361,565.00 100.000% 23,615,710.00 100.000% Cost of Sales Food 6,392, 110.00 85.71% 5,802,805.00 84.693% 5,995,020.00 84.783% Beverage 1,065,500.00 14.29% 1,048,800.00 15.307% 1,076,005.00 15.217% Total Cost of Sales 7,457,610.00 100.00% 6,851,605.00 100.000% 7,071,025.00 100.000% Gross Profit 14,915,220.00 100.00% 13,703,210.00 100.000% 14, 142,050.00 100.000%er 2021 Quarter Total (October, November, and December) Azzera Variance to Budget Variance to Actual Actual Last Year Variance to Budget Variance to Last Year % $ or Amount Budget % $ or Amount Ratio % $ or Amount Last Year % $ or Amount Budget % Total In-house Customer -1.83% 4, 125 2.42% 11,675 11,925 -2.10% 12, 125 -3.71% Total Walk-in Customer 4. 17% 245 2.04% 715 695 2.88% 720 -0.690 Total Customer -1.50% 4,370 -2.17% 12,390 12,620 -1.82% 12,845 -3.54% Total Average Food Check 0.95% 215.00 -1.40% 212.33 207.39 2.38% 215.99 -1.69% Total Average Beverage Check 1.27% 80.00 0.00% 77.71 78.67 -1.22% 81.65 -4.82% Total Average F&B Check 1.04% 295.00 -1.02% 290.04 286.06 1.39% 297.64 -2.55% Total Food Revenue 0.56% 939,550.00 -3.54% 2,630,800.00 73.21% 2,617,260.00 0.52% 2,774,395.00 5.18% Total Beverage Revenue -0.25% 349,600.00 -2.17% 962,835.00 26.79% 992,795.00 -3.02% 1,048,775.00 -8.19% Total F&B Revenue -0.48% 1,289, 150.00 -3.17% 3,593,635.00 100.00% 3,610,055.00 -0.45% 3,823, 170.00 -6.00%Quarter Total (October, November, and December) I nara Actual Actual Last Year Variance to Budget Variance to $ or Amount Ratio % $ or Amount Last Year % $ or Amount Budget % Dinner Total Revenue 3,626,095.00 68.67% 3,365,800.00 ' 7.73% 3,563,105.00 ' 1.77% Total Total In-house Customer 18,671 18,717 ' 0.25% 19,649 ' -4.98% Total Walk-in Customer 2,988 2,804 ' 6.56% 2,867 ' 4.22% Total Customer 21,659 21,521 0.64% 22,453 ' 3.54% Total Average Food Check 179.38 149.67 19.86%' 173.32' 3.50% Total Average Beverage Check 64.40 44.11 46.00% ' 61.30 ' 5.06% Total Average F&B Check 243.79 193.78 25.81%' 234.62' 3.91% Total Food Revenue 3,885,280.00 73.58%' 3,685,940.00' 5.41%' 3,891,645.00' 0.16% Total Beverage Revenue 1,394,890.00 26.42% 1,277,250.00' 9.21%' 1,376,465.00' 1.34% Total F&B Revenue 5,280,170.00 100.00% 4,963,190.00' 6.39% 5,268,110.00' 0.23%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Pat Wheeler, Ulric J Gelinas, Richard B Dull

9th Edition

0538469315, 9780538469319

More Books

Students also viewed these Accounting questions

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago

Question

1. What will happen in the future

Answered: 1 week ago