Generate the histogram

Assignment Help Other Subject
Reference no: EM132274836

Assignment -

Q1. Suppose your company wanted to determine the amount of sales of a new SUV model, called Lightning. The sales estimate would be based on the overall demand of various SUV model types. Overall demand is assumed to be normally distributed with a mean of 3 million units and standard deviation of 500,000 units. The share of demand that Lightning will take is assumed to be 4%. After running 1,000 simulated scenarios, a 95% confidence interval was constructed for the expected sales of Lightning units sold with limits of 93,048 and 146,964.

1. If 1,000 new simulated scenarios were run, would you get the exact result? Explain why.

2. Would the results be more stable if you ran 2,000 runs? Explain why.

3. Is there a number of simulations that can be run so that the results do not change if you re-ran the simulations? Explain

Q2. Suppose your company wanted to determine the amount of sales of a new SUV model, called Lightning. The sales estimate would be based on the overall demand of various SUV model types. Overall demand is assumed to be normally distributed with a mean of 3 million units and standard deviation of 500,000 units. The share of demand that Lightning will take is assumed to be 4%. After running 1,000 simulated scenarios, a 95% confidence interval was constructed for the expected sales of Lightning units sold with limits of 93,048 and 146,964.

1. If a mean of 6 million units was used in the simulation, how would the confidence interval change? Explain.

2. How would the confidence interval change if a standard deviation of 250,000 was used? Explain

Q3. Using specified data files, chapter example files, and templates from the "Topic 2 Student Data, Template, and Example Files" topic material, complete Chapter 15, Problems 2, 7, 9, 32 (parts a and b only), 33, and 35 from the textbook. Use the Palisade DecisionTools Excel software to complete these problems where requested and applicable. Problem 2 only requires the use of Microsoft Excel; however, you may optionally use the Palisade DecisionTools Excel software to generate the histogram.

Use the Palisade DecisionTools Excel software to complete the rest of the problems and ensure that all Palisade software output is included in your files. Unless otherwise stated, run simulations with 1,000 trials. Use 500 trials if the software will not allow you to run 1,000 trials. Ensure that only one Excel file is open when running a simulation.

To receive full credit on the assignment, complete the following.

1. Ensure that the Palisade software output is included with your submission.

2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.

3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.

4. Include screenshots of all simulation distribution results for output variables.

Note - Instructions: Please note that the attachments are only relevant for number 3. Need to see your discussion for number 3.

Attachment:- Assignment Files.rar

Reference no: EM132274836

Questions Cloud

Imagine scenario in real-world workplace environment : Imagine a scenario in a real-world workplace environment that you are familiar with where you have to apply critical thinking to determine a logical solution
Compare and contrast the parties goals in that area : How effective each party's goals are likely to be in mobilizing voters to support the party's candidates on the national level.
What do you think is the value of reading political theory : What do you think is the value of reading/ studying political theory? Even if you don't know much about political theory, please do not use outside sources.
Advanced management accounting case : Advanced Management Accounting Case: Harwood Medical Instruments PLC (HMI), What was the purpose of the change?
Generate the histogram : You may optionally use the Palisade DecisionTools Excel software to generate the histogram. Use Palisade DecisionTools Excel software to complete the problem
Maximum asset to capital ratio that a regulator : If we lived in an economy where interest rates were highly volatile, would you expect the maximum asset to capital ratio that a regulator would allow
Summarize recent developments in several states enacting : Share your own experience with the relative difficulty or ease of voting in your locale. Draw your own conclusion about the debate over voter ID laws.
Who are the people who live in your region : Who are the people who live in your region? Are they native or immigrant, and what is the impact on the region because of this?
What is the long term objectives and strategies for zappos : Explain how an employee with poor performance impacts a small firm. What is the long term objectives and strategies for Zappos?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd