Develop a three-year moving average to forecast sales

Assignment Help Other Subject
Reference no: EM131262030

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

$1500

$750

-$500

Medium

$3500

$1500

-$1000

Large

$7500

$4500

-$20,000

1. What is the Maximax decision?

2. What is the Maximin decision?

3. What is the criterion of realism decision? Use α = 0.4.

4. Develop an Opportunity Loss Table.

5. What is the Minimax Regret Decision?

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

15

2

13

3

12

4

10

5

9

6

9

7

12

8

14

9

10

10

15

11

12

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

2. Develop a three-year weighted average to predict demand in year 12, in which sales in the most recent year is given a weight of 4, the second most recent year is weighted 2 and sales in the third most recent year has a weight of 1.

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

4. Analysis of the forecasting errors indicates which forecasting method (moving average, weighted moving average or regression) is best in this situation?

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.

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

2. What length of cable is required?

The buildings can be connected with a minimal length of 5800 feet of cable.

Q4. 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

500

1

4

250

2

3

200

2

4

120

3

4

50

3

5

75

3

6

350

4

5

500

4

7

200

5

6

245

5

7

375

6

7

400

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

Q5. 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 seven branches in this network.

From Node

To Node

Fluid Flow

1

2

50

2

1

20

1

3

75

3

1

100

1

4

125

4

1

75

1

5

25

5

1

15

2

4

50

4

2

75

3

4

100

4

3

45

3

5

35

5

3

25

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

Q6. The governor of Michigan believes that the state can improve the state's poverty rate if the state can reduce the college debt carried by its citizens and if they can reduce the percent of the population not covered by health insurance. (This requires you to use the States Dataset file that is included in Doc Sharing->Instructor Graded Projects.)

1. Using the States Data Set and Excel DataAnalysis (Regression),create the multiple regression prediction equation of the form Y = β0 + β1(X1) + β2(X2)

2. Predict the poverty rate for Michigan if the college debt was $30,000 and the percent not covered by insurance was 10% or 10?

Q7. 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

$15,000

$12,000

-$1,000

Average Inventory

$12,500

$25,000

$7,500

Small Inventory

$4,000

$3,000

$2,500

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

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

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

Attachment:- Assignment.rar

Reference no: EM131262030

Questions Cloud

Which statement seems to you most useful : Which statement seems to you most useful? If, due to time constraints, your organization could only prepare one financial statement, which one-balance sheet, statement of income, or statement of cash flow-would you recommend? Why?
What was the goal of the human genome project : What was the goal of the Human Genome Project? What makes you, you? Where do the instructions that make you, you come from? What are these instructions stored on?
Consumer that the coca cola company is targeting : What types of demographic segmentation is each product's marketing most likely to include? - Which Coca-Cola products are most likely to lose customers to Coke Zero?
Identify a particular lymph disorder : Address the following in your paper: Identify a particular lymph disorder. Provide information on the disorders of the lymph system.
Develop a three-year moving average to forecast sales : Develop a three-year moving average to forecast sales in year 12. Develop a three-year weighted average to predict demand in year 12, in which sales in the most recent year is given a weight of 4, the second most recent year is weighted 2 and sales..
Analyze how the brand is positioned by its corporate owners : Identify and interpret a brand in the current, US marketplace. Analyze how the brand is positioned by its corporate owners versus outside influences - for example, consumers or the whole marketplace.
Discuss how smoking has affected someone in your life : Discuss how smoking has affected someone in your life. What disease(s) have they developed and do they still smoke? Based on our week's lecture on the respiratory system, what damage does smoking do to our bodies?
How the operon helps microbe survive and possibly thrive : Explain how the operon helps microbe survive and possibly thrive in its environment. Include details about conditions that trigger expression of the gene(s). Explain when this regulation occurs: During transcription, translation, or posttranslation
Do buildings have identifiable features : What are typical foods served in the culture? Are there any typical styles of dress?

Reviews

len1262030

11/1/2016 6:17:45 AM

Please see attached assignment. Thank you in advance. 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.

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