Jewel Joy is a new company that manufactures custom jewelry. Jewel Joy 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

More info

Customer orders. The salespeople, designers, and jewelry makers spend time with the customer. The cost$-$driver rate is $$30$ per hour

spent with a customer.

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 $$21$ per hour.

Rush orders. Some customers want their jewelry quickly. The cost$-$driver rate is $$100$ per rush order.

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 $$20$ per return visit.

Data table

$\backslash$table$[[\backslash$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,02,03,04,05,06],[$Sales revenue,$$,600,$$$,4,000,$$$,330,$$$,2,500,$$$,5,300,$$$,620],[$Cost of item$($s$),$$$,360,$$$,2,400,$$$,198,$$$,r_{1,500},$$$,3,180,$$$,\mathrm{.}372],[$Hours spent on customer order,,$3,,5,,2,,3,,24,,5],[$Hours on fittings,,$1,,2,,1,,4,,4,,1],[$Number of rush orders,,$0,,0,,1,,1,,0,,0],[$Number of return visits,,$0,,2,,2,,1,,4,,1]]$

Enter a

$06$

$62$

$37$

$$

Rush order costs

Requirements

Calculate the customer$-$level operating income for each customer. Rank the

customers in order of most to least profitable and prepare

a customer$-$profitability analysis.

Are any customers unprofitable? What is causing this? What should

Jewel Joy do about these customers?