1. Consider the following sales figures for the past five years.Year 12 3 45Sales 135 142 150 145 160(a) Use simple average to forecast sales for this year (year 6).(b) Use moving average with n = 2 to forecast sales for this year.(c) Use exponential smoothing with a = 0.1 and an initial forecast value of 150 toforecast sales for this year.(d) Use linear regression to forecast sales for this year.(e) Using mathematical evidence (SSE on forecasts for years 4 and 5), show which ofthe above methods is superior.

Given sales figures for the past 5 years is.Year12345Sales135142150145160a) simple average = So…

Answered: 1. Consider the following sales figures…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Consider the following data: Month Jan-14 Feb-14 Profit ($) 16,113 16,263 Monthly Profit of an Auto Repair Shop Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 15,055 17,117 18,763 17,210 19,141 18,468 20,254 Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.35. If necessary, round your answer to one decimal place.
Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. Take the logs of the variables, and estimate the demand function. Interpret the R-square. Interpret the coefficients for logP and logPsub Interpret the p-values associated with each independent variable Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? How sensitive are our consumers to changes in the rival good’s price? Explain in detail. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Suppose we are charging a price of $2 and our current marginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?
Find forecasted value for 2017using α = 0.5 and α = 0.7 using exponential smoothing method.Which α is better Years Sales Forecasted sale 2012 25 ……. 2013 17 2014 21 2015 30 2016 27 2017 ?
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast ( F1�1 ) of 31. Note: Round your intermediate calculations and answers to 2 decimal places. b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.30, an initial trend forecast ( T1�1 ) of 1, and an initial exponentially smoothed forecast ( F1�1 ) of 30. Note: Round your intermediate calculations and answers to 2 decimal places. c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. Note: Round your intermediate calculations and answers to 2 decimal places. c-2. Which is best? multiple choice Exponential smoothing with trend forecast Single exponential smoothing forecast
Suppose that a firm's sales were $3,750,000 five years ago and are $5,250,000 today. What was the geometric mean growth rate in sales over the past five years?
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the exponential smoothing method to forecast the number of sales to expect next month. Use the following value of alpha: 0.2. Month Demand Forecast 1 308 349.2 2 388 340.9 3 344 350.3 4 400 349.1 5 341 359.3
Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. Thesmoothing constant is 0.2, and the old forecast for month 1 is 245.
Need a Net balance graph for the given data

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS