Question: Demand data over 5 months is given below: Month Demand 1 48 2 51 3 52 4 55 5 54 Give your answers to three

Demand data over 5 months is given below:

Month Demand
1 48
2 51
3 52
4 55
5 54

Give your answers to three decimal places.

  1. Find the forecast for month 6 using 3-month weighted moving average. Use weights of 2, 4 and 7 (highest weight for the most recent value).

  2. Use trend adjusted exponential smoothing with alpha = 0.2, and beta = 0.25. Assume for month 4, forecast for stationary component is 52 and trend is 1.8.

    1. Find the forecast for month 6
    2. Find the forecast for month 7

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

I need this for a marketing presentation can you make it as detailed as possible and cite your sources thank you AND I NEED IT SOON THANK YOU. Question? "Does Flexiti's financial marketing plan...

Q:

10 20 pts This Excel file contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a...

Q:

please show step by step instructions and formulas i dont know the VLook up function the excel spreadsheet was empty and i need to find all of that this is the text problem it refers to This is an...

Q:

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

Q:

please do any other article except second one it been done already and please apply correct theory 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1 2016 A. OVERVIEW The...

Q:

10-Based on the data shown below, calculate the regression line. Regression Equation: Enter the equation in slope-intercept form(y=mx+b) with parameters accurate to three decimal places. x y -4 -14...

Q:

could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting theory. I...

Q:

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

Q:

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

Q:

two articles needs to be done according to the given requirement in the attatched file 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1 2016 A. OVERVIEW The research...

Q:

(a) Show the isoprene units in each of the following terpenes. (b) Classify each as a monoterpene, sesquiterpene, diterpene, and so on. CH Zingiberene (from oil of ginger (from oil of celery)...

Q:

Skysong , Inc. is considering the purchase of a new machine for $ 490000 that has an estimated useful life of 5 years and no salvage value. The machine will generate net annual cash flows of $ 85750...

Q:

En un swap de tasas de interes, aquien paga la tasa variable?: a. La bolsa de valores b. Vendedor c. Comprador d. Banco

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...