Data table Activity Allocation Base Materials handling . . . . Number of parts Machine setup ........ Number of setups Insertion of parts ..... Number of parts Finishing ............ Finishing direct labor hours Activity Cost Allocation Rate $4.50 per part $325.00 per setup $31.00 per part $51.00 per hour Requirements 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. 2. Compute the manufacturing overhead cost per wheel of each model using ABC. 3. Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per wheel under the traditional system. More info She developed an ABC system very similar to the one used by Dettling's chief rival. Part of the reason Metzgar developed the ABC system was because Dettling's prots had been declining even though the company had shifted its product mix toward the product that had appeared most profitable under the old system. Before adopting the new ABC system, the company had used a plantwide overhead rate based on direct labor hours that was developed years ago. Data table Standard Deluxe Parts per wheel ....................... 4.0 6.0 Setups per 1,000 wheels ................ 20.0 20.0 Finishing direct labor hours per wheel . . .. 1.0 3.0 Total direct labor hours per wheel ........ 2.7 3.8 The company's managers expect to produce 1,000 units of each model during the year. Several years after reengineering its production process, Dettling Corporation hired a new controller, Alana Metzgar. 0 (Click the icon to view additional information.) For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: @ (Click the icon to view the additional data.) The number of parts is now a feasible allocation base because Dettling recently installed a plantwide computer system. Dettling produces two wheel models: Standard and Deluxe. Budgeted data for the upcoming year are as follows: (Click the icon to view the additional data.) Read the @uirements. Requirement 1. Compute the total budgeted manufacturing overhead cost forthe upcoming year. (Enter the rates to two decimal places.) Dettling Corporation Total Budgeted Indirect Manufacturing Costs Activity Budgeted Quantity of Cost Allocation Base Activity Cost Allocation Rate Total Budgeted Indirect Cost Materials handling Machine setups Insertion of parts Finishing Total budgeted indirect cost | | | Requirement 2. Compute the manufacturing overhead cost per wheel of each model using ABC. (Round the cost allocation base to three decimals and cost per wheel to the nearest cent.) Dettling Corporation ABC Indirect Manufacturing Cost per Unit Cost Quantity of Cost Allocation Allocated Activity Activity Allocation Rate Base Used By: Cost Per Wheel Standard Deluxe Standard Deluxe Materials handling I Machine setup I: Insertion of parts I Finishing Total ABC allocated indirect cost HW Requirement 3. Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per wheel under the traditional system. Begin by identifying the formula to compute the current plantwide manufacturing overhead rate, then compute the rate. (Round your answer to the nearest cent.) ' + l : Plantwide overhead rate I + = per DL hour Now use the plantwide overhead rate to determine the manufacturing overhead cost per wheel. (Round your answers to the nearest cent.) Standard I Deluxe |:| x Manufacturing overhead | | |:| X ll X H