Five years of a well-established brand’s monthly sales volume data are shown in the table below....

Five years of a well-established brand’s monthly sales volume data are shown in the table below. As may be noted, there is substantial seasonality in this brand's sales.

Forecaster Simulation: Problem #3 Data

	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
January	5550	4782	5283	4760	4314
February	5398	4897	4544	4930	4476
March	4236	4693	4370	4930	4476
April	2977	3747	2419	3065	3350
May	2345	2235	2463	2546	2274
June	1198	1156	1887	1602	1250
July	1090	1196	1194	1818	1392
AUgust	1530	1889	1759	2190	1942
September	1388	1324	2077	2007	1836
October	1522	1269	1440	1387	1593
November	2252	1763	1601	1571	1356
December	3746	3812	3712	3720	3642

Develop a monthly sales volume forecast for the brand for each of the first six months of Year 6. A total of six monthly forecasts are needed … one for each of January, Year 6 through to June, Year 6.

Describe the tool you will use to complete this forecast. Be sure to include "The tool I chose ..." or your answer will be marked incorrect.

Expert Solution

The tool i chose to forecast sales is "projection of past sales" or "historical forecasting" method.

Percentage of increase and decrease of sales for each year is analysed and calculated the average percentage of change in the sales yearwise. With the help of that, Sales forecast is prepared for year 6..

Calculation is as follows:

Particulars	Year 1	Change in % to year2	Year 2	Change in % to year3	Year 3	Change in % to year4	Year 4	Change in % to year5	Year 5	Average change in %	Increase/ Decrease	Sales Forecast Year 6
January	5550	-14%	4782	10%	5283	-10%	4760	-9%	4314	-6%	-244	4070
February	5398	-9%	4897	-7%	4544	8%	4930	-9%	4476	-4%	-193	4283
March	4236	11%	4693	-7%	4370	13%	4930	-9%	4476	2%	84	4560
April	2977	26%	3747	-35%	2419	27%	3065	9%	3350	7%	221	3571
May	2345	-5%	2235	10%	2463	3%	2546	-11%	2274	0%	-10	2264
June	1198	-4%	1156	63%	1887	-15%	1602	-22%	1250	6%	71	1321
July	1090	10%	1196	0%	1194	52%	1818	-23%	1392	10%	134	1526
AUgust	1530	23%	1889	-7%	1759	25%	2190	-11%	1942	7%	144	2086
September	1388	-5%	1324	57%	2077	-3%	2007	-9%	1836	10%	185	2021
October	1522	-17%	1269	13%	1440	-4%	1387	15%	1593	2%	32	1625
November	2252	-22%	1763	-9%	1601	-2%	1571	-14%	1356	-12%	-158	1198
December	3746	2%	3812	-3%	3712	0%	3720	-2%	3642	-1%	-25	3617

ekkarill92 answered 2 years ago

The table below shows data on population and expenditures in five countries, as well as the...

The table below shows data on population and expenditures in five countries, as well as the value of home production, the underground economy, and environmental externalities in each. Note all figures are expressed in millions of dollars. a. Calculate GDP and GDP per capita in each country. b. Calculate the size of home production, the underground economy, and environmental externalities in each country as a percentage of GDP. c. Calculate total and per capita “GDP plus” in each country by...

The data shown in the table were collected by surveying 100 employees with five years’ experience....

The data shown in the table were collected by surveying 100 employees with five years’ experience. Find the correlation relationship for the data. Use Microsoft Excel. Create a scatter plot. Identify and discuss the type of correlation, and whether is negative or positive, strong or weak. Create a regression line and analyze the coefficients for significance. Predict the estimates salary with 20 years of schooling. Years of schooling Total annual salary 10 $32 K 12 $33 K 13 $44.3 K...

The table below shows the monthly sales of a motorcycle store during the last two years....

The table below shows the monthly sales of a motorcycle store during the last two years. Month Sales Month Sales 1 195 13 155 2 210 14 120 3 190 15 135 4 170 16 110 5 180 17 122 6 156 18 97 7 134 19 85 8 155 20 110 9 145 21 85 10 165 22 78 11 128 23 66 12 135 24 45 Compute an exponential smoothing and an adjusted exponential smoothing for the data...

The data in the table below (and available online) represent monthly gross sales for Ska Brewing...

The data in the table below (and available online) represent monthly gross sales for Ska Brewing Company from 2009 to 2012. This is real data, let’s help Ska forecast 2013… Year January February March April May June July August September October November December Total 9 9 $193,481 $170,674 $228,095 $232,372 $288,188 $304,763 $337,825 $342,121 $320,011 $304,756 $221,514 $235,591 10 $267,782 $225,592 $356,604 $274,723 $377,369 $439,907 $430,999 $485,822 $407,577 $450,234 $315,238 $345,135 11 $319,313 $323,726 $342,353 $361,315 $612,500 $564,599 $518,422 $623,860 $412,091...

The monthly value of sales for the first 3 years of a restaurant’s operation is shown...

The monthly value of sales for the first 3 years of a restaurant’s operation is shown below (values are in 1,000 USD). Use a multiple linear regression model with dummy variables to develop an equation to account for seasonal effect in the data. (data below) ---- SHOW IN EXCEL Month Sales 1 242 2 235 3 232 4 178 5 184 6 140 7 145 8 152 9 110 10 130 11 152 12 206 13 263 14 238 15...

Using the data shown in the table? here, LOADING... ?, that contains historical monthly prices and...

Using the data shown in the table? here, LOADING... ?, that contains historical monthly prices and dividends? (paid at the end of the? month) for Ford Motor Company stock? (Ticker: F) from August 1994 to August? 1998, compute? the: a. Average monthly return over this period. b. Monthly volatility? (or standard? deviation) over this period. c.? 95% confidence interval of the estimate of the average monthly return. Date Stock Price Dividend Return 1+Rt Aug-94 $29.250 $0.000 Sep-94 $27.750 $0.000 -5.13%...

Using the data shown in the table here, , that contains historical monthly prices and dividends...

Using the data shown in the table here, , that contains historical monthly prices and dividends (paid at the end of the month) for Ford Motor Company stock (Ticker: F) from August 1994 to August 1998, compute the: a. Average monthly return over this period. b. Monthly volatility (or standard deviation) over this period. c. 95% confidence interval of the estimate of the average monthly return. Here is the data set Date Stock Price Dividend Return ( % ) 1+Rt...

Winfield Company operates a retail store a) Below is a table containing monthly sales and sales...

Winfield Company operates a retail store a) Below is a table containing monthly sales and sales staff compensation, in dollars for the previous year. Use the high-low method to create an equation in the form Y = a+ bX to describe the behavior of sales staff compensation. Month Comp Sales 1 412,700 1,808,000 2 386,000 1,659,000 3 359,700 1,512,000 4 346,500 1,138,000 5 359,400 1,218,900 6 341,000 1,233,000 7 366,500 1,409,300 8 364,200 1,437,000 9 400,100 1,616,600 10 443,000 1,833,000...

The sales of a company in million dollars) for each year are shown in the table below.

Problem 3: The sales of a company in million dollars) for each year are shown in the table below. x (year)20052006200720082009y (sales)1219293745a) Find the least square regression line y -ax+b. b) Use the least squares regression line as a model to estimate the sales of the company in 2012.

The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic. month visits...

The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic. month visits July 2160 august 2186 September 2246 october 2251 november 2243 december 2162 Prepare a forecast for January visits, using the simple exponential smoothing method with α = 0.3. If α = 0.5, what is the predicted value for January visits? If α = 0.0, what is the predicted value for January visits If α = 1.0, what is the predicted value for January visits...

Question