How do you calculate two year historical moving average

Assignment Help Operation Management
Reference no: EM132910216

How do you calculate two year historical moving average, four year historical moving average and exponential smoothing using Excel? I have the following information: Year and Actual Sales for the past 8 years. Year 1 $8,4000,000 Year 2 $8,820,000 Year 3 $8,644,000 Year 4 $8,212,000 Year 5 $8,622,000 Year 6 $9,484,000 Year 7 $9,674,000 and Year 8 $10,060,000. I am being asked to forecast year 9 using several forecasts including 2 year historical moving average, 4 year hisorical moving average and exponential smoothing. For exponential smoothing I must choose the best coefficient comparing a=0.2 a=0.5 and a=0.8.

 

 

Reference no: EM132910216

Questions Cloud

Layout a marketing problem in services : Give an example of a service system layout designed to maximize the amount of time the customer is in the system.
Challenging personal and professional communication : Comment/discuss on your experiences and feelings about dealing with challenging personal and/or professional communication situations
How does the production volume affect break-even analysis : How does the production volume affect break-even analysis?
Determine the standard time for job : A worker-machine operation was found to involve 3.9 minutes of machine time per cycle in the course of 40 cycles of stopwatch study. The worker's time averaged
How do you calculate two year historical moving average : How do you calculate two year historical moving average, four year historical moving average and exponential smoothing using Excel? I have the following informa
Hisorical moving average and exponential smoothing : How do you calculate two year historical moving average, four year historical moving average and exponential smoothing using Excel?
Maintaining required inventory levels : Explore how bills of material (BOM) will help in maintaining required inventory levels
Consequences of behavior contribute to likelihood : A key concept in operant conditioning is to examine how the consequences of a behavior contribute to the likelihood of the behavior occurring again.
Crimmigration system at our southern border : Explain, in detail, using two sociological theories listed below, the crimmigration system at our southern border.

Reviews

Write a Review

Operation Management Questions & Answers

  How could attacks on those vulnerabilities be done

Of the different vulnerabilities and potential exploits in all the various voting options, what are a couple of the most dangerous and serious threats?

  Hdmi wires inventory does cisco sell per day

How many inventory dollars worth of HDMI wires inventory does Cisco sell per day?

  Why is understanding the importance of health care laws

Why is understanding the importance of health care laws and regulations as they pertain to medical staff human capital relations?

  Collar crime is major risk for corporations and management

Government allegation and prosecution of white collar crime is a major risk for corporations and management.

  How much of an impact is on the timely decision making

From an international cultural perspective, how much of an impact is on the timely decision making and control processes can there be when there is a difference in national and corporate culture? Explain.

  Market will itself be in?uenced by performance of economy

It is thought that the size of the market will itself be in?uenced by the performance of the economy.

  Implementation plan for product organizational structure

Would someone guide me in making an Implementation plan for a product organizational structure?

  Demand is normally distributed with a standard deviation of

your firm uses a fixed order quantity system and operates 52 weeks per year. one of the items handled has the following

  Using the total quality management initiative

How to write an outline on the Kellogg Company using the Total Quality Management Initiative?

  Duties and moral case for redistribution

Compare on contrast Rawls and Nozick on the issue of individual rights and duties and the moral case for redistribution. You should briefly mention Nozick’s entitlement theory, and Rawls’ two principles. Then consider what obligations they place on y..

  Concepts within transportation and logistics field

Identify and discuss 2-3 emerging concepts within the transportation and logistics field.

  Explain how the model could be used in this situation

Present an example of a business situation that you believe would lend itself to the use of a quantitative business model.

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