Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following tabs to develop the plan amounts for each account except Other Income and Tax Expense. Make 2 comments below regarding Other Income
Use the following tabs to develop the plan amounts for each account except | ||||||||||||||||
Other Income and Tax Expense. Make 2 comments below regarding Other | ||||||||||||||||
Income and Tax Expense. | ||||||||||||||||
Income Statement for the year ended December 31 | ||||||||||||||||
(000s) | Actual Results | Plan | ||||||||||||||
2021 | 2022 | 2023 | 2024 | |||||||||||||
Sales Revenue | $ 5,000 | $ 5,224 | $ 5,318 | $ - | Use the Sales tab to build your Sales Revenue plan amount | |||||||||||
Cost of Goods Sold | 3,300 | 3,300 | 3,390 | - | Use the Sales tab to build your Cost of Goods Sold plan amount | |||||||||||
Gross Profit | 1,700 | 1,924 | 1,928 | - | ||||||||||||
Selling and Administrative | 1,250 | 1,329 | 1,381 | - | Use the Expense tab to build your expense amount | |||||||||||
Other Operating Expense | 180 | 176 | 172 | - | Use the Expense tab to build your expense amount | |||||||||||
Operating Income | 270 | 419 | 375 | - | ||||||||||||
Other Income | 20 | 30 | 40 | Input plan number and note assumption below in comments section | ||||||||||||
Income Before Taxes | 290 | 449 | 415 | - | ||||||||||||
Tax Expense | 58 | 90 | 83 | Input plan number and note assumption below in comments section | ||||||||||||
Net Income | $ 232 | $ 359 | $ 332 | $ - | ||||||||||||
At least 2 comments to support plan assumptions of Other Income and Tax Expense: | ||||||||||||||||
Use the information below to make product decisions for 2023 and build the sales plan | |||||||||||
Calculate ratios to support the plan revenue and cost of sales amounts | |||||||||||
2021 | 2022 | 2023 | 2024 | ||||||||
Product A | |||||||||||
Unit Sales | 100 | 104 | 125 | Input | |||||||
Price Per Unit | $ 20.00 | $ 21.00 | $ 19.50 | Input | |||||||
Sales Revenue | $ 2,000 | $ 2,184 | $ 2,438 | $ - | Calculated | ||||||
Cost of Goods Sold | $ 1,500 | $ 1,600 | $ 1,840 | Input | |||||||
Gross Profit | $ 500 | $ 584 | $ 598 | $ - | Calculated | ||||||
Product B | |||||||||||
Unit Sales | 200 | 190 | 160 | Input | |||||||
Price Per Unit | $ 15.00 | $ 16.00 | $ 18.00 | Input | |||||||
Sales Revenue | $ 3,000 | $ 3,040 | $ 2,880 | $ - | Calculated | ||||||
Cost of Goods Sold | $ 1,800 | $ 1,700 | $ 1,550 | Input | |||||||
Gross Profit | $ 1,200 | $ 1,340 | $ 1,330 | $ - | Calculated | ||||||
Total | |||||||||||
Sales Revenue | $ 5,000 | $ 5,224 | $ 5,318 | $ - | |||||||
Cost of Sales | 3,300 | 3,300 | 3,390 | - | |||||||
Gross Profit | 1,700 | 1,924 | 1,928 | - | |||||||
At least 4 comments to support plan assumptions: |
Help fill in the 2024 plan. This is an estimate.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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