omer is geographically separated from Cool Can's other customers, and existing sales will not be affected. Cool Can normally produces and sell only 65,000 in the coming year. The normal sales price is $12 per unit. Unit cost information is as follows: aterial Venable overhead Fixed overhead Total $3.10 1.50 1.00 1.80 $7.40 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 orde Decrease X 2. Conceptual Connection: Should Cool Can accept the special order when sales at the regular price are expected to be 70,000 units? No 3. Now assume that all direct variable costs are 20% higher and all indirect costs are 40% higher than originally stated in the set up box. These cos both normal and special-order units. Finally, assume the new customer has offered to increase its price to $10.00 (from the $7.00 originally stated in Using your spreadsheet, calculate the amount by which total operating income increases or decreases if the order is accepted. Increase 4. Should Cool Can accept the special order as described in Requirement 3?