Build a spreadsheet to calculate a manufacturing job's total cost and unit product cost. This lab uses "Job #$26"$ information HINT: STEP$-$BY$-$STEP WALKTHROUGH

To help you get started, the file already has a job order costs sheet populated with information. To complete the task, complete the following steps;

Naming Cells: Individual cells, cell ranges, and tables can be named within Excel for formula ease. For example, the Total Materiat Subtal $($ceell referenced using words instead of the Excel coordinates. Label the completed units $($cell G$5),$ "Units." Manufacturing Overhead: Review the manufacturing overhead rate in cell $K9$ of the job$-$order spreadsheet and observenty Hours$)$

Che mafacturing overhead is allocated for Job $=26.($Hint: $"$DLH$"$ stands for Direct Labor

$1$ more Check My Work uses remaining variations in total hours.

hours

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

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

The manufacturing overhead amount is found fo

Cost Summary

a$.$ 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?

b$.$ 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?

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

d$.$ Calculate the total costs for Job $=26$ in cell $G21$

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

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

Reflect on your calculation process to further understand cost concepts.

a$.$ How does manufacturing overhead differ from direct materials and direct labor?

Manufacturing overhead is

$2cost,$ not

$$

osts, associated with manufacturing. It requires analyzation of total

What variable$($s$)$ does direct labor depend on$?$ traceable outright to producing a unit.

What variable$($s$)$ do direct materials depend on$?$

What variable$($s$)$ does manufacturing overhead depend on$?$

c$.$ What information can you gleam from the job$-$cost spreadsheet? What is the most expensive part of the job? least expensive?

The least expensive part of this manufacturing iob is $?$

$5.$ Explain how job cost sheets are used $to$ evaluate and control costs. $Itis$ abou $\%of$ the job's cost.

The input in the box below will not be graded, but may be reviewed a

and considered by your instructor.