x Chapter 2 Applying Excel Student Form HW - Copy - Microsoft Excel x = Review View Data Formulas File Home Page Layout Insert Number Font $10.00 Arial - 10 - A Conditional Format $ % Formatting - as Table - Sty Paste AA BIU Number Styles Alignment Clipboard D53 fo=D51+052 D B A 60,000 80,000 34 Total machine hours or direct labor-hours $8.50 $10.00 35 Predetermined overhead rate per machine-hour or direct labor-hour 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 Milling Assembly 38 39 Predetermined overhead rate per machine-hour or direct labor-hour $8.50 40 Machine-hours or direct labor-hours for the job 90 20 41 Manufacturing overhead applied $765.00 $200.00 42 43 Step 4: Calculate the total job cost for Job 407 44 Milling Assembly Total 45 Direct materials $800.00 $370.00 $1,170.00 46 Direct labor cost $70.00 $280.00 $350.00 47 Manufacturing overhead applied $765.00 $200.00 48 Total cost of Job 407 $965.00 49 $2,485.00 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 2,485.00 53 Selling price of Job 407 1.863.75 54 4618.75 CE * Chapter 2 Form Ready 2 Part 2 of 2 Required information Chapter 2: Applying Excel This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5 2.5 points Chapter 2: Applying Excel: Exercise (Part 2 of 2) eBook 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 Print 1 Chapter 2: Applying Excel 2 RE o References 3 Cost summary for Job 408 Department Milling Assembly 4 5 70 3 6 9 20 Machine-hours Direct labor-hours Direct materials cost Direct labor cost 7 $ 490 880 $ 162 $ 8 $ 380 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 UMULILAR Part 2 of 2 2.5 points 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.) eBook Selling price for Job 403 Print References 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 6,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 403