Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the projected yearly food and drink sales. Show your forecast model. below image of how I calculated the revenue. However, I am not confident
Calculate the projected yearly food and drink sales. Show your forecast model.
below image of how I calculated the revenue. However, I am not confident that it is correct because the numbers do not look correct when preparing the projected income statement and balance sheet. If it is not correct, please help me figure out the projected sales yearly food and drink sales.
Sales Forecast Model Lunch: Food January February March April May June July August September October November December Grand Total Monday Tuesday 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 Wednesday 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 Thursday 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 Friday 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 Saturday 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sunday 0.00 Total 6,500.00 0.00 6,500.00 0.00 6,500.00 0.00 6,500.00 0.00 6,500.00 0.00 0.00 0.00 0.00 6,500.00 6,500.00 6,500.00 6,500.00 0.00 6,500.00 0.00 6,500.00 0.00 6,500.00 78,000.00 January February March April May Lunch: Drink June July August September October November December Grand Total Monday 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 Tuesday 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 Wednesday 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 Thursday 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 Friday 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 Saturday 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sunday 0.00 0.00 0.00 0.00 0.00 0.00 Total 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 0.00 1,300.00 0.00 0.00 0.00 0.00 0.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 15,600.00 Sales Forecast Model Dinner: Food January February March April May June July August September October November December Grand Total Monday 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 Tuesday 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 Wednesday 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 Thursday 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 Friday 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 Saturday 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 6,500.00 Sunday 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 5,200.00 Total 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 33,800.00 405,600.00 January February March April May Dinner: Drink June July August September October November December Grand Total Monday 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 Tuesday 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 Wednesday 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 Thursday 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 975.00 Friday 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 Saturday 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 1,625.00 Sunday 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 1,300.00 Total 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 8,450.00 101,400.00
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