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:

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:

Expense History - use the detail below to help build the expense plan
Calculating expenses as a percent of product revenue will help you make decisions and build the expense plan
		2021		2022		2023		2024
Marketing - Product A	100		109		195			Input these 5 expense lines
Marketing - Product B	210		182		144
Commissions - Product A	140		153		146
Commissions - Product B	300		365		346
Administrative Expense	500		520		550
	Selling and Admin Exp	1,250		1,329		1,381		-	Calculated
Depreciation Expense	100		95		90			Input these 3 expense lines
Rent Expense	50		53		55
Other Operating Exp	30		28		27
	Other Operating Expense	180		176		172		-	Calculated
At least 5 comments to support plan assumptions:

Help with an annual income statement plan using the information on the above worksheet. The first is the income statement; the plan column will populate sales and operating expenses from your inputs on the second and third tabs. You will directly input "other income" and "tax expense" on the fist tab. The second is the sales history to help you develop the sales plan on this tab. The third is the expense detail history to help you develop the expense plan on this tab. Add comments to the tabs to help support the assumptions you are making. When analyzing the historical performance, you will note certain aspects of the company strategy regarding each product.