What is the cost assigned to each of the three activities

Question

ABC Data, Capacity-Resource Planning, Nonfinancial Performance Indicators National Compu- ter (a fictitious company) competes at the retail level on the basis of customer service. It has invested significant resources in its Customer Service Department. Recently, the company has installed a tra- ditional activity-based costing (ABC) system to provide better-quality cost information for pricing, decision making, and customer-profitability analysis. Most of the costs of running the Customer Service Department are considered committed (i.e., short-term fixed) costs (principally, personnel and equipment costs). The budgeted cost for the upcoming period is $1 million. Activity analysis, recently conducted when the ABC system was implemented, revealed the following information:

 

Required

1. Based on the preceding information, calculate the activity-cost driver (ABC) rates for each of the three activities performed by the Customer Service Department. Assume that during the period actual cost- driver activity levels are exactly as planned. Under this situation, what is the total cost assigned to each of the three activities? For each activity, what is the cost of unused capacity?

2. Suppose that during the upcoming period, activities (i.e., cost-driver quantities) are exactly as budgeted. Suppose, too, that the practical capacity level for each of these activities is 10,000 customer orders, 500 customer complaints, and 500 credit checks. Using cost-driver rates based on practical capacity levels for each activity, what is the cost assigned to each of the three activities? Also, what is the unused capacity and the associated cost of unused capacity for each activity?

3. What actions might the management of National Computer take in response to the analysis conducted in response to (2) above?

4. What nonfinancial performance indicators do you recommend National Computer monitor in terms of its Customer Service Department? In general, how are these indicators chosen? (That is, how do you justify the items you are recommending?)

Answer 1

Please note all the information and data from the question illustrated above and solve the following questions by using the value provided. 1) On the basis of the preceding information, compute the activity-cost driver (ABC) rates for each of the three activities carried by the Customer Service Department. Suppose that throughout the period actual cost- driver activity levels are precisely as planned. Under this condition, what is the net cost assigned to each of the three activities? For every activity, find the cost of the unused capacity? 2) Assume that throughout the upcoming period, activities (that is, cost-driver quantities) are precisely as budgeted. Assume, too, that the practical capacity level for each of such activities is 10,000 customer orders, 500 customer complaints and 500 credit checks. By using cost-driver rates based on the practical capacity levels for each and every activity, determine the cost assigned to one of the three activities?