Answered step by step
Verified Expert Solution
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.)
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,923Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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