Chapter 2: Applying Excel Da Markup on job t Machine hours Direct labor-hours Total fed manufacturing overhead co " Variable manufacturing overhead per machine-hour 12 Variable manufacturing overhead per direct labor-hour 14 Cost summary for Job 408 Machine-hou Direct labor-hours Direct materia " Direct labor ot 30 21 75%6 Department Ming Assembly 60,000 8,000 $390,000 3.000 80,000 $500,000 $2.00 $3.75 Department Ming Assembly $300 $50 $150 2 14 " Total fed manufacturing overhead cost 31 Tuta machine-hours or direct labor hours " Total variable manufacturing Variable manufacturing overhead per machine-hour or direct labor-hour Total manufacturing overheat Step 2: Calculate the predetermined overhead rate in each department Mng Assembly $390,000 $500,000 $120,000 $300,000 $510.000 $400.000 . Req. 2: Enter the new data given for requiment 2 on page 48-455, or page 78 of the textbook in the green cells at the left. After the data is entered, check your work, then answer the question below. gnore the note in the textbook reganing changing the job number in this Excel file as the Job number has alread been upated What is the new Selling Price for Job 408? Ming Assembly Instructions- Formulas Reg 1 Ch2- Beg 2 Ch2- Reg3Ch2- Req 4 Ch2- Check My Work