ok Required information This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5 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 C 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 Department 4 Miling Assembly 5 Machine-hours 6 Direct labor-hours 90 7 2 40 7 Direct materials cost $ 700 $ 360 Direct labor cost $ 126 $ 640 B 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 Job 408 Prey 1 of 1 Next Required information 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.) Seiling price for Job 408 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total number of machine- hours in the Assembly Department increases from 3,000 machine-hours to 5,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 labor-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.) Selling price for Job 408 eBook appears earlier in the chapter. 2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C Print 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $ 365,400 6 Estimated total amount of the allocation base 58,000 machine-hours 7 Actual manufacturing overhead cost $ 374,300 Actual total amount of the allocation base 8 57,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate per machine-hour ints 1 eBook Print Required information (b) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 3. Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer back to this worksheet. Change the estimated total amount of the allocation base to 63,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A 1 Chapter 3: Applying Excel B C 2 3 Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $ 365,400 6 Estimated total amount of the allocation base 63,000 machine-hours e a4 son Required information A B C 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hour Book 5 Estimated manufacturing overhead cost $ 365,400 6 Estimated total amount of the allocation base 63,000 machine-hours 7 Actual manufacturing overhead cost. $ 374,300 Print B Actual total amount of the allocation base 57,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead Required information (b) Why is the amount of underapplied (overapplied) manufacturing overhead different from Requirement 2 above? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answers. Any boxes left with a question mark will be automatically graded as incorrect.) The change in the estimated total amount of the allocation base affected the predetermined overhead rate. Book The change in the estimated total amount of the allocation base affected the amount of manufacturing overhead applied. Pint Actual manufacturing overhead cost differs from period to period. The estimated manufacturing overhead cost did not change in proportion to the change in the estimated total amount of the allocation base. 4. Change the estimated total amount of the allocation base back to 58,000 machine-hours, so that the data area of you worksheet looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $374,300 to $376,200. The data area of your worksheet should now look like this: A B 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hours S Estimated manufacturing overhead cost $ 365,400 6 Estimated total amount of the allocation base 58,000 machine-hours 7 Actual manufacturing overhead cost $ 376.200 Actual total amount of the allocation base 57,000 machine-hours 8 1 mits mama man in new mance in non in me enanne meme con Required Information 4. Change the estimated total amount of the allocation base back to 58,000 machine-hours, so that the data area of you worksheet looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $374,300 to $376,200. The data area of your worksheet should now look like this: A B C 1 Chapter 3: Applying Excel eBook 2 14 3 Data 4 Allocation base Machine-hours Print 5 Estimated manufacturing overhead cost $ 365,400 6 Estimated total amount of the allocation base 58,000 machine-hours 7 Actual manufacturing overhead cost $ 376,200 Actual total amount of the allocation base 57,000 machine-hours 8 (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead Book Print Mc Required information (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead (b) Why is the amount of underapplied (overapplied) manufacturing overhead different from Requirement 2 above? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answers. Any boxes left with a question mark will be automatically graded as incorrect.) The predetermined overhead rate changed 2 The change in the actual manufacturing overhead cost directly resulted in a comparable change in the amount of underapplied toverapplied) manufacturing overhead The change in the estimated total amount of the allocation base affected the amount of manufacturing overhead applied Prev 1 of 1 Next