p

Please answer the last to fill in the blank answer of percentage for the job's cost.

Job-Order Sheet \begin{tabular}{|l|l|} \hline Cost Summary for Job 226 \\ \hline Direct Materials & \\ \hline Direct Labor & \\ \hline Manufacturing Overhead & \\ \hline Total Cost & \\ \hline Unit Product Cost & \\ \hline \end{tabular} a. Calculate the total hours for Job \#26 in cell J9. 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 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? 4 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? 4 c. Calculate manufacturing overhead for Job \#26 in cell G20. 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 G22. 4 4. Reflect on your calculation process to further understand cost concepts. a. How does manufacturing overhead differ from direct materlals and direct labor? Manufacturing overhead is cost, not costs, associated with manufacturing. It requires analyzation of total costs, a rational method of allocating the cost, and a rate. This differs from direct material and labor because those costs traceable outright to producing a unit. b. What variable(s) does direct labor depend on? What varlable(s) do direct materlals depend on? What varlable(s) does manufacturing overhead depend on? Manufacturing overhead depends on a variety of variables including units, hours, jobs, etc. 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 % of the job's cost