Q15. Consulting income at Kate Walsh Associates for the period January – May has been as follows:
|
Month |
Income |
|
January |
7 |
|
February |
8 |
|
March |
9 |
|
April |
6 |
|
May |
5 |
Use 3-month weighted moving average to forecast June’s income with weights of 3 for the most recent period, 2 for the second most recent period, and 1 for the third most recent period.
3-month weighted moving average to forecast June’s income =(w1*x1+w2*x2+w3*x3)/(w1+w2+w3)
=(3*5+2*6+1*9)/(3+2+1) =6
Q15. Consulting income at Kate Walsh Associates for the period January – May has been as...
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
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...
The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...
Question 4 [12 marks] Sales of commercial elevators at Armsteel Co. over the 12 months were as below: Month Sales Month Sales January 898 July 900 February 1325 August 1502 March 1250 September 1311 April 1008 October 899 May 1497 November 1311 June 1186 December 1074 Use three-period weighted moving average with weights 0.5, 0.3, 0.2 (0.5 = most recent) to forecast the forecast for April and May. Show your works in the Excel. (label the tab in Excel spreadsheet...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...
Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 4 months were as follows: Month Price Per Chip January $1.801.80 February $1.671.67 March $1.701.70 April $1.851.85 This exercise contains only parts a, b, and c. a) Using a 2-month moving average, calculate the forecast for March and April (round your responses to two decimal places). Month Mar Apr Forecast $nothing $nothing a) Using a 2-year moving average, the...
Problem 1 The table below presents data for tire sales in the Costco Branch at South Dakota Avenue, Washington D.C. from the months of January through December of the Year 2019. 5983 Automobile Month Year Tire Sales January 5610 2019 February 5790 2019 March 2019 2019 April 6202 6460 2019 May 6608 2019 June July 2019 August 2019 9110 September 2019 8690 October 2019 8799 November 2019 8896 December 2019 9210 a. Compute a two-month moving average. What is the...
tioners? Refer to Problems 5-22, 5-25, and 5-26. 8 Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows: SALES SALES ($1,000s) MONTH ($1,000s) MONTH 11 January 14 August 14 February September 17 16 March 12 October 10 14 November April December 15 Мay 16 January 17 June 11 July 11 (a) Using a moving average with three periods, de- termine the demand for vacuum cleaners for next February (b) Using a...