Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Implement a francial simulation model for a new product proposal and determine a distribution of profit wing the provided discrete distributions for the unit cott,
Implement a francial simulation model for a new product proposal and determine a distribution of profit wing the provided discrete distributions for the unit cott, demand, and the con Price in fixed at 51.000. Simulate this model for 50 trials and a production quantity of 140. What is the average profit? Click here to w. discrete stributions Click here to view ito bonimubition tritt Set up a lookup table for the unit cost, (Type integers or decimals. Do not round. Unscending order) Unit Cost Probability Lower Limit Upper Limit 3400 0.20 $400 S600 0.40 $600 $700 0.30 $700 5800 0.10 5800 Discrete distributions Unit Cost Probability $400 0.20 $600 0.40 $700 0.30 $800 0.10 Demand Probability 120 0.30 140 0.40 160 0.30 Fixed Costs Probability $45,000 0.15 Discrete distributions $600 $700 $800 0.40 0.30 0.10 Demand Probability 120 0.30 140 0.40 160 0.30 Fixed Costs Probability $45,000 0.15 $50,000 0.55 $55,000 0.30 Print Done Simulation results X Ir th $1,000 - $13,000 $34,000 $1,000 $6,000 $34,000 $34,000 - $8,000 - $13,000 - $22,000 $29,000 - $13,000 - $28,000 - $8,000 $6,000 $29,000 $39,000 - $8,000 $29,000 $11,000 - $13,000 $1,000 - $27,000 -- $13,000 $1,000 $1,000 $1,000 $34,000 - $8,000 $14,000 $1,000 - $8,000 - $14,000 $1,000 - $8,000 $11,000 $6,000 $14,000 $1,000 $1,000 $1,000 - $8,000 -$8,000 $11,000 - $42,000 - $19,000 - $8,000 - $13,000 - $8,000 - $13,000 G Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started