Question

In: Operations Management

The actual demand data for an item at a local retailer during the past six weeks...

The actual demand data for an item at a local retailer

during the past six weeks are shown below:

WEEK

ACTUAL DEMAND

(number of units)

Six weeks ago

202

Five weeks ago

201

Four weeks ago

199

Three weeks ago

200

Two weeks ago

203

One week ago

198

THIS WEEK

ACTUAL DEMAND NOT KNOWN

Determine the demand forecast for THIS WEEK using each of the following methods:

a. A 3-week moving average.

[3]

b. A 4-week weighted moving average using weights of 15, 5, 3, and 2 for one week ago, two

weeks ago, three weeks ago, and four weeks ago, respectively. (

Hint

: the higher weights

are applied to the more recent time periods.)

c. Exponential smoothing using the following: smoothing constant,

= 0.4 and the demand

forecast for three weeks ago = 199 units.

Solutions

Expert Solution

a) A 3-periods moving average method averages the actual value for the previous three periods to generate the forecast for the next period. This can be calculated as the sum of the actual value for the previous three periods / 3

So using the above formula the forecast for this week = (200+203+198)/3

= 601/3

= 200.33

b) using a four period weighted moving average method the formula to calculate the forecast is : Sum of the product of the actual value and their respective weights for the previous four periods/(Sum of weights).

So using this formula the forecast for this week= [(2 x 199) + (3 x 200) + (5 x 203) + (15 × 198)]/(2+3+5+15)

= (398+600+1015+2970)/25

= 4983/25

= 199.33

c) Using the exponential smoothing method the formula to calculate the forecast is as follows :

Ft = F(t-1) + [A(t-1) - F(t-1)]

Where Ft = forecast for period t

A(t-1)= actual value for period previous to t

F(t - 1)= forecast for period previous to t

= smoothing constant

So using the above formula with =0.4 and forecast for three weeks ago = 199 , the forecast for the following weeks are :

For two weeks ago = 199 + 0.4(200-199) = 199+0.4= 199.4
For one week ago = 199.4+ 0.4(203-199.4) = 199.4+1.44 = 200.84
For this week = 200.84 + 0.4(198-200.84)= 200.84+(-1.136) = 200.84-1.136 = 199.704

keosha answered 1 month ago

Next > < Previous

Related Solutions

The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks...

The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks of this year are as follows: Week Actual # of Patients 65 66 70 58 63 54 Compute a simple exponential smoothing forecast for week 7 with ?=.5. Assume the forecast for week 1 is 65. b)Compute MAPE. c)What is the interpretation of your answer in part b)?

A retailer stocks an item that has an annual demand of 2400 units. The retailer uses...

A retailer stocks an item that has an annual demand of 2400 units. The retailer uses an order quantity of 300 units. For this item the retailer carries an average inventory of X units and places Y orders annually. X= 150 units; Y=8 orders X=1200 units; Y = 8 orders X=300 units; Y = 16 orders X = 1200 units; Y = 2 orders 0.67 0.33

The actual demand for the patients at Omaha Emergency MedicalClinic for the first 6 weeks...

The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows: Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three periods ago. a)...

Health Record Data Managnment During the past 6 weeks, you have been introduced to multiple knowledge...

Health Record Data Managnment During the past 6 weeks, you have been introduced to multiple knowledge areas, including healthcare environment in the US, healthcare settings, health information profession, professional organizations, and some health data management aspect. This week is dedicated to a review of some important concepts, which you will also see in the mid-term exam. You may start the review by selecting one of the questions below. Please try to read the answers prior to yours and try to...

The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows:

The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows: WEEKACTUAL NO. OF PATIENTS165262370448563652Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167...

11. You are responsible for the Demand Forecasting group at a mid-size company. Six weeks into...

11. You are responsible for the Demand Forecasting group at a mid-size company. Six weeks into the fiscal year, you are called to a meeting with two days of notice with the vice-president of sales, one of the finance directors and the company president. This is in reference to an email from executive leadership that the sales goals and plans are mis-aligned with your fiscal year forecast. It seems that your forecasts are 3.8% below sales plans and 3.5% below...

With the stock market reflecting extreme volatility during the past few weeks, some individuals are becoming...

With the stock market reflecting extreme volatility during the past few weeks, some individuals are becoming concerned about their equity portfolio’s and are either considering selling their stocks or have already done so. Many investors are looking for stability and believe the bond market is a safe haven for their money. Using the following information, please compute the investment performance and end of period asset value for the following “realistic” scenario. A $100,000 investment in a 15 year, AA-rated corporate...

Aligning Performance Appraisals and Compensation Plans During the past few weeks, we have learned that there...

Aligning Performance Appraisals and Compensation Plans During the past few weeks, we have learned that there are various methods of conducting employee performance appraisals (e.g., trait, behavioral, ranking, MBO, etc.). Your task for this assignment is to pick one of those methods, explain it, and discuss how it could be effectively used to impact employee compensation. Your response should consider the potential impact the performance evaluation method could have on at least three different organizational stakeholder groups. Also, your assignment...

Following are the data of a price and demand of an item recorded at different period...

Following are the data of a price and demand of an item recorded at different period of time for a garment manufacture Price(Rs.) 13 15 18 25 22 18 28 Demand 65 60 50 41 40 56 45 (a) Find the Karl Pearson’s Correlation coefficient. Also comment on its strength. (b) Estimate demand if price is Rs.68 (c) If Rs.2 is increased in price and demand is reduced by 3units, how the coefficient of correlation would be effected. (d) If...

Over the past 5? weeks, demand for wine at? Winston's Winery has been 950?, 2200?, 3300?,...

Over the past 5? weeks, demand for wine at? Winston's Winery has been 950?, 2200?, 3300?, 1800?, and 1550 bottles. Winston has placed weekly orders for glass bottles of 1150?, 2400?, 3900?, 1050?, and 900 units.? (Recall that the sample variance of a data set can be found by using the VAR.S function in Excel or by plugging each value x of the data set into the? formula: VarianceequalsStartFraction Summation from nothing to nothing left parenthesis x minus x overbar...

Subjects