Please answer the questions using Excel spreadsheet or Word. Neat and understandable. Show All Working!

PROBLEM 5 (Manufacturing Costs and Standard Costs) Part A 15 Marks Intune's production supervisor is tasked with computing the manufacturing costs for June 2021 for one of the company's top selling products. The following details are provided: Raw Materials Inventory, June 1st 30,000 Raw Material Purchases 1,500,000 Raw Materials Inventory June 30th 60,000 Direct Labour 690,000 Depreciation - Factory Equip. 200,000 Work in Process, June 1st 27,000 Depreciation - Admin. Equip. 100,000 Work in Process June 30th 18,000 Factory Supplies Used 75,000 Factory Utilities 125,000 Finished Goods, June 1st 60,000 Other Factory Expenses 50,000 Finished Goods June 30th 48,000 Sal Comm 275,000 Indirect Labour 200,000 Indirect Materials 150,000 Required: a) From the information provided, compute: i. Direct Materials Used ii. Manufacturing Overhead cost b) Prepare a Cost of Goods Manufactured Schedule for June 2021. c) Compute the cost of Goods Sold for June 2021. 3 Marks 3 Marks 5 Marks 4 Marks