Required information This Excel workshect relates to the Dickson Company example summarized in Eatibat.5 Download the Applying Excel form and enter formulas in all cells that comtain question marks The Chopter 2 Form worksheet is to be used to create your own worksheet version of the example in the text. Enter formulas in the cells that contain question marks for example, in cell 825 enser the formula va10". Aner entering formulas in all of the celis that contained question marks, verify that the amounts mstch the example in the sext. You should proceed to the requirements below only aher completing your worksheet. Required: 1. Check your worksheet by changing the totai fined manufocturing overhead cost for the Miling Department in the Data area to 5300,000 , keeping atbther dota the same as in the original example. If your worksheet is operating property, the total cost of J106 407 should now be $2,350. If you do not get this answer, find the encrs in your worksheot and correct beem. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Nent, elick "Save"- You will use this worksheet to answer the questions in Part 2. Chapter 2: Applying Excel Data Mawie on ket cost =$390,000+$120,000=$510,000 Assembly Department Overhead Cost (Y)=$50 =$500,000+$300,000=$800,000 Step 2: Calculate the predetermined overhead rat Milling Department Overhead Rate =$510,000/ =$8.50 per machine-hour Assembly Department Overhead Rate =$800,00 =$10.00 per direct labor-hour Step 3: Calculate the amount of overhead applie Milling Department: Overhead Applied to Job 4 =$8.50 per MH90MHs =$765 Assembly Department: Overhead Applied to Joh =$10.00 per DLH 20 DLHs =$200 Step 4: Calculate the total job cost for Job 407. Step 5: Calculate the selling price for Job 407. Required information This Excel workshect relates to the Dickson Company example summarized in Eatibat.5 Download the Applying Excel form and enter formulas in all cells that comtain question marks The Chopter 2 Form worksheet is to be used to create your own worksheet version of the example in the text. Enter formulas in the cells that contain question marks for example, in cell 825 enser the formula va10". Aner entering formulas in all of the celis that contained question marks, verify that the amounts mstch the example in the sext. You should proceed to the requirements below only aher completing your worksheet. Required: 1. Check your worksheet by changing the totai fined manufocturing overhead cost for the Miling Department in the Data area to 5300,000 , keeping atbther dota the same as in the original example. If your worksheet is operating property, the total cost of J106 407 should now be $2,350. If you do not get this answer, find the encrs in your worksheot and correct beem. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Nent, elick "Save"- You will use this worksheet to answer the questions in Part 2. Chapter 2: Applying Excel Data Mawie on ket cost =$390,000+$120,000=$510,000 Assembly Department Overhead Cost (Y)=$50 =$500,000+$300,000=$800,000 Step 2: Calculate the predetermined overhead rat Milling Department Overhead Rate =$510,000/ =$8.50 per machine-hour Assembly Department Overhead Rate =$800,00 =$10.00 per direct labor-hour Step 3: Calculate the amount of overhead applie Milling Department: Overhead Applied to Job 4 =$8.50 per MH90MHs =$765 Assembly Department: Overhead Applied to Joh =$10.00 per DLH 20 DLHs =$200 Step 4: Calculate the total job cost for Job 407. Step 5: Calculate the selling price for Job 407
