Calculating the mad, mse, and mape

Assignment Help Operation Management
Reference no: EM13106121

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?

Reference no: EM13106121

Process has an initial review team

Auto-Moto receives 6 loan applications per day. Its process has an initial review team (IRT) that preprocess all applications and classifies them as A (excellent), B (more det

Compute the total direct cost for each project duration

Assume the network and data that follow. Compute the total direct cost for each project duration. If the indirect costs for each project duration are $ 400 (19 time units), $

Tremendous impact on society and our culture

Music has had a tremendous impact on society and our "culture" for the past 50 years. Which music genre do you believe has has the greatest impact on our society and the forma

What is the likely result of the litigation

Davidson’s Microbrew, Inc. is a small beer manufacturer located in Denver, Colorado. The owner of Davidson’s Microbrew, Benjamin Davidson, takes great pride in offering the pu

The influence of alcohol will be subject to discharge

Explain in some detail the difficulties management would have in administering the following work rule in accordance with the disciplinary principles established in the chapte

What type of qualifications should the trainer have

A lesson plan often includes some sort of reading assignment. For this exercise, identify at least two sources from the CSU Online Library that you would have your attendees

Second? meeting-patrick was frustrated with the fact

While Joe goes over the agenda for the? meeting, Rosa interrupts and asks to speed up the meeting. Is this statement true or? false? After the second? meeting, Patrick was fru

Employment-related medical examinations

What steps would you take as a human resource professional to ensure that employment-related medical examinations are conducted in a legally sound manner in a company for wh

Reviews

Write a Review

 
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