Food and Beverage Control System
LABORATORY MANUAL
Food and Beverage Control System
Laboratory Activity No. ___
MAKING A SALES FORECAST
Objectives: * To be able to know the future sales of the restaurant * |
Materials to be used: Paper Pen Calculator
Procedures: 1. Read and analyze the stated assumptions. 2. Supply the data needed for the percentage increase for the forecast 2013. 3. To get the forecasted actual covers, multiply the total covers for each month of 2012 to the assumed percentage increase. 4. To get the forecasted average check, multiply the average check for each month of 2012 to the assumed percentage increase. 5. Then, get the sales forecast for 2013 by multiplying the forecasted total covers to the forecasted average check.
Instructions: Make a 2013 sales forecast for KSP Bar and Grill using the following data and assumptions.
KSP Bar and Grill, a food outlet with 200 seating capacity, generated the following revenue in the year 2012. Make a sales forecast for year 2013, working on the following assumptions: 1. There is an expected fifty percent (50%) increase of patronage in the month of February because the food outlet will come out with special promotions on Valentine’s Day (February 14) and Chinese Year (also in the month of February). For November 2013, the projected increase in covers is 40% and 50% by the month of December. 2. With better products, intensive promotions and improved services, 20% increase in covers for 2013 is expected. 3. Because of the upgraded menus, prices will increase by 18% for 2013.
| SALES 2012 | Months | Total Covers | Average Check | Total F&B Revenue | January | 13,020 | P 247.25 | P 3,219,195 | February | 19,500 | P 253 | P 4,933,500 | March | 17,250 | P 250.70 | P 4,324,575 | April | 12,840 | P 258.75 | P 3,322,350 | May | 12,000 | P 255.30 | P 3,063,600 | June | 9,600 | P 224.25 | P 2,152,800 | July | 9,000 | P 227.70 | P 2,049,300 | August | 7,200 |
Food and Beverage Control System
Laboratory Activity No. ___
MAKING A SALES FORECAST
Objectives: * To be able to know the future sales of the restaurant * |
Materials to be used: Paper Pen Calculator
Procedures: 1. Read and analyze the stated assumptions. 2. Supply the data needed for the percentage increase for the forecast 2013. 3. To get the forecasted actual covers, multiply the total covers for each month of 2012 to the assumed percentage increase. 4. To get the forecasted average check, multiply the average check for each month of 2012 to the assumed percentage increase. 5. Then, get the sales forecast for 2013 by multiplying the forecasted total covers to the forecasted average check.
Instructions: Make a 2013 sales forecast for KSP Bar and Grill using the following data and assumptions.
KSP Bar and Grill, a food outlet with 200 seating capacity, generated the following revenue in the year 2012. Make a sales forecast for year 2013, working on the following assumptions: 1. There is an expected fifty percent (50%) increase of patronage in the month of February because the food outlet will come out with special promotions on Valentine’s Day (February 14) and Chinese Year (also in the month of February). For November 2013, the projected increase in covers is 40% and 50% by the month of December. 2. With better products, intensive promotions and improved services, 20% increase in covers for 2013 is expected. 3. Because of the upgraded menus, prices will increase by 18% for 2013.
| SALES 2012 | Months | Total Covers | Average Check | Total F&B Revenue | January | 13,020 | P 247.25 | P 3,219,195 | February | 19,500 | P 253 | P 4,933,500 | March | 17,250 | P 250.70 | P 4,324,575 | April | 12,840 | P 258.75 | P 3,322,350 | May | 12,000 | P 255.30 | P 3,063,600 | June | 9,600 | P 224.25 | P 2,152,800 | July | 9,000 | P 227.70 | P 2,049,300 | August | 7,200 |