ABC Firm uses a job costing system. OH is applied based on DL dollars. At the beginning of 2020, the firm made the following estimates. Actuals as of the end of the year are also reported.

Estimates Actuals

Direct labour hours 41,000 43,480

Machine hours 207,000 196,600

Direct labour $732,000 $792,310

Direct materials 863,000 858,200

Overhead 2,457,000 2,491,200

On June 17, Job 403 was begun. It was completed on July 30. It required 5,400 machine hours and 960 DLH. Direct manufacturing costs were DM of $7,800 and DL of $21,210.

The job sold for $125,000.

On November 11, Job 890 was begun. It was completed on November 21. It required 3,700 machine hours and 1,250 DLH. Direct manufacturing costs were DM of $7,400 and DL of $28,500. The job sold for $130,000.

1. Compute the cost of jobs 403 and 890.

2. Compute OH over or under applied for the year.

3. Now suppose that, instead of using DL$ as the OH application base, the firm was to use machine hours. Compute the cost of jobs 403 and 890.

4. If machine hours were the OH application base, what would be the amount of OH over or under-applied.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please provide a solution in excel format with all the formulas/computation.