ZuoTi.Pro
Question

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

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Ans) By using the given data 3-month weighted Moving Average forecast for March = (3x89) +(3 x 103) +(2x82) 3+372 = 92-5

0 0
Add a comment
Know the answer?
Add Answer to:
Latest monthly sales for a company are as follows: Month Sales November 84 December 82 January...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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 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

  • 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.

  • 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...

  • 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...

  • A can opener manufacturer has had monthly sales for a seven-month period as follows: Month         ...

    A can opener manufacturer has had monthly sales for a seven-month period as follows: Month          Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .20...

  • 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 July through December of the Year 2017. Automobile Tire Sales 55...

    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 July through December of the Year 2017. Automobile Tire Sales 550 576 590 602 622 664 689 905 860 869 886 920 Y ear 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Month Janua Februar March April June Jul August September October November December a. Compute a two-month moving average. What is...

  • Problem 1 The table below presents data for tire sales in the Costco Branch at South...

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

  • 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.

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

    The monthly sales for Yazici Batteries, Inc., were as follows:                                                                                                                                        Month Jan       Feb      Mar     Apr      May     Jun       Jul        Aug      Sept     Oct      Nov      DecSales    19        21        17        14        11        18        16        19        20        20        23        23b) The forecast for the next month (Jan) using the naive method (round your response to a whole number)The forecast for the next period (Jan) using a 3-month moving average approach =(round your response to two decimal places)The forecast for the next period (Jan) using a 6-month weighted average with weights ofandwhere the heaviest weights are applied to the most recent month = (round your response to one decimalplace)Using...

  • Q15. Consulting income at Kate Walsh Associates for the period January – May has been as...

    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.

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