EB Ch 02 131 Lab F22 r1 (1) XLSM File Edit View Insert Format Data Tools Help Last edit was 2 minutes ago T 100%- C28 Chapter 2 Applying Excel Data . Markup on job cost 1400 122- Arial " Machine-hours " Direct laber-hours 10 Total feed manufacturing overhead cost " Variable manufacturing overhead per machine-hour " Variable manufacturing overhead per direct labor-hour 14 Cost summary for Job 408 " " Machine-hours " Direct labor-hours Direct materials " Direct labor cost 9 " 10 BIG 75% BE-> C D A T J M Req. 4: Change the total number of Assembly Department direct labor hours in green cell at the left to 50,000 hours. the new Selling Price for a 408 charge compared to req. 27 Miling 60,000 8,000 Department Assembly 3,000 50.000 $300,000 $600,000 $2.00 $3.75 Department Milling Assembly Why or why not? 40 10 2 B $700 $360 $50 $150 24 Ming Assembly " Total feed manufacturing overhead cost $300,000 $500,000 " Variable manufacturing overhead per machine hour or dred labor-hour $2.00 $3.75 37 Total machine-hours or direct labor-hours 00,000 50.000 Total variatie manufacturing overhead $120,000 Total manufacturing overhead Step 2: Calculate the predetermined overhead rate in each department $510.000 Miling Assembly Instructions Formules Reg 1 Ch2- Reg 2 Ch2- Req 3Ch2- Reg 4 Ch2- Check My Work C28 Ch 02 131 Lab F22 r1 (1) XLSM 1/8823.google.com/spreadsheets/d/1xvz1uZB_nyfMKXrVycc9xz00hraGS/edit#gid=856804384 File Edit View Insert Format Data Tools Help Last edit was 2 minutes ago 100%- $0.00 123- Arial 10 BIG A 24 25 Total fixed manufacturing overhead cost Milling $390,000 B Assembly $500,000 26 Variable manufacturing overhead per machine-hour or direct labor-hour $2.00 $3.75 27 Total machine-hours or direct labor-hours 60,000 50,000 IN Total variable manufacturing overhead $120,000 2 Total manufacturing overhead $510.000 20 21 Step 2: Calculate the predetermined overhead rate in each department 33 Total manufacturing overhead Milling $510,000 Assembly 34 Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour 60,000 $8.50 76 37 Step 3: Calculate the amount of overhead applied from both departments to Job 408 30 Miling Assembly " Predetermined overhead rate per machine-hour or direct labor-hour $8.50 40 Machine-hours or direct labor-hours for the job 40 6 41 Manufacturing overhead applied $340.00 4 43 Step 4: Calculate the total job cost for Job 408 " Milling Assembly 4 Direct materials 47 D E F H Direct labor cost Manufacturing overhead applied Total cost of Job 408 Step 5: Calculate the selling price for Job 408 $700.00 $360.00 $50.00 $150.00 $340.00 $1,000 00 $610.00 Total $1,060.00 $200.00 11 Total cost of Job 408 33 Markup 9 Selling price of Job 408