Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use the excel templete Trained tabor Variable cost Production Cost (Variable cost Trial Prot Function 1 Selling Price New Technology 3 Cuted cost Advertising
please use the excel templete
Trained tabor Variable cost Production Cost (Variable cost Trial Prot Function 1 Selling Price New Technology 3 Cuted cost Advertising Center 3 S000 1 $20.000 2 3 Trained to Normal Distribution Mean SS. Standard Demon $ 10 Production Custom Distribution $15.00 4 5 6 7 3 9 10 11 12 13 14 15 16 17 18 19 Probably 01 1 215 West Coast Health Corp. develops new probiotic food ingredients. They developed a prototype of a new organic material which can substitutes unhealthy oil. They have performed preliminary marketing and financial analysis to determine their target customers. Following parameters are determined with certainty Selling price=$1200 /ton New technology cost=$ 850,000 Advertising cost=$700,000 The cost of a trained worker follows a Normal Distribution with the mean $75 per ton and the standard deviation $35 per ton. The large-scale production cost follows a Uniform Distribution with smallest value $185 per ton and the largest value $455 per ton. They are expecting a limited market for the first-year demand. Thus, the first-year demand follows a Discrete Distribution as follows: + Demand (ton) Probability 0.1 0.1 1500 1600 2250 2400 2600 0.3 0.3 0.2 a) Download the template and develop a simulation model for 200 trials. b) Fill the summary of statistics in your file. c) Plot the histogram for the specified ranges of profit Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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