financial project

Topics: Expense Pages: 8 (721 words) Published: August 18, 2014
My Project
Sales Projections: Forecasted Weekly Sales Calculation
Food average24.16
Capacity100
MondayTuesdayWednesdayThursdayFridaySaturdaySunday Total Covers Food Check AveBeverage Check Ave (85/15)Total Check Ave Average Weekly Revenue
Capacity 100 100 100 100 100 100 100 X % Full50%60%65%70%80%80%50%
Occupied Seats 50 60 65 70 80 80 50

X Turns 2.5 2.5 2.5 2.5 3.0 3.0 3.0

Total Covers 125 150 163 175 240 240 150 1,243 $24.16 $4.26 $28.42 $35,316 Notes:
This projection is based on occupancy rates once the restaurant is up and running. These rates will be reduced in the early 20XX forecastes and will gradually increase over time to reach this projection by the end of the 1st year of operations. See the 1st and 2nd year detailed sales projections for those adjustments.

Beverage check average is calculated as 15% of total check average, where food is calculated at 85% of total check average.

My Project
Forecasted Sales - Year One

Adjustments to Revenue
WeekBeginning Date (Monday)Forecasted Ave Weekly RevenueDecreased OccupancyHolidays & Special DaysNotes on Special DaysAdjusted Revenue Revenue by Month Adj for occ Adj for holiday 11/3/18 $35,316 -75% $8,829 $8,829 $-

21/10/18 $35,316 -75% $8,829 $8,829 $-
31/17/18 $35,316 -70% $10,595 $10,595 $- 41/24/18 $35,316 -70% $10,595 $10,595 $- 51/31/18 $35,316 -70% $10,595 49,443 $10,595 $- 62/7/18 $35,316 -65% $12,361 $12,361 $-

72/14/18 $35,316 -65%20%Valentine's Day $14,833 $12,361 $2,472 82/21/18 $35,316 -65% $12,361 $12,361 $- 92/28/18 $35,316 -65% $12,361 51,915 $12,361 $- 103/7/18 $35,316 -60% $14,126 $14,126 $- 113/14/18 $35,316 -60% $14,126 $14,126 $- 123/21/18 $35,316 -60%-15%Good Friday/Easter $12,008 $14,126 $(2,119) 133/28/18 $35,316 -60% $14,126 54,387 $14,126 $- 144/4/18 $35,316 -50% $17,658 $17,658 $- 154/11/18 $35,316 -50% $17,658 $17,658 $- 164/18/18 $35,316 -50% $17,658 $17,658 $- 174/25/18 $35,316 -50% $17,658 70,632 $17,658 $- 185/2/18 $35,316 -40%25%Mother's Day $26,487 $21,190 $5,297 195/9/18 $35,316 -40% $21,190 $21,190 $- 205/16/18 $35,316 -40% $21,190 $21,190 $- 215/23/18 $35,316 -40% $21,190 $21,190 $- 225/30/18 $35,316 -40%-20%Memorial Day $16,952 107,008 $21,190 $(4,238) 236/6/18 $35,316 -30% $24,721 $24,721 $- 246/13/18 $35,316 -30% $24,721 $24,721 $- 256/20/18 $35,316 -30% $24,721 $24,721 $- 266/27/18 $35,316 -30% $24,721 98,885 $24,721 $- 277/4/18 $35,316 -25%-20%Independence Day $21,190 $26,487 $(5,297) 287/11/18 $35,316 -25% $26,487 $26,487 $- 297/18/18 $35,316 -25% $26,487 $26,487 $- 307/25/18 $35,316 -25% $26,487 100,651 $26,487 $- 318/1/18 $35,316 -20% $28,253 $28,253 $- 328/8/18 $35,316 -20% $28,253 $28,253 $- 338/15/18 $35,316 -20% $28,253 $28,253 $- 348/22/18 $35,316 -20% $28,253 $28,253 $- 358/29/18 $35,316 -20% $28,253 141,265 $28,253 $- 369/5/18 $35,316 -15% $30,019 $30,019 $- 379/12/18 $35,316 -15% $30,019 $30,019...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Four Types of It Projects Essay
  • Abandoned Construction Project Essay
  • Project Pickings Essay
  • Financial intermediaries Essay
  • Project Charter: Setting Up a Virtual Private Network Essay
  • Prioritizing Projects at D.D. Williamson Essay
  • Project Essay
  • Projects Essay

Become a StudyMode Member

Sign Up - It's Free