please rank the customers in order of most to least profitable and prepare a custoner-profitability analysis in terms of operating income.

- More info 1 Customer orders. The salespeople, designers, and jewelry makers spend time with the customer. The cost-driver rate is $40 per hour spent with a customer 2. Customer fittings. Before the jewelry piece is completed, the customer may come in to make sure it looks right and fits properly Cost-driver rate is $24 per hour 3. Rush orders. Some customers want their jewelry quickly. The cost-driver rate is $100 per rush order 4 Number of customer return visits Customers may return jewelry up to 30 days after the pickup of the jewelry to have something refitted or repaired at no charge The cost-driver rate is $35 per retum visit S Ind Print Done ome - X Data table Information about the six customers follows. Some customers purchased multiple items. The cost of the jewelry is 60% of the selling price Customer number 01 03 04 05 06 Sales revenue $ 650 $ 4,500 $ 310 $ 2.700 $ 4,900 S 550 Cost of item(s) $ 390 $ 2,700 $ 186 $ 1,620 $ 2,940 $ 330 Hours spent on customer order 3 5 2 4 24 Hours on fittings 1 2 1 1 Number of rush orders 0 1 2 3 Number of return visits 0 2 2 2 3 4 1 1 NN 3 custod Print Done Cus Requirement 1. Calculate the customer-level operating income for each customer (Complete all answer boxes. Enter a "O for any zero balances Use parentheses or Customer 03 04 06 05 02 01 550 $ Revenue 650 $ 390 4.500 5 2,700 310 $ 186 2.700 5 1620 4900 5 2,940 330 260 1.800 220 124 1.080 1.960 Cost of product Gross profil Customer level costs Customer orders Customer fittings Rush order costs 160 960 120 200 80 24 160 24 24 24 48 0 O 100 24 300 105 100 70 200 70 35 0 70 Returns for repair 5 116 $ 571 $ 13825 (150) s 6265 Customer developerating income (ons) Rank the customers in order of most to least profitable and prepare a customer-profitability analysis in terms of operating Income (Use parentheses or a minus sign when Customer Customer level Numbes Oper. Income Customer Revenue Customer Level Oper, Income Revenue Cumulative Customer. Level Oper. Income si princovne (Use parentheses or a minus sign when Cumulative Customer. Level Oper. Income as a % of Total Customer Level Oper. Income % % % 20 % 9