Develop a three-year moving average to forecast sales

Assignment Help Basic Statistics
Reference no: EM131030815

Problem 1. Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gas station.  Susan's problem is to decide how large her station should be.  The annual returns will depend on both the size of the station and a number of marketing factors related to oil industry and demand for gasoline.  After careful analysis, Susan developed the following table:

Size of Gasoline Station

Good Market ($)

Fair Market ($)

Poor Market ($)

Small

 $70,000

$30,000

-$30,000

Medium

$110,000

$50,000

-$40,000

Large

$170,000

$70,000

-$50,000

1. Develop a decision table for this decision.

2. What is the Maximax decision?

3. What is the Maximin decision?

4. What is the criterion of realism decision? Use α = 0.6.

5. Develop an Opportunity Loss Table

6. What is the Minimax Regret Decision?

Problem 2. Data collected on the yearly demand for 50-pound bags of fertilizer at Sunshine Garden Supply are shown in the following table.

Year

Demand for Fertilizer (1,000s of Bags)

1

4

2

7

3

5

4

5

5

10

6

7

7

8

8

9

9

11

10

14

11

15

Use Excel QM to:

1. Develop a three-year moving average to forecast sales in year 12.

2. Develop a 3-year weighted average to predict demand in year 12, in which sales in the most recent year is  given a weight of 2 and sales in the two years prior to that are each given a weight of 1.

3. Develop a regression/trend line to estimate the demand for fertilizer in year 12.

4. Based on the three forecasts you have created, which forecast is the most accurate?

Problem 3. Kaplan College has decided to "wire" its campus. The first stage in this effort is to install the "backbone," i.e., to connect all the buildings. The table below gives the distances between the various buildings on campus in hundreds of feet.

Distances in Hundreds of Feet

From

To

 

 

 

 

 

 

Building 1

Building 2

Building 3

Building 4

Building 5

Building 6

Building 1

 

3

7

5

5

4

Building 2

 

 

5

2

6

6

Building 3

 

 

 

5

4

4

Building 4

 

 

 

 

5

3

Building 5

 

 

 

 

 

4

Building 6

 

 

 

 

 

 

1. How should the buildings be connected to minimize the total length of cable?

2. What length of cable is required?

Problem 4. The following represents the distances in miles from a warehouse (node 1) to various cities in Montana. The major outlet store is located at node 7.

From Node

To Node

Distance

1

2

40

1

4

100

2

3

20

2

4

30

3

4

60

3

5

40

3

6

20

4

5

70

4

7

50

5

6

50

5

7

80

6

7

40

1. Find the shortest route and distance from Node 1 to Node 7.

Problem 5. The network of a city sewer system and their capacities are shown below. Remember that the arc has both capacity and reverse capacity. For example, row 1 is the flow from node 1 to node 2 and row 2 is the reverse flow from node 2 to node 1. There are eight branches in this network.

From Node

To Node

Fluid Flow

1

2

150

2

1

100

1

3

0

3

1

150

1

4

300

4

1

300

1

5

150

5

1

100

2

4

300

4

2

200

3

4

250

4

3

300

3

5

300

5

3

250

4

5

100

5

4

0

Determine the maximum flow (in hundreds of gallons of water per minute) from node 1 to node 5

Problem 6. The governor of Michigan believes that the state can improve the state's crime rate if the state can reduce the college debt carried by its citizens and if they can increase the percent of the population covered by health insurance.

1. Using the States Data Set and PHStat, create the multiple regression prediction equation.

2. Predict the crime rate for Michigan if the college debt were $25,000 and the percent not covered by insurance was 10?

Problem 7. A concessionaire for the local ballpark has developed a table of conditional values for the various alternatives (stocking decisions) and states of nature (size of crowd).

Stocking Decision

Large Crowd ($)

Average Crowd ($)

Small Crowd ($)

Large Inventory

$22,000

$12,000

-$2,000

Average Inventory

$15,000

$12,000

$6,000

Small Inventory

$9,000

$6,000

$5,000

If the probabilities associated with the states of nature are 0.30 for a large crowd, 0.50 for an average crowd, and 0.20 for a small crowd, determine:

1. The alternative that provides the greatest expected monetary value (EMV).

2. The expected value of perfect information (EVPI).

Reference no: EM131030815

Questions Cloud

Discuss effectiveness of organisations : If HRM is to contribute to the effectiveness of organisations, it needs to be strategic, and HR strategy needs to be integrated with business strategy. Discuss.
Prefer to create a digital outline : Describe a professional scenario in which you’d prefer to outline a document in hard copy, using a pen and paper, and also describe a scenario in which you’d prefer to create a digital outline. What are the advantages and disadvantages of each method..
What is refers to the political party of republicanism : _____ is one of the newest jihadist groups grown from the tangled political situation in Yemen, and it maintains cross border ties with radicals in Saudi Arabia.
What is the purpose of adding conc hcl : what is the purpose of adding conc hcl before adding he pp agent in the estimation of barium
Develop a three-year moving average to forecast sales : Develop a three-year moving average to forecast sales in year 12. Develop a 3-year weighted average to predict demand in year 12, in which sales in the most recent year is  given a weight of 2 and sales in the two years prior to that are each given..
Implement a secure information and network infrastructure : you are required to design and implement a secure information and network infrastructure that ensures high availability, reliability, scalability, performance and security to support TCU services.
Critical issues that must be addressed in ethical dilemma : Consider yourself the manager of a nonunion steel mill that must operate 24-hour days, and where the physical demands are such that 8-hour days are preferable to 10- or 12-hour days. Perform an ethical analysis using the concepts presented in the Wee..
Define the term-brand : Define the term – brand. Discuss the functions of branding and branding dichotomy. Give a real world example of an outstanding brand and explain why it is outstanding.
Which machine would you choose after evaluating it : If your discount rate is 10 percent, using EAC which machine would you choose?

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  Find probability that two undergraduates will be selected

If four students are to be randomly selected from this group, find the probability that exactly two undergraduates will be among the four chosen.

  Create probability-probability plots for each variable

Now create probability-probability (p-p) plots for each variable. This output will give you additional information. Read over the Case Processing Summary. Notice that there is missing data for Days 2 and Day 3.

  Campaign for reelection

In a speech during her campaign for reelection, a Republican candidate claims that 55% of regis- tered Democrats in her county intend to vote for her.

  To just break even how many cd-roms must be sold per month

cdrw prime ltd manufactures and replicates cd-roms for software and music recording companies. cdrw prime ltd sells

  Suppose that x y and z are independent random variables

suppose that x y and z are independent random variables each having a standard normal distribution. determine

  The following table was presented in an article summarizing

question the following table was presented in an article summarizing a study to compare a new drug to a standard drug

  A national manufacturer of unattached garages discovered

a national manufacturer of unattached garages discovered that the distribution of the lengths of time it takes two

  The population of interest to the american company

What's The POPULATION of interest to the American company?

  What is the probability of choosing a ball numbered 30

A lottery game contains 29 balls numbered 1 through 29. What is the probability of choosing a ball numbered 30?

  Maximum variance of the raw score population

What maximum variance of the raw score population could you have and still be able to reject the null hypothesis of μ = 20 (α = .05), if the sample size is 100 and the sample mean is 22?

  Lt y1 y2 y3 and y4 constitute a random sample of size n

let y1 y2 y3 and y4 constitute a random sample of size n 4 from a bernoulli population with parameter p. a determine

  Find mean and standard deviation of number of recovered cars

If 100 stolen cars are randomly selected, what is the mean and standard deviation of the number of cars recovered after being stolen?

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