Question

Problem 3-11 A manager of a store that sells and installs spas wants to prepare a...

Problem 3-11

A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 90 + 2t, where t = 0 in June of last year. Seasonal relatives are 1.08 for January, .87 for February, and 1.01 for March. What demands should she predict? (Round your answers to 2 decimal places.)

Month Forecast
January of the next year
February of the next year
March of the next year
0 0
Add a comment Improve this question Transcribed image text
Answer #1

in June Last year t=0

July,last year t=1

January, this year t=7

January, next year t-19

Feb,next year t=20

Mar, next year t=21

hence forecast for Jan next year=Sesonality component*(90+2*t)

=1.08*(90+2*19)=138.24

Feb Next year=0.87*(90+2*20)= 113.1

March,next year= 1.01*(90+2*21)=133.32

.

.

I have given complete and detailed solution to your problem, in case of any query you can comment and

PLEASE DO GIVE A THUMBS UP

Add a comment
Know the answer?
Add Answer to:
Problem 3-11 A manager of a store that sells and installs spas wants to prepare a...
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
  • A manager of a store that sells and installs spas wants to prepare a forecast for...

    A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 90 + 3t where t-O in June of last year. Seasonal relatives are 1.00 for January 96 for February, and .95 for March, what demands should she predict? (Round your answers to 2...

  • A manager of a store that sells and installs spas wants to prepare a forecast for...

    A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 90 + 3t, where t = 0 in June of last year. Seasonal relatives are 1.00 for January, .96 for February, and .95 for March. What demands should she predict? (Round your answers...

  • A manager of a store that sells and installs spas wants to prepare a forecast for...

    A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 60 + 4t, where t = 0 in June of last year. Seasonal relatives are .89 for January, .95 for February, and 1.11 for March. What demands should she predict? (Round your answers...

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

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

  • Master Budget Case: ToyWorks Ltd. ToyWorks Ltd. is a company that manufactures and sells a single...

    Master Budget Case: ToyWorks Ltd. ToyWorks Ltd. is a company that manufactures and sells a single product, which they call a toodle. For planning and control purposes they utilize a quarterly master budget, which is usually developed at least six months in advance of the budget period. Their fiscal year end is December 31. During the summer of 2018, Chris Leigh, the ToyWorks controller, spent considerable time with Pat Frazer, the Manager of Marketing, putting together a sales forecast for...

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