Question: SET UP A LOOKUP TABLE FOR DEMAND! This Is every single detail that the problem gave, the two tables are the information and I need


SET UP A LOOKUP TABLE FOR DEMAND!
This Is every single detail that the problem gave, the two tables are the information and I need help answering the second table from the top of the 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, 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. 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.20 .00 .20 $400 $600 0.35 .20 .55 $600 $700 0.35 .55 .9 $700 $800 0.10 .9 1 $800 Set up a lookup table for the demand. (Type integers or decimals. Do not round. Use ascending order.) Demand Probability Lower Limit Upper Limit 120 0.20 120 140 0.60 140 160 0.20 160 1 Discrete Distributions Unit Cost Probability $400 0.20 $600 0.35 $700 0.35 $800 0.10 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.25 Print Done Simulation Results $1,000 - $27,000 - $28,000 $14,000 $14,000 $34,000 $11,000 $39,000 $6,000 $6,000 - $17,000 - $8,000 $11,000 - $28,000 - $13,000 $39,000 - $28,000 - $8,000 - $27,000 $14,000 - $8,000 - $14,000 $14,000 - $37,000 - $28,000 $6,000 $6,000 $6,000 - $8,000 - $8,000 $34,000 $39,000 $29,000 $11,000 - $14,000 - $8,000 $6,000 $1,000 $19,000 $34,000 - $8,000 - $3,000 $29,000 - $33,000 $6,000 - $3,000 - $3,000 $1,000 - $13,000 $6,000 Print DoneStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
