Goal Seek is another scenario tool that maximizes Excel's cell$-$referencing capabilities and enables you to find the input values needed to achieve a goal or objective. Goal Seek can be used to determine the number of boxes of golf balls and high$-$performance golf polo shirts Red Bluff needs to sell to meet its sales goals as well as the selling price of golf shorts and golf umbrellas required to meet its sales goals.

On the SalesForecast worksheet, use Goal Seek to determine the quantity of stock golf balls needed to sell in order to meet the sales goal $($extended price$)$ of $$27,500.$