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.
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 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 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, 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 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 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...
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...
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: 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 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 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...