a$.$ 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 ty a formula should be used to accommodate variations in total hours.

$ $$ X 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.$

$ $x$

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 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 G$21.$

Email Instructor

Save and Exit

Submit Assignment for Grac