Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions