Need the answers with excel calculation

Please show calculation for answer for better understanding What is the total opening DM inventory? * You have been asked to sort through the costs provided by the accounting clerk to determin e the COGS for the period Looking at the list, you can see that direct labour has not yet been calculated and that a lot ofthe costs are not relevant. Cost per labour hour 650 Direct iabour hours 700 Sales 450 Paint used on the product 900 Factory utilities 700 Factory repairs 600 Office window upgrades 500 Amortization, conveyor belt 400 Indirect materials 200 Indirect labour EGO Sale Commissions 900 Heating cost at the head ofce 250 By-produet sales 350 Direct material purchases 1,1 00 Promotional items 550 Electricity used at the head ofce 1.400 Materials inventory,]uiy 1, 19 500 Work-in-F'rocess lnventory,july 1, 19 600 Finished Goods Inventory, Juiy 1, 19 1,200 Materials Inventory,June 30. 20 1.300 Worki nProcess Inventorydune 30, 20 1,100 Finished Goods Inventory, June 30, 20 300 What is the total opening DM INVENTORY? 1 What is the total DM available for sale? 2 What is the total DL? 3 What is the total cost of materials used? 4 What is the total COGM'? - 5 What is the total COGS? 6 ***ALL above questions from the same data Please show calculation for answer for better understanding * Assuming the ABC method is used What is the total estimated CD for Square footage used in the factory? * Your boss is able to understand quite clearly now to allocate direct costs attributable to your two products. She understands that the direct labour spent making a certain product should be included in that products costs of good manufactured. Spear Sword Direct Labour Hours worked 120 22 Direct Labour Wage 4O 18 Direct Material Used 30 45 Actual MOH Machine Hours 200 420 400 Square footage used In the 1100 1500 420 factory Inspections 4 2 580 Estimated MOH Machine Hours 300 500 500 Square footage used In the 1400 1600 300 factory Inspections 8 \"I 520 What is the total estimated CD for Square footage used in the factory? i 8 What is the PDOR for Inspections? 9 What is the overhead applied for the Sword? 10 What is the total actual overhead costs? - l l The above data again used for Traditional method calculation Answer the following using traditional method Assuming the traditional method is used and Square footage used in the factory is the CD: Total estimated overhead? 12 Assuming the traditional method is used and Square footage used in the factory is the CD: What is the total estimated CD? l3 Please show calculation for answer for better understanding Assuming the traditional method is used and Square footage used in the factory is the CD: What is the PDOR?-14 Assuming the traditional method is used and Square footage used in the factory is the CD: How much overhead is applied to the Sword?-15 Assuming the traditional method is used and Square footage used in the factory is the CD: What is the absolute value of the true up require for MOH?-16 What is the PDOR? * Your construction company has been having a good year. Lots of work has been done, but as a lot of the work is carried over from the PY, you are unsure how to record the JE required for the job completed. Cost applied in the prior year Warehouse School Office Building DM 14 18 10 DL 18 22 12 MOH 18 22 14 In the current year I have applied the following costs Warehouse School Office Building DM 25 22 12 DL 6 3 9 Two units of MOH are applied based on every three DL used. If I have complete the School job, what is the value of the JE? - 18 What is the ending value of the Office Building in the prior year? - 19 What is the ending value of the Office Building?- 20Please show calculation for answer for better understanding How much MOH is applied to Warehouse?- 21 What was the opening value of the School?-22 With the final journal entry, the debit is to - 23 With the final journal entry, the credit is to - 24 Question 25 - DM 5 Conversion Costs 12 Prime Costs 7 MOH