Hello I need assistance with the spreadsheet attached for "Financial Statement for a Manufacturer"

Required:

1. Prepare the schedule of cost of goods manufactured for the year ended December 31, 2018

2. Compute the unity product cost for 2018

3. Prepare the income statement for the year ended December 31, 2018

You must enable macros in order Please visit the Microsoft Office Support s Contact the World Campus Helpdes e macros in order for this assignment to function. ft Office Support site for documentation and instructions. d Campus Helpdesk if you continue to have trouble. ction. d instructions. trouble. Preparing financial statements The accounting records for Ashburn Manufacturing Company's accounting record show the following balances at the end of 2018: Account Beginning finished goods inventory Beginning direct materials inventory Beginning work in process inventory Depreciation expense, office equipment Depreciation, production equipment Direct labor used Ending finsihed goods inventory Ending direct materials inventory Ending work in process inventory Income tax expense Indirect labor Indirect materials Insurance expense Interest expense Other factory overhead costs Purchases of direct materials Rent expense Sales Sales discounts Sales returns and allowances Supplies expense Utilities expense Wages expense Additional information provided by the company includes: Number of units produced Amount 54,670 20,847 19,490 173,590 24,507 98,132 35,905 7,948 18,846 $0 18,503 5,716 19,814 9,693 5,858 68,031 13,621 532,661 20,650 28,649 2,434 13,812 44,905 76,807 Required: 1. Prepare the schedule of cost of goods manufactured for the year ended December 31, 2018 2. Compute the unit product cost for 2018 3. Prepare the income statement for the year ended December 31, 2018 Us (*Note Us (*Note Ashburn Manufacturing Company Schedule of cost of goods manufactured For year ended, December 31, 2018 Cost per unit - Use the area below to show your work and calculati (*Note: Your instructor may use this area to help review and resolve any incorrect Ashburn Manufacturing Company Income Statement For year ended, December 31, 2018 Cost of goods sold: Selling and administrative expenses k and calculations. resolve any incorrect answers)