Question

In: Economics

Sales for boxes of Girl Scout cookies over a 4-month period were forecasted as follows: 100,...

Sales for boxes of Girl Scout cookies over a 4-month period were forecasted as follows: 100, 120, 115, and 126. The actual results over the 4-month period were as follows: 110, 114, 119, 115. What was the MAD of the 4-month forecast?

5

0

108

7

None of the above

Solutions

Expert Solution

MAD means the Mean Absolute Deviation. Mean absolute deviation is calculated by actual value minus forcasting value all periods divided by number of periods. We take the absolute value of the difference. So we are not bother about sign of difference . So MAD = SUM OF (ACTUAL VALUE - FORCASTING VALUE) / NO OF PERIODS. We will take the absolute value of the difference. Here total number of periods is 4 because here data is given for 4 months.

Now forecasing value of 4 months are 100, 120, 115 and 126. Now actual value value for the 4 months are 110, 114, 119 and 115. So we can say for the first month the absolute deviation is 110 - 100 = 10, for the second monthe devation is 114 - 120 = -6 , absolute deviation is 6. For the third month deviation is 119 - 115 = 4, absolute deviation is also 4. For the 4th monthe the deviation is 115 - 126 = -11, absolute deviation is 11. So total absolute deviation is 10+6+4+11 = 31 and number of periods is 4 . So MAD = 31/4 = 7.75.

MAD = 7.75 , Ans. None of the above

So answer is None of the above. If we take the round up value it will not be 7.


Related Solutions

GIRL SCOUT COOKIES                 You are contacted by the top cookie-selling Girl Scout troop in the...
GIRL SCOUT COOKIES                 You are contacted by the top cookie-selling Girl Scout troop in the city. As part of their sales plan for next year’s cookie selling season, they need to know (with 90% confidence) if the types of cookies purchased by their customers depends on where the scouts sell them. Here is their confidential sales data from last year: Type of Cookie Sold Thin Mints Tagalongs Do-si-dos Trefoils Samoas Sales Method At parents’ workplace 472 641 350 223...
Girl Scout Cookies and the Snack Tax State sales taxes often exempt food purchased for at-home...
Girl Scout Cookies and the Snack Tax State sales taxes often exempt food purchased for at-home consumption to help relieve regressivity. However, that exemption causes substantial loss of revenue. Furthermore, some people question the nutritional value of certain items exempted under the food label and doubt the wisdom of losing revenue in a tax structure to provide relief to such purchases. In difficult fiscal times in the early 1990's, a few states sought additional revenue by narrowing the food exemption,...
A girl scout and her mom are setting up a table to sell cookies in front...
A girl scout and her mom are setting up a table to sell cookies in front of a grocery store. They have available 3 boxes of Samoas, 4 boxes of Tagalons, 6 boxes of Do-si-dos, and 7 boxes of Trefoils. Each box sells for $5. a.) Define random variable you will need. b.) Determine the probability distribution and parameters for the random variable defined. c.) Suppose that, after two hours, ten boxes of cookies have been purchased. Determine the cumulative...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $100,000 June 180,000 July 200,000 August 140,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $100,000 June 180,000 July 200,000 August 140,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...
The following data relate to the sales of a product over an 8-month period: MONTH Jan...
The following data relate to the sales of a product over an 8-month period: MONTH Jan Feb Mar Apr May June July Aug Sales (units) 56 72 70 65 68 75 66 67 Price ($) 75 65 59 69 69 49 59 59 a) Investigate whether sales are affected more by the level of price or by the change in price of the product. b) Interpret the regression coefficient of the explanatory variable. c) Forecast sales in September if price...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: SalesMonth(000)UnitsFeb.19Mar.22Apr.8May.24Jun.19Jul.27Aug .22b. Forecast September sales volume using each of the following: (1) A linear trend equation. (2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000). (4) The naive approach. (5) A weighted average using .50 for August, .15 for July, and.35 for June. 
Problem # 1 The monthly sales for Telco Batteries Inc. were as follows:                         Sales Month     &
Problem # 1 The monthly sales for Telco Batteries Inc. were as follows:                         Sales Month            (000 units) January            20 February          21 March              15 April                14 May                 13 June                 16 July                 17 August            18 September       20 October           20 November       21 December        23 Plot the monthly sales data. Forecast coming January sales using each of the following: The naïve approach A 6-month moving average A 6-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2 and 0.3, with the heaviest...
Over a 4 year period the black corp purchased 100% of the outstanding voting shares of...
Over a 4 year period the black corp purchased 100% of the outstanding voting shares of White Co. The acquisition was made in a series of steps as follows: DATE:                             %                        Purchase Price Jan 1, Year 1 5% 5,000 Jan 1, Year 2 10% 12,000 Jan 1, Year 3 10% 15,000 Jan 1, Year 4 75% 200,000 Total 100% 232,000 Any excess of the purchase price over the net book value of the assets was attributed to goodwill. The acquisition...
Over a 4 year period the Yellow corporation purchased 100% of the outstanding voting shares of...
Over a 4 year period the Yellow corporation purchased 100% of the outstanding voting shares of Green Co. The acquisition was made in a series of steps as follows... Date % Purchase Price January, Year 1 5% 5,000 January, Year 2 10% 12,000 January, Year 3   10% 15,000 January, Year 4 75% 200,000 Total 100% 232,000 Any excess of the purchase price over the net book value of the assets was attributed to goodwill. The acquisition in Year 3 allowed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT