Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Forecasting Sample

    Uploaded by

    Annalyn Peña
    simple forecasting for restaurant

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Forecasting Sample

    Uploaded by

    Annalyn Peña
    12 views8 pages
    simple forecasting for restaurant

    Original Title

    forecasting sample

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    simple forecasting for restaurant

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    12 views8 pages

    Forecasting Sample

    Uploaded by

    Annalyn Peña
    simple forecasting for restaurant

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 8

    Sales Forecast Form 1

    LV FAMILY RESTAURANT
    SALES FORECAST BASED ON PREVIOUS SALES HISTORY
    SALES LAST YEAR SALES FORECAST SUCCEEDING YEAR
    COVERS AVERAGE CHECK
    Turn Over Actual Ave. Check Sales in % % AMT (in
    Month Rate Covers (In Pesos) Pesos Increase Qty. increase Pesos)
    January 0.3 2590 220 569,800
    February 0.5 1900 210 399,000
    March 0.3 2500 195 487,500
    April 0.3 2600 200 520,000
    May 0.4 3520 180 633,600
    June 0.3 2500 170 425,000
    July 0.3 2290 160 366,400
    August 0.3 2455 175 429,625
    September 0.5 4300 175 752,500
    October 0.6 5590 178 995,020
    November 0.8 6150 180 1,107,000
    December 0.9 8270 240 1,984,800
    TOTAL 44,665 8,670,245
    Restaurant Seating Capacity: 100, serving breakfast, lunch and dinner

    Sales Forecast Form 2 - NEW RESTAURANT


    SALES PROJECTION FOR ABS RESTAURANT
    FIRST YEAR OF OPERATIONS

    Month TURNOVER RATE COVERS AVERAGE


    max Projected Full House Projected CHECK

    Projected
    TO x full PROJECTED
    300 x No. house SALES (In
    of days covers (in Pesos) Pesos)
    January 1.5 1.2 9300 11160 250 2,790,000
    February 1.5 1.5 8400 12600 250 3,150,000
    March 1.5 0.6 9300 5580 250 1,395,000
    April 1.5 0.8 9000 7200 250 1,800,000
    May 1.5 0.6 9300 5580 250 1,395,000
    June 1.5 0.4 9000 3600 250 900,000
    July 1.5 0.3 9300 2790 250 697,500
    August 1.5 0.3 9300 2790 250 697,500
    September 1.5 0.6 9000 5400 250 1,350,000
    October 1.5 0.7 9300 6510 250 1,627,500
    November 1.5 0.8 9000 7200 250 1,800,000
    December 1.5 1.5 9300 13950 250 3,487,500
    TOTAL 84,360 21,090,000

    Seating Capacity: 100 Meals Served: Breakfast, Lunch and Dinner

    SALES FORM 3
    SALES VARIANCE REPORT FOR ABS RESTAURANT
    ABS RESTAURANT

    Previous Year Forecast Actual Attainment Sales Variance


    Ave. Ave. Ave.
    Check in Sales in Check in Sales in % Attain- Check in
    pesos Covers Pesos pesos Covers Pesos ment pesos
    January 250 11,160 2,790,000 260 8,500 2,210,000 79 10
    February 250 18,900 4,725,000 280 17,000 4,760,000 101 30
    March 250 5,580 1,395,000 300 5,000 1,500,000 108 50
    April 250 7,200 1,800,000 240 6,500 1,560,000 87 -10
    May 250 5,580 1,395,000 245 5,000 1,225,000 88 -5
    June 250 3,600 900,000 230 3,500 805,000 89 -20
    July 250 2,790 697,500 220 2,850 627,000 90 -30
    August 250 2,790 697,500 200 3,000 600,000 86 -50
    September 250 5,400 1,350,000 250 5,500 1,375,000 102 0
    October 250 6,510 1,627,500 270 7,000 1,890,000 116 20
    November 250 7,200 1,800,000 280 7,000 1,960,000 109 30
    December 250 13,950 3,487,500 300 14,000 4,200,000 120 50
    TOTAL 90,660 22,665,000 84,850 22,712,000
    EEDING YEAR

    SALES (in
    Pesos)
    Sales Variance

    Sales in
    Covers pesos
    -2,660 -580,000
    -1,900 35,000
    -580 105,000
    -700 -240,000
    -580 -170,000
    -100 -95,000
    60 -70,500
    210 -97,500
    100 25,000
    490 262,500
    -200 160,000
    50 712,500
    SALES FIRST YEAR SALES FORECAST SUCCEEDING YEAR
    COVERS AVERAGE CHECK
    Ave. Total F/B
    Total Check (In revenue (In % % AMT (in
    Month Covers Pesos) Pesos) Increase Qty. increase Pesos)
    January 10850 215 2,332,750 40% 15,190 20% 258
    February 13000 220 2,860,000 40% 18,200 20% 264
    March 11500 218 2,507,000 40% 16,100 20% 262
    April 10700 225 2,407,500 15% 12,305 20% 270
    May 10000 222 2,220,000 15% 11,500 20% 266
    June 8000 195 1,560,000 20% 9,600 20% 234
    July 7500 198 1,485,000 20% 9,000 20% 238
    August 6000 195 1,170,000 20% 7,200 20% 234
    September 10800 202 2,181,600 15% 12,420 20% 242
    October 11200 228 2,553,600 15% 12,880 20% 274
    November 12200 235 2,867,000 15% 14,030 20% 282
    December 13500 240 3,240,000 40% 18,900 20% 288
    TOTAL 125,250 27,384,450 157,325
    CCEEDING YEAR

    SALES (in Pesos)


    3,919,020
    4,804,800
    4,218,200
    3,322,350
    3,059,000
    2,246,400
    2,142,000
    1,684,800
    3,005,640
    3,529,120
    3,956,460
    5,443,200
    41,330,990
    XYZ Restaurant

    Previous Year Forecast Actual Attainment


    Ave. Ave.
    Check in Check in % Attain-
    pesos Covers Sales in Pesos pesos Covers Sales in Pesos ment
    January 250 20,250 ₱ 5,062,500.00 250 21,263 ₱ 5,315,750.00 105%
    February 250 30,375 ₱ 7,593,750.00 210 25,200 ₱ 5,292,000.00 70%
    March 250 30,375 ₱ 7,593,750.00 200 11,160 ₱ 2,232,000.00 29%
    April 250 30,375 ₱ 7,593,750.00 205 14,400 ₱ 2,952,000.00 39%
    May 250 30,375 ₱ 7,593,750.00 195 11,160 ₱ 2,176,200.00 29%
    June 250 12,150 ₱ 3,037,500.00 190 7,200 ₱ 1,368,000.00 45%
    July 250 8,100 ₱ 2,025,000.00 198 5,580 ₱ 1,104,840.00 55%
    August 250 8,100 ₱ 2,025,000.00 200 5,580 ₱ 1,116,000.00 55%
    September 250 11,138 ₱ 2,784,500.00 220 10,800 ₱ 2,376,000.00 85%
    October 250 14,175 ₱ 3,543,750.00 225 13,020 ₱ 2,929,500.00 83%
    November 250 14,175 ₱ 3,543,750.00 230 14,400 ₱ 3,312,000.00 93%
    December 250 30,375 ₱ 7,593,750.00 255 27,900 ₱ 7,114,500.00 94%
    TOTAL 239,963 59,990,750 167,663 37,288,790
    Sales Variance
    Ave.
    Check in Sales in
    pesos Covers pesos
    0 1,013 253,250
    -40 -5,175 -2,301,750
    -50 -19,215 -5,361,750
    -45 -15,975 -4,641,750
    -55 -19,215 -5,417,550
    -60 -4,950 -1,669,500
    -52 -2,520 -920,160
    -50 -2,520 -909,000
    -30 -338 -408,500
    -25 -1,155 -614,250
    -20 225 -231,750
    5 -2,475 -479,250
    -72,300 -22,701,960

    You might also like