Describe double exponential smoothing, Operation Management

Assignment Help:

The Cardinal Electronics Company must project the sales of cellular phones for the next year (called year 2). The number of cell phones sold by Cardinal Electronics in each of the past 6 months (July of year 1 through December of year 1) is shown below. Month Number of Cellular Phones Sold July 183 August 215 September 294 October 333 November 410 December 438 a. Forecast the number of cellular phones demanded in January of year 2 using a rolling (i.e. updated at end of each month when new demand data becomes available) 4-month linear regression model. For example, forecasts generated at the end of October are made by fitting a linear regression to the demands in months July through October and forecasts generated at the end of December are made by fitting a linear regression to the demands in months September through December. Forecast the number of cellular phones demanded in July of year 2. Calculate the MAD, MSE, and MAPE for a rolling 4-month linear regression model. b. Using Double Exponential Smoothing (DES) with ? = 0.15 and ?= 0.10 (i.e. assume the data has a linear trend pattern), forecast the number of cellular phones demanded in January of year 2. Forecast the number of cellular phones demanded in July of year 2. Calculate the MAD, MSE, and MAPE for your double exponential smoothing model. c. Based on the measures of forecast accuracy you calculated for the part a) linear regression model and the part b) DES (0.15, 0.10) model, which model is a better fit for this data?


Related Discussions:- Describe double exponential smoothing

Explain problems can you identify with the current layout, 1. Develop an lD...

1. Develop an lD score for the current layout. What problems can you identify with the current layout? 2. Use trial and error to come up with a better layout that lowers the lD

Find what is the labour productivity per dollar, Klein Karpet cleaned 65 ru...

Klein Karpet cleaned 65 rungs in October, consuming the following resources: Labour: 520 hours at$13 per hour Solvent: 100 gallons at $5 per gallon Machine rental: 20 days at $50 p

Describe opportunities to improve the system, Define the product you will b...

Define the product you will be offering at College Pretzel Company (CPC) in detail. Create any necessary documentation such as an engineering drawing or a bill of material for the

Explain work study, Explain work study. Definition of Work Study: it,...

Explain work study. Definition of Work Study: it, as defined by British Standard Institution, is a generic form for those techniques mainly 'Method Study' and 'Work Measureme

Develop a spreadsheet model as well corresponding data table, The circulati...

The circulation manager of The New York Times in State College, PA is trying to decide how many copies of the upcoming Sunday edition of the paper to order so as to meet the demand

Process based layout, Process Based Layout In this layout machines and...

Process Based Layout In this layout machines and services are grouped on a functional basis operation of the same type are performed in the same area. For example all welding

Explain what''s your opinion about compensation, 1. Does your company's com...

1. Does your company's compensation plans help to attract and retain people with the right skills, knowledge and motivation to help the company succeed? Explain. 2. Is your comp

Describe double exponential smoothing, The Cardinal Electronics Company mus...

The Cardinal Electronics Company must project the sales of cellular phones for the next year (called year 2). The number of cell phones sold by Cardinal Electronics in each of the

Explain total compensation system, How might a company's business strategy ...

How might a company's business strategy affect the contribution (pay-for-performance) policies and techniques of its Total Compensation system?

Explain delivered weekly freestanding ads, How your local newspaper would b...

How your local newspaper would be affected if local supermarkets switched to weekly advertising and instead used a service that delivered weekly freestanding ads directly to each h

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd