Question

In: Operations Management

On hand inventory at end of week 5 = 75 Week 6 7 8 9 10...

On hand inventory at end of week 5 = 75

Week

6

7

8

9

10

11

12

13

Forecasted demand

200

200

200

300

300

300

250

250

Booked orders

265

210

190

280

260

225

180

120

Projected ending inventory

Master production schedule

600

900

750

Available to promise

???

XXX

Q4: What is the Available to Promise for week 9?

a. 135 units.

b. 145 units.

c. 0 units.

d. 360 units.

e. None of these answers are correct.

On hand inventory at end of week 5 = 75

Week

6

7

8

9

10

11

12

13

Forecasted demand

200

200

200

300

300

300

250

250

Booked orders

265

210

190

280

260

225

180

120

Projected ending inventory

???

Master production schedule

600

900

750

Available to promise

XXX

Q5: What is the Projected Ending Inventory for week 10?

a. 300 units.

b. None of these answers is correct.

c. 310 units.

d. 360 units.

e. 370 units.

Solutions

Expert Solution

Q4. Option a) 135 units

Explanation

Available to Promise for week 9 is MPS of the week 9-Actual orders till next production cycle(which is on 12 th week )

MPS of week 9 is 900

So Available to Promise for week 9 is 900-(280+260+225)=900-765=135 units

Q5.Option a) 300 units

Explanation

Projected Inventory=MPS+Opening Inventory-Requirement(Maximum of Forecast and Actual order)

Opening Inventory of week 10 is 600(closing inventory of week 9)

Requirement of week 10 is 300

MPS of week 10 is 0

Projected Inventory of week 10=0+600-300=300 units


Related Solutions

3, 7, 8, 5, 6, 4, 9, 10, 7, 8, 6, 5 Using the previous question...
3, 7, 8, 5, 6, 4, 9, 10, 7, 8, 6, 5 Using the previous question 's scores, If three points were added to every score in this distribution, what would be the new mean? If three points were added to every score in this distribution, what would be the new standard deviation. Remember, you have already calculated population standard deviation in a previous problem. This problem requires two answers.
Lawyer Nurse Teacher Control 8 6 9 8 5 7 6 7 7 6 8 6...
Lawyer Nurse Teacher Control 8 6 9 8 5 7 6 7 7 6 8 6 7 8 8 7 4 9 7 9 A researcher is interested in whether the likeability of a crying woman is affected by the viewer’s knowledge of the woman’s occupation. Twenty participants were shown a video of a woman crying and were asked to rate her likeability on a scale from 1 (not very likable) to 10 (highly likable). Prior to viewing the video,...
x 2 8 5 9 4 3 9 6 7 8 y 3 6 5 7...
x 2 8 5 9 4 3 9 6 7 8 y 3 6 5 7 9 7 4 6 9 9 -5.48x + 0.17 5.48x + 0.17 -0.17x + 5.48 0.17x + 5.48
Consider the paired sample {(3, 1),(3, 5),(6, 6),(6, 8),(7, 10)}. Do the following by hand (you...
Consider the paired sample {(3, 1),(3, 5),(6, 6),(6, 8),(7, 10)}. Do the following by hand (you may use a basic calculator, but not a statistical program). (a) Find estimates βˆ 0 and βˆ 1 of the regression parameters β0 and β1. (b) Make a rough sketch of the data and regression line. (c) Predict the value of y when x = 5. (d) Predict the value of y when x = 15. (e) Which prediction (part c or d) do...
Table: x: 6, 2, 15, 9, 12, 5, 8 y: 8, 9, 4, 7, 6, 9,...
Table: x: 6, 2, 15, 9, 12, 5, 8 y: 8, 9, 4, 7, 6, 9, 8 1) Make the scatter diagram. 2) Find the equation of the regression line using the formulas given in class. They must appear the intermediate steps of substitutions. Round the answers to three decimal places. 3) Find the correlation coefficient using the formulas given in class. Steps should appear intermediates of substitutions. Round the answer to three decimal places. 4) Find the value predicted...
Shoe Size 12 6 11 13 8 9 8 8 9 9 11 5 10 8...
Shoe Size 12 6 11 13 8 9 8 8 9 9 11 5 10 8 7 7 11 9 9 9 12 8 8 8 12 9 11 8 11 8 13 5 9 8 11 We need to find the confidence interval for the SHOE SIZE variable. To do this, we need to find the mean and standard deviation with the Week 1 spreadsheet. Then we can the Week 5 spreadsheet to find the confidence interval. This does...
Considering the following time series data: Week 1 2 3 4 5 6 7 8 9...
Considering the following time series data: Week 1 2 3 4 5 6 7 8 9 10 Sales 8 11 14 19 16 10 8 12 14 16 Compute the naïve forecast and the three-week Moving Average and evaluate the forecast accuracy considering the Mean Absolute Error (MAE), Mean Squared Error (MSE) and the Mean Absolute Percentage Error (MAPE) for each of these two predictions. Compare both of them and determine which is the best model
There is a deck with 42 cards, with 4, 5, 6, 7, 8, 9, A. There...
There is a deck with 42 cards, with 4, 5, 6, 7, 8, 9, A. There are three suits spades, hearts, and clovers. In each suit there are two of each card. So there are two 7 of spades, 7 of hearts, 7 of clovers and so on. Each hand dealt consists of 5 cards. 1. How many hands contains exactly a pair that consists of two cards with the same value? 2. How many hands contains exactly one pair...
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5...
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5 8 1 12 14 Each column represents a different treatment given to sick rats. Each cell is a different rat. Use statistical analysis and use post hoc testing using contrasts to find the best treatment. Treatment 1: vitamins Treatment 2: prescription pills Treatment 3: brain surgery Treatment 4: shock therapy Treatment 5: dietary changes
Use the sample space (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) to find...
Use the sample space (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) to find the probability for a random selected a) P(integer) b) P(less than 10 | less than 13) c) P(greater than 8 | less than 11) d) P(greater than 7 | greater 12)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT