Calculate the projected yearly food and drink sales. Show your forecast model. below image of how I
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Calculate the Intrinsic Value of Google Cash Flow from Operations $53,971,000 CAPITAL EXPENDITURES = $24,915,000. INTEREST = $86,000 Tax Rate: 13.66% TTM Free Cash Flows: $29,129,252.40 WACC: 12%...
-
Abstract Aggregate production planning is a critical skill for anyone studying operations and supply chain management. Because most of the world's manufacturing occurs in China, this case takes place...
-
Using the data in the file named Monthtomonth.xlsx, create a PivotTable that shows for the year 2010 how each months sales differ from the previous month. Sum of Revenue Column Labels Row Labels...
-
Prepare journal entries to record each of the following sales transactions for the sales company. The company uses a perpetual inventory system and the gross method. 1. April 1st Sold for $3,000,...
-
What are the advantages and disadvantages of a centralized organizational structure?
-
Motorola: China Experience (Case #18, Notes) Overview The case analyzes Motorola's operations in China, the overall Chinese cellular phone industry, and Motorola's current marketing strategies. An...
-
Kathryn Kathryn plc, a listed company, provides a defined benefit pension for its staff, the details of which are given below. Pension scheme As at the 30 April 2004, actuaries valued the companys...
-
a. Use the CAPM to compute the required rate of return on common equity capital for Starbucks. b. Using your projected financial statements from Case 10.1 for Starbucks, begin with projected net cash...
-
stion 2 stion 3 The mean is sleepwalker(s). (Round to one decimal place as needed.) able of numbers of sleepwalkers and robabilities XO123 P(x) 0 0.168 0.364 0.311 0.129 X
-
Flounder Design Works generated $519,750 in operating income on sales revenue of $2,887,500. The company had $2,610,000 in assets on January 1 and $2,890,000 in assets on December 31. (a-b) (a) Cal...
-
A distillation column is operating under a vacuum. The column has 18 stages with the feed at stage 9, a partial reboiler, and a partial condenser. The pressure drop is 5.0 mm Hg in the condenser, 4.0...
-
For a simple, single-feed distillation column, derive an equation for calculation of \((\overline{\mathrm{V}} / \mathrm{B})_{\min }\) from \((\overline{\mathrm{L}} / \overline{\mathrm{V}})_{\max }\)
-
What should the internal auditor include in an individual, tailor-made program?
-
In a well-managed EDP installation, the internal auditor should expect to find: a. A password protection system. b. Duplicate files for all computer systems. c. Computer operators with an extensive...
-
How is net sales computed?
-
An investor subject to loss aversion and whose reference point is the amount paid for an investment will be more likely to __________. 1 point Sell winning investments and hold losing investments...
-
AB CORPORATION ISSUED THE FOLLOWING 850 COMMON STOCKS PAR VALUE P100 750 PARTICIPATING PREFERRED STOCKS PAR VALUE P100 AT 3% AB CORPORATION DECLARED P100,000.00 DIVIDEND IN 2022.
-
How do teams work?
-
Task characteristics, reward systems, and team size are all ____________ that can make a difference in group effectiveness. (a) group processes (b) group dynamics (c) group inputs (d) human resource...
-
When a new team member is anxious about questions such as Will I be able to influence what takes place? the underlying issue is one of ____________. (a) relationships (b) goals (c) processes (d)...
Study smarter with the SolutionInn App