A Chapter 2: Applying Excel Data Markup on job cost 75% Department Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour Cost summary for Job 407 Machine-hours Direct labor-hours Direct materials Direct labor cost Milling 60,000 Assembly 8,000 $390,000 3,000 80,000 $500,000 $2.00 $375 Department \begin{tabular}{|r|r|} Milling & Assembly \\ 90 & 4 \\ 5 & 20 \\ $800 & $370 \\ $70 & $280 \\ \hline \end{tabular} Enter a formula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 25 Total fixed manufacturing overhead cost 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 Step 2: Calculate the predetermined overhead rate in each department