Sales Month (000 units) Feb. Mar. Apr. May Jun. Jul. Aug. 19 18 15 20 18 22 20 a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five-month moving average (3) A weighted average using .60 for August, .30 for July, and .10 for June (4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of 19(000) (5) A linear trend equation c. Which method seems least appropriate? Why? (Hint: Refer to your plot from part a.) d. What does use of the term sales rather than demand presume?

Sales Month (000 units) Feb. Mar. Apr. May Jun. Jul. Aug. 19 18 15 20 18 22 20 a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five-month moving average (3) A weighted average using .60 for August, .30 for July, and .10 for June (4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of 19(000) (5) A linear trend equation c. Which method seems least appropriate? Why? (Hint: Refer to your plot from part a.) d. What does use of the term sales rather than demand presume?

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter5: Business And Economic Forecasting

Section: Chapter Questions

Problem 5E: A firm experienced the demand shown in the following table. *Unkown future value to be forecast Fill...

See similar textbooks

Similar questions

Please help, use second image as reference (different equation)
FORCASTING using the data below can you answer the question: Month Sales Jan-16 747 Feb-16 697 Mar-16 1014 Apr-16 1126 May-16 1105 Jun-16 1450 Jul-16 1639 Aug-16 1711 Sep-16 1307 Oct-16 1223 Nov-16 975 Dec-16 953 Jan-17 1024 Feb-17 928 Mar-17 1442 Apr-17 1371 May-17 1536 Jun-17 2004 Jul-17 1854 Aug-17 1951 Sep-17 1516 Oct-17 1642 Nov-17 1166 Dec-17 1106 Jan-18 1189 Feb-18 1209 Mar-18 1754 Apr-18 1843 May-18 1769 Jun-18 2207 Jul-18 2471 Aug-18 2288 Sep-18 1867 Oct-18 1980 Nov-18 1418 Dec-18 1333 Jan-19 1333 Feb-19 1370 Mar-19 2142 Apr-19 2138 May-19 2078 Jun-19 2960 Jul-19 2616 Aug-19 2861 Sep-19 2237 Oct-19 2225 Nov-19 1590 Dec-19 1659 Jan-20 1613 Feb-20 1605 Mar-20 2349 Apr-20 2468 May-20 2532 Jun-20 3127 Jul-20 3288 Aug-20 3285 Sep-20 2485 Oct-20 2723 Nov-20 1835 Dec-20 1894 Consider five years of monthly profit for a company Plot the data and discuss its…
FORCASTING using the data below can you answer the question: Month Sales Jan-16 747 Feb-16 697 Mar-16 1014 Apr-16 1126 May-16 1105 Jun-16 1450 Jul-16 1639 Aug-16 1711 Sep-16 1307 Oct-16 1223 Nov-16 975 Dec-16 953 Jan-17 1024 Feb-17 928 Mar-17 1442 Apr-17 1371 May-17 1536 Jun-17 2004 Jul-17 1854 Aug-17 1951 Sep-17 1516 Oct-17 1642 Nov-17 1166 Dec-17 1106 Jan-18 1189 Feb-18 1209 Mar-18 1754 Apr-18 1843 May-18 1769 Jun-18 2207 Jul-18 2471 Aug-18 2288 Sep-18 1867 Oct-18 1980 Nov-18 1418 Dec-18 1333 Jan-19 1333 Feb-19 1370 Mar-19 2142 Apr-19 2138 May-19 2078 Jun-19 2960 Jul-19 2616 Aug-19 2861 Sep-19 2237 Oct-19 2225 Nov-19 1590 Dec-19 1659 Jan-20 1613 Feb-20 1605 Mar-20 2349…
What is the lowest level of measurement for the data where the mode could bedetermined?A. NominalB. OrdinalC. IntervalD. Ratio Consider a data set of 11 distinct measurements with mean equal to A and median equalto B. If the highest value was decreased to a value smaller than the median B, how wouldthe mean and median be affected?A. The mean and median will both decrease.B. The mean and median will not change.C. The mean will not change and the median will decrease.D. The mean will decrease and the median will not change. What is one distinction between a parameter and a statistic?A. A parameter is only based on conceptual measurements, but a statistic is basedon a combination of real and conceptual measurements.B. A statistic changes every time you try to measure it (using different samples), but aparameter remains fixed.C. A parameter changes each time you try to measure it, but a statistic remains fixedacross samples.D. The true value of a statistic can never be known but the true…
Mr. Geppetto uses exponential smoothing to predict revenue in his wood carving business. He uses a weight of  = .4 for the naïve forecast and (1-) = .6 for the past forecast. What revenue did he predict for March using the data below? MONTH REVENUE FORECAST Nov 100 100 Dec 90 100 Jan 115 ---- Feb 110 ---- MARCH ? ?
Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the tax would be levied on the sales revenue of retail stores, the senator has asked you to prepare a forecast of retail store sales for year 8, based on data from year 1 through year 7. The data are: (c1p2) Year Retail Store Sales 1 $1,225 2 1,285 3 1,359 4 1,392 5 1,443 6 1,474 7 1,467 54 Chapter One a. Use the first naive forecasting model presented in this chapter to prepare a forecast of retail store sales for each year from 2 through 8. b. Prepare a time-series graph of the actual and forecast values of retail store sales for the entire period. (You will not have a forecast for year 1 or an actual value for year 8.) c. Calculate the root-mean-squared error for your forecast series using the values for year 2 through year 7. 3. Use the second naive forecasting model presented in this chapter to answer parts (a) through (c) of Exercise 2. Use P 0.2 in…
kindly provide an equation = ((107.37-100))/100 × 100=7.37%
Show that b ^β0 is an unbiased estimator of β0. (Hint: Use the fact that ^β1 isunbiased.
The following table shows the sales volumes for company XYZ in millions of KES. Use the belowinformation to forecast the sales volumes in in 2022, 2023, 2024. 2026.Year2012203320142015201620172018201920202021Sales 220024003200450055009000150010800163009500 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Define Forecasts and forecast errors in time series anaylsis?
Provide a trend analysis for income taxes ratios. What does it mean when a company's income taxes ratios increase over the years?
Suppose the relationship between the government's tax revenue (T) and national income (Y) is represented by the equation T = 30 +0.5Y. Plot this relationship on a scale diagram, with Y on the horizontal axis and T on the vertical axis. Interpret the equation. Use the line drawing tool to draw the equation. Make sure to plot the vertical axis as one endpoint of the line. Properly label this line. Carefully follow the instructions above, and only draw the required objects.