West Coast Health Corp. develops new probiotic food ingredients. They developed a prototype of a new organic material which can substitute unhealthy oil. They have performed preliminary marketing and financial analysis to determine their target customers. Following parameters are determined with certainty Selling price $1200/ tonNew technology $850,000Advertising $700,000The 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. The first year demand follows a discrete distribution as followsDemand ton. Probability 1500. 0.11600. 0.12250. 0.32400. 0.32600. 0.2Develop a simulation model for 200 trials?Fill the summary of statistics in the file?Plot the histogram for the specified ranges of profit?

A B C D E F G H Trained Labor Production Cost ling Price $1,200 Trial (Variable cost) (Variable cost) Random Number First-Year Demand Profit Fu w Technology st(Fixed cost) $850,000 vertising Cost(Fixed st) $700,000 IN Trained labor: Normal Distribution lean $75.00 tandard Deviation $35.00 7 8 9 Production Cost: Uniform Distribution 10 Smallest Value $185.00 11 argest Value $455.00 12 13 14 Demand: Discrete Distribution 15 Demand Probability 16 1500 0.1 17 1600 0.1 18 2250 0.3 19A B C D E F G H Trained Labor Production Cost ling Price $1,200 Trial (Variable cost) (Variable cost) Random Number First-Year Demand Profit Fu w Technology st(Fixed cost) $850,000 vertising Cost(Fixed st) $700,000 IN Trained labor: Normal Distribution lean $75.00 tandard Deviation $35.00 7 8 9 Production Cost: Uniform Distribution 10 Smallest Value $185.00 11 argest Value $455.00 12 13 14 Demand: Discrete Distribution 15 Demand Probability 16 1500 0.1 17 1600 0.1 18 2250 0.3 193 West Coast Health Corp. develops new probiotic food ingredients. They developed a prototype of new organic material which can substitutes unhealthy oil. They have performed preliminary marketing and financial analysis to determine their target customers. Following parameters are letermined 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