1. Naming Cells: Individual cells, cell ranges, and tables can be named within Excel for formula ease. For example, the Total Material Subtotal (cell E15) can be named "TotalMaterialSubtotal." Going forward, cells can be referenced using words instead of the Excel coordinates. Label the completed units (cell G5), "Units." 2. Manufacturing Overhead: Review the manufacturing overhead rate in cell K9 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 Job \#26 in cell 19. Remember, your goal is to create a reusable spreadsheet. Total labor hours shou NOT be hardcoded (or typed in), but a formula should be used to accommodate variations in total hours. hours b. Now you have the bullding blocks to calculate the amount of manufacturing overhead. Calculate the manufacturing overhead in cell L9 for Job \#26. : Is the manufacturing overhead amount you found for the JOB or for EACH UNIT? The manufacturing overhead amount is found for 3. Cost Summary a. Calculate total direct materials for job #26 in cell G18. 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 G19. Hint: is the direct labor information given the total for the fob or for each unit? b. Calculate direct labor for job #26 in cell G19. 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 G20. Do not hard-code. d. Calculate the total costs for 20b=26 in cell G21. \$ e. Calculate the unit product cost for Job #26 in cell G22. s 4. Reflect on your calculation process to further understand cost concepts. o. How does manufacturing overhead differ from direct materials and direct labor? Manufacturing overhead is requires analyzation of total direct material and labor because those costs b. What variable(s) does direct labor depend on? cost, not costs, a rational method of allocating the cost, and a rate. This differs from traceable outright to producing a unit. What variable(s) do direct materials depend on? a. How does manufacturing overhead differ from direct materials and direct labor? Manufacturing overhead is requires analyzation of total direct material and labor because those costs b. What variable(s) does direct labor depend on? 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? is the most expensive part of manufacturing this job. It accounts for about cost. The least expensive part of this manufecturing job is . It is about 5. Explain how job cost sheets are used to evaluate and control costs. The input in the box below will not be graded, but may be reviewed and considered by your instructor. cost, not costs, associated with manufacturing. It costs, a rational method of allocating the cost, and a rate. This differs from traceable outright to producing a unit
