Question: Hello, i need the best tutor available please because I need help and nobody has been able to help with this problem. Please. I can't

Hello, i need the best tutor available please because I need help and nobody has been able to help with this problem. Please. I can't figure out the Average profit

is ___ . ( that section)

Hello, i need the best tutor available please because I need helpand nobody has been able to help with this problem. Please. Ican't figure out the Average profit is ___ . ( that section)\fSet up a lookup table for the fixed costs. (Type integers or

\fSet up a lookup table for the fixed costs. (Type integers or decimals. Do not round. Use ascending order.) Fixed Costs Probability Lower Limit Upper Limit 45,000 0.15 0.15 $45,000 50,000 0.50 0.15 0.65 $50,000 55,000 0.35 0.65 1 $55,000 Suppose a Monte Carlo simulation using these lookup tables generated the 50 trial results in the problem statement. What is the average profit of this simulation? The average profit is $. (Round to the nearest dollar as needed.)Implement a nancial simulation model for a new product proposal and determine a distribution of prots using the provided discrete distributions for the unit cost1 demand. and xed costs. Price is xed at$1,000. Simulate this model for 50 trials and a production quantity of 140. What is the average prot? Click here to view the discrete distributions. Click here to view a sample of 50 simulation trial results. Setup a lockup table for the unit cost. (Type integers or decimals. Do not round. Use ascending order.) Unit Cost Probability Lower Limit Upper Limit $400 0.20 0 0.20 5400 $500 0.35 0.20 0.55 5500 $700 0.35 0.55 0.9 5?00 $500 0.10 0.9 1 5500 Setup a lockup table for the demand. (Type integers or decimals. Do not round. Use ascending order.) Demand Probability Lower Limit Upper Limit 120 0.25 0 0.25 1 20 140 0.45 0.25 0.? 1 40 160 0.30 0.? 1 1 60 l'l_z.._ _ |__|..._ :_I_I_ 1__u__ 2..-; ___I._ Profit Model Lookup table Profit 6000 Data Unit Cost Probability Lower limit upper limit 40 0.25 0 0.2 400 Unit Price 1,000 600 0.35 0.2 0.55 600 700 0.2 0.55 0.9 700 Unit Cost 600 800 0.2 0.9 1 300 Fixed Cost 50000 Demand Probability Lower Limit Upper Limit Demand 140 120 .25 0.25 120 9 140 D.5 0.25 0.7 140 10 160 0.25 0.7 1 160 11 Model 12 13 Unit Price 1,000 Fixed Costs Probability Lower Limit Upper Limit 14 Quantity Sold 140 45,000 0.2 0.15 45,000 15 Revenue 140000 50,000 0.45 0.15 0.65 50,000 16 55,000 0.35 0.65 55,000 17 Unit Cost 600 18 Quantity Proc 140 19 Variable Cost 84000 20 Fixed Cost 50000 21 22 Profit 5000 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

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 Mathematics Questions!