Financial Table #2 - Five-Year Operating Forecast Including Restaurant Bar Business and Existing Patio Barbecue Business
BUDGET
YEAR - 4
BUDGET
YEAR - 5
BUDGET
YEAR - 2
BUDGET
YEAR - 3
RESTAURANT PATIO BBQ BUDGET
YEAR - 1
BUDGET
SECOND 6 MO.
BUDGET
FIRST 6 MO.
Bistro and Bar Stays in Restaurant
BISTRO/BAR OPERATIONS - TOTAL BUSINESS
EXISTING BUSINESS
LAST 12 MONTHS NEW BUSINESS TOTAL BUSINESS
2015/2016 2016/2017Existing Existing Bar Business 2012/2013 2013/2014 2014/2015
SALES
FOOD 38,566 98,844 150,696 288,106 333,060 374,192 401,492 422,240
BAR 184,295 4,871 25,159 36,036 250,361 264,739 273,839 280,391 288,763
TOTAL 184,295 43,437 124,003 186,732 538,467 597,799 648,031 681,883 711,003
SALARY & WAGES 72,100 39.1% 18,590 42.8% 92,234 74.4% 110,824 59.3% 293,748 54.6% 296,252 49.6% 301,252 46.5% 307,452 45.1% 314,252 44.2%
COST OF SALES 53,446 29.0% 14,911 34.3% 36,995 29.8% 52,182 27.9% 157,534 29.3% 171,792 28.7% 186,131 28.7% 195,296 28.6% 203,526 28.6%
OPERATING SUPPLIES 4,600 2.5% 975 2.2% 3,025 2.4% 4,500 2.4% 13,100 2.4% 14,475 2.4% 14,975 2.3% 15,275 2.2% 15,625 2.2%
UTILITIES 0.0% 6,000 4.8% 6,000 3.2% 12,000 2.2% 12,600 2.1% 13,230 2.0% 13,900 2.0% 14,600 2.1%
OUTSIDE SERVICE 0.0% 600 0.5% 800 0.4% 1,400 0.3% 1,750 0.3% 1,800 0.3% 1,850 0.3% 1,900 0.3%
INSURANCE 0.0% 150 0.1% 150 0.1% 300 0.1% 330 0.1% 350 0.1% 355 0.1% 370 0.1%
LAUNDRY 3,650 2.0% 775 1.8% 2,200 1.8% 3,100 1.7% 9,725 1.8% 10,925 1.8% 11,325 1.7% 11,525 1.7% 11,725 1.6%
MARKETING/START-UP 0.0% 25,000 20.2% 12,000 6.4% 37,000 6.9% 24,000 4.0% 24,000 3.7% 24,000 3.5% 24,000 3.4%
ALL OTHER/JANITORIAL 925 0.5% 200 0.5% 3,600 2.9% 3,850 2.1% 8,575 1.6% 8,925 1.5% 9,025 1.4% 9,125 1.3% 9,200 1.3%
TOTAL 134,721 73.1% 35,451 81.6% 169,804 136.9% 193,406
103.6% 533,382
99.1% 541,049
90.5% 562,088 86.7% 578,778 84.9% 595,198
83.7%
SURPLUS/(DEFICIT) 49,574 7,986 (45,801) (6,674) 5,085 56,750 85,943 103,105 115,805
LABOR HOURS 3,120 1,040 7,501 8,541 20,202 20,242 20,462 20,562 20,662
PATRONS SERVED 7,193 21,017 31,668 59,878 68,042 74,958 78,962 82,238
REVENUE PER PATRON 6.04 5.90 5.90
5.91
6.08
6.19 6.30
6.40