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 | |||||||
Attachments:
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
