Chapter 2: Applying Excel: Exercise (Part 2 of 2) 2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A B 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 4 5 Machine-hours Direct labor-hours Direct materials cost Direct labor cost Department Milling Assembly 60 3 9 40 760$ 460 1715 800 6 7 $ $ 8 In your worksheet, enter this new data in the cells for Job 407 What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) Selling price for lob 408 3. Without changing the data for the job from requirement 2 above what is the selling price for Job 408 of the total number of machine hours in the Assembly Department increases from 3.000 machine-hours to 4 000 machine hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 4 Restore the total number of machine-hours in the Assembly Department to 3.000 machine-hours. And keep the job data the same as it was in Requirement 2. What is the selling price for Job 408 if the total number of direct tabor hours in the Assembly Department decreases from 80.000 direct labor hours to 40.000 direct labor-hours? (Round your final answer to 2 decimal places) Solling price for Job 40B Problem 2-19 Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4) High Desert Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which departmental predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Molding Department is based on machine hours, and the rate in the Painting Department is based on direct labor hours. At the beginning of the year, the company provided the following estimates. Direct labor-hours Machine-hours Fixed manufacturing overhead cost Variable manufacturing overhead per sachine-hour Variable manufacturing overhead per direct labor hour Department Molding Painting 33,000 59,700 35,000 35,000 $212,500 $537,300 $ 4.00 Job 205 was started on August 1 and completed on August 10. The company's cost records show the following information concerning the job Direct labor hours Machine-hours Direct materials Direct labor cost Department Molding Painting 74 13e 320 73 $934 $1,200 57ee $ 960 Required: 1. Compute the predetermined overhead rates used in the Molding Department and the Painting Department 2. Compute the total overhead cost applied to Job 205. 3-a. What would be the total manufacturing cost recorded for Job 205? 3-6. If the job contained 29 units, what would be the unit product cost? Complete this question by entering your answers in the tabs below. Roq 1 Roq 2 Req 3A Reg 3B Compute the Predetermined Overhead Rates used in the Molding Department and the Painting Department. (Round your answers to 2 decimal places.) Prodetermined Overhead Rate Molding Department $ 5 30 per MH Painting Department $ 13.80 per DLH Req 2 > Reg 1 Reg 2 Reg 3A Req 3B Compute the total overhead cost applied to Job 205. (Round "Predetermined overhead rate" to 2 decimal places. Round other intermediate calculations and final answers to the nearest daliar amount.) Total overhead cost s 3.490 Req 1 Reg 2 Req 3A Req 38 What would be the total manufacturing cost recorded for Job 205? (Round "Predetermined overhead rate" to 2 decimal places Round other intermediate calculations and final answers to the nearest dollar amount.) Total 2.134 Direct materials Direct labor Manufacturing overhead Total cost Department Molding Painting 934 $ 1,200 $ 700 960 1,696 1,794 3,330 $ 3,954 $ 1.660 3,490 7.284 $ Req1 Reg 2 Req 3A Reg 3B If the job contained 29 units, what would be the unit product cost? (Round "Predetermined overhead rate" to 2 decimal places. Round other intermediate calculations to the nearest dollar amount. Round your final answer to 2 decimal places.) Unit product cost $ 251 17 per unit Reg 1 Reg 2 Reg 3A Req 3B Compute the total overhead cost applied to Job 205. (Round "Predetermined overhead rate" to 2 decimal places. Round other intermediate calculations and final answers to the nearest daliar amount.) Total overhead cost s 3.490 Req 1 Reg 2 Req 3A Req 38 What would be the total manufacturing cost recorded for Job 205? (Round "Predetermined overhead rate" to 2 decimal places Round other intermediate calculations and final answers to the nearest dollar amount.) Total 2.134 Direct materials Direct labor Manufacturing overhead Total cost Department Molding Painting 934 $ 1,200 $ 700 960 1,696 1,794 3,330 $ 3,954 $ 1.660 3,490 7.284 $ Req1 Reg 2 Req 3A Reg 3B If the job contained 29 units, what would be the unit product cost? (Round "Predetermined overhead rate" to 2 decimal places. Round other intermediate calculations to the nearest dollar amount. Round your final answer to 2 decimal places.) Unit product cost $ 251 17 per unit