Question: USE EXCEL SOLVER AND SHOW HOW ANSWER IS 3 9 3 0 Benetton has entered into a quantity flexibility contract with a retailer for a
USE EXCEL SOLVER AND SHOW HOW ANSWER IS
Benetton has entered into a quantity flexibility contract with a retailer for a seasonal product. If the retailer orders O units, Benetton is willing to provide up to another percent if needed. Benettons production cost is $ and it charges the retailer a wholesale price of $ The retailer prices to customers at $ per unit. Any unsold units can be sold by the retailer at a salvage value of $ Benetton can salvage only $ per unit for its leftover inventory. The retailer forecasts demand to be normally distributed, with a mean of and a standard deviation of a How many units O should the retailer order?
The answer is please show me how to use EXCEL SOLVER to derive this answer stepbystep please
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
