Please see the data in the next tab ("Data \& Template"). For this data, please implement This data pertains to a particular netbook sold by a retailer specializing in consumer electronics. The netbook becomes available (and goes on sale) in September and is sold through February of the subsequent year (at that point, a new generation product is launched). In March, the retailer needs to place an order for delivery in early September. The retailer will not have an opportunity to place replenishment orders before and throughout the selling season. Please use the information provided to answer the following questions: 1) How many units of the netbook should the retailer order (keeping in mind that the goal is to minimize total costs)? Answer: units 2) What is the expected total cost in this case? Answer: 3) How many units will the retailer expect to salvage at the end of the selling season? Answer: units 4) What is the expected total profit in this case? Answer: 5) The VP of Sales tells you that she thinks a 99% in-stock rate would be desirable. What is the actual (optimal) instock rate and why is it preferable over the (arbitrary) 99% figure mentioned by the VP of Sales? Answer: Optimal in-stock rate: Explanation: \begin{tabular}{lccc} \hline Parameter & Notation & Value \\ Unit purchase cost (incl. transportation, etc.) & C & $ & 305.0 \\ Unit sales price & SP & $ & 575.0 \\ Unit salvage value & G & $ & 140.0 \\ Cost of overstocking & Co & & \\ Cost of understocking & Cu & & \\ Average demand/season & D & 15,000 \\ Std. deviation of demand/season & D & 3,500 \\ \hline \end{tabular}