Option #2: Kamron’s Supply Inc.

profilemohanaddarwish
ACT570_Critical_Thinking_Student_Worksheet_Module_01_Option_02.xlsx

Data

Kamron's Supply, Inc. provides cleaning supplies to the automobile detailing industry. The most popular product is an all-in-one detailing package with several types of cleaning agents, wax, towels and supplies. Kamron's purchases the all-in-one boxes wholesale by the crate. The cost of each crate (50 all-in-one boxes) is $1,950. The list sale price of the all-in-one box is $64.
Customer
Raven used cars Bear's Auto Wildcat Motors Greyhound Classic Cars Colt Auto
All-in-one Detail Kits (in boxes) 172 267 712 417 257
List selling price 64 64 64 64 64
Actual selling price $ 54.00 $ 53.20 $ 49.50 $ 54.00 $ 53.50
Number of shipments 3 4 26 3 3
Sales calls 3 5 36 4 12
Number of deliveries 3 7 22 1 5
Miles traveled per delivery 14 4 50 6 12
Customer appreciation days 1 2 12 0 0
Cost drivers for each activity:
Activity Cost-Driver Rate
Deliveries $3 per delivery mile traveled
Product handling $0.90 per box sold
Packaging $14 per shipment
Sales calls $140 per sales call
Customer appreciation days $250 per day

Required 1

Customer
Raven used cars Bear's Auto Wildcat Motors Greyhound Classic Cars Colt Auto
Revenues at list prices
Discount
Revenues (at actual prices)
Cost of good sold
Gross margin
Customer level operating costs:
Packaging
Sales calls
Deliveries
Product handling
Customer appreciation days
Total
Customer-level operating income
Explain the customer profitability data (what is this data telling us?). Be thorough and specific:

Requirement 2

What value is there to management in reporting both the list selling price and the actual selling price for each customer?
How does this insight relate to the performance evaluation of the sales department?

Requirement 3

What issues from the data should managers consider in deciding whether to make adjustments or drop any of these customers?