This is a Multipart question, each part is a separate page, not sure if that matters.

I know nothing about the class so if possible can I get the answers super clear with answers and parts corresponding.

THANK YOU SO MUCH!

I tell everyone I know about this amazing website!

4 Data Markup on job cost 75% 5 7 D Department Milling Assembly 60,000 3,000 8,000 80,000 $390.000 $500,000 S2.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 407 15 16 Department Milling Assembly 90 4 5 20 $800 $370 S70 $280 Machine hours Direct labor-hours Drect materials Direct labor cost 17 18 19 20 21 Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. 22 33 Step 1: Calculate the estimated total manufacturing overhead cost for each department Milling Assembly 2 2 26 27 Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? ? ? ? ? 2 ? ? 29 30 31 Step 2: Calculate the predetermined overhead rate in each department a2 Milling Assembly 33 14 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 7 ? ? 36 P. Stap 3: Calculate the amount of overhead applied from both departments to Job 407 Milling ? 39 Predetermined overhead rate per machine-hour or direct labor-hour 40 Machine-hours or direct labor-hours for the job Manufacturing overhead applied Assembly ? 2 2 7 ? 41 42 23 Step 4: Calculate the total job cost for Job 407 Milling Total ? Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 407 2 2 ? Assembly 2 ? 2 2 ? ? 49 30 51 ? Step 5: Calculate the selling price for Job 407 Total cost of Job 407 Markup Selling price of Job 407 52 ? ? 54 1 Chapter 2: Applying Excel 2 Data Markup on job cost Req. 1: Enter $300,000 for the green Total fixed manufacturing overhead cost cell in the Milling Department data section at the left. If your formulas are correct the total cost of Job 407 should now be $2,350. If not, go back to the formulas page, make corrections, press the copy formulas button, and recheck your answers until they are correct. When correct answer the questions below. 2 75% 5 b 7 B How much is the Selling Price of Job 407? 9 Department Milling Assembly 60,000 3,000 8,000 80,000 ? $500,000 52.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cast summary for Job 407 15 Did the Selling Price of Job 407 change? Why or why not? 16 Machine-hours Direct labor-hours Direct materials Direct labor cost Department Milling Assembly 90 4 5 20 S000 $370 $70 $280 10 19 20 21 22 23 24 Milling Accombly 25 ? 26 ? Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? 2 2 28 ? 29 ? ? 30 31 22 Step 2: Calculate the predetermined overhead rate in each department Milling Assembly 33 2 7 34 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 2 35 36 ST Step 3: Calculate the amount of overhead applied from both departments to Job 407 30 Milling Assembly 39 ? 7. 40 Predetermined overhead rate per machine-hour or direct labor-hour Machine hours or direct labor-hours for the job Manufacturing overhead applied ? 2 ? ? 41 Step 4: Calculate the total job cost for Job 407 44 Milling Total Assembly 7. P. 2 45 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 407 2 2 2 ? 2 ? ? ? ? 50 Step 5: Calculate the selling price for Job 407 Total cost of Job 407 Markup Selling price of Job 407 2 ? ? ? 54 55 B D Chapter 2: Applying Excel E H Req.2: Enter the data from requirment 2 on page 85of the text in the green cells for Job 408 at the left. Data Markup on job cost 1 75% 5 7 8 What is the new Selling Price for Job 408? Department Milling Assembly 60,000 3,000 8,000 80,000 $390.000 $500 000 $2.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 408 15 10 17 Machine-hours Direct labor-hours Direct materials Direct labor cost Department Milling Assembly 7. ? 2 ? ? ? 2 7 19 21 24 Milling Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead 26 Assembly ? ? ? ? ? ? ? ? 2 ? 29 2 30 31 22 Step 2: Calculate the predetermined overhead rate in each department Milling Assembly 2 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 35 2 2 Total manufacturing overhead Total machine hours or direct labor hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? 7 ? 7 ? 34 35 30 17 38 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling 19 ? Predetermined overhead rate per machine hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied Assembly ? ? 7 ? 11 2 12 P. 3 13 Step 4: Calculate the total job cost for Job 408 Milling Total 2 45 46 Assembly 7 ? 2 2 2 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? 2 2 ? 18 49 30 51 ? Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 12 53 14 2 2 1 Chapter 2: Applying Excel Req. 3: Change the total number of Assembly Department machine hours in green cell at the left to 6,000 hours. 2 Data Markup on job cast 4 75% 5 6 Did the new Selling Price for Job 408 change compared to req. 2? Department Milling Assembly 60,000 ? 8,000 80,000 $390,000 $500,000 $2.00 53.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cast summary for Job 408 15 Why or why not? 16 Department Milling Assembly 90 4 5 20 $800 $370 $70 $280 Machine-hours Direct labor-hours Direct materials 17 18 Direct labor cost 10 20 21 22 22 24 Milling 25 7 Assembly 7 ? ? 26 2 Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead 27 28 ? ? 7 ? 29 7 30 31 Step 2: Calculate the predetermined overhead rate in each department 32 Milling Assembly 93 ? Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? 34 ? 2 23 7 ? 34 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour 7 2 ? 95 ? 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling Assembly 32 2 40 Predetermined overhead rate per machine-hour or direct labor-hour Machine hours or direct labor-hours for the job Manufacturing overhead applied ? ? ? 2 41 ? 43 Step 4: Calculate the total job cost for Job 408 P. Milling Total Assembly 2 45 ? 7 ? 7 ? 47 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? ? ? 2 40 50 Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 12 ? ? ? 33 54 Chapter 2: Applying Excel Req. 4: Change the total number or Assembly Department direct labor hours in green cell at the left to 50,000 hours. 2 2 Data Markup on job cast 4 75% 5 Did the new Selling Price for Job 408 change compared to req. 2? Department Milling Assembly 60.000 3.000 8,000 ? $390,000 $500,000 $2.00 $3.75 Machine-hours Direct labor hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 408 15 Why or why not? 16 Department Milling Assembly 90 4 5 20 $800 $370 $70 $280 Machine-hours Direct labor-hours Direct malerials Direct labor cost 17 18 19 21 28 28 Milling Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? ? ? ? Assembly 2 ? 2 ? ? 31 32 Step 2: Calculate the predetermined overhead rale in each department Milling Assembly ? 2 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor hour ? ? ? 35 7 Step 2: Calculate the predetermined overhead raie in each department Milling 33 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour 34 Assembly ? ? ? ? ? 7 35 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling 29 Predetermined overhead rate per machine-hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied 00 Assembly ? ? ? ? ? ? Step 4: Calculate the total job cost for Job 408 P.5 Milling Assembly Total 7 2 ? ? Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? ? ? 2 2 90 Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 ? ? ? 53 4 Data Markup on job cost 75% 5 7 D Department Milling Assembly 60,000 3,000 8,000 80,000 $390.000 $500,000 S2.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 407 15 16 Department Milling Assembly 90 4 5 20 $800 $370 S70 $280 Machine hours Direct labor-hours Drect materials Direct labor cost 17 18 19 20 21 Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. 22 33 Step 1: Calculate the estimated total manufacturing overhead cost for each department Milling Assembly 2 2 26 27 Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? ? ? ? ? 2 ? ? 29 30 31 Step 2: Calculate the predetermined overhead rate in each department a2 Milling Assembly 33 14 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 7 ? ? 36 P. Stap 3: Calculate the amount of overhead applied from both departments to Job 407 Milling ? 39 Predetermined overhead rate per machine-hour or direct labor-hour 40 Machine-hours or direct labor-hours for the job Manufacturing overhead applied Assembly ? 2 2 7 ? 41 42 23 Step 4: Calculate the total job cost for Job 407 Milling Total ? Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 407 2 2 ? Assembly 2 ? 2 2 ? ? 49 30 51 ? Step 5: Calculate the selling price for Job 407 Total cost of Job 407 Markup Selling price of Job 407 52 ? ? 54 1 Chapter 2: Applying Excel 2 Data Markup on job cost Req. 1: Enter $300,000 for the green Total fixed manufacturing overhead cost cell in the Milling Department data section at the left. If your formulas are correct the total cost of Job 407 should now be $2,350. If not, go back to the formulas page, make corrections, press the copy formulas button, and recheck your answers until they are correct. When correct answer the questions below. 2 75% 5 b 7 B How much is the Selling Price of Job 407? 9 Department Milling Assembly 60,000 3,000 8,000 80,000 ? $500,000 52.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cast summary for Job 407 15 Did the Selling Price of Job 407 change? Why or why not? 16 Machine-hours Direct labor-hours Direct materials Direct labor cost Department Milling Assembly 90 4 5 20 S000 $370 $70 $280 10 19 20 21 22 23 24 Milling Accombly 25 ? 26 ? Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? 2 2 28 ? 29 ? ? 30 31 22 Step 2: Calculate the predetermined overhead rate in each department Milling Assembly 33 2 7 34 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 2 35 36 ST Step 3: Calculate the amount of overhead applied from both departments to Job 407 30 Milling Assembly 39 ? 7. 40 Predetermined overhead rate per machine-hour or direct labor-hour Machine hours or direct labor-hours for the job Manufacturing overhead applied ? 2 ? ? 41 Step 4: Calculate the total job cost for Job 407 44 Milling Total Assembly 7. P. 2 45 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 407 2 2 2 ? 2 ? ? ? ? 50 Step 5: Calculate the selling price for Job 407 Total cost of Job 407 Markup Selling price of Job 407 2 ? ? ? 54 55 B D Chapter 2: Applying Excel E H Req.2: Enter the data from requirment 2 on page 85of the text in the green cells for Job 408 at the left. Data Markup on job cost 1 75% 5 7 8 What is the new Selling Price for Job 408? Department Milling Assembly 60,000 3,000 8,000 80,000 $390.000 $500 000 $2.00 $3.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 408 15 10 17 Machine-hours Direct labor-hours Direct materials Direct labor cost Department Milling Assembly 7. ? 2 ? ? ? 2 7 19 21 24 Milling Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead 26 Assembly ? ? ? ? ? ? ? ? 2 ? 29 2 30 31 22 Step 2: Calculate the predetermined overhead rate in each department Milling Assembly 2 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? ? 35 2 2 Total manufacturing overhead Total machine hours or direct labor hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? 7 ? 7 ? 34 35 30 17 38 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling 19 ? Predetermined overhead rate per machine hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied Assembly ? ? 7 ? 11 2 12 P. 3 13 Step 4: Calculate the total job cost for Job 408 Milling Total 2 45 46 Assembly 7 ? 2 2 2 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? 2 2 ? 18 49 30 51 ? Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 12 53 14 2 2 1 Chapter 2: Applying Excel Req. 3: Change the total number of Assembly Department machine hours in green cell at the left to 6,000 hours. 2 Data Markup on job cast 4 75% 5 6 Did the new Selling Price for Job 408 change compared to req. 2? Department Milling Assembly 60,000 ? 8,000 80,000 $390,000 $500,000 $2.00 53.75 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cast summary for Job 408 15 Why or why not? 16 Department Milling Assembly 90 4 5 20 $800 $370 $70 $280 Machine-hours Direct labor-hours Direct materials 17 18 Direct labor cost 10 20 21 22 22 24 Milling 25 7 Assembly 7 ? ? 26 2 Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead 27 28 ? ? 7 ? 29 7 30 31 Step 2: Calculate the predetermined overhead rate in each department 32 Milling Assembly 93 ? Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? 34 ? 2 23 7 ? 34 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour 7 2 ? 95 ? 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling Assembly 32 2 40 Predetermined overhead rate per machine-hour or direct labor-hour Machine hours or direct labor-hours for the job Manufacturing overhead applied ? ? ? 2 41 ? 43 Step 4: Calculate the total job cost for Job 408 P. Milling Total Assembly 2 45 ? 7 ? 7 ? 47 Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? ? ? 2 40 50 Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 12 ? ? ? 33 54 Chapter 2: Applying Excel Req. 4: Change the total number or Assembly Department direct labor hours in green cell at the left to 50,000 hours. 2 2 Data Markup on job cast 4 75% 5 Did the new Selling Price for Job 408 change compared to req. 2? Department Milling Assembly 60.000 3.000 8,000 ? $390,000 $500,000 $2.00 $3.75 Machine-hours Direct labor hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour 10 11 12 13 14 Cost summary for Job 408 15 Why or why not? 16 Department Milling Assembly 90 4 5 20 $800 $370 $70 $280 Machine-hours Direct labor-hours Direct malerials Direct labor cost 17 18 19 21 28 28 Milling Total fixed manufacturing overhead cost Variable manufacturing overhead per machine hour or direct labor-hour Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? ? ? ? ? Assembly 2 ? 2 ? ? 31 32 Step 2: Calculate the predetermined overhead rale in each department Milling Assembly ? 2 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor hour ? ? ? 35 7 Step 2: Calculate the predetermined overhead raie in each department Milling 33 Total manufacturing overhead Total machine-hours or direct labor-hours Predetermined overhead rate per machine-hour or direct labor-hour 34 Assembly ? ? ? ? ? 7 35 36 37 Step 3: Calculate the amount of overhead applied from both departments to Job 408 Milling 29 Predetermined overhead rate per machine-hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied 00 Assembly ? ? ? ? ? ? Step 4: Calculate the total job cost for Job 408 P.5 Milling Assembly Total 7 2 ? ? Direct materials Direct labor cost Manufacturing overhead applied Total cost of Job 408 ? ? ? 2 2 90 Step 5: Calculate the selling price for Job 408 Total cost of Job 408 Markup Selling price of Job 408 ? ? ? 53