Exercise 5 Your Co. sells two products (1 & 2), and two departments serve factory workers (materials dept. 8 support dept.). To follow are various production data Expected Usage Activity Expected Cost $10,000 $5,000 $7,500 Driver Purchase orders Square feet storage Parts Product 1 Purchasing & receiving Moving materials Machine maintenance Product 2Total 200 600 200 1,000 1,000 300 800 400 100 Materials Storage of materials $15,000 $2,500 $10,000 Machine hours Square feet production Square feet production 1,000 3,000 3,000 2,000 3,000 5,000 5,000 Support Cleaning workspace 2,000 Factory security 2,000 Determine the departmental overhead rates assuming the Materials Dept assigns overhead based on purchase orders and the Support Dept assigns overhead based on square feet used in production a) Materials Dept OH Rate b) Support Dept OH Rate per PO per sq. ft production Calculate total overhead assigned to products 1 & 2 and overhead per unit assuming you made 1,000 units of product 1 produced and 500 units of product 2 Product 1 Product 2 c) Materials OH assigned d)Support OH assigned e) Total