Question: Problem 3 (15 points): Consider the Special Products break even analysis spreadsheet shown below. Special Products Co. Break-Even Analysis Data Results Unit Revenue $2,000 $10,000,000

Problem 3 (15 points): Consider the Special Products break even analysis spreadsheet shown below. Special Products Co. Break-Even Analysis Data Results Unit Revenue $2,000 $10,000,000 $1,000 30000 Total Revenue $60,000,000 Fixed Cost Total Fixed Cost $10,000,000 Marginal Cost Total Variable Cost $30,000,000 Sales Forecast Profit (Loss) $20,000,000 Production Quantity 30000 Break-Even Point 10,000 The production manager has decided to order a production run of Q=35000. Use simulation to find the distribution of profit given the following random inputs: The fixed cost varies uniformly between 9 and 11 million dollars. The marginal cost is normally distributed with a mean of $1000 and a standard deviation of $200. The Sales Forecast is triangularly distributed with a minimum of 20000, a most likely value of 30,000 and an upper limit of 40000. All variables are continuous. Dont round to integer values. Use 1000 iterations and find the mean and the 90th percentile of the profit distribution and the probability of a loss. Include the histogram of Profit in your response.

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!