Question: Two-factor Exponential Smoothing Alpha .20 Beta .30 Data Trend Forecast % error 83.2 1 2 3 4 5 5,159 5,197 Smoothed 5,076.1 5,124.6 5,175.8 5,305.4

Two-factor Exponential Smoothing Alpha .20 Beta

Two-factor Exponential Smoothing Alpha .20 Beta .30 Data Trend Forecast % error 83.2 1 2 3 4 5 5,159 5,197 Smoothed 5,076.1 5,124.6 5,175.8 5,305.4 5,494.0 4,987 5,091 5,559 5,906 5,266 5,395 72.8 66.3 85.3 116.3 95.6 81.1 61.0 51.7 6 7 8 9 10 11 12 -3.4 -2.1 5.7 8.7 -6.5 -4.5 -6.3 -2.9 -8.9 -6.5 -6.3 5,391 5,610 5,637 5,670 5,664 5,684 5,615 5,550 5,588.6 5,602.8 5,632.6 5,591.4 5,546.6 5,507 5,221 5,273 5,220 5,762 3.2 -16.5 * initial values - estimated by linear trend of first six values Provide only the answers (final calculations) to the following questions. (1 point each) 1. What is the Forecast in period 3? 2. What is the Smoothed Average in period 5? 3. What is the Demand (data) in period 7? 4. What is the Trend in period 9? 5. Calculate the Bias based on periods 3 through 7. 6. Calculate a Trackoing Signal for periods 2 through 5. 7. Using the model shown, what is the Forecast for period 15? 8 Using the data in the model calculate a four period moving average for period 14

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!

Two-factor Exponential Smoothing Alpha 20 Beta 30 Trend Forecast % error 1 2 5.150 5.197 Data Smoothed 50781 4 997 5124 5,091 5.175 a 5,669 6.306.4 5.908 54940 5.200 5995 5,560 9.002.8 5 507 5.632...

Two - Chapter Three (six problems) Due: 11/12 #1 Accountants at the firm Walker and Walker believed that several traveling executives submit unusually high travel vouchers when they return from...

Dealer Satisfaction North America Scale 0 2010 2011 2012 2013 2014 Scale 1 1 0 1 1 2 Scale 2 0 0 1 2 3 2 2 1 6 5 Scale 3 Scale 4 Scale 5 Sample 14 22 11 50 14 20 14 50 8 34 15 60 12 34 45 100 15 44...

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.,...

Linear Trend - Multiple Regression The average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below: Month 1999 2000 2001 January...

You are hired by one of the leading news channel CNBE who wants to analyze recent elections. This survey was conducted on 1525 voters with9 variables. You have to build a model, to predict which...

I attached 5 excel spreadsheets. Please note: a. Time series data will need its own spread sheets completed. I attached 4 excel sheets 1. Seasonal Index 2. Quadratic Trend 3. Exponential Smoothing 4....

The data is monthly data from July 1926 until January 2016 for the following series: the excess return on the market (Mkt-RF), the performance of small stocks relative to big stocks (SMB, Small Minus...

1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a sample to estimate the daily trading...

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Panel AB is a parabola with its maximum at point A. It is 150 cm wide into the paper. Neglect atmospheric pressure. Find (a) the vertical and (b) horizontal water forces on the panel.

A gas is heated at constant pressure in a piston-cylinder assembly. The initial volume is 0.05 m3 and the initial temperature is 300 K. The final temperature is 600 K. Determine the final volume of...

Identifying and analyzing financial statement effects of cash dividends On Marxh 1 5 of the current fiscal year, Bank of America issued 9 4 , 0 0 0 shares of 5 . 8 7 5 % Fixed - to - Floating Rate...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...