Job$-$Order Sheet

Customer ABC, Inc. Date Initiated $4/1/2020$

Job Number $26$ Date Completed $4/30/2020$

Department $1$ Units Completed $17$

Direct Materials per Unit Direct Labor per Unit Job Manufacturing Overhead $($MOH$)$

Item # Utilized per Unit Amount Subtotal Employee # Hours Amount Subtotal Hours DLH Rate Amount

$52$B $1$ $$40\mathrm{.}00$ $$0\mathrm{.}001234562$ $$45\mathrm{.}00$ $$0\mathrm{.}00$ $$6\mathrm{.}00$

$52$D $10$ $$0\mathrm{.}19$ $$0\mathrm{.}002345672$ $$55\mathrm{.}00$ $$0\mathrm{.}00$

$60$A $1$ $$75\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$

$$0\mathrm{.}00$ $$0\mathrm{.}00$

$$0\mathrm{.}00$ $$0\mathrm{.}00$

$$0\mathrm{.}00$ $$0\mathrm{.}00$

Total Materials $$0\mathrm{.}00$ Total Hours $0$ $$0\mathrm{.}00$ Total MOH $$0\mathrm{.}00$

Cost Summary for Job #$26$

Direct Materials

Direct Labor

Manufacturing Overhead

Total Cost

Unit Product Cost Calculate the total hours for Job #$26$ in cell J$9.$ Remember, your goal is to create a reusable spreadsheet. Total labor hours should NOT be hardcoded $($or typed in$),$ but a formula should be used to accommodate variations in total hours.

fill in the blank $2$

hours

Now you have the building blocks to calculate the amount of manufacturing overhead. Calculate the manufacturing overhead in cell L$9$ for Job #$26.$

$fill in the blank $3$

Is the manufacturing overhead amount you found for the JOB or for EACH UNIT?

The manufacturing overhead amount is found for

Job #$26$

$.$

Cost Summary

Calculate total direct materials for Job #$26$ in cell G$18.$ Hint: Is the direct material information given the total for the job or for each unit?

$fill in the blank $5$

Calculate direct labor for Job #$26$ in cell G$19.$ Hint: Is the direct labor information given the total for the job or for each unit?

$fill in the blank $6$

Calculate manufacturing overhead for Job #$26$ in cell G$20.$ Do not hard$-$code.

$fill in the blank $7$

Calculate the total costs for Job #$26$ in cell G$21.$

$fill in the blank $8$

Calculate the unit product cost for Job #$26$ in cell G$22.$

$fill in the blank $9$