Question: What equation should I enter into the box for Total variable manufacturing overhead? A B 1 Chapter 3: Applying Excel 2 3 Data 4 Markup

What equation should I enter into the box for Total variable manufacturing overhead?

What equation should I enter into the box for Total variable manufacturing

A B 1 Chapter 3: Applying Excel 2 3 Data 4 Markup on job cost 75% 5 6 Department 7 Milling Assembly 8 Machine-hours 60,000 3,000 9 Direct labor-hours 8,000 80,000 10 Total fixed manufacturing overhead cost $390,000 $500,000 11 Variable manufacturing overhead per machine-hour $2.00 12 Variable manufacturing overhead per direct labor-hour $3.75 13 14 Cost summary for Job 407 Department 15 Milling Assembly 16 Machine-hours 90 4 17 Direct labor-hours 5 20 18 Direct materials $800 $370 19 Direct labor cost $70 $280 20 21 Enter a formula into each of the cells marked with a ? below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department 24 Milling Assembly 25 Total fixed manufacturing overhead cost $390,000 $500,000 26 Variable manufacturing overhead per machine-hour or direct labor-hour $2.00 $3.75 27 Total machine-hours or direct labor-hours 60,000 3,000 28 Total variable manufacturing overhead ? ? 29 Total manufacturing overhead #VALUE! #VALUE! 30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!