Lee Manufacturing makes a component they call P14-31. This component is manufactured only when ordered by a customer, so Lee keeps no inventory of P14-31. The list price is $100 per unit, but customers who place "large" orders receive a 10% discount on price. Currently, the salespeople decide whether an order is large enough to qualify for the discount. When the product is finished, it is packed in cases of ten. When a customer order is not a multiple of ten, Lee uses a full case to pack the partial amount left over (e.g., if Customer C orders 25 units, three cases will be required). Customers pick up the order so Lee incurs costs of holding the product in the warehouse until customer pickup. The customers are manufacturing firms; if the component needs to be exchanged or repaired, customers can come back within ten days for free exchange or repair.
The full cost of manufacturing a unit of P14-31 is $80. In addition, Lee incurs customer-level costs. Customer-level cost-driver rates are:
Order taking .................................................. $380 per order
Product handling ................................................ 10 per case
Warehousing (holding finished product) ...................... 55 per day
Rush order processing .................................. 520 per rush order
Exchange and repair costs ....................................... 40 per unit
Information about Lee's five biggest customers follows:

The salesperson gave Customer C a price discount because, although Customer C ordered only 1,200 units in total, 12 orders (one per month) were placed. The salesperson wanted to reward Customer C for repeat business. All customers except E ordered units in the same order size. Customer E's order quantity varied, so E got a discount some of the time but not all the time.
Required
1. Calculate the customer-level operating income for these five customers. Use the format in Exhibit 16-2. Prepare a customer profitability analysis by ranking the customers from most to least profitable, as in Exhibit 16-10.
2. Discuss the results of your customer profitability analysis. Does Lee have unprofitable customers? Is there anything Lee should do differently with its five customers?

Transcribed Image Text:

Number of units purchased Discounts given Number of orders Number of cases Days in warehouse 5,000 2,400200 4,00 8,000 10% 10% 0 10% on half the units 12 240 16 12 812 120 500 144 400 13 12 (total for all orders) Number of rush orders Number of units 30 20 95 exchanged/repaired