Broadening Your Perspective 17-2
The idea for this example is to further explain Activity Based Costing and how it can help the Ideal Manufacturing Company keep its costs at the correct level. Activity based costing is defined as “An activity based costing (ABC) system recognizes the relationship between costs, activities and products, and through this relationship assigns indirect costs to products less arbitrarily than traditional methods..” (Investopedia, 2014)
A.) 17-2 broadening your perspective asks that we compute the activity-based overhead rate for each activity cost. To calculate the activity-based overhead rate for each activity cost we use the formula:
The following chart are the results of that formula for each activity cost related to is driver.
For market analysis we take the market analysis amount/hours of analysis. This is 1,050,000/15,000=$70.00. For the Product design we take the product design of 2,350,000 divided by the number of designs 2,500. This is calculation is 2,350,000/2,500=940. For the Product Development we calculate the Product Development/Number of Products. 3,600,000/90=40. Lastly the Prototype testing/Number of Tests or 1,400,000/500= 2,800.
B) The next section that we are looking at is “How much cost would be charged to an in-house manufacturing department that consumed 1,800 hours of market analysis time, was provided 280 designs relating to 10 products, and request 92 engineering tests. The following chart is based on these calculations.
The market analysis is calculated by taking the calculated rate of 70*1,800 hours. This calculation comes to a $126,000 cost. The product design is calculated by multiplying the previous calculations of 940*280. This calculation comes to $263,200 in costs. The Product Development is calculated by 10 products* recalculated 40,000. This calculation is equal to $400,000in costs. We then take the Prototype testing pre-calculated 2800*92 engineering tests. This calculation...