Ch 02 131 Lab F22 r1 (1) XLSM B File Edit View Insert Format Data Tools Help Last edit was 2 minutes ago P 100%- fx $% 0.00 123 Arial 10 BIGA Chapter 2: Applying Excel Data Markup on job cost A R 75% Department Milling Assembly 3,000 Machine-hours Direct labor-hours O Total fixed manufacturing overhead cost 2 3 4 15 Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour Cost summary for Job 408 Milling 16 Machine-hours 60,000 8,000 80,000 $390,000 $500,000 $2.00 $3.75 Department Assembly 40 10 17 Direct labor-hours 18 Direct materials 19 Direct labor cost 5700 $360 $50 $150 20 21 22 23 24 Milling Assembly 25 Total fixed manufacturing overhead cost $390,000 $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 80,000 20 Total variable manufacturing overhead $120,000 $300,000 29 Total manufacturing overhead $510,000 $800,000 30 21 Step 2: Calculate the predetermined overhead rate in each department 22 Milling Assembly + Instructions Formulas Req 1 Ch2- Req 2 Ch2- Req 3 Ch2- Req 4 Ch2- Check AUG 31 MacBook Pro https://docs.google.com/spreadsheets/d/1xvz1UZB_nyfMKIxlirv dit#gid=92 Ch 02 131 Lab F22 r1 (1) XLSM File Edit View Insert Format Data Tools Help Last edit was 2 minutes ago 100%- $% 0.00 123- Arial 10 BIGA 1- fx Total foxed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead Step 2: Calculate the predetermined overhead rate in each department o D Milling $390,000 Assembly $500,000 $2.00 $3.75 60,000 80,000 $120,000 $300,000 $510,000 $800,000 Total manufacturing overhead Milling $510,000 Assembly $800,000 Total machine-hours or direct labor-hours 60,000 80,00 Predetermined overhead rate per machine-hour or direct labor-hour $8.50 $10.00 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling Predetermined overhead rate per machine-hour or direct labor-hour $8.50 Assembly $10.00 Machine-hours or direct labor-hours for the job 40 $340.00 $60.00 Manufacturing overhead applied Step 4: Calculate the total job cost for Job 408 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 Milling Assembly Total $700.00 $360.00 $1,060.00 $50.00 $340.00 $150.00 $60.00 $200.00 $400.00 $1,660.00 1,660.00 Instructions - Formulas Req 1 Ch2- Req 2 Ch2- Req 3 Ch2- Req 4 Ch2- Check My W 31 MacBook Pro