XYZ company manufactures chemicals used in radiological imaging systems. The company had originally used machine hours as the cost driver to develop one predetermined overhead rate.You have been recently hired by this company to review the costing of chemicals and realize that maybe a predetermined overhead rate does not give an accurate cost picture. You have to do some research and come up with the following activity cost pools and cost drivers.

XYZ company manufactures chemicals used in radiological imaging systems. The company had originally used machine hours as the cost driver to develop one predetermined overhead rate You have been recently hired by this company to review the costing of chemicals and realize that maybe a predetermined overhead rate does not give an accurate cost picture You remember discussing overhead cost issues in MBA641 and want to implement ABC, so you have done some research and come up with the following activity cost pools and cost drivers Budgeted Overhead Cost Budgeted Level Activity for cost Driver Pool Rate 30,000 1,000 Activity cost Pool Cost driver $1.00 Material handing Quality Assurance Hazardous waste control Other overhead costs 0,000 Weight of raw materials in pounds 20,000 Number of quality checks Weight of hazardous chemical 8,000 150,000 100,000 used in pounds 300,000 Machine hours Total Budgeted overhead cost 450.000 Required: Make sure you show your work or use cell references for a? calculations. You will not earn credit if you just type in your answer 1. Using the information above calculate the single predetermined overhead rate this company is using based on machine hours as the cost driver Predetermined overhead rate: 2. If the company uses the ABC approach, what would be the pool rates for the activities you have identified above have computed the first activity pool rate above in column E and you should compute the remainder of the rates for the other 3 activities 3. An order for a special chemical mix has the following production requirements 3000 pounds Material handling Quality Assurance Hazardous waste Other overhead costs 10 inspections 200 pounds 700 machine hours If the company is using the predetermined overhead rate based on machine hours, what is the overhead cost for this order? Total Overhead cost of this order using a predetermined overhead rate If the company is using the ABC method, what is the overhead cost for this order? Material handling Quality Assurance Hazardous waste Other overhead costs Total Overhead cost of this order using ABC 4. Write a short report (at least 75 words) that identifies factors that explain why the two product-costing systems result in differing costs Which system do you recommend? Why