please use these file and the excel sheet that i have uploaded and provided with help on this.

Estimated Manufacturing Overhead Estimated DLH Predetermined Overhead Rate $ 1,000,000.00 40000 $ 25.00 per DLH Mono-Relay Time to Make One Unit Estimated Units Produced Estimated Total DLH Direct Materials Direct Labor $12 per hour Manufacturing Overhead Bi-Relay 0.75 40000 30000 $ $ 1 hours 10000 10000 35.00 9.00 $ $ 48.00 12.00 Total Unit Cost ABC Maintaining Parts Inventory Processing Purchase Orders Quality Control Machine related Estimated Overhead Expected Activity Rate $ 180,000.00 225 $ 90,000.00 1000 $ 230,000.00 5750 $ 500,000.00 10000 per part type per purchase order per test per machine hour $ 1,000,000.00 Mono-Relay Maintaining Parts Inventory Processing Purchase Orders Quality Control Machine related 75 800 2500 4000 Maintaining Parts Inventory Processing Purchase Orders Quality Control Machine related Mono-Relay $ $ $ $ Total Direct Materials Direct Labor Overhead per unit Total Unit Cost Bi-Relay Total 150 200 3250 6000 - Bi-Relay $ $ $ $ - $ - $ - $ $ $ 35.00 $ 9.00 $ - $ 48.00 12.00 - 225 1000 5750 10000 per part type per purchase order per machine hour This exercise will deal with the costing of a product using a predetermined overhead rate and Activity Based Costing [ABC]. Please note the different results from using the different methods. The Sample Companv wants to compare the results from the use of a predetermined overhead rate versus Activity Based Costing LAB-C]. The following are the estimated costs: Estimated Manufacturing Dvemead $ 1,000,000.00 Estimated DLH 40000 Predetermined Overhead Rate 5 25.00 per DLH Mono-Relay Bi- Relav Time to Make Dne Unit 0.?5 1 Hours Estimated Units Produced 40000 10000 Estimated Total DLH 30000 10000 Direct Materials $ 35.00 $ 43.00 Estimated Units Produced Estimated Total DLH Direct Materials Direct Labor Maintaining Parts Inventory Processing Purchase Orders Quality Control Machine related Maintaining Parts Inventory Processing Purchase Orders $12 per hour 40000 10000 30000 10000 $ 35.00 $ 43.00 $ 9.00 $ 12.00 Estimated Overhead Expected Activity $ l 225 $ P l $ 23,00.00 5?50 $ SDDDUDDD l $ LUUDDUDDD MonoRelay Ei-Relay Total 2'5 150 225 300 200 100D Mo no~Relayf Ei~ Relay:r Total Maintaining Parts Inventoryr 3'5 151:) 225 Processing Purchase Orders 300 200 1000 Quality:r Control 2500 32 50 SEC! Machine related 4000 (EDD-D 10000 Compute the direct material, direct labor. overhead and total unit cost using the following: o Predetermined overhead rate no Activity Based Costing {ABC}