Question
In: Operations Management
1. The demand data for a product over the past 5 months are shown below: MONTH...
1. The demand data for a product over the past 5 months are shown below:
|
MONTH |
DEMAND (number of units sold) |
|
Five months ago |
51 |
|
Four months ago |
58 |
|
Three months ago |
63 |
|
Two months ago |
71 |
|
Last month |
77 |
a. Plot the monthly demand data using a software OR on a sheet of graph paper.
b. Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in units sold).
c. Use the equation of the trend line to predict demand for THIS MONTH.
Solutions
Expert Solution
a.
|
# month |
MONTH |
DEMAND |
|
(number of units sold) |
||
|
1 |
Five months ago |
51 |
|
2 |
Four months ago |
58 |
|
3 |
Three months ago |
63 |
|
4 |
Two months ago |
71 |
|
5 |
Last month |
77 |
(b)
|
Slope: |
?=(n?(xy)??x?y)/(n?x2?(?x)2) |
||
|
Offset: |
?=(?y???x)/n |
||
|
Linear regression equation : |
y=?x+? |
||
|
# month (x) |
DEMAND (y) |
xy |
x^2 |
|
1 |
51 |
51 |
1 |
|
2 |
58 |
116 |
4 |
|
3 |
63 |
189 |
9 |
|
4 |
71 |
284 |
16 |
|
5 |
77 |
385 |
25 |
|
Total: |
|||
|
15 |
320 |
1025 |
55 |
|
Slope: |
?= |
6.5 |
|
|
Offset: |
?= |
44.5 |
|
|
Linear Trend Line: |
|||
|
Demand = 6.5(#month)+44.5 |
|||
formulae used:
|
c. Use the equation of the trend line to predict demand for THIS MONTH. |
||
|
# month = |
6 |
|
|
Linear Trend Line: |
Demand = 6.5(#month)+44.5 |
|
|
Demand = 6.5*6+44.5 |
||
|
demand= |
83.5 |
units |
keosha answered 10 months agoRelated Solutions
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular
product over the past 10 months.
Month
1
2
3
4
5
6
7
8
9
10
Value
324
311
303
314
323
313
302
315
312
326
a. Use α = 0.2 to compute the
exponential smoothing values for the time series. Compute MSE and a
forecast for month 11.
b. Develop a three-week moving average for
this time series. Compute MSE and a forecast for month 11.
c. ...
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular
product over the past 10 months. Month Value
1 324
2 311
3 303
4 314
5 323
6 313
7 302
8 315
9 312
10 326
a. Use α = 0.2 to compute the exponential smoothing values for
the time series. Compute MSE, MAPE and a forecast for month 11.
b. Calculate MSE and MAPE for three month moving average ?
c. Compare the three-month moving average forecast...
Question No.1: Demand for a certain model of Camry car during the past 5 months...
Question No.1:
Demand for a certain model of Camry car during the past 5 months
is shown below:
Months(Time)
Demand
January
195
February
265
March
315
April
295
May
105
Compute the forecast demand for each month, using single
exponential smoothing with ? =
0.05 . Assuming that forecast for January is 220
please make clearly answer must Today
Thank you
The following table contains the demand from the last 5 months. Month Actual Demand 1 25...
The following table contains the demand from the last 5
months.
Month
Actual Demand
1
25
2
30
3
33
4
35
5
38
Calculate the single exponential smoothing forecast for these
data using an α of 0.3 and an initial forecast (F1) of
28. Report the forecast for Month 6 in AnswerSheet. Show your work
in worksheet “Show your work for Q1.” (2
pts.)
Calculate the exponential smoothing with trend forecast for
these data using an α of 0.25,...
The time series showing the sales of a particular product over the past 12 months is...
The time series showing the sales of a particular product over
the past 12 months is contained in the Excel Online file below.
Construct a spreadsheet to answer the following
questions.
Use a=0.2 to compute the exponential smoothing forecasts for the
time series (to 2 decimals).
Month
Time-Series
Value
Forecast
1
105
2
130
3
125
4
100
5
90
6
120
7
150
8
135
9
95
10
75
11
100
12
105
13
Use a smoothing constant of...
Question 1 a. Over the past twelve months, Lululemon had monthly returns of -5%, 0%, 0%,...
Question 1
a. Over the past twelve months, Lululemon had monthly returns of
-5%, 0%, 0%, -5%, 0%, 0%,
10%, 15%, 10%, 0%, 0%, and 5%. What was the total return over
this period?
b. Suppose Shake Shack returns 10% this year and -10% next year.
What is the total return over this
2-year period? Explain why this is not equal to 0%. What would
the return for next year have to
equal (assuming this year’s return is still 10%)...
QUESTION 11 Questions 11-12 Q11. The past demand data shown below can be regarded as having...
QUESTION 11
Questions 11-12
Q11. The past demand data shown below can be regarded as having
a horizontal pattern. The naïve method ( Y't+1 =
Y't ) was applied to make the forecasts for February –
May.
Month
Demand
January
40
February
45
March
50
April
32
Q11. What are the mean absolute errors (MAE) for February,
March, and April forecasts?
a.
9.33
b.
25.0
c.
84.75
d.
8.47
e.
None of the above
1.5 points
QUESTION 12
Q12....
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
(b)
Use α = 0.3 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
A time series plot contains a series of 12 points connected by
line segments. The horizontal axis ranges from 0 to 13 and is
labeled: Month. The vertical axis ranges from 0...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a
particular product over the past 12 months. can be found in the
below excel file.
https://drive.google.com/file/d/1gIpr0IBYUGgCIRSO7g3mqZ84F89vJU_P/view?usp=sharing
1. Using the three-month moving average, what is the Mean
Squared Error (MSE)?
(Round your answer to 2 decimal places. Negative values
should be indicated by a minus sign.)
2. Using the three-month moving average, what is the
forecast for month 13 ?
(Round your answer to 2 decimal places. Negative values
should be indicated by...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Ten-year zero coupon bonds issued by the U.S. Treasury have a face value of $1,000 and...
- The Blossom Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a...
- Please answer all 4 parts of this question John Johnson just received a cash gift from...
- Question #1 C4H10O with a butanol combustion cycle (formation enthalpy-332,000 kJ / kmol) 25 per cent...
- Suppose a survey revealed that 19% of 494 respondents said they had in the past sold...
- Topic: Choose a company which are you are starting, and a main product or service that...
- 4. Why did the United States and the Soviet Union find themselves in a “Cold War”...
ADVERTISEMENT