Madeira Computing
Base - Case
Unit Selling Price
Fixed Cost
Variable Cost
Demand
Profit:
Worst - Case
Unit Selling Price
Fixed Cost
Variable Cost
Demand
Profit:
Best - Case
Unit Selling Price
Fixed Cost
Variable Cost
Demand
Profit:

• The problem assumes that the random demand follows GAMMA distribution with = 3 and = 2. In order to generate the required random demand, use the following functions: =1000*GAMMA.INV(RAND(),3,2)
• Use 1000 simulation trials