Question: Implement a financial simulation model for a new product proposal and determine a distribution of profits using the provided discrete distributions for the unit cost,

Implement a financial simulation model for a newImplement a financial simulation model for a newImplement a financial simulation model for a new
Implement a financial simulation model for a new product proposal and determine a distribution of profits using the provided discrete distributions for the unit cost, demand, and fixed costs. Price is fixed at $1,000 Simulate this model for 50 trials and a production quantity of 140. What is the average profit? Click here to view the discrete distributions Click here to view a sample of 50 simulation trial resulis. Set up a lookup table for the unit cost. (Type integers or decimals. Do not round. Use ascending order.) Unit Cost Probability Lower Limit Upper Limit $400 0.25 $400 $600 0.40 $600 $700 0.15 $700 $800 0.20 $800 Discrete Distributions Unit Cost Probability $400 0.25 $600 0.40 $700 0.15 $800 0.20 Demand Probability 120 0.20 140 0.60 160 0.20 Fixed Costs Probability $45,000 0.20 $50,000 0.55 $55,000 0.25Simulation Results - $17,000 - $14,000 - $8,000 $11,000 - $8,000 $39,000 $6,000 $34,000 $6,000 $1,000 $11,000 $29,000 - $14,000 $39,000 - $8,000 $11,000 $1,000 $6,000 $11,000 $34,000 - $19,000 - $17,000 $29,000 $6,000 - $8,000 - $42,000 $14,000 - $3,000 - $8,000 $6,000 - $3,000 $6,000 $34,000 $11,000 - $22,000 $11,000 $1,000 $11,000 - $8,000 - $13,000 - $13,000 - $8,000 $6,000 $29,000 - $42,000 $1,000 - $22,000 $6,000 - $42,000 $1,000

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!