AutoSave Off 605 Assignment 6 - Excel Levi Estes LE File Home Insert Page Layout Formulas...

Transcribed Image Text:

AutoSave Off 605 Assignment 6 - Excel Levi Estes LE File Home Insert Page Layout Formulas Data Review View Developer Help Search Arial 10 ' ' Wrap Text General Paste BIU v x A v = Merge & Center $ - %, 50-08 Conditional Format as Cell Formatting Insert Delete Format Table Styles Clipboard Font Alignment Number Styles Cells J11 A fx F WA Share Comments 28 Sort & Find & Filter Select Editing Ideas Ideas H J K L M N P R 1 ACC 605 ASSIGNMENT 2 3 Maple Wood Company Manufactures two products, dining room tables, and desk chairs. Materials and labor 4 per unit for the two products are: 5 6 7 8 9 Materials Direct labor Tables $127.00 Chairs $211.00 $306.00 $408.00 10 Manufacturing overhead costs are: 11 12 13 14 Cost pool 15 Machinery cost 16 Indirect materials cost 17 Quality control cost 18 19 Other overhead costs Total Cost Activity Cost Driver Tables Chairs 4,800 hrs $101,600 6,300 hrs $109,720 $155,511 Machine hours $42,264 Materials cost $20,460 Number of units $2,239,104 Direct labor cost 20 Compute the total overhead allocated to each product using Activity Based Costing 800 units $244,800 520 units $212,160 21 Tables Chairs 22 Total overhead allocated to $ $ ABC Ready H Type here to search O N 4:17 PM 10/26/2019 + 100% AutoSave Off 605 Assignment 6 - Excel Levi Estes LE File Home Insert Page Layout Formulas Data Review View Developer Help Search Arial 10 ' ' Wrap Text General Paste BIU v x A v = Merge & Center $ - %, 50-08 Conditional Format as Cell Formatting Insert Delete Format Table Styles Clipboard Font Alignment Number Styles Cells J11 A fx F WA Share Comments 28 Sort & Find & Filter Select Editing Ideas Ideas H J K L M N P R 1 ACC 605 ASSIGNMENT 2 3 Maple Wood Company Manufactures two products, dining room tables, and desk chairs. Materials and labor 4 per unit for the two products are: 5 6 7 8 9 Materials Direct labor Tables $127.00 Chairs $211.00 $306.00 $408.00 10 Manufacturing overhead costs are: 11 12 13 14 Cost pool 15 Machinery cost 16 Indirect materials cost 17 Quality control cost 18 19 Other overhead costs Total Cost Activity Cost Driver Tables Chairs 4,800 hrs $101,600 6,300 hrs $109,720 $155,511 Machine hours $42,264 Materials cost $20,460 Number of units $2,239,104 Direct labor cost 20 Compute the total overhead allocated to each product using Activity Based Costing 800 units $244,800 520 units $212,160 21 Tables Chairs 22 Total overhead allocated to $ $ ABC Ready H Type here to search O N 4:17 PM 10/26/2019 + 100%