The table below shows the quarterly sales of television set (in thousands) in an electrical appliance shop inyears 2017-2019.YearQuarter 1Quarter 2Quarter 3Quarter 420174.84.16.06.520185.85.26.87.420196.5.67,57.8(a) Describe the trend and seasonal variation of the sales of television setby referring to the following timeseries plot. (In a short paragraph of around 30 words.)Sales of Television Set (1000s)23589101112Time: (2017 Quarter 1 to 2019 Quarter 4)(b) Calculate the seasonal variation for Quarter 1, Quarter 2, Quarter 3, and Quarter 4 respectively by usingthe calculated 4-quarter moving average as below.YearQuarterSalesCentered Moving(1000)Average (1000)20175.475201746.55.7375201815.85.975201825.26.1875201836.86.32520187.46.42019166.5375201925.66.675TTTT"

Seasonal variation will be variation in a period series inside one year that is rehashed pretty much…

Answered: The table below shows the quarterly…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A seasonal index for a monthly series is about to be calculated on the basis of the past four years' accumulation of data. The four previous July values were 110, 135, 125, and 130. The four previous total year values were 1440, 1920, 1920, and 2400. Calculate the seasonal index for July If the total-year forecast for next year is 2400. What is the July forecast for next year?
DETERMINE I) the adjusted seasonal indexes ofautumn: II) the de-seasonalised of period 1: III) the de-seasonalised of period 16:
DETERMINE I) the median seasonal index of spring: II)the total median seasonal index: III) the adjustment factor:
Which forecasting model assumes that what will happen in the immediately succeeding period is most likely similar to what happened this period than to that of, say, three periods ago?
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
Use the data set below to answer the following questions: [Gunakan set data di bawah untuk menjawab soalan-soalan berikut:] Table 1: Monthly sales unit IJadual 1: Unit jualan bulanau) Month Sales Units [Bulan] 1 [Unit Jualan] 1100 2 1200 3 1450 4 1800 2100 2700 i) Calculate the three-period simple moving average forecasts for months 4, 5 and 6. (Hitunskau rawalan pALata bergerak nudak weNEgUrakan empat-tenroh untuk bulau 5 dan 6.) Calculate the four-period weighted moving average forecasts for months 5 and 6 usıng weights of 0.05, 0.15, 0.30, and 0.50 from the earliest period to the latest period, respectively.
B. The following table shows the number of televisions sold over the last ten years at a local electronic store. year TV sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using the trend projection, develop a formula to predict sales for years 11 and 12. Develop a table to calculate the slope and intercept. Please Show All Working. Use that formula to forecast television sales for years 11 and 12
1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. [10 Points] Month Sales Jan Feb 18 19 Mar Apr May Jun 17 21 20 19 Jul 20 Aug 23 a. Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). b. Calculate forecasts for February 2007, April 2007, and February 2008
In a short paragraph, describe the trend and seasonal variation of the number of customers (in thousand)in this coffee shop by referring to the following time series plot:(b) Find the trend by calculating the 4-period moving average.(Present your work in a table format and correct all answers to 4 decimal places.)
2
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 45 6 53 50 7 59 44 8 59 51 64 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, G. MAD, and MAPE) for this forecasting procedure? How about ?? Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Period Forecast, F 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD MAPE 6.72 2.75 2.1 4.1 % Find the coefficient of determination (). The coefficient of determination ? = (Enter your response rounded to two decimal places.)
The following shows five months forecast demand and the corresponding actual demand for certain product.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS