90.2K

Verified Solution

Link Copied!

please include cell references!! thanks so much

D F G G H - Milling + + 1 Chapter 2: Applying Excel 2 3 Data & Markup on job cost 75% 5 6 Department 7 Assembly # Machine hour 60,000 3,000 9 Direct labor hours 8,000 80,000 10 Total fred manufacturing overhead cost $390,000 $500,000 11 Variable manufacturing overhead per machine-hour $2.00 12 Variable manufacturing overhead per direct labor hour $3.75 13 14 Cost summary for Job 407 Department 15 Mling Assembly 16 Machine-hours 90 4 17 Direct labor hours 5 20 18 Direct materials $800 $370 19 Direct labor cost $70 5280 20 21 Enter a fomul into each of the cells marked with a 7 below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 Milling Assembly 25 Total food manufacturing overhead cost ? 2 26 Variable manufacturing overtad por machine-hour or direct labor hour 2 2 27 Total machine hours or direct labor hours ? ? 28 Total variable manufacturing overhead ? ? 29 Total manufacturing overhead 2 ? 30 31 Step 2: Calculate the predetermined overhead rato In each department 32 Miling Assembly 33 Total manufacturing overhead 2 2 34 Total machine hour or direct labor hours ? ? as Predetermined overhead rate per machine-hour ordred labor hour 2 2 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Mling Assembly 39 Predetermined overhead rate per machine hour ordrect labor hour ? ? 40 Machine houn or direct labor hours for the job ? 2 41 Manufacturing overhead applied 2 ? 42 43 Step 4 Calculate the total job cost for Job 407 Min Assembly 45 Direct materiais 2 12 2 45 Direct labor cost 7 2 47 Manufacturing overhead applied 7 2 2 48 Total cost of Job 407 17 49 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 7 52 Markup 2 53 Seling pece of Job 407 2 54 55 56 57 SH 59 60 44 Total ? Chapter 2 Form + Ready

Answer & Explanation Solved by verified expert

See Answer