Question: how do i fill out average, trend and forecast for the following data MADE Trend Forecast Anstre SMAD Trend Adjusted Exponential Smoothing Formulas: +03 Jan-10

how do i fill out average, trend and forecast for the following data

MADE Trend Forecast Anstre SMAD Trend Adjusted Exponential Smoothing Formulas: +03 Jan-10 15925 A, = aD, + (1 - a)(A,_1 + T1-1) T, = B(A,- A,-1) + (1 - B)T-1 Apr 10 15.6921 May-10 un-10 16653 15.411 Aur 10 12.454 F+1 = A,+T, or A, +pT, Oct-10 23,378 Nov 101 10,975 18 Assignment 19 calculate Exponential m ed Average and trend for Feb'10 Mar'12 -akate Forecast for Mar 10-Dec 12 calculate total annual forecast for 2012 22 calculate MAD 21 calculate SMA mest period SAD-plastrophy show your work Apr. 117 740 May 1117952 1115699 A-11 15. 09 Sm MAD = D. - F, + (1 - )SM MAD- Ny 1116175 Feb 1211534 Man 15054 May 12 Jun 12 Sep 12 Oct 12 Dec-12 Assignment: - graph this data as line chart (show Industry and MMFD as lines) - include chart title, axis labels, chart legend - Do you see any patterns? If so, what kind? - Is there a difference between Industry and MMFD data? Briefly Industry vs MMFI 13 120,000 100,000 15 16 17 Month Industry Jan-10 35,941 Feb-10 32,140 Mar-10 43,245 Apr-10 38,301 May-10 40,442 Jun-10 38,356 Jul-10 31,198 Aug-10 29,763 Sep-10 42,042 Oct-10 55,946 Nov-1037,044 Dec-10 35,298 Jan-11 42,838 Feb-11 41,784 Mar-11 45,500 Apr-11 42,513 May-11 41,874 Jun-11 48,716 Jul-11 38,577 Aug-11 36,407 Sep-11 56,864 Oct-11 67,886 Nov-11 39,735 Dec-11 36,604 Jan-12 42,277 Feb-12 36,701 Mar-12 43,541 MMFD 15,925 13,532 14,648 15,697 16,653 15,411 13,534 12,454 16,300 23,378 16,975 15,135 19,430 17,534 17,822 17,740 17,952 21,552 15,699 15,059 23,508 30,519 16,175 15,315 17,950 13,534 15,054 80.000 60,000 40,000 20,000 May-10 May Jan-10 Mar-10 Industry MME Jul-10 Sep-10 Nov-10 Jan-11 Mar-11

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!

Below is a trend adjusted model fitted to quarterly revenues of a startup company selling PowerDrink , a new energy drink geared toward college millennials. Based on the data and model below, answer...

Following are the data on demand for white bread loves to be 10 214 212 229 237 24 259 11 12 207 201 270 270 200 31 Develop a lineartrend equation for the above data on demand for wnite bread loves...

1. Goodrice Company is importing a new variety of rice into Hong Kong. The sales data for ten weeks are given as follows in the unit of one thousand kg). Answer the following questions, Keep two...

Below is a trend adjusted model fitted to quarterly revenues of a startup company selling PowerDrink, a new energy drink geared toward college millennials. Based on the data and model below, answer...

Show your responses on the answer sheet provided. Hand in only the answer sheet with your responses. Fill in the Blanks in the table ( 1 - 4 ) The Smoothed Average in period 6 The Forecast in period...

1 . Please respond to the weekly forum 2 provided in Week 2 . 2 . Forecast demands using weighted moving average. Please apply weights of 0 . 3 for the most recent period, then 0 . 4 , then 0 . 3 1 6...

b) Develop a linear trend, multiplicative model for the data, including seasonality and forecast visits to the clinic for each month of 20X7. To develop a linear trend, multiplicative model, we need...

PARTI OVERVIEW The following discussion expands upon exponential smoothing and seasonality as presented in Chapter 11, Forecasting, in the text. There are a variety of forecasting methods and...

1. QUESTION 1 ________ methods assume that what has occurred in the past will continue to occur in the future. Time series Regressio n Quantitati ve Qualitativ e 1 points QUESTION 2 1. ________ is...

Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 5th ed.,...

ABC Partnership incurred 52,650 of start-up cost during the year. ABC started business on August 30, 2021. Calculate the total deduction of start-up cost for ABC in 2021 under IRC 195. ABC wants to...

Following are the 2010 year-end balances before adjustments: Accounts receivable (AR) ........ $ 80,000 Allowance for uncollectible accounts .. $ (2,000) Net sales ............. $250,000 Using the...

Caterpillar ( U . S . ) just purchased a Korean company that produces plastic nuts and bolts for heavy equipment. The purchase price was Won 7 , 0 3 0 million. Won 1 , 0 0 0 million has already been...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...