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.

Transcribed Image Text:

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 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