In 2005, Xerox Corporation's revenue fromcolor products and services was $4.6 billion,30%of Xerox's total revenue.following data show the quarterly percentagechange in revenue for 12 quarters.orTheYear Quarter %Growth2003 11521931514202004 126173184212005 1152.17322417(a)Use exponential smoothing to forecast thistime series. Consider smoothing constants ofa=0.2, and a=0.3.What value of thesmoothingconstant provides thebestforecast?(b)What is the forecast of the percentagechange for the first quarter of 2006?

Solution: This exponential smoothing is performed on Microsoft Excel. a) Step 1 : Open the…

In 2005, Xerox Corporation's revenue from color products and services was $4.6 billion, or 30%of Xerox's total following data show the quarterly percentage change in revenue for 12 quarters. revenue. The Year Quarter %Growth 2003 1 15 2 19 3 15 4 20 2004 1 26 2 17 3 18 4 21 2005 1 15 2 17 3 22 4 17 (a)Use exponential smoothing to forecast this time series. Consider smoothing constants of a=0.2, and a=0.3.What value of the smoothing constant provides the best forecast? (b)What is the forecast of the percentage change for the first quarter of 2006?

In 2005, Xerox Corporation's revenue from color products and services was $4.6 billion, or 30%of Xerox's total following data show the quarterly percentage change in revenue for 12 quarters. revenue. The Year Quarter %Growth 2003 1 15 2 19 3 15 4 20 2004 1 26 2 17 3 18 4 21 2005 1 15 2 17 3 22 4 17 (a)Use exponential smoothing to forecast this time series. Consider smoothing constants of a=0.2, and a=0.3.What value of the smoothing constant provides the best forecast? (b)What is the forecast of the percentage change for the first quarter of 2006?

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter6: Exponential And Logarithmic Functions

Section: Chapter Questions

Problem 8RE: Suppose an investment account is opened with aninitial deposit of 10,500 earning 6.25...

See similar textbooks

Similar questions

Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 71.8 Q2 85 Q3 107.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,215 Time 59.3 If the original value of the series in a Q1 was 2,179, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
What is the Simple Exponential Smoothing (SES) forecast with an alpha of .6 for period 4 is: (round to 2 decimal places) Week or X(Period) Time series value or Y(Sales) Forecast 14 214 37 410 515 612 7 ( don't hand writing solution)
Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 812 2 799 3 777 4 811 5 765 6 791 The Period 4 forecast by using exponential smoothing with 0.33 alpha = (in 2 decimal places)
With the gasoline time series data from table 17.1, show the exponential smoothing forecasts using a = .1.a. applying the MSe measure of forecast accuracy, would you prefer a smoothing constant of a = .1 or a = .2 for the gasoline sales time series?b. are the results the same if you apply Mae as the measure of accuracy?c. What are the results if Mape is used?
In the simple exponential smoothing model, when α =0, it is equivalent to which of the following: Simple moving average Delphi Naïve Forecast in the previous time period
The profits of a small company for each of the first five years of itsoperation are given in the following table:Year Profit in $1000s2010 62011 272012 622013 1112014 174 What is the average rate of increase of the profits between 2012 and 2014?
The following table reports the percentage of stocks in a portfolio for nine quarters: a. Construct a time series plot. What type of pattern exists in the data?b. Use trial and error to find a value of the exponential smoothing coefficient a thatresults in a relatively small MSE.c. Using the exponential smoothing model you developed in part b, what is the forecastof the percentage of stocks in a typical portfolio for the second quarter of year 3?
Use the exponential series to find an approximation to e-1 correct to three significant figures.
A company expects its income stream from a new product to be F (t)=100, 000t for the next 9 years. What is the Present Value of this income stream over the 9 years, if we assume an annual interest rate of 4% compounded continuously?
a car sells for $12,500 and one year later it is valued at $11,375. find the decay rate of the car
If a new car is valued at $20,600 and 8 years later it is valued at $3000, then what is the average rate of change of its value during those 8 years?
Since January 1, 1960, the population of Slim Chance has been described by the formula P=37000(0.93)^t, where P is the population of the city t years after the start of 1960. At what rate was the population changing on January 1, 1991?