Answered step by step
Verified Expert Solution
Link Copied!

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.

imageimageimageimage

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transport Operations

Authors: Allen Stuart

2nd Edition

978-0470115398, 0470115394

More Books

Students also viewed these General Management questions

Question

What are the ethical issues in this situation? Discuss.

Answered: 1 week ago