Hisorical moving average and exponential smoothing

Assignment Help Operation Management
Reference no: EM132910215

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: EM132910215

Questions Cloud

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.
School resource officer with report of child abuse : The parents of the student contact the school administration and school resource officer with a report of child abuse.

Reviews

Write a Review

Operation Management Questions & Answers

  Was the trigger event internal or external

What trigger event forced Company X to consider changing the way they produced their product for 20 years? Was the trigger event internal or external? Explain.

  Process analysis of a problematic business process

process analysis of a problematic business process. Pick a process that affects you personally-it should be a process that you have experience

  How should these actions be triggered to take effect

This week, we will embark upon a study of project risk management. Believe me; it is a worthwhile pursuit. As in most cases, Murphy's Law (i.e., "if anything can go wrong, it will.") is in effect. What contingency plans should we have in place to cou..

  Diamond was genuine high quality diamond

Both Minh and Fine Jewellers were shocked, as they had both believed the diamond was a genuine high quality diamond.

  Leadership challenges in today environment

Leadership Challenges in Today's Environment There are some who argue that leaders face unprecedented demands as we enter the 21st century.

  Production process consists of three-step operation

A production process consists of a three-step operation.

  Cost including both cycle inventory and safety inventory

what is the annual inventory carrying cost including both cycle inventory and safety inventory? What is the economic order quantity?

  What experience have you had with organizations

What examples have you seen or heard that have helped foster a culture where employees are engaged in their jobs?

  Small steel manufacturing firm has had chronic problem

A small steel manufacturing firm has had a chronic problem of scrap and rework in the wire mill.

  What are the criteria for deciding whether this is good idea

What are the criteria for deciding whether this is a good idea? Has this been a good idea?

  Determine the recommendations to ensure supply of nurses

In view of a national nursing shortage and inadequate numbers of nursing faculty for increasing enrollments, determine the recommendations would you make to ensure an adequate supply of nurses in your organization.

  Describe the generic product development process

Describe the generic product development process described in the chapter. How does the process change for "technology-push" products

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