Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started