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

Questions Cloud

What is its volume in cubic feet : The largest building in the world by volume is the Boeing 747 plant in Everett, Washington. It measures approximately 634 m long, 709 yards wide, and 108 ft high. a)What is its volume in cubic feet? b) Convert your result from part A to cubic mete..
Determine the ratio of the time interval for the one-bounce : An outfielder throws a baseball to his catcher in an attempt to throw out a runner at home plate. The ball bounces once before reaching the catcher.
At what speed must the player throw the basketball : A basketball player is standing on the floor 10.0 m from the basket. The height of the basket is H = 3.05 m, and he shoots the ball at an angle, ? = 36.4°, with the horizontal from a height of h = 1.82 m.
What were the main features of athenian democracy : Read the Pericles Funeral Oration and citing specific evidence from the Funeral Oration, what were the main features of Athenian democracy according to Pericles?
Calculating the mad, mse, and mape : 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.
How recruitment policies influence labor market : It is well known that labor markets influence recruitment policies. Can recruitment policies in turn influence labor market?
How much does the brains mass increase in one day : The mass of a newborn baby's brain has been found to increase by about 1.6 mg per minute. How much does the brain's mass increase in one day? How long does it take for the brain's mass to increase by 0.0045 kg ?
Confidence interval for mean of breaking strength : Consider the trash bag problem. Suppose that an independent laboratory has tested trash bags and has found that no 30-gallon bags that are currently on the market have a mean breaking strength of 50 pounds or more.
Describe and explain how the velocity varies with time : suppose that a projectile which is subject to a linear resistive force is thrown down with a speed of Vyo which is greater than the terminal speed Vterm. Describe and explain how the velocity varies with time, and make a plot of Vy against t for t..

Reviews

Write a Review

Operation Management Questions & Answers

  Calculate current capacity of the entire process

If you could increase the capacity of only two operations through process improvement efforts, which two operations would you select, how much additional capacity would you strive for in each of those operations?

  What are the advantages for using pseudocode

What are the advantages to using a flowchart for the solution? What are the advantages for using pseudocode?

  Avoiding the first mover disadvantages

avoiding the "first mover disadvantages" associated with making early commitments to alternative technologies, wider product selection, different styling, or new distribution channels.

  Explain why profits have been down recently

Explain why profits have been down recently, including possible causes of the decline. He also desires to know illustrate what he would need to do if he decides to downsize he operation.

  Explain how could a road map enhance the ability

Explain how could a road map enhance the ability of the organization to achieve its ethical also regulatory compliance goals.

  The presenting problem or specific request for help

The presenting problem or specific request for help. Any other problems or concerns that might need to be addressed if an ongoing relationship were to occur

  Considering the wide-range of government and private grants

Considering the wide-range of government and private grants that you could pursue, which would you see as most advantageous to obtain?

  Spatial value is transported to another place

I know temporal is being stored for later use which gains temporal value of the item and spatial value is transported to another place for consumption gaining spatial value

  What is the effective capacity of the process

or the month of November, 2010, the firm has generated the 150 orders, 75 of each type. Assume one month equals 20 days. What is the effective capacity of the process

  Computes the schedule variance performance index

This was expected to cost a total of $8,501,000. To date they have spent $5,001,000 on the superstructure. Computes the schedule variance, schedule performance index also cost performance index for the project to date.

  Illustrate what is change in productivity of non-defective

Illustrate what is change in productivity of non-defective units for Aztec using new assembly process? Note: list answer in three decimal place format.

  Explain the logic behind explain how mrp gross to net

Explain the logic behind explain how MRP's gross-to-net calculations are processed. Illustrate what input files are comprised in this process.

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