Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Ebook Principles Of Financial Accounting

Authors: John Wild, Ken Shaw, Barbara Chiappetta

2nd Edition

0077166183, 9780077166182

More Books

Students also viewed these Accounting questions

Question

4.3 Describe the job analysis process and methods.

Answered: 1 week ago