Quantitative Analysis for Mgmt

posted by .

Computer sales over the past 4 months have been 35, 34, 38, and 44 units.
„L Using a 3-month moving average, forecast sales for the next month.
(35+34+38)/3 = 35.67
(34+ 38+44)3 = 38.67
„L Using a 3-month 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 (44-35)
35 +1 (9)
35 + 9
44

I am kinder lost on this, not sure if I did it correctly.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. 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 …
  2. 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 …
  3. 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 …
  4. 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 …
  5. 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 …
  6. 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 Sales-on-crdt 140 160 130 110 On average, 40% of credit sales are paid for in the …
  7. 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?
  8. Qualitative analysis

    Computer sales over the past 4 months have been 35, 34, 38, and 44 units. Using a 3-month moving average, forecast sales for the next month. Using a 3-month weighted moving average with the weights 3, 2, and 1, and with the most weight …
  9. 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 …
  10. 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 …

More Similar Questions