Stat

Part 1 of 4 O Points: 0 of 6 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 results X Set up a lookup table for the unit cost. Simulation Results 4 (Type integers or decimals. Do not round. Use ascending order.) Unit Cost Probability Lower Limit Upper Limit $400 0.20 $400 $600 $11:000 $34,000 - $28,000 $22,000 $11,000 0.35 $600 -$13.000 - $14 000 $13.000 -$22.000 $1,000 $700 0.35 $700 $34.000 -$23,000 -$8.000 - $14,000 $19.000 $800 0.10 $800 $8 000 $3.000 $29 000 -$22 000 $1,000 $34.000 $14.000 -$8 000 - $8.000 $1.000 X -$8,000 $34.000 $29.000 -$14 000 - $8.000 Discrete Distributions $39 000 $8.000 - $13,000 - $13,000 $34 000 $6,000 $6,000 $11,000 - $19.000 $23.000 $1,000 -$8,000 $33.000 - $22 000 $19.000 Unit Cost Probability $8,000 $6,000 $14 000 $29,000 -$14,000 $400 0.20 $600 0.35 $700 0.35 6800 0.10 Print Done Demand Probability 120 0 25 140 0 45 160 0 30 Fixed Costs Probability $45.000 0.25 $50.000 0.50 $55,000 0.25 Print Done