Question

Latest monthly sales for a company are as follows: Month Sales November 97 December 73 January...

Latest monthly sales for a company are as follows:

Month

Sales

November

97

December

73

January

106

February

100

March

Compute an exponential smoothing forecast for March with a smoothing coefficient of 0.6. Suppose that the forecast for February was 90.

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Latest monthly sales for a company are as follows: Month Sales November 97 December 73 January...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Latest monthly sales for a company are as follows: Month Sales November 84 December 82 January...

    Latest monthly sales for a company are as follows: Month Sales November 84 December 82 January 103 February 89 March Compute a 3-Month weighted Moving Average forecast for March with the following weights: 3 for the most recent month 3 for 2 months ago 2 for 3 months ago

  • Latest monthly sales for a company are as follows: Month Sales November 93 December 84 January...

    Latest monthly sales for a company are as follows: Month Sales November 93 December 84 January 105 February 72 March Compute a 3-Month weighted Moving Average forecast for March with the following weights: 3 for the most recent month 2 for 2 months ago 1 for 3 months ago

  • The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16,...

    The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.

  • Actual sales of TV's for the first six month in 2021 were as follows: January      60           ...

    Actual sales of TV's for the first six month in 2021 were as follows: January      60            February     80          March   42 April           68            May             44           June     72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period          2 Trends: Reduce this average by 6% per month for the next three months    3 Simple Moving Average (SMA): make a forecast for July using a three months simple moving average.        4 Weighted Moving Average (WMA): make...

  • 1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...

    1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...

  • Why %uncollected in November Sales = 15% and December = 35% ?

    The following is the sales budget for Shleifer, Inc., forthe first quarter of 2013:January February MarchSales budget $234,800 $249,300 $271,000Credit sales are collected as follows:65 percent in the month of the sale.20 percent in the month after the sale.15 percent in the second month after the sale.The accounts receivable balance at the end of the previous quarter was $106,800($76,300 of which were uncollected December sales).a. Compute the sales for November.b. Compute the sales for December.c. Compute the cash collections from...

  • The monthly sales for Telco Batteries Inc. were as follows:

    Problem # 1The monthly sales for Telco Batteries Inc. were as follows:                       SalesMonth            (000 units)January            20February          21March              15April                14May                 13June                 16July                 17August            18September       20October           20November       21December        23Plot the monthly sales data.Forecast coming January sales using each of the following:The naïve approachA 6-month moving averageA 6-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2 and 0.3, with the heaviest weights applied to the most recent months.Calculate the mean absolute deviation (MAD) and the mean squared error (MSE) for each of...

  • 1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

    1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. 21 Mar. 20 Apr. 17 May 22 Jun. 20 Aug. 22 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 March-forecast of...

  • Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83...

    Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83 March 1.70 September 1.70 April 1.85 October 1.65 May 1.90 November 1.70 June 1.87 December 1.75 Use a 3-month moving average and add the 3-month plot to the graph created in part (a). Which is better (using the mean absolute deviation): the 2-month average or the 3-month average? Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of...

  • The following is the data of recent refrigerator sales at a local Home Depot store. Month...

    The following is the data of recent refrigerator sales at a local Home Depot store. Month 1 2 3 4 5 Actual Sales 95 100 80 90 ??? Inputs will be exact numbers. What is the forecasted sales in month 5 using naive approach. Please use a 2-month simple moving average method to forecast sales in month 5. Please use a weighted moving average method, with weights of 0.6 one period ago, 0.3 two periods ago, and 0.1 three periods...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT