Weekly demand for a certain brand of a golf ball at The Golf Outlet is normally distributed with a mean of 35 and a standard deviation of 5. The profit per box is $5.00. Write an Excel formula that simulates the weekly profit: = 5* NORMINV(RAND(), 35, 5) = 5 * 35 * NORMSINV(RAND()) = 5 * RANDBETWEEN(5, 35) = NORMINV(RAND(), 5 * 35, 5)

Varto company has 9,400 units of its sole product in inventory that it produced last year at a cost of $23 each. this year’s model is superior to last year’s, and the 9,400 units cannot be sold at last year’s regular selling price of $42 each. varto has two alternatives for these items: (1) they can be sold to a wholesaler for $8 each, or (2) they can be reworked at a cost of $251,100 and then sold for $34 each. prepare an analysis to determine whether varto should sell the products as is or rework them and then sell them.