1: Data Table

Customer
	1	2	3	4	5
Cases sold	1,900	8,760	62,300	33,200	2,000
List selling price	$15.00	$15.00	$15.00	$15.00	$15.00
Actual selling price	$15.00	$14.75	$13.50	$14.47	$13.55
Number of purchase orders	21	31	39	27	40
Number of customer visits	3	2	7	2	4
Number of deliveries	23	41	69	36	40
Miles traveled per delivery	17	7	9	9	45
Number of expedited deliveries	0	0	0	0	3

2: Data Table

Activity	Cost Driver Rate
Order taking	$150 per purchase order
Customer visits	$50 per customer visit
Deliveries	$2 per delivery mile traveled
Product handling	$0.50 per case sold
Expedited deliveries	$340 per expedited delivery

REQUIREMENTS: Please answer in the table format below (You do not need to explain the answer or show work!)

Requirement 1. Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results.
Begin by calculating each customer's gross margin. Then calculate the operating income for each customer. (Complete all input fields. Enter a "0" for any zero balances. Use parentheses or a minus sign for operating losses.)
	1	2	3	4	5
(1)
(2)
(3)
(4)
Gross margin
Part 2
(5)
(6)
(7)
(8)
(9)
(10)
Total customer-level operating costs
Customer-level operating income (loss)

REQUIREMENT 2 & 3: