need help with exercises 4-5

Exercise 4 Your Co. sells two products (1 & 2), and two departments serve factory workers (materials dept. & support dept.). To follow are various production data. Expected Usage Activity Purchasing & receiving Materials Storage of materials Moving materials Expected Cost $10,000 $5,000 $7,500 Driver Purchase orders square feet storage Parts Product 1 Product 2 800 200 400 600 100 200 Total 1,000 1,000 300 Machine maintenance $15,000 Machine hours 1,000 2,000 3,000 Support Cleaning workspace $2,500 square feet production 3,000 2.000 5.000 Factory security $10,000 square feet production 3,000 2,000 5,000 Assuming Your Co uses the ABC method to assign overhead, calculate the following ABC rates: a) Purchasing & receiving per PO b) Storage of materials per sq. ft storage c) Moving materials per part d) Machine maintenance per mach.hr e) Cleaning workspace per sq. ft production f) Factory security per sq.ft production Calculate the overhead assigned to products 1 & 2 from each cost pool: Product 1 Product 2 g) Purchasing & receiving h) Storage of materials Moving materials Machine maintenance k) Cleaning workspace 0 Factory security m) Total overhead Assume 1,000 units of product 1 and 500 units of product 2 were produced Product 1 Product 2 pl Overhead cost per unit Exercise 5 Your Co. sells two products (1 & 2), and two departments serve factory workers (materials dept. & support dept.). To follow are various production data. Expected Usage Activity Purchasing & receiving Materials Storage of materials Moving materials Expected Cost $10,000 $5,000 $7,500 Driver Purchase orders square feet storage Parts Product 1 Product 2 800 200 400 600 100 200 Total 1,000 1,000 300 Support Machine maintenance Cleaning workspace Factory security $15,000 $2,500 $10,000 Machine hours square feet production square feet production 1,000 3,000 3,000 2,000 2,000 2,000 3,000 5,000 5,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 I 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 Product 1 Product 2 Overhead cost per unit