pls I need the answer to be displayed on an excel sheet separately and I want the answer to be done step by step

Question 2 (20 marks) ABC Manufacturing is a small manufacturer that uses machine hours as its activity base for assignment of overhead costs to jobs. The company estimated the following amounts for the current year and for Job 62. Company Job 62' Direct Materials $60,000 $4,000 Direct Labour $25,000 $2,500 ' Manufacturing Overhead $54,000 "4 Machine Hours l30,000 1,350 During the Year: "astasters;to};' _... " __ $54,000 Actual Overhead Costs Instructions A. How much is predetermined overhead rate? B. How much are the total manufacturing costs of Job 62? G. How much overhead is over or under-applied for the year? D. What is the gross prot when $15,000 equals the total proceeds from the sale of Job 62? Question 3 (20 marks) The following information is available for ABC Company at the end of last year: Start of Year End of Year Finished Goods 25,000 26,000 Work in Process 100,000 153,000 Direct Materials 15,000 14,500 During the year the following information was recorded: $75,000 Raw Materials Bought $10,000 Indirect Materials $125,000 Total Wages $80,000 Direct Labour $20,000 Indirect Labour Balance was Sales and Administration $160,000 Other Manufacturing Overhead $100,000 Manufacturing Overhead Applied Instructions A. Prepare a cost of goods manufactured schedule for last year. B. Calculate the over- or under-applied manufacturing overhead for the year