Question

In: Statistics and Probability

The following data shows the quarterly profit (in thousands of dollars) made by a particular company...

  1. The following data shows the quarterly profit (in thousands of dollars) made by a particular company in the past 3 years.

Year

Quarter

Profit ($1000s)

1

1

45

1

2

51

1

3

72

1

4

50

2

1

49

2

2

45

2

3

79

2

4

54

3

1

42

3

2

58

3

3

70

3

4

56

a.  Use α = 0.3 to compute the exponential smoothing values for the time series. Compute MSE and the forecast of profit (in $1000s) for the next quarter.

b. Compare the three-period moving average forecast with the exponential smoothing forecast using α = 0.3. Which appears to provide the better forecast based on MSE?

Solutions

Expert Solution

Answer:-

Given That:-

a.  Use α = 0.3 to compute the exponential smoothing values for the time series. Compute MSE and the forecast of profit (in $1000s) for the next quarter.

Use α = 0.3 to compute the exponential smoothing values for the time series.

b. Compare the three-period moving average forecast with the exponential smoothing forecast using α = 0.3. Which appears to provide the better forecast based on MSE?

Compare the three-period moving average forecast with the exponential smoothing forecast using α = 0.3.

Plz like it....,


Related Solutions

This data shows the series of quarterly shipments in millions of US dollars of US hosehold...
This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989. Quarter Shipments Q1-1985 4009 Q1-1986 4123 Q1-1987 4493 Q1-1988 4595 Q1-1989 4245 Q2-1985 4321 Q2-1986 4522 Q2-1987 4806 Q2-1988 4799 Q2-1989 4900 Q3-1985 4224 Q3-1986 4657 Q3-1987 4551 Q3-1988 4417 Q3-1989 4585 Q4-1985 3944 Q4-1986 4030 Q4-1987 4485 Q4-1988 4258 Q4-1989 4533 (a) which of the following methods would be suitable for forecasting this series if applied to raw...
The following table shows the quarterly demand in thousands of cases, for a national beer distributor...
The following table shows the quarterly demand in thousands of cases, for a national beer distributor over the past four years. This data is also available in an Excel spreadsheet on Blackboard.                                             Year Quarter 2015 2016 2017 2018 1 280 321 419 266 2 485 493 502 510 3 423 515 487 501 4 330 271 468 516 Forecast the demand for each quarter of 2019 by using the multiplicative decomposition model and using overall average to calculate seasonal...
The following table shows the quarterly demand in thousands of cases, for a national beer distributor...
The following table shows the quarterly demand in thousands of cases, for a national beer distributor over the past four years. This data is also available in an Excel spreadsheet on Blackboard.                                             Year Quarter 2015 2016 2017 2018 1 280 321 419 266 2 485 493 502 510 3 423 515 487 501 4 330 271 468 516                                                                                         Using a smoothing coefficient of a = 0.3, exponentially smooth the series. Assume an initial forecast for the first quarter of...
Gross Profit Percentage The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars,...
Gross Profit Percentage The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars, except earnings per share.) 2016 Sales revenue $209,500 Cost of goods sold 125,500 Net income 8,300 Dividends 2,600 Earnings per share 4.15 Hi-Tech Instruments, Inc. Balance Sheet (Thousands of Dollars) Dec. 31, 2016 Dec. 31, 2015 Assets Cash $18,300 $18,000 Accounts receivable (net) 46,000 41,000 Inventory 39,500 43,700 Total current assets 103,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 Total assets...
The profit P, in thousands of dollars, that a manufacturer makes is a function of the...
The profit P, in thousands of dollars, that a manufacturer makes is a function of the number N, in thousands, of widgets produced in a year, and the formula is P(N)= 10N-N2-6.34. The formula is valid up to a level of 7,000 widgets produced. Express in functional notation the profit at a production level of 4,500 widgets. Calculate the value and explain the result in practical terms. What are the fixed costs? Determine the break-even point(s) for this manufacturer. What...
The following data give the annual incomes (in thousands of dollars) and amounts (in thousands of dollars) of life insurance policies for eight persons.
The following data give the annual incomes (in thousands of dollars) and amounts (in thousands of dollars) of life insurance policies for eight persons.(a) At the 98% confidence level, test whether annual income and the amount of life insurance policies are independent.(b) Find the attained significance level.(c) State any assumptions you have made in solving the problem.
The following data represent the salaries (in thousands of dollars) of a sample of 13 employees...
The following data represent the salaries (in thousands of dollars) of a sample of 13 employees of a firm: 26.5, 23.5, 29.7, 24.8, 21.1, 24.3, 20.4, 22.7, 27.2, 23.7, 24.1, 24.8, and 28.2. Calculate the interquartile range. What does this tell you about the data? Show your work. Describe the shape of distribution of salaries of employees of the firm based on the values of the quartiles. Give a possible reason for the shape of this data set, in terms...
The accompanying table shows the annual​ salaries, in thousands of​ dollars, earned by a sample of...
The accompanying table shows the annual​ salaries, in thousands of​ dollars, earned by a sample of individuals who graduated with MBAs in the years 2012 and 2013. Perform a hypothesis test using α equals= 0.05 to determine if the median salary for 2012 MBA graduates is lower than 2013 MBA graduates. Salaries​ (in thousands of​ dollars) for 2012 MBA graduates 92.6 66.1 60.6 85.5 92.8 44.7 84.4 81.1 44.2 94.3 66.6 61.6 94.6 81.6 Salaries​ (in thousands of​ dollars) for...
the following are the monthly sales (in thousands of dollars) for a company in four regions...
the following are the monthly sales (in thousands of dollars) for a company in four regions of the country. North East South West 34 28 18 24 47 36 30 38 44 40 30 41 29 21 30 24 37 23 Does the data suggest that there is a difference in the mean monthly sales among the different regions?
This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989.
Please show answers and code using R/R Studio. This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989. Quarter Shipments Q1-1985 4009 Q1-1986 4123 Q1-1987 4493 Q1-1988 4595 Q1-1989 4245 Q2-1985 4321 Q2-1986 4522 Q2-1987 4806 Q2-1988 4799 Q2-1989 4900 Q3-1985 4224 Q3-1986 4657 Q3-1987 4551 Q3-1988 4417 Q3-1989 4585 Q4-1985 3944 Q4-1986 4030 Q4-1987 4485 Q4-1988 4258 Q4-1989 4533 (b) apply a moving average with window span w=4...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT