$\backslash$table$[[,$letorin,Iroentojut,Sopactin,,$],[,$S$,4+9,$S$,119,8,199,,],[$Situcet$,,000,,00,,0,,0],[$Grosples$,,1,,5,,$Dete,,$],[$Uilt coit,,,,tes,,b$.$t$,,],[,,12,,,,,,],[$Gros Protit,$s,5,1,+-,4,1=,5,15]]$

Figure $02-1$

$3.$ Select cell B$5$ and change the format of the number shown so that it has no decimal placemaking it $0$ instead of $0\mathrm{.}00$

$4.$ With cell $85$ still selected, click on the Data tab, and then select Data Validation in the Data Tools group to open the Data Validation dialog box. The validation should allow only a Whole Number greater than or equal to zero. On the Input Message tab, enter "Enter Positive Number' as the title and "Only values $0$ as the input message. Finally, on the Error Alert tab, keep the Style as "Stop", enter "Positive Numbers Only" for the title and "The value must be greater than or equal to zero" for the Error Message. Click OK to apply the new Data Validation rule to B$5.$ Apply the same validation rules cells C$5$ and D$5.$

$5.$ The Unit Cost needs to be updated to reflect the discounted cost $-$ as the Sales Goal increases $($which is the number of units sold$),$ the cost per unit decreases. Use the vlookup function as follows:

VLOOKUP$($lookup$\_$value, table$\_$array, col$\_$index$\_$num$)$

WHERE: lookup$\_$value is the Sales Goal for the lee Crean $($cell B$5)$

table$\_$array is the lookup table $($located in cells G$3$ to J$10)$

col$\_$index$\_$number is the second column $($so wse $2)$

Putting this all together, the formula in cell BB would be:

$cosc1702$

Project #$3$ Ver $2$

$5.$ Using the same logic. provide the Unit Costs with a discount for both the Frozen Yogurt and Popsides. If you put $1000$ in each of the cells BS$,$ C$5$ and D$5,$ then the unit costs should be $1\mathrm{.}85,1\mathrm{.}76,$ and $0\mathrm{.}72$ respectively. Set cells $85,C5$ and D$5$ back to zero to confirm the starting values are eorrect.

$6.$ Using Goal Seek, determine the Sales Goal necessary to achieve a profit of $$4000$ from the sale of tce Cream. In short, set the cell $811($the profit for lce Cream$)$ to the value of $4000$ by changing the value in cell $85($the Sales Goal for Ice Cream$).$