Cornerstone Exercise 11.3 (Algorithmic) Activity-Based Customer Costing Deeds Co
ID: 2513517 • Letter: C
Question
Cornerstone Exercise 11.3 (Algorithmic)
Activity-Based Customer Costing
Deeds Company sells custom-made machine parts to industrial equipment manufacturers by bidding cost plus 40 percent, where cost is defined as manufacturing cost plus order processing cost. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Cost and sales information by customer category is provided below.
Order-filling capacity is purchased in steps (order-processing clerks) of 1,000, each step costing $50,000; variable order-filling activity costs are $30 per order. The activity capacity is 43,000 orders; thus, the total order-filling cost is $3,437,000 [(43 steps × $50,000) + ($30 × 42,900)]. Current practice allocates ordering cost in proportion to the units purchased.
Deeds recently lost a bid for 150 units. (The per-unit bid price was $2 per unit more than the winning bid.) The manager of Deeds was worried that this was a recurring trend for the larger orders. (Other large orders had been lost with similar margins of loss.) No such problem was taking place for the smaller orders; the company rarely lost bids on smaller orders.
Required:
1. Calculate the unit bid price offered to Deeds’s customers assuming that order-filling cost is allocated to each customer category in proportion to units sold. Round your answer to the nearest cent.
$
2. Assume that a newly implemented ABC system concludes that the number of orders placed is the best cost driver for the order-filling activity. Assign order-filling costs using this driver to each customer type and then calculate the new unit bid price for each customer type. Round the amount of order cost allocation to the nearest whole dollar. Round other computations and the bid price to the nearest cent.
3. What if Deeds offers a discount for orders of 39 units or more to the frequently ordering customers? Assume that all the frequently ordering customers can and do take advantage of this offer at the minimum level possible. Compute the new order cost allocation and bid price. In your calculations, round the number of steps to the nearest whole number. Round the amount of order cost allocation to the nearest whole dollar. Round other computations and the bid price to the nearest cent.
Cornerstone Exercise 11.3 (Algorithmic)
Activity-Based Customer Costing
Deeds Company sells custom-made machine parts to industrial equipment manufacturers by bidding cost plus 40 percent, where cost is defined as manufacturing cost plus order processing cost. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Cost and sales information by customer category is provided below.
Frequently OrderingCustomers Less Frequently
Ordering Customers Sales orders 39,000 3,900 Order size 15 150 Average unit manufacturing cost $60 $60 Order-processing activity costs: Processing sales orders $3,087,000
Order-filling capacity is purchased in steps (order-processing clerks) of 1,000, each step costing $50,000; variable order-filling activity costs are $30 per order. The activity capacity is 43,000 orders; thus, the total order-filling cost is $3,437,000 [(43 steps × $50,000) + ($30 × 42,900)]. Current practice allocates ordering cost in proportion to the units purchased.
Deeds recently lost a bid for 150 units. (The per-unit bid price was $2 per unit more than the winning bid.) The manager of Deeds was worried that this was a recurring trend for the larger orders. (Other large orders had been lost with similar margins of loss.) No such problem was taking place for the smaller orders; the company rarely lost bids on smaller orders.
Required:
1. Calculate the unit bid price offered to Deeds’s customers assuming that order-filling cost is allocated to each customer category in proportion to units sold. Round your answer to the nearest cent.
$
2. Assume that a newly implemented ABC system concludes that the number of orders placed is the best cost driver for the order-filling activity. Assign order-filling costs using this driver to each customer type and then calculate the new unit bid price for each customer type. Round the amount of order cost allocation to the nearest whole dollar. Round other computations and the bid price to the nearest cent.
Order Cost Allocation Bid Price Frequently ordering $ $ Less frequently ordering $ $Using this new price, would Deeds have won the bid for the 150 units recently lost?
- Select your answer -YesNoItem 6
3. What if Deeds offers a discount for orders of 39 units or more to the frequently ordering customers? Assume that all the frequently ordering customers can and do take advantage of this offer at the minimum level possible. Compute the new order cost allocation and bid price. In your calculations, round the number of steps to the nearest whole number. Round the amount of order cost allocation to the nearest whole dollar. Round other computations and the bid price to the nearest cent.
Order Cost Allocation Bid Price Frequently ordering $ $Can Deeds offer the original price from Requirement 1 to the frequently ordering customers and not decrease its profitability?
- Select your answer -YesNoItem 9
Explanation / Answer
1…Order-filling cost is allocated to each customer category in proportion to units sold Total units sold= (39000*15)+(3900*150)= 1170000 ie. 585000 + 585000 each category So, order cost allocation for either customer category= 585000/1170000*3437000= 1718500 So, Bid price for either category= (Mfg. cost+Order processing cost)*(1+Mark-up %) (60+(1718500/585000))*1.40= 88.11 2… No. of orders placed is the best cost driver for the order-filling activity Order cost allocation: Frequently ordering customers 39000/42900*3437000= 3124545 Less Frequently ordering customer: 3900/42900*3437000= 312455 Now calculating the Bid-price for each category as in 1 above, For Frequently ordering customers (60+(3124545/585000))*1.40= 91.48 for Less Frequently ordering customer: (60+(312455/585000))*1.40= 84.75 Yes. As per the ABC costing, Deed could have won the bid, as it is almost $ 4 (88.11-84.75) less than the original bid in 1. 3… Given----Assume that all the frequently ordering customers can and do take advantage of this offer No.of Orders for 39 units at a time = (39000*15)/39 = 15,000 (frequent order customers) So, now the total orders will be = 15,000 + 3,900 = 18900 No.of steps=18900/1,000 = 18.9 ie. 19 steps Order-filling cost= (19* $ 50000)+(30*18900)= $ 1517000 Order-filling cost allocated to the frequent category=(15,000/18900)*1517000= $1203968 So, Bid Price for frequent category customers=(60+(1203968/585000))*1.40= $ 86.88 Yes. As both the bid prices are almost the same, Deeds can offer the old price & quantity discounts without much decrease in profits.