Prepare an original excel spreadsheet with will include 3 tabs: Input, COGM, and income statement. The input should include the following data:

Inventories	Beginning	Ending
Raw Materials	$ 13,200	$ 8,000
Work-in-Process	3,000	4,000
Finished Goods	7,000	5,800
Other Information:
Raw materials purchases		$ 43,000
Plant janitorial services		200
Sales salaries		5,300
Delivery costs (outbound freight)		1,500
Sales revenue		120,000
Utilities for plant		1,600
Rent on plant		11,000
Customer service hotline costs		1,100
Direct labor		23,000

The COGM tab should have a cost of goods manufactured report. Follow the example on canvas. Change the overhead section to reflect the relevant product costs in this problem. There should be no numbers keyed into this sheet; all numbers should be formulas. All numbers should be consistently formatted (preferably use accounting number format).

The IS tab should have an income statement. Follow the example on canvas. Change the S&A section to reflect the appropriate costs in this problem. There should be no numbers keyed into this sheet; all numbers should be formulas. All numbers should be consistently formatted.