need in excel with all formulas clearly shown

ana problems. IC D HIJ 1 Problem 1: Polyfill Compounding Company has established the following activity cost pools and cost drivers: Budgeted Level for 2 Activity Cost Pool Overhead Cost Cost Driver Cost Driver Pool Rate Machine setups $ 250,000 Number of 125 $2,000 per setup setups Material handling 75,000 Weight of raw 37,500 lb $2 per pound material Hazardous waste 25,000 Weight of 5,000 lb $5 per pound control hazardous chemicals Quality control 75,000 Number of 1,000 $75 per inspection inspections Other overhead 200,000 Machine hours 20,000 hrs $10.00 per hour 7 costs 8 Total 625,000 10 An order for 1,000 boxes of compounding material has the following production requirements. 11 Machine setups 5 setups 12 Raw material 10,000 pounds 13 Hazardous materials 2,000 pounds 14 Inspections 10 inspections 15 Machine hours 500 machine hours 16 Units manufactured 1,000 units 18 Required 19 Required: Construct a calculating Excel spreadsheet to solve requirements (1), (2), (3), and (3). 20 1. Compute the total overhead that should be assigned to the production order. 21 2. Compute the overhead cost per per box of compounding agent. 22 3. Suppose the company were to use a single pre-determined overhead rate based on machine hours. 23 The budget calls for: 20,000 machine hours 24 a. Compute the pre-determined overhead rate per machine hour. 25 b. Compute the total overhead cost that would be assigned to the order for compounding agent. 26 C. Compute the overhead cost per box of compounding agent. 27 4. Explain why the two product-costing systems yield such widely differing overhead costs per unit. 28 Which overhead costing system would you recommend using? Why? 29 5. After completion of the order, an audit established the following changes: 30 a. The overhead associated with machine setups is $375,000, 31 b. There were 500 inspection budgeted. 32 Show how the overhead calculations (1) through (3) would change. 33