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!

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!