Use the Information Below to Answer the Following Question(s) We Assume That the Production (Demand) Volume Is Normally Distributed

question 4

Multiple Choice

Use the information below to answer the following question(s) . Consider the following spreadsheet for an outsourcing decision model. $\begin{array}{|l|c|c|}\hline & \text { A } & \text { B } \\\hline 1 & \text { OutsourcingDecision Model } & \\\hline 2 & & \\\hline 3 & \text { Data } & \\\hline 4 & & \\\hline 5 & \text { Manufactured in-house } & \\\hline 6 & \text { Fixed cost } & \$ 60,000 \\\hline 7 & \text { Unit variable cost } & \$ 130 \\\hline 8 & & \\\hline 9 & \text { Purchased from supplier } & \\\hline 10 & \text { Unit cost } & \$ 165 \\\hline 11 & & \\\hline 12 & \text { Demand volume } & 1,000 \\\hline 13 & \\\hline 14 & \text { Model } \\\hline 15 & \\\hline 16 & \text { Total manufacturing cost } \\\hline 17 & \text { Total purchased cost } \\\hline 18 & \\\hline 19 & \text { Difference } \\\hline 20 & \text { Decision } \\\hline\end{array}$ We assume that the production (demand) volume is normally distributed with a mean of 1,000 and a standard deviation of 100. For the unit cost, select the triangular distribution. It has a minimum value of $150, most likely value of $165, and a maximum value of $190. The number of trials per simulation is equal to 5,000 at a Sim. Random Seed of 1. Run the simulation and answer the following question(s) using the Risk Solver Platform.
-What is the cost difference upper cutoff in thousands of dollars if the likelihood is 75%?

• A) approximately 46
• B) approximately 28
• C) approximately 32
• D) approximately 59

---

Definitions:

Align Top

A formatting feature in text editors and design software that adjusts content to align with the top margin of the page.

Table Cell

The intersection of a row and column in a table, used to hold a piece of data or content.

Axis Title

A label or text that describes the data represented along an axis in a chart or graph.

Columns

Vertical blocks in a page layout or table used to organize text, images, or data logically.