Please respond to question d. The original and changed Excel worksheets are provided.
Requirement 2: Change the direct labor-hour requirement for the Deluxe model back to 5 hours in cell B10. Assume that the production orders change so that the Deluxe model Will have 240 orders in cell C19 and the Tourist model will have 260 orders in cell D19. The Data area should now look like this: (d). Which of the following statements are true concerning the effects of the change in production orders on the ABC unit product costs? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because o lower proportion of the production orders are now attributable to the Deluse model. The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because a higher proportion of the production orders are now attributabie to the Deluxe model. The ABC unit product cost of the Delixe model has decreased and the ABC unit product cost of the Tourist model has increased because a lower proportion of the production orders are now attributable to the Deluxe model. The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the fourist model has increased because a higher proportion of the production orders are now attributable to the Deluse modeL. Enter a fomiule into each of the cells maked with a ? below Review Problem: Actlvily-Based Costing Dath Enter a formula into eoch of the celis marked with a ? below Revlew Problen: Actvity Based Costing Datia Annual sales in units Dimet materials per unit Direct laborhours per unit \begin{tabular}{|r|r|} \hline Deluxe & \multicolumn{1}{|c|}{ Tourist } \\ \hline 2,000 & 10,000 \\ \hline$25 & $17 \\ \hline 5 & 4 \\ \hline \end{tabular} Direct labor rate $12 per DLH 4 5 Estimated 15 Activities and Activity Measums 17 Labor related (dimect laborthoun). 18 Machlne setups. (setups) 19 2roduction orders (orders) 20 seneral factory (machine-hours) \begin{tabular}{|c|r|r|r|} \hline Overtead & \multicolumn{3}{c|}{ Expected Activity } \\ \hline Cost & Delure & Touifst & Total \\ \hline 50,000 & 10,000 & 40,000 & 50,000 \\ \hline 150,000 & 3,000 & 2,000 & 5,000 \\ \hline 70,000 & 240 & 260 & 500 \\ \hline 250,000 & 12,000 & 28,000 & 40,000 \\ \hline 5550,000 & & & \\ \hline \end{tabular} 23 Compute the predefermined everhead rate 28 Compute the manufacturing overhead applied 29 Direct laborthoun per unit (a) 30 Predeteminied overhead rate (b) 31 Manufacturing overthead applied per unit (a) (b) \begin{tabular}{|cc} \hline Doluxe & Tounst \\ 5 DLHs & 4 DLHs \\ $11.00 per DLH & $11.00 per DLH \\ $55.00 & $44.00 \\ \hline \end{tabular} 32 Compute tradilionar tunit 34 Direct materials 35 Direct labor 35 Manufacturing overhead 37 Traditonal unlt product e 38 Comperte acelvity rates 39 Com 40 \begin{tabular}{|r|r|} \hline Deluxe & \multicolumn{1}{|r|}{ Toufist } \\ \hline 525 & $17 \\ \hline 60.00 & 48.00 \\ \hline 55.00 & 44.00 \\ \hline$140 & $109.00 \\ \hline \end{tabular} 40 41 Activitien 42 -abor rislated 43 Machine setups 44 Production orders 45 Seneml factory 46 . 47 Compute the ABC overhead cost per unit 48
