Question

Quantitative Methods (STAT-201 Q5 Given the following gasoline data: Quarter Year 1 Year 2 1 95...

Quantitative Methods (STAT-201

Q5 Given the following gasoline data:

Quarter

Year 1

Year 2

1

95

105

2

85

95

3

105

115

4

100

120

a. Compute the seasonal index for each quarter.

b. Suppose we expect year 3 to have annual demand of 400. What is the forecast value for each quarter in year 3?

Q6 Number of students present in a class of STAT201 on different days of the week is given in the following table:

Day

Number of students present in the class

Sunday

20

Monday

30

Tuesday

20

Wednesday

50

a. Develop a three-day moving average for Thursday.

b. Develop a forecast of presents for Thursday using exponential smoothing with an alpha = 0.2. Assume that an initial forecast for Wednesday was 40.

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Quantitative Methods (STAT-201 Q5 Given the following gasoline data: Quarter Year 1 Year 2 1 95...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Quantitative Methods (STAT-201) Q3 . A manager is deciding whether or not to build a small...

    Quantitative Methods (STAT-201) Q3 . A manager is deciding whether or not to build a small facility. Demand is uncertain and can be either at a high or low level. If the manager chooses a small facility and demand is low, the payoff is $30. If the manager chooses a small facility and demand is high, the payoff is $10. On the other hand, if the manager chooses a large facility and demand is low, the payoff is -$20, but...

  • The following payoff table provides profits based on various possible decision alternatives and various levels of...

    The following payoff table provides profits based on various possible decision alternatives and various levels of demand with probabilities of different demands: States of Nature Demand Alternatives Low Medium High Alternative A 80 120 140 Alternative B 70 90 100 Alternative C 30 60 120 Probability 0.4 0.3 0.3 What will be the expected value of perfect information (EVPI) for this situation? 2. Given the following gasoline data: Quarter Year 1 Year 2 1 95 105 2 85 95 3...

  • Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...

    Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...

  • Consider the following time series data: Quarter Year 1 Year 2 Year 3 1 71 68...

    Consider the following time series data: Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 58 60 53 4 78 81 72 Question: Use a multiple regression linear model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Q1=1 if quarter 1, 0 otherwise Q2=1 if quarter 2, 0 otherwise Q3=1 if quarter 3, 0 otherwise What is the R^2 (coefficient of determination)? Round to...

  • Q1. Find mean deviation from the mean of the following data. Size of the items ??...

    Q1. Find mean deviation from the mean of the following data. Size of the items ?? 4 6 8 10 12 14 16 Frequency ?? 2 4 5 3 2 1 3 where mean is given 10 marks. Q2. The daily sale of chocolate in Othammarket given below: Monday Tuesday Wednesday Thursday Friday Saturday Sunday 140kg 50kg 60kg 70kg 80kg 90kg 100kg The average daily sale is 75kg. Calculate the variance and the standard deviation of the above data. Q3....

  • Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8...

    Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8 10 2 1 3 7 3 3 6 8 4 7 10 12 (d) Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t =...

  • E I MINDTAP Video eBook Consider the following time series. Quarter Year 1 Year 2 Year 3 71 49 58 73 68 41 60 86 62 51 53 72 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePer...

    E I MINDTAP Video eBook Consider the following time series. Quarter Year 1 Year 2 Year 3 71 49 58 73 68 41 60 86 62 51 53 72 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) TimeSeries Value -60 40 20 Time Periodit) TimeSeries Value ype here to search TimeSeries Valu 60 40 20 Time Periodt) TimeSeries Vale 40 b. Use the folio ving dummy variables to devel。an estmsted regression munion to accent for seasonal...

  • Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...

    Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...

  • Copy all the classes given in classes Calendar, Day, Month, & Year into BlueJ and then...

    Copy all the classes given in classes Calendar, Day, Month, & Year into BlueJ and then generate their documentation. Examine the documentation to see the logic used in creating each class. (Code given below) import java.util.ArrayList; import java.util.Iterator; class Calendar { private Year year; public Calendar() { year = new Year(); } public void printCalendar() { year.printCalendar(); } } class Year { private ArrayList<Month> months; private int number; public Year() { this(2013); } public Year(int number) { this.number = number;...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT