Question: Please use Frontline Solver and show steps: Monte Carlo Simulation Problem Ice-amole is trying to develop a new product, asparagus flavored ice cream, called Ice-sparagus.

Please use Frontline Solver and show steps:

Monte Carlo Simulation Problem
Ice-amole is trying to develop a new product, asparagus flavored ice cream, called "Ice-sparagus."
Ice-amole needs to show its investors that the new product is likely to provide profits that exceed its costs after one year.
The company will build a new factory with a fixed, one-time cost of $25,000.
In the first year, the company expects to produce 5000 gallons.
The cost of raw materials per gallon is modeled as a triangular random variable, with min of $1, most likely of $2, and max of $4.
In the first year, the company expects sales to follow a triangular distribution, with a min of 3000, most likely of 4500, and max of 5000.
The sales price of each gallon is $10.
Use Monte Carlo simulation with 1000 trials to answer the following questions.
Questions
1. What is the expected profit after one year of operation?
2. What is the 95% confidence interval on this expected value?
3. What is the probability of a loss?
4. What should the sales price be increased to in order to reduce the probability of a loss to 10%?

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 Finance Questions!