Question: I would like this Excel simulation to be converted to risk simulation using the risk (palisade) software . 1st scenario Price level Bushel price tomatoes

I would like this Excel simulation to be converted to risk simulation using the risk (palisade) software .
1st scenario
Price level Bushel price tomatoes Bushel price potatoes Bushel price green beans Excel solver
Highest price $5.80 $4.15 $6.80 Price level Bushel price tomatoes Bushel price potatoes Bushel price green beans
Avg. price $5.00 $4.60 5.9 Highest price $6.12 $5.23 $7.63
Profit $800 Avg. price $5.20 $4.96 $6.20
std $50 Profit 1400
2nd scenario Excel solver
Price level Bushel price tomatoes Bushel price potatoes Bushel price green beans Price level Bushel price tomatoes Bushel price potatoes Bushel price green beans
Highest price $6.00 $4.50 $7.00 Highest price $6.40 $5.30 $7.23
Avg. price $5.50 $4.80 $5.50 Avg. price $5.74 $4.95 $5.89
Profit $2700 Profit 1350
std $100
First scenario
Price is x $5.80
Demand is y (based on figure 1)
Demand 7.4833
Profit per unit price - cost per unit (1st scenario) 3.5
Total profit for 1st scenario 26.19155
Price is x $6.00
Demand is y (based on figure 2) 7.8333
Profit per unit price - cost per unit (2nd scenario) 3.5
Total profit for 2nd scenario 27.41655

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!