Assuming the ABC method is used, What is the PDOR for Inspections?

Assuming the ABC method is used, What is the overhead applied for the Sword?

Assuming the ABC method is used, What is the total actual overhead costs?

Please explain in EXCEL

* 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 how 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. Sword 22 Spear Direct Labour Hours worked 120 Direct Labour Wage 40 Direct Material Used 30 18 45 MOH 400 200 420 Actual Machine Hours Square footage used in the factory Inspections 1100 1500 420 4 2 580 MOH 500 300 500 Estimated Machine Hours Square footage used in the factory Inspections 1400 1600 300 8 1 520