Please present answers in Word or Excel format.

Antietam, Inc. has the following information available for the year ended December 31, 2018. You are a consultant and have been asked to produce statements and make reccomendations. Costs Incurred: Raw Material Purchased Direct Labor Indirect Labor Factory Maintenance Factory Insurance Factory Rent Factory Depreciation Factory Supplies Advertising Expenses Selling & Admin Expenses Net Revenue $100,000 50,000 35,000 9,000 11,000 40,000 20,000 12,000 18,000 25,000 350,000 Inventories Raw Material Inventory Work in Process Inventory Finished Good Inventory Beginning $15,000 20,000 35,000 Ending $18,000 29,000 30,000 1. 25pts Required: Prepare a statement of Cost of Goods Manufactured Make operating recommendations