Note: I tried solving for this problem two different ways. First I got $21,000, and then I got $6,000 (both were marked wrong). Please show your work!

The Cool Can Company manufactures drink koozies and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $7.00. The new customer is geographically separated from Cool Can's other customers, and existing sales will not be affected. Cool Can normally produces 82,000 units but plans to produce and sell only 65,000 in the coming year. The normal sales price is $12 per unit. Unit cost information is as follows: However, assume that Cool Can plans to produce and sell 70,000 units in the coming year (rather than the originally anticipated 65,000 units). Required: 1. Using Excel (or some other spreadsheet software tool), calculate the amount by which total operating income increases or decreases if the order is accepted