CHANGE This question will be sent to your instructor for grading Required information Chapter 2: Applying Excel This Excel worksheet relates to the Dickson Company example that is summarized in 25 Chapter 2: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in a cells that contain question marks The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text Ester forms in the cells that contain question markt. For example, in cel 825 enter the formula 10 Aer entering forms of the cells that contained question marks,verity that the amounts match the example in the text. Check your worksheet by changing the total fled manufacturing overhead cost for the Ming Department in the Data area to $300,000, keeping all other data the same as in the original emple. If your worksheet is operating property, the total cost of Job 407 should now be $2.350 H you do not get this answer. Find the errors in your worksheet and correct their You should proceed to the requirements below only after completing your worksheet. seve your completed Applying Excel form to your computer and then upload it here by clicking "browse." Next, click "Save." You will use this worksheet to answer the questions in Part 2 download reference in upload a response file (SMB max) Choose File No flichen Prey 2 Next > MacBook Pro Cut Arial 10 A A C Dm Copy v Paste BIU A Format 345 2 ? ? 2 7 ? Assembly ? ? ? Assembly 7 ? Assembly Total 26 Variable manufacturing overhead per machine hour or direct labor hour 27 Total machine-hours or direct labor hours 28 Total variable manufacturing overhead 29 Total manufacturing overhead 30 31 Stop 2: Calculate the predetermined overhead rate in each department 32 Miling 33 Total manufacturing overhead 34 Total machine hours or direct labor hours 35 Predetermined overhead rate per machine hour or direct tobor hour 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Milling 39 Predetermined overhead rate per machine hour or direct laborhout 40 Machine hours or direct laborhoun for the job 41 Manufacturing overhead applied 42 43 Step 4: Calculate the total job cost for Job 407 44 Mling 45 Direct materials 2 46 Direct labor cost 47 Manufacturing overhead applied 48 Total cost of Job 407 69 So Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 53 Seling price of Job 407 54 55 56 57 58 59 60 61 62 53 66 65 66 67 68 7 2 ? 7 7 2 2 70 71 72 71 22 Chapter 2 Form Ready CHANGE This question will be sent to your instructor for grading Required information Chapter 2: Applying Excel This Excel worksheet relates to the Dickson Company example that is summarized in 25 Chapter 2: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in a cells that contain question marks The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text Ester forms in the cells that contain question markt. For example, in cel 825 enter the formula 10 Aer entering forms of the cells that contained question marks,verity that the amounts match the example in the text. Check your worksheet by changing the total fled manufacturing overhead cost for the Ming Department in the Data area to $300,000, keeping all other data the same as in the original emple. If your worksheet is operating property, the total cost of Job 407 should now be $2.350 H you do not get this answer. Find the errors in your worksheet and correct their You should proceed to the requirements below only after completing your worksheet. seve your completed Applying Excel form to your computer and then upload it here by clicking "browse." Next, click "Save." You will use this worksheet to answer the questions in Part 2 download reference in upload a response file (SMB max) Choose File No flichen Prey 2 Next > MacBook Pro Cut Arial 10 A A C Dm Copy v Paste BIU A Format 345 2 ? ? 2 7 ? Assembly ? ? ? Assembly 7 ? Assembly Total 26 Variable manufacturing overhead per machine hour or direct labor hour 27 Total machine-hours or direct labor hours 28 Total variable manufacturing overhead 29 Total manufacturing overhead 30 31 Stop 2: Calculate the predetermined overhead rate in each department 32 Miling 33 Total manufacturing overhead 34 Total machine hours or direct labor hours 35 Predetermined overhead rate per machine hour or direct tobor hour 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Milling 39 Predetermined overhead rate per machine hour or direct laborhout 40 Machine hours or direct laborhoun for the job 41 Manufacturing overhead applied 42 43 Step 4: Calculate the total job cost for Job 407 44 Mling 45 Direct materials 2 46 Direct labor cost 47 Manufacturing overhead applied 48 Total cost of Job 407 69 So Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 52 Markup 53 Seling price of Job 407 54 55 56 57 58 59 60 61 62 53 66 65 66 67 68 7 2 ? 7 7 2 2 70 71 72 71 22 Chapter 2 Form Ready