Question

Two products are considered for evaluation, the data of which is as given per week. Historical...

Two products are considered for evaluation, the data of which is as given per week.

Historical Data for Product A

Week

1

2

3

4

5

6

7

8

Massachusetts

33

45

37

38

55

30

18

58

New Jersey

46

35

41

40

26

48

18

55

Total

79

80

78

78

81

78

36

113

Historical Data for Product B

Week

1

2

3

4

5

6

7

8

Massachusetts

0

3

3

0

0

1

3

0

New Jersey

2

4

0

0

3

1

0

0

Total

2

7

3

0

3

2

3

0

The lead time is 1.5 weeks and the standard deviation of lead time is 1.25 weeks. Refer the attached King Safety Stock analysis for conceptual clarity and answer the following questions,

i) If the lead time is considered to be constant, what would be the safety stock for product A & B?

ii) If the lead time is not constant and is as given in the data above but independent of the demand, what would be the safety stock for product A & B?

iii) If the lead time is not constant and is as given in the data above but dependent on the demand fluctuations, what would be the safety stock for Product A & B?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Two retailers are considering inventory management of one of the products they are both selling. Each...
Two retailers are considering inventory management of one of the products they are both selling. Each of them has an average demand of 12 units per week with a standard deviation of 2 units per week. The supply lead time is constant and equal to 2 weeks. 1. How much safety stock should each retailer keep to achieve a service level of 95% (z = 1.64)? Imagine now that those two retailers are going to be combined into one integrated...
Part A.  For Questions 1-8, Assume a constant demand, D=90 items/week Lead time, LT= 1.3 weeks Safety...
Part A.  For Questions 1-8, Assume a constant demand, D=90 items/week Lead time, LT= 1.3 weeks Safety stock, SS=6 Unit ordering cost, Co=$40/order Question 1a.  If the lot size, Q=78, then what is the inventory period in months? (A) 1.00     (B) 0.10     (C) 2.00     (D) 0.20     (E) 0.43 Question 1b.  If the lot size, Q=78, then what is the order frequency in quarters? (A) 30.0     (B) 10.0     (C) 2.3     (D) 120.0     (E) 15.0
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 16 2 22 3 17 4 23 5 15 6 17 7 21 8 19 9 20 10 18 11 15 12 23 (a) Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 16 2 22 3 17 4 23 5...
For a particular SKU, the lead time is 6 weeks, the average demand is 100 units...
For a particular SKU, the lead time is 6 weeks, the average demand is 100 units a week, and safety stock is 200 units. What is the average inventory if 10 weeks’ supply is ordered at one time? What is the order point? The standard deviation of demand during the lead time is 100 units. Calculate the safety stock required for the following service levels: 75%, 80%, 85%, 90%, 95%, and 99.99%. Calculate the change in safety stock required to...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 21 3 19 4 24 5 18 6 15 7 21 8 19 9 22 10 21 11 16 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 17 2 21 3 19 4 24 5 18 6...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 18 4 22 5 17 6 15 7 20 8 18 9 21 10 20 11 14 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3 18 4 22 5 17 6 15 7 20...
Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving...
Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving averages for the time series. Compute the MSE for the four-week and five-week moving average forecasts. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22. Week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5...
The demand for subassembly S is 120 units in week 7. Each unit of S requires2...
The demand for subassembly S is 120 units in week 7. Each unit of S requires2 units of T and 1 unit of U. Each unit of T requires 1 unit of​ V,1unit of​ W, and1 unit of X.​ Finally, each unit of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make​ S,1week to make​ T, 2 weeks to make​ U, 2 weeks to make​ V, 3...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14 17 12 17 14 Calculate the measures of forecast error using the naive (most recent value) method and the average of historical data (to 2 decimals). Naive method Historical data Mean absolute error Mean squared error Mean absolute percentage error Which method provides the most accurate forecasts? SelectNaiveHistorical dataItem 7