Question

The demand for a product for the last six years has been 15, 15, 17, 18,...

The demand for a product for the last six years has been 15, 15, 17, 18, 20, and 19. The manager wants to predict the demand for this time series using the following simple linear trend equation: trt = 12 + 2t. What are the forecast errors for the 5th and 6th years?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

The simple linear trend equation is given as below:

trt = 12 + 2t

For t = 5 years

trt = 12 + 2*5

trt = 22

Observed trt = 20

Predicted trt = 22

Forecast error = Observed – Predicted = 20 – 22 = -2

Absolute forecast error = |-2| = 2

For t = 6 years

trt = 12 + 2*6

trt = 24

Observed trt = 19

Predicted trt = 24

Forecast error = Observed – Predicted = 19 – 24 = -5

Absolute forecast error = |-5| = 5

Add a comment
Know the answer?
Add Answer to:
The demand for a product for the last six years has been 15, 15, 17, 18,...
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
  • The demand for a product for the last six years has been 15, 15, 17, 18,...

    The demand for a product for the last six years has been 15, 15, 17, 18, 20, and 19. The manager wants to predict the demand for this time series using the following simple linear trend equation: trt = 12 + 2t. What are the forecast errors for the 5th and 6th years? A. 0, −3 B. 0, +3 C. +2, +5 D. −2, −5 E. −1, −4

  • 1) A company has recorded the demand for a new type of tire for the last...

    1) A company has recorded the demand for a new type of tire for the last five months. Month 1 2 3 4 5 Demand ('00s) 14 17 19 23 24 a) Use a two month moving average to generate a forecast for demand in month 6. b) Apply exponential smoothing with a smoothing constant of 0.9 to generate a forecast for demand for demand in month 6. c) Which of these two forecasts do you prefer and why? 2)...

  • Exhibit 18-2 Consider the following time series. Refer to Exhibit 18-2. The slope of linear trend equation, b1, is Refer to Exhibit 18-2. The intercept, b0, is Refer to Exhibit 18-2. The forecast for...

    Exhibit 18-2 Consider the following time series. Refer to Exhibit 18-2. The slope of linear trend equation, b1, is Refer to Exhibit 18-2. The intercept, b0, is Refer to Exhibit 18-2. The forecast for period 5 is Refer to Exhibit 18-2. The forecast for period 10 is Please if you can show work so I can understand along with equations. I have the answers already and am just working to see how I got those answers. For the following time...

  • Ch8-B Hudson Marine has been an authorized dealer for C&D marine radios for the past six years. T...

    Ch8-B Hudson Marine has been an authorized dealer for C&D marine radios for the past six years. The number of radios sold each quarter is shown in the Excel template. Hudson Marine would like to forecast the quarterly sales for year 7. (a) Construct a time series plot. (Hint: You need to create a line chart of the sales column. Make sure to label both axes.) (b) Construct a multiple regression model with dummy variables to develop an equation that...

  • Freight car loadings over an 18-week period at a busy port are as follows. Week 13 14 15 16 17 18...

    Freight car loadings over an 18-week period at a busy port are as follows. Week 13 14 15 16 17 18 Week 1 Number 280 295 310 295 310 320 Week Number 350 400 450 435 485 535 Number 545 585 600 615 630 10 12 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the above trend equation to predict expected loadings for Weeks...

  • A relatively recent firm has been active for the last five years and now wants to...

    A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2020, based on the following historical data: Sales YEAR t (y) t*y t? 1 2015 1 3.000 3.000 2016 2 6.000 12.000 4 2017 3 8.000 24.000 9 2018 4 7.000 28.000 16 2019 5 10.000 50.000 25 SUM 15 34000 117.000 55 a. What is the forecast for this year, 2020, using a four-year simple moving...

  • Company Epic has experienced declining sales during the last six months. Epic wants to break this...

    Company Epic has experienced declining sales during the last six months. Epic wants to break this negative trend by a new innovative product line, i.e. tablets for youths, between 12-18 years of age. The target group consists of young people who like new cool gadgets for a reasonable price. The management’s watchword for the new product line is “simplicity and coolness”. You are a project manager at Cool Design, a consultant company in Stockholm. You are hired to design the...

  • Freight car loadings over an 18-week period at a busy port are as follows: Week Number...

    Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 13 230 250 270 7 320 510 2 8 370 14 520 3 420 15 560 16 4 250 400 580 270 11 450 17 600 12 18 6 280 500 620 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) 10.42 305.2 b. Use the...

  • (5) A company which manufactures compact discs has found that demand for its product has been...

    (5) A company which manufactures compact discs has found that demand for its product has been increasing rapidly over the last 12 months. A decision now has to be made as to how production capacity can be expanded to meet this demand. Three alternatives are available: (1) Expand the existing plant. (11) (111) Build a new plant in an industrial development area. Subcontract the extra work to another manufacturer. The returns which would be generated by each alternative over the...

  • Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...

    Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The company is considering either using a simple mean or a three-period moving average to forecast monthly sales. Given sales data for the past 10 months use both forecasting methods to forecast periods 7 to 10 and then evaluate each. Which method should they use? Use the selected method to make a forecast for month 11. (Show all calculations .... Please read Examples1, 2, 3...

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