Question

In: Statistics and Probability

The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given...

The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given below.

Month

Sales

Month

Sales

1

12

8

14

2

14

9

17

3

16

10

12

4

10

11

14

5

15

12

16

6

17

13

11

7

11

a) Use a weighted moving average for three periods to forecast sales for next month. Use a weight of 3 for the most recent period, 2 for the middle period, and 1 for the third previous period. What is the forecasted number of vacuum sales for next month?

b) Use a weighted moving average for three periods to forecast sales for next month. Use a weight of 4 for the most recent period, 3 for the middle period and 2 for the third previous period. What is the forecasted number of vacuum sales for next month?

c) Which forecast of sales should Lowenthal use and why?

Solutions

Expert Solution

a)

MAD = 2.73

MSE = 9.63

MAPE = 21.55%

b)

MAD = 2.54

MSE = 8.45

MAPE = 20.04%

c)

MSE part a > MSE part b

Part b forecast of sales should Lowenthal use


Related Solutions

Sales of floor cleaners at Lavoie's Flooring Co. over the past 13 months are as follows:...
Sales of floor cleaners at Lavoie's Flooring Co. over the past 13 months are as follows: Sales of floor cleaners -Lavoie's Flooring Co.   Month Sale ($1,000s) Total 3 Months 3 Months Avg. January 11 February 14 41 13.66666667 March 16 40 13.33333333 April 10 41 13.66666667 May 15 42 14 June 17 43 14.33333333 July 11 42 14 August 14 42 14 September 17 43 14.33333333 October 12 43 14.33333333 November 14 42 14 December 16 41 13.66666667 January 11...
QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as...
QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as follows: MONTH UNITS SOLD 1 1140 2 1180 3 1130 4 1180 5 1110 6 1200 7 1280 8 1340 9 1340 10 1240 11 1140 12 1230 13 1440 14 1530 15 1560 16 1350 17 1350 18 1420 19 1530 20 1530 21 1430 22 1430 23 1490 24 1570 It is obvious that the monthly sales are increasing, but it is...
If you were given a large data set, such as the sales over the last year...
If you were given a large data set, such as the sales over the last year of our top 100 customers, what might you be able to do with these data? What might be the benefits of describing the data?
Budgeted sales in Acer Corporation over the next four months are given below: September October November...
Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted Sales $140,000 $150,000 $170,000 $130,000 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder...
1. Budgeted sales at O’Brien Vineyards over the next four months are given below: July August...
1. Budgeted sales at O’Brien Vineyards over the next four months are given below: July August September October Budgeted sales $100,000 $160,000 $180,000 $120,000 All of the company's sales are on account. Collections for sales on account follow a pattern as follows: 70% of a month's credit sales are collected in the month of sale, 25% are collected in the month following sale, and the remainder is uncollectible. There is a $20,000 accounts receivable balance that will be collected in...
Based on an analysis of the last six months’ sales, your boss notices that sales of...
Based on an analysis of the last six months’ sales, your boss notices that sales of beef products are declining in your chain’s restaurants. As beef entrée sales decline, so do profits. Fearing beef sales have declined due to several newspaper stories reporting E.coli contamination discovered at area grocery stores, he suggests a survey of area restaurants to see if the situation is pervasive. What do you think of this research suggestion? How, if at all, could you improve on...
Given these sales figures over the last 7 weeks, your boss needs you to test two...
Given these sales figures over the last 7 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of “best”, recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 8 in part c. Week                        Unit Sold 1                                 9,040 2                                 11,150 3 9,420 4                                 10,310 5                                 11,950...
Thomas Train has collected the following information over the last six months.
Thomas Train has collected the following information over the last six months.MonthUnits producedTotal costsMarch10,000$25,600April12,00026,200May19,60028,000June13,00026,450July12,00026,000August15,00026,500Using the high-low method, what is the variable cost per unit?Round to two decimal places.
Over the last few months, the Bank of Ghana (BoG) has cracked the whip at the...
Over the last few months, the Bank of Ghana (BoG) has cracked the whip at the banking industry in a bid to restore sanity in the industry. In August 2017, the UT and Capital Banks were liquidated for failing to meet the BoG’s minimum capital ratio. The operations of UniBank, Royal Bank, Beige Bank, Sovereign Bank, and Construction Bank ended. In their place the BoG announced a new bank called the Consolidated Bank, as part of measures to ensure the...
The following data represent the profit in thousands over the last 60 months, of an SME...
The following data represent the profit in thousands over the last 60 months, of an SME 142 123 109 124 142 117 108 106 103 114 91 102 108 110 83 90 69 117 84 122 113 105 112 117 122 129 100 138 99 106 102 115 120 120 117 122 111 119 109 125 108 116 105 117 114 101 99 112 120 108 91 115 105 99 122 106 113 114 75 96 (a) Make a frequency...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT