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

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

Moving average
Weighted moving average
The same
Not enough information to evaluate

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

jeff jeffy answered 10 months ago

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

USE THE FOLLOWING INFORMATION FOR THE NEXT 2 QUESTIONS Cornell Products has the following information available...

USE THE FOLLOWING INFORMATION FOR THE NEXT 2 QUESTIONS Cornell Products has the following information available for 2020: UNITS BEGINNING INVENTORY-----0 UNITS ENDING INVENTORY----5,400 UNITS COSTS Direct materials $1.00 per unit Direct labor $2.00 per unit Variable manufacturing overhead $1.50 per unit Variable selling and administrative costs $ .50 per unit Fixed manufacturing overhead $30,000/6,000 = $5.00 per unit Fixed selling and administrative costs $25,000 During 2020, Cornell produced 6,000 units out of which 5,400 units...