Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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:
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started