Question: Please prepare answer in EXCEL SHEET. Also, add formula used. Thank you! 2) The total factory overhead for Lifestyle Furniture Company is budgeted at $600,000
Please prepare answer in EXCEL SHEET. Also, add formula used. Thank you!

2) The total factory overhead for Lifestyle Furniture Company is budgeted at $600,000 for the year, divided among four activities: fabrication $300,000; assembly $120,000; setup $100,000 and materials handling $80,000. Lifestyle manufactures two designer furniture products: a wingback chair (chair) and a computer desk (desk). The activity-based usage quantities for each product by each activity are estimated as follows: Fabrication Assembly Setup Materials Handling Chair 5,000 dlh 15,000 dlh 30 setups 50 moves Desk 15,000 5,000 220 350 Total activity- 20,000 dlh 20,000 dlh 250 setups 400 moves based usage Production for the year is budgeted for 5000 chairs and 5000 desks. Determine the: a. Activity rate for each activity. b. Activity based factory overhead per unit for each product
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
