Harold plans to order 3,300 White Sox caps for this upcoming season. Use Nested IF statements to calculate the Unit Cost per Cap, depending on the quantity ordered (in B13). Place your formula in Cell B10. In the last few years, demand for White Sox caps has hovered in the 3,200 range. But, the demand for caps - for any team - is closely tied to the team's popularity, which fluctuates each season depending on the team's record. As a result, it is difficult for Harold to assess what demand will be when he orders caps for the upcoming season. In general, demand for White Sox caps is never less than 1,250 and never more than 4,250. Also, at the end of the baseball season demand for caps at the 30 price drops precipitously. Rather than hold leftover inventory over the winter, Sports-Minded sells any caps left at the end of the season for12.50. Historically, all of the caps have sold at the reduced price.