Cost Analysis of Job$-$Order Sheets Completing this activity will help you learn to: $1.$ build calculations to find cumulative costs and unit costs for a manufacturing job. $2.$ understand and utilize a manufacturing overhead rate. $3.$ understand what variable the direct labor, direct materials and manufacturing overhead costs depend on $($hours$,$ units, etc.$).4.$ reflect and utilize the helpful information you created in the job$-$order sheet. Case scenario: You are working at a manufacturing plant. You do not have the specific identification of the good sold. You are given the buliding blocks of cost $($labor$,$ materials, etc.$)$ for Job # $26,$ which your plant completed. Your company accumulates cost per job on a job: Order Sheet. Required: Build a spreadsheet to calculate a manufacturing job's total cost and unit product cost. This lab uses "Job o$26"$ information. HINT: STEP$-$BY$.$STEP WALKTHROUGH To help you get started, the fle already has a yob order costs sheet populated with information, To complete the task, complete the following steps: $1.$ Naming Celis: Individual ceils, cell ranges, and tables can be named within Excel for formula ease. For example, the Total Material Subtotal $($cell E$15)$ can be named "TotalMaterialsubtotal." Golng forward, cells can be referenced using words instead of the Excel$(?)$ This spreadsheet has missing fonts.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: $1.$ Naming Celis: Individual cells, cell ranges, and tables can be named within Excel for formula ease, For example, the Total Material Subtotal $($cell E$15)$ can be named "TotalMaterialSubtotal." Going forward, cells can be referenced using words instead of the Excel coordinates. Label the completed units $($cell G$5),$ "Units." $2.$ Manufacturing Overhead: Review the manufacturing overhead rate in cell K$9$ of the job$-$order spreadsheet and observe how the manufacturing overhead is allocated for Job #$26.($Hint: $"$DLH$"$ stands for Direct Labor Hours$).$ a$.$ Calculate the total hours for $30$b$=26$ in cell $19.$ 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. hours b$.$ Now you have the bulding blocks to calculate the amount of manufacturing overhead. Calculate the manufacturing overheod in cell $19$ for $30$ b $ $26.$ Is the manufacturing overhead amount you found for the $3$ O B or for EACH UNIT? The manufacturing overhead amount is found for $3.$ Cost Summary a$.$ Calculate total direct materials for $30$b$=26$ in cell G$18.$ Hint: is the direct material information given the total for the job or for each unit?$3.$ Cost Summary a$.$ Calculate total direct materials for J $0$ b # $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 $426$ 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 $10$b# $26$ in cell G$20.$ Do not hard$-$code. d$.$ Calculate the total costs for Job $\backslash$pi $26$ in cell $621.$ e$.$ Calculate the unit product cost for Job $=26$ in cell G $22.4.$ 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 cost$,$ not costs, associated with manufacturing. It requires analyzation of tota costs, a rational method of allocating the cost, and a rate. This differs from direct material and labor because those costs are. treceable outriaht to producing a unit.

Job$-$Order Sheet

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

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

Department $1$ Units Completed $19$

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$ $$35\mathrm{.}00$ $$35\mathrm{.}001234563$ $$40\mathrm{.}00$ $$120\mathrm{.}00$ $$5\mathrm{.}00$

$52$D $10$ $$0\mathrm{.}21$ $$2\mathrm{.}102345672$ $$55\mathrm{.}00$ $$110\mathrm{.}00$

$60$A $1$ $$80\mathrm{.}00$ $$80\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 $$117\mathrm{.}10$ Total Hours $5$ $$230\mathrm{.}00$ Total MOH $$0\mathrm{.}00$

Cost Summary for Job #$26$

Direct Materials

Direct Labor

Manufacturing Overhead

Total Cost

Unit Product Cost