I did the journal entry for each transaction just need to prepare a schedule in the required section. Thanks

please help prepare a schedule of cost of goods manufactured and cost of goods sold for the year!!!!

The company applies overhead cost to jobs based on machine-hours worked. For the current year, the company estimated that it would work 75,000 machine-hours and incur $450,000 in manufacturing overhead cost. The following transactions were recorded during the year: 1. Raw materials were purchased on account: $410,000. 2. Raw materials were requisitioned for use in production: $380,000($360,000 direct materials and $20,000 indirect materials). 3. The following costs were incurred for employee services: direct labour, $75,000; indirect labour, $110,000; sales commissions, $90,000; and administrative salaries, $200,000. 4. Sales travel costs were incurred: $17,000. 5. Utility costs were incurred in the factory: $43,000. 6. Advertising costs were incurred: $180,000. 7. Depreciation was recorded for the year: $350,000 ( 80% relates to factory operations, and 20% relates to selling and administrative activities). 8. Insurance expired/used during the year: $10,000(70% relates to factory operations, and the remaining 30% relates to selling and administrative activities). 9. Manufacturing overhead was applied to production. Due to greater than expected demand for its products, the company worked 80,000 machine-hours during the year. 10. Goods costing $900,000 to manufacture according to their job cost sheets were completed during the year. 11. Goods were sold on account to customers during the year at a total selling price of $1,500,000. The goods cost $870,000 to manufacture according to their job cost sheets. Font The total applied overhead is =$475,000/75,00080000=$480,000 TotalOverheadIncurred=$20,000+$110,000+$43,000+$280,000+$7,000=$460,000 Since Actual Overhead is less than the Applied Overhead, the Manufacturing Overhead is OVERAPPLED by $20,000. REQUIRED: 1. Prepare a Schedule of Cost of Goods Manufactured and Cost of Goods Sold for the year. Assuming the company writes off any balance in the overhead account to the Cost of Goods Sold account, prepare the appropriate journal entry to dispose of under/overapplied overhead at year-end and include this number on your Cost of Goods Sold Statement (10 marks)