Question

In: Operations Management

Using the Weighted Average Forecasting model and the information below, calculate the demand forecast for Period...

  1. Using the Weighted Average Forecasting model and the information below, calculate the demand forecast for Period 19. Please Show Work

Week Number

10

11

12

13

14

15

16

17

18

Weight

0

0

0

5%

10%

10%

20%

25%

30%

Cases Shipped

2,500

2,650

2,325

2,200

2,700

2,750

2,900

2,850

2,925

Solutions

Expert Solution

Using weighted average model for forecasting, we know that

Forecast = ∑(weight of week*cases shipped in that week)

Here weights for 10th, 11th and 12th week = 0. SO we need not consider those weeks. We only will consider 13th to 18th week for calculating the forecast for 19th week.

Forecast for week 19 = weight for week 18*cases shipped in week 18 + weight for week 17*cases shipped in week 17 + weight for week 16*cases shipped in week 16 + weight for week 15*cases shipped in week 15 + weight for week 14*cases shipped in week 14 + weight for week 13*cases shipped in week 13

The data is:

Week

Weight

Cases shipped

13

5% = 0.05

2200

14

10% = 0.1

2700

15

10% = 0.1

2750

16

20% = 0.2

2900

17

25% = 0.25

2850

18

30% = 0.3

2925

Hence forecast for week 19 = (0.05*2200 + 0.1*2700 + 0.1*2750 + 0.2*2900 + 0.25*2850 + 0.3*2925)

= 110 + 270 + 275 + 580 + 712.5 + 877.5

= 2825

Forecast for week 19 = 2825

.

IF YOU HAVE ANY DOUBT, KINDLY COMMENT. I WOULD LOVE TO HELP YOU!!!

IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!

keosha answered 12 hours ago
Next > < Previous

Related Solutions

Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Using the information provided, calculate the weighted average number of common shares in circulation for the...
Using the information provided, calculate the weighted average number of common shares in circulation for the year 2020.  The common shares of a company were 120,000 on January 1, 2020.  On February 1, the company issued 60,000 additional shares  Another 48,000 were issued on March 1.  On April 1, the company issued 24,000 new shares.  On May 1, the company bought 36,000 portfolio shares  Purchased another 36,000 portfolio shares on June 1.  On...
Using the information below, calculate the cost of goods manufactured for the period:
Using the information below, calculate the cost of goods manufactured for the period:Beginning Raw Materials Inventory$26,000Ending Raw Materials Inventory31,000Beginning Work in Process Inventory56,000Ending Work in Process Inventory65,000Beginning Finished Goods Inventory81,500Ending Finished Goods Inventory68,000Cost of Goods Sold for the period541,000Sales revenues for the period1,255,000Operating expenses for the period233,000
1) Using a 5 period simple moving average, the forecast for period 13 will be:
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Using the following information, calculate the Weighted Average Cost of Capital (Ka) for the Carmel Restaurant:...
Using the following information, calculate the Weighted Average Cost of Capital (Ka) for the Carmel Restaurant: Capital Structure is 40% debt/ 60% equity, Interest Rate (Kdbt) = 7.5%, tax rate = 30%, market portfolio (Km) = 10.5%, risk-free rate = 4%, beta is estimated at 0.9 and the company has enough in new retained earnings to finance the equity portion of the capital budget.
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
Calculate the weighted average cost of capital for a firm with the following information:
Calculate the weighted average cost of capital for a firm with the following information:            Marginal corporate tax rate:                                                               25%            Bonds with $1,000 face value with a 6% coupon rate   with semi-annual payments matures in 10 years now sells for               $928.94            Preferred stock dividend                                                                        $5.50            Preferred stock price                                                                               $55.00Current common stock dividend per share                                               $1.50            Price per share of common stock                                                             $12.00            Floatation cost to sell new common stock                                    ...
​ Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective.
Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective. Please use Excel to calculate your forecasting answers, so behind the cells in Excel, there has to be formulas for answering the below questions. Your company wants to forecast the demand for their product, based on the data below a) Calculate the simple four-week moving average for weeks 5 through 12 b) Calculate the weighted three-week moving average using weights of 0.40, 0.40, and...
Calculate the Ending inventory from the following information using FIFO, WEIGHTED AVERAGE methods of Material issues:...
Calculate the Ending inventory from the following information using FIFO, WEIGHTED AVERAGE methods of Material issues: The details relating to the purchase and sales of Material X is given below. Calculate the Ending inventory and Cost of goods sold for the Material X: Date PARTICULARS OMR 1.1.2014 Opening stock of Material X 250 units at 1.200 5.1.2014 Purchased 350 units of Material X at 1.275 7.12014 Purchased 425 units of Material X at 1.340 10.1.2014 Sold 800 units 12.1.2014 Purchased...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT