Answer the Following Questions) Using the Analytic Solver Platform 5000

question 6

Multiple Choice

Answer the following questions) using the Analytic Solver Platform 5000 trials per simulation; use the Latin Hypercube sampling method) .
[Hint: choose the closest value.]
Consider the spreadsheet for a Monte Carlo Simulation in Excel. $$\begin{array} { | l | l | l | l | l | l | } \hline & { \text { A } } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & \text { Monte Carlo Sirnulation } & & & \text { Histarical } & \\& \text { in Exarel } & && \text { Candy Sales } & \$ 264.00 \\\hline 2 & & && 50 & \$ 264.00 \\\hline 3 & \text { Data } & & & 45 & \$ 264.00 \\\hline 4 & & & & 40 & \$ 228.00 \\\hline 5 & \text { Selling price } & \$ 18.00 & & 46 & \$ 264.00 \\\hline 6 & \text { Cost } & \$ 12.00 & & 43 & \$ 255.00 \\\hline 7 & \text { Discourt price } & \$ 9.00 & & 43 & \$ 255.00 \\\hline 8 & & && 46 & \$ 264.00 \\\hline 9 & \text { Model } & & & 42 & \$ 246.00 \\\hline 10 & & && 44 & \$ 264.00 \\\hline 11 & \text { Dernand } & 44 & & 43 & \$ 255.00 \\\hline 12 & \text { Purchase Quantity } & 44 && 47 & \$ 264.00 \\\hline 13 & & && 41 & \$ 237.00 \\\hline 14 & \text { Quantity Sold } & && 41 & \$ 237.00 \\\hline 15 & \text { Surplus Quantity } & && 45 & \$ 264.00 \\\hline 16 & & && 51 & \$ 264.00 \\\hline 17 & \text { Profit } & && 43 & \$ 255.00 \\\hline 18 & & && 45 & \$ 264.00 \\\hline 19 & & && 42 & \$ 246.00 \\\hline 20 & & && 44 & \$ 264.00 \\\hline 21 & & && 48 & \$ 264.00\\\hline 21 &&&\text { Average Profit }\\\hline\end{array}$$ $\quad$
-What is the value of mean profit?

• A) $255.90
• B) $251.45
• C) $245.98
• D) $264.00

---

Definitions:

Legal Reason

A rationale or basis that is recognized or upheld by the legal system.

State Laws

The body of law enacted by each state or territory in the United States governing local affairs.

Discrimination

Unjust or prejudicial treatment of different categories of people or things, especially on the grounds of race, age, or sex.

Federal Laws

Regulations established by the national government that apply throughout the country, superseding state and local laws where there is conflict.