Fill in Payoff table. PLEASE SOLVE ON EXCEL. SHOW BREAKDOWN, FORMULAS USED & SOLVER (if used).

You are selling widgets for $5/unit You buy the widgets for $3/unit Any unsold widgets can be returned for 50 cents Any customer who is turned away without a widget gets 10 cents You cannot control the # of customers who come to your store. You can control how many widgets you plan on buying (this is a guess on your part) Let me give you the answers for the TWO yellow boxes. You need to fill all the box with formula. Order 200 Customers 300. Your revenue is 200 times 5 = 1000. Your cost is 200 times 3 = 600. You turn away 100 customers. Each of these 100 customers get 10 cents each which is 100 times 10 cents. Your payoff is 1000 minus 600 minus 10 = 390 Order 400 Customers 100. Your revenue is 100 times 5 = 500. Your cost is 400 times 3 = 1200 You can return 300 and gets 50 cents each. 300 times 50 cents is 150. Your payoff is 500 minus 1200 plus 150 = -550 (loss of 550)