Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

13. Switch to the Income Statement worksheet. For the Add 1 Truck scenario, project the income from Food sales for 2020-2022 (cells D5:F5) using a

13. Switch to the Income Statement worksheet. For the Add 1 Truck scenario, project the income from Food sales for 2020-2022 (cells D5:F5) using a Growth Trend interpolation. (Hint: Select the range C5:G5 before filling this series with values.)

image text in transcribed

The Mobile Vegan Expansion Plan Income Statement Add 1 Truck Income Food sales Beverage sales Catering Total Revenue 2019 2020 2021 2022 2023 96,000 48,000 90,000 236,019 $ 280,000 115,000 220,000 617,023 58,000 70,000 88,000 60,020 $ 72,021 $ 90,022 $ Expenses Food cost of goods Beverage cost of goods Payroll Maintenance Insurance 50,000 $ 52,000 $ 28,500 48,000 $ 55,000 $ 58,000 32,000 24,000 27,500 30,000 120,000 1,500 2.400 12,000 207,900 $ 2,000 2.400 12,000 93,900 $ 2,000 2,400 12,000 96,900 $ 2,500 2,600 12,000 102,100 $ 2,500 2,600 12,000 107,100 Total General Expenses Initial Earnings 28,119 $ (33,880) $ (24,879) S (12,078) $ 509,923 The Mobile Vegan Expansion Plan Income Statement Add 1 Truck Income Food sales Beverage sales Catering Total Revenue 2019 2020 2021 2022 2023 96,000 48,000 90,000 236,019 $ 280,000 115,000 220,000 617,023 58,000 70,000 88,000 60,020 $ 72,021 $ 90,022 $ Expenses Food cost of goods Beverage cost of goods Payroll Maintenance Insurance 50,000 $ 52,000 $ 28,500 48,000 $ 55,000 $ 58,000 32,000 24,000 27,500 30,000 120,000 1,500 2.400 12,000 207,900 $ 2,000 2.400 12,000 93,900 $ 2,000 2,400 12,000 96,900 $ 2,500 2,600 12,000 102,100 $ 2,500 2,600 12,000 107,100 Total General Expenses Initial Earnings 28,119 $ (33,880) $ (24,879) S (12,078) $ 509,923

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions