Q: p15-30

Data table - More info 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 02 03 04 05 06 Sales revenue $ 550 $ 5.300 $ 330 $ 4,700 $ 600 2,200 $ 1,320 $ 1 Customer orders. The salespeople, designers, and jewelry makers spend time with the customer. The cost-driver rate is $46 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 $22 per hour. 3. Rush orders. Some customers want their jewelry quickly. The cost-driver rate is $90 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 $32 per return visit. $ 330 $ 3,180 $ 198 $ 2,820 $ 360 3 10 2 7 25 4 Cost of item(s) Hours spent on customer order Hours on fittings Number of rush orders Number of return visits 1 0 1 3 1 0 5 0 2 0 1 2 3 0 0 0 1 4 1 Print Done Print Done (Use parentheses or a minus sian when entering negative numbers and losses. Enter percents rounded to two decimal places. X.XX%) Bracelet Delights is a new company that manufactures custom jewelry. Bracelet Delights currently has six customers referenced by customer number: 01, 02, 03, 04, 05, and 06. Besides the costs of making the jewelry, the company has the following activities: (Click the icon to view the activities.) (Click the icon to view the customer data.) Read the requirements. Requirement 1. Calculate the customer-level operating income for each customer. (Complete all answer boxes. Enter a "0" for any zero balances. Use parentheses or a minus sign when entering operating losses.) Customer 01 02 03 04 05 06 Revenue $ 2,200 $ 550 $ 330 5,300 $ 3,180 330 $ 198 4,700 $ 2,820 600 360 1,320 Cost of product Gross profit Customer-level costs 220 2,120 132 880 1,880 240 Customer orders 138 460 92 322 1,150 184 Customer fittings 22 110 0 22 66 22 Rush order costs 0 90 180 270 0 0 64 Returns for repair 0 0 32 128 32 $ 60 $ 1,486 $ (50 $ 324 $ 266 $ 2 Customer-level operating income (loss) 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 entering negative numbers and losses. Enter percents rounded to two decimal places, X.XX%) Cumulative Customer- Customer-Level Cumulative Level Oper. Income as a % of Total Customer- Customer Customer-level Customer Oper. Income Customer-Level Oper. Income Number Oper. Income Revenue Level Oper. Income Revenue 5300 02 1486 28.04 % % 04 % % 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 entering negative numbers and losses. Enter percents rounded to two decimal places, X.XX%) Cumulative Customer- Customer-Level Cumulative Level Oper. Income as a Customer Customer-level Customer Oper. Income Customer-Level % of Total Customer- Number Revenue Oper. Income Level Oper. Income Oper. Income 1486 Revenue 5300 02 28.04 % % 04 % % 05 % % 01 % % 06 % % 03 % %