Question

In: Finance

The next three questions are based on the following information. Sam has a cleaning service. To...

The next three questions are based on the following information.

Sam has a cleaning service. To better allocate his resources, he would like to forecast his weekly orders based on the order number he received in the past 13 weeks as shown in the following table.

Week

Demand

Week 1

11

Week 2

14

Week 3

16

Week 4

10

Week 5

15

Week 6

17

Week 7

11

Week 8

14

Week 9

17

Week 10

12

Week 11

14

Week 12

16

Week 13

15

  1. Using a three week moving average, Sam's forecast for his Week 14 order number is ________ . (Please round to two decimal points and include no units.)
  2. Using a three week weighted moving average with weights 3, 2, and 1 given to the most recent, second most recent, and third most recent week, respectively, Sam’s forecast for his week 14 order number is _____________ . (Please round to two decimal points and include no units.)
  3. If the MAD for moving average is 4.17 and the MAD for weighted moving average is 2.38, then which forecast is more accurate?
  1. Moving average
  2. Weighted moving average
  3. The same
  4. Not enough information to evaluate

Solutions

Expert Solution

A) Calculation of Week 14 order using a three week moving average:

-To derive the demand for week 14, we need to calculate the average of demands of week 11, 12 and 13 (Using a three week moving average)

-The three weeks selected (i.e:11,12 and 13) are the latest and hence the best indicators to calculate the demand for week 14.

-Therefore,

14+15+16/3

=15

Hence, the demand for Week 14 is 15 units.

B) Calculation of Week 14 order using a three week weighted moving average:

-To derive the demand for week 14, we need to calculate the weighted average of demands of week 11, 12 and 13 (Using a three week weighted moving average)

-Week 13 being the latest will be assigned a weight of 3.Similarly, week 12 will be assigned a weight of 2 and week 11 will be assigned a weight of 1.

-Therefore,

Week Demand Weights Demand*weight
11 14 1 14
12           16 2 32
13           15 3 45
6 91

Therefore, weighted average demand=Demand*weight/weights

=91/6

=15.17 units

Hence the demand using the weighted moving average approach is 15.17 units.

C) MAD is an acronym of mean absolute deviation. It is the deviation of a population from its average (mean) in absolute terms. Therefore, lesser the deviation from the mean, the more accurate the population is.

In the above case, MAD for moving average is 4.17 and for weighted moving average is 2.38. Hence, the forecast using the weighted moving average is more accurate as compared to moving average since its deviation from the mean is lesser.


Related Solutions

This question and the next are based on the following information. Paul and Sam (an 80%...
This question and the next are based on the following information. Paul and Sam (an 80% owned affiliate) reported the following income related accounts for year X1: Paul Sam Revenue $100,000 $50,000 Cost of Sales -$60,000 -$30,000 Depreciation -$20,000 -$10,000 Income $20,000 $10,000 During year X1, Sam sold 100 inventory units to Paul for $50 each that cost Sam $30. As of 12/31/X1, Paul had managed to sell 50 of the units. How much income should be recognized by P?...
The next three questions are based on the following information. To study the weight accuracy of...
The next three questions are based on the following information. To study the weight accuracy of a 50lb fertilizer bag, 12 samples of 12 bags of fertilizer in each sample were taken and the results are as follows. Mean Range Sample 1 47 1.1 Sample 2 46 1.31 Sample 3 46 0.91 Sample 4 47 1.1 Sample 5 48 1.21 Sample 6 50 0.82 Sample 7 49 0.86 Sample 8 49 1.11 Sample 9 51 1.12 Sample 10 52 0.99...
The next three questions are based on the following information: Strata Company is a retailer whose...
The next three questions are based on the following information: Strata Company is a retailer whose shares are publicly traded. During year X1, Strata reported the following quarterly financial information in its SEC filings: Quarter Q1 Q2 Q3 Q4 Pre-Tax Income 100,000 130,000 140,000 180,000 Taxes (20%) (20,000) (26,000) (28,000) (36,000) Net Income 80,000 104,000 112,000 144,000 As a retailer, Strata counts its inventory on 6/30 and 12/31 of each year. While observing Strata's inventory count on 12/31/X1 prior to...
The next three questions are based on the following information. The Low Knock Oil Company produces...
The next three questions are based on the following information. The Low Knock Oil Company produces two grades of cut-rate gasoline for industrial distribution. The grades, regular and economy, are produced by refining a blend of two types of crude oil, type X100 and type X220. Each crude oil differs not only in cost per barrel, but in composition as well. The following table indicates the percentage of crucial ingredients found in each of the crude oils and the cost...
The following information is for the next three questions. Investor P has the following portfolio: Stock...
The following information is for the next three questions. Investor P has the following portfolio: Stock Amount Return Beta A 10,000 10% 1.2 B 30,000 12% 0.8 C 20,000 15% 1.4 D 40,000 20% 2.0 01 - What are the weights of these four stocks in the portfolio? A. w1= 20%, w2= 30% w3 = 20% w4= 10% B. w1= 10%, w2= 40% w3 = 20% w4= 10% C. w1= 10%, w2= 30% w3 = 20% w4= 40% D. w1=...
Use the following information to answer the next three questions: The following information is available from...
Use the following information to answer the next three questions: The following information is available from the records of Aggies R Us, Inc. at the end of the 2017 calendar year.  Assume this is Aggies’ 1st year of operation. Accounts Receivable           $102,200        Notes Payable                       $???? Cash                                        70,890              Salary Expense                   320,000 Building                                    75,000           Retained earnings ???? Advertising Expense                60,000             Accounts Payable                  62,800                                    Dividends                                 12,200             Income Tax Expense             23,100 Service Revenues                  460,000             Common Stock                    120,000            Office Equipment                     22,500             Wages Payable                     15,450 Determine Aggies’ Net Income for the year ended December 31, 2017: A. $36,900 B. $80,000 C. $56,900 D. $44,700...
The next 6 questions are based on the following information for Wagner Company for the years...
The next 6 questions are based on the following information for Wagner Company for the years 2012, 2011, and 2010: 2012 2011 2010 Total revenues $910,000 $620,000 $540,000 Total expenses $780,000 $530,000 $450,000 Total assets $600,000 $300,000 $270,000 Total liabilities $320,000 $180,000 $140,000 Total owners’ equity $ ? $ ? $ ? 1. The percent increase in total revenues from 2010 to 2012 is (round to nearest whole percent) A. 85% B. 14% C. 69% D. 44% E. None of...
The next three questions are based on the following data on the closing price at year’s...
The next three questions are based on the following data on the closing price at year’s end in Euros of the DAX Stock Index. year 1994 1995 1996 1997 closing price 2100.98 2280.81 2844.09 4125.54 11. Find ˆm. A. ≈ 506.4 B. ≈ 663.7 C. ≈ 792.4 D. ≈ 914.9 E. other value 12. Find the coefficent of determination. A. ≈ .877 B. ≈ .899 C. ≈ .936 D. ≈ .948 E. other value 13. Find a 90% confidence interval...
USE THE FOLLOWING INFORMATION FOR THE NEXT 2 INDEPENDENT QUESTIONS:    Tremaine Inc. has three product...
USE THE FOLLOWING INFORMATION FOR THE NEXT 2 INDEPENDENT QUESTIONS:    Tremaine Inc. has three product lines: A, B, and C. A B C Total Sales $50,000 $85,000 $90,000 $225,000 Variable costs 30,000 30,000 44,000 104,000 Contribution margin 20,000 55,000 46,000 121,000 Fixed costs 23,000 25,000 18,000     66,000 Net income $ (3,000) $30,000 $28,000 $ 55,000 28. Management is considering dropping product line A. If it is discontinued, $18,000 of its fixed costs are DTFC & can be avoided....
he next two questions are based on the following information: Assume that Forrest Company uses the...
he next two questions are based on the following information: Assume that Forrest Company uses the LIFO accounting method. In year X1, Forrest reported the following information: Units Unit Cost Total Cost Beginning Inventory (1/1/X1) 1,000 10 10,000 Purchases (year X1) 2,000 11 22,000 Year X1 Sales 1,500 Ending Inventory (12/31/X1) 1,500 Based on the above information, Forrest Company will report which of the following amounts for its LIFO Inventory on 12/31/X1? The next two questions are based on the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT