Answered step by step
Verified Expert Solution
Link Copied!

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Students also viewed these General Management questions

Question

What is the difference between a prime loan and a subprime loan?

Answered: 1 week ago