A Chapter 2: Applying Excel Data Markup on job cost 75% Department 6 7 8 Machine-hours 9 Direct labor-hours 10 Total fixed manufacturing overhead cost 11 Variable manufacturing overhead per machine-hour Milling Assembly 12 Variable manufacturing overhead per direct labor-hour $3.75 14 Cost summary for Job 407 Department 16 Machine-hours 17 Direct labor-hours 18 Direct materials 19 Direct labor cost Milling Assembly 20 21 Enter a formula into each of the cells marked with a ? below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 Total fixed manufacturing overhead cost Milling Assembly 26 Variable manufacturing overhead per machine-hour or direct labor-hour 27 Total machine-hours or direct labor-hours 28 Total variable manufacturing overhead 29 Total manufacturing overhead 30 Step 2: Calculate the predetermined overhead rate in each department Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour Step 3: Calculate the amount of overhead applied from both departments to Job 407 Predetermined overhead rate per machine-hour or direct labor-hour Machine-hours or direct labor-hours for the job Milling Assembly Manufacturing overhead applied 42 43 Step 4: Calculate the total job cost for Job 407 44 45 Direct materials 46 Direct labor cost 47 Manufacturing overhead applied Total cost of Job 407 \begin{tabular}{|l|l|c|} \hline \multicolumn{1}{c|}{ Milling } & Assembly & Total \\ \hline? & ? & ? \\ \hline? & ? & ? \\ \hline? & ? & ? \\ \hline \end{tabular} Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 53 Solling price of Job 407 \begin{tabular}{l} ? \\ ? \\ \hline \end{tabular}