A Cost drivers information - X Variable Department Cost Driver MOH in 2018 Design CAD design-hours $ 42,000 Engineering Engineering-hours 30,000 Production Machine-hours 240,000 $ Total 312,000 Use of Cost Drivers by Customer Northern Hamlet Jupiter Motors Motors Vehicle 115 202 83 85 78 237 120 2.800 1,080 Print Done Parts World (PW) designs, manufactures, and sells automotive parts. Actual variable manufacturing overhead costs for 2018 were $312,000. PW's simple costing system allocates variable manufacturing overhead to its three customers based on machine-hours and prices its contracts based on full costs. One of its customers has regularly complained of being charged non-competitive prices, so PW's controller, Devon Johnson, realizes that it is time to examine the consumption of resources more closely. PW has three main operating departments: design, engineering, and production Designthe design of parts, using state-of-the-art, computer-aided design (CAD) equipment Engineeringthe prototyping of parts and testing of their specifications. . Productionthe manufacture of parts. Interviews with the department personnel and examination of time records yield the following detailed information. E: (Click the icon to view the cost drivers information.) Required Determine the formula needed to calculate overhead using the simple costing method and then calculate PW's variable manufacturing overhead rate for 2018. (Round your answer to the nearest cent.) Variable overhead rate - Simple costing per machine-hour Calculate the overhead allocated to each customer using the simple costing method. (Round your answers to the nearest cent.) Northern Hamlet Jupiter Motors Motors Motors Total Variable overhead allocations (simple costing system) Requirement 2. Compute the variable manufacturing overhead rate for 2018 and the variable manufacturing overhead allocated to each customer in 2018 using department-based variable overhead rates. Determine the formula used to calculate the department-based variable manufacturing overhead rates: Variable overhead rate by department PW's 2018 variable manufacturing overhead rates by department are as follows. Variable Manufacturing Overhead Rate (by Department) Department per Design Engineering Production per per Calculate the overhead allocated to each customer, by department, using the departmental variable manufacturing overhead rates calculated in the previous step. Calculate the total overhead cost for each department and each customer. Northern Hamlet Jupiter Motors Motors Motors Total Department Design Engineering Production Total Requirement 3. Comment on your answers in requirements 1 and 2. Which customer do you think was complaining about being overcharged in the simple system? If the new department-based rates are used to price contracts, which customer(s) will be unhappy? How would you respond to these concerns? Under the simple costing system, was likely unhappy about its bill because the contract appears to have been If the new department-based rates are used to price contracts, will likely be happier about its bill. If the new department-based rates are used to price contracts, will likely be unhappy. This is because their bills under the simple costing system appear to have been Using the department-based rates, their bills will be If the new department-based rates are used, PW should explain to the unhappy customers how the calculation was done and point out their high use of relative to Requirement 4. How else might PW use the information available from its department-by-department analysis of variable manufacturing overhead costs? Other than for pricing, PW can also use the information from the department-based system to its own operations so that there is maximum value V from all indirect resources. It might set targets over time to both the consumption of each indirect resource and the unit costs of the resources. The department-based system gives PW more opportunities for targeted cost management Requirement 5. PW's managers are wondering if they should further refine the department-by-department costing system into an ABC system by identifying different activities within each department. Under what conditions would it not be worthwhile to further refine the department costing system into an ABC system? (Round the percentage to the nearest whole percent.) It worthwhile to further refine the costing system into an ABC system if there by CAD design-hours, then the more refined system would be among contracts in the consumption of activities within a department. If, for example, most activities within the design department were, in fact, driven V than the department-based cost system. Even if there were sufficient variation, considering the relative sizes of the three department cost pools, it to further analyze the production cost pool, which consumes % of the manufacturing overhead. A Cost drivers information - X Variable Department Cost Driver MOH in 2018 Design CAD design-hours $ 42,000 Engineering Engineering-hours 30,000 Production Machine-hours 240,000 $ Total 312,000 Use of Cost Drivers by Customer Northern Hamlet Jupiter Motors Motors Vehicle 115 202 83 85 78 237 120 2.800 1,080 Print Done Parts World (PW) designs, manufactures, and sells automotive parts. Actual variable manufacturing overhead costs for 2018 were $312,000. PW's simple costing system allocates variable manufacturing overhead to its three customers based on machine-hours and prices its contracts based on full costs. One of its customers has regularly complained of being charged non-competitive prices, so PW's controller, Devon Johnson, realizes that it is time to examine the consumption of resources more closely. PW has three main operating departments: design, engineering, and production Designthe design of parts, using state-of-the-art, computer-aided design (CAD) equipment Engineeringthe prototyping of parts and testing of their specifications. . Productionthe manufacture of parts. Interviews with the department personnel and examination of time records yield the following detailed information. E: (Click the icon to view the cost drivers information.) Required Determine the formula needed to calculate overhead using the simple costing method and then calculate PW's variable manufacturing overhead rate for 2018. (Round your answer to the nearest cent.) Variable overhead rate - Simple costing per machine-hour Calculate the overhead allocated to each customer using the simple costing method. (Round your answers to the nearest cent.) Northern Hamlet Jupiter Motors Motors Motors Total Variable overhead allocations (simple costing system) Requirement 2. Compute the variable manufacturing overhead rate for 2018 and the variable manufacturing overhead allocated to each customer in 2018 using department-based variable overhead rates. Determine the formula used to calculate the department-based variable manufacturing overhead rates: Variable overhead rate by department PW's 2018 variable manufacturing overhead rates by department are as follows. Variable Manufacturing Overhead Rate (by Department) Department per Design Engineering Production per per Calculate the overhead allocated to each customer, by department, using the departmental variable manufacturing overhead rates calculated in the previous step. Calculate the total overhead cost for each department and each customer. Northern Hamlet Jupiter Motors Motors Motors Total Department Design Engineering Production Total Requirement 3. Comment on your answers in requirements 1 and 2. Which customer do you think was complaining about being overcharged in the simple system? If the new department-based rates are used to price contracts, which customer(s) will be unhappy? How would you respond to these concerns? Under the simple costing system, was likely unhappy about its bill because the contract appears to have been If the new department-based rates are used to price contracts, will likely be happier about its bill. If the new department-based rates are used to price contracts, will likely be unhappy. This is because their bills under the simple costing system appear to have been Using the department-based rates, their bills will be If the new department-based rates are used, PW should explain to the unhappy customers how the calculation was done and point out their high use of relative to Requirement 4. How else might PW use the information available from its department-by-department analysis of variable manufacturing overhead costs? Other than for pricing, PW can also use the information from the department-based system to its own operations so that there is maximum value V from all indirect resources. It might set targets over time to both the consumption of each indirect resource and the unit costs of the resources. The department-based system gives PW more opportunities for targeted cost management Requirement 5. PW's managers are wondering if they should further refine the department-by-department costing system into an ABC system by identifying different activities within each department. Under what conditions would it not be worthwhile to further refine the department costing system into an ABC system? (Round the percentage to the nearest whole percent.) It worthwhile to further refine the costing system into an ABC system if there by CAD design-hours, then the more refined system would be among contracts in the consumption of activities within a department. If, for example, most activities within the design department were, in fact, driven V than the department-based cost system. Even if there were sufficient variation, considering the relative sizes of the three department cost pools, it to further analyze the production cost pool, which consumes % of the manufacturing overhead