Just a,b,c show spreadsheet pls :)

2. Y Company reported the following actual costs data for the year: Purchase of raw materials (all direct) $200,000 Direct labour (average hourly rate of $20) 320,000 Manufacturing overhead costs 100,000 Changes in inventory: Increase in raw materials $20,000 Increase in work in process 16,000 Increase in finished goods 32.000 Y Company used a predetermined overhead rate based on direct labour hours. Estimated annual manufacturing overhead cost and direct labour hours were $150,000 and 20,000, respectively. Required: a. What was the pre-determined manufacturing overhead rate? b. Calculate the cost of goods manufactured. c. What was the cost of goods sold before adjusting for any under or overapplied overhead? d. By how much was manufacturing overhead cost under or overapplied? e. Prepare a summary journal entry to close any under or overapplied manufacturing overhead cost to cost of goods sold. Is such an entry appropriate in this situation? Why or why not