Quantitative Analysis for Mgmt
posted by JeannieC .
Computer sales over the past 4 months have been 35, 34, 38, and 44 units.
„L Using a 3month moving average, forecast sales for the next month.
(35+34+38)/3 = 35.67
(34+ 38+44)3 = 38.67
„L Using a 3month weighted moving average with the weights 3, 2, and 1, and with the most weight on the most recent data, forecast the next period¡¦s sales.
[(1x44) + (3x38) + (3x34)]/6=
1x44= 44
3x38=114
3x34=102
44+114+102=260/6 = 43.3
„L Calculate the forecast using exponential smoothing with an alpha of 1 and a first period¡¦s forecast of 35.
New forecast (NF) = 44
Last period¡¦s forecast (LPF) =38
Last period¡¦s actual demand = 38.67
(NF=LPF + a (LPAD ¡VLPF)
35 + 1 (4435)
35 +1 (9)
35 + 9
44
I am kinder lost on this, not sure if I did it correctly.
Respond to this Question
Similar Questions

Finance
Forecasting Collections. Here is a forecast of sales by National Bromide for the first 4 months of 2001 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 15 24 18 14 Sales on credit 100 120 90 70 On average, 50 percent of … 
statistics
Refer to the following table which contains the sales (in $,000) for a department store for the first ten months of the year. Month Sales January 440 February 480 March 590 April 400 May 500 June 550 July 470 August 500 September 600 … 
budget and forecasting
Using the table “Gasoline Sales Time Series”, calculate the forecast for gasoline sales (in thousands) for Week 13 using a three day moving average. Gasoline Sales Time Series Week Sales (000’s of gallons) 1 17 2 21 3 19 4 23 … 
Math
you're setting sales goals for next month, you base your goals on previous avg sales. The actual sales for the same month for the last 4 yrs have been 24 units, 30 units, and 27 units, what is the avg number of units you can expect … 
Marketing
A survey of local businesses firms to determine how they forecast sales will produce a variety of answers. Some will claim they do not use any format techniques to forecast sales. You know they must be using some approach, no matter … 
Finance
Here is a forecast of sales by National Bromide for the first 4 months of 2012 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 19 28 22 18 Salesoncrdt 140 160 130 110 On average, 40% of credit sales are paid for in the … 
math
the actual sales for the last four years have been 24 units,30units,23units and 27 units what is the average number of units you can expect to sell next month? 
Qualitative analysis
Computer sales over the past 4 months have been 35, 34, 38, and 44 units. Using a 3month moving average, forecast sales for the next month. Using a 3month weighted moving average with the weights 3, 2, and 1, and with the most weight … 
C Programming
Write a C program that accepts sales made by 5 sales reps for the 4 months that they have been selling the company's products. The program should then find the total sales for 4 months, total sales for each sales rep, and total sales … 
C Programming
how do i write a C program that accepts sales made by 5 sales reps for the 4 months that they have been selling the company's products. The program should then find the total sales for 4 months, total sales for each sales rep, and …