Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain how to do on Excel if you can! This is all the information I was given Consider the accompanying spreadsheet for an outsourcing

image text in transcribed
image text in transcribed
Please explain how to do on Excel if you can!
This is all the information I was given
Consider the accompanying spreadsheet for an outsourcing decision model. 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 using the Risk Solver Platform. What is the value of mode obtained from the simulation results? Click the icon to view the spreadsheet. A. $28,435 B. $27,198 C. $25,394 D. $22,485 Spreadsheet Consider the accompanying spreadsheet for an outsourcing decision model. 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 using the Risk Solver Platform. What is the value of mode obtained from the simulation results? Click the icon to view the spreadsheet. A. $28,435 B. $27,198 C. $25,394 D. $22,485 Spreadsheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago