Question

In: Operations Management

Complete the two Available-to-Promise tables below. a. On-hand = 30 Period 1 2 3 4 5...

Complete the two Available-to-Promise tables below.

a.

On-hand = 30

Period

1

2

3

4

5

6

Forecast

100

50

100

50

100

50

Customer Orders

75

50

116

73

45

23

Master Production Schedule

100

200

150

Available-to Promise

b.

On-hand = 100

Period

1

2

3

4

5

6

Forecast

50

100

50

100

100

150

Customer Orders

75

125

75

135

45

53

Master Production Schedule

200

200

200

Available-to Promise

Solutions

Expert Solution

a

ATP for Period 1 and 2 = On-hand + Master Production Schedule for Period 1 - (Customer order for Period 1 + Customer Order For period 2) = 30 + 100 - (75+50) = 130 - 125 = 5

ATP for Period 3 and 4 = Master Production Schedule for Period 3 - (Customer order for Period 3 + Customer Order For period 4) = 200 - (116 + 73) = 200 - 189 = 11

ATP for Period 5 and 6 = Master Production Schedule for Period 5 - (Customer order for Period 5 + Customer Order For period 6) = 150 - (45 + 23) = 150 - 68 = 82

b.

ATP for Period 1 and 2 = On-hand + Master Production Schedule for Period 1 - (Customer order for Period 1 + Customer Order For period 2) = 100 +200 - (75+125) = 100 + 200 - 200 = 100

ATP for Period 3 and 4 = Master Production Schedule for Period 3 - (Customer order for Period 3 + Customer Order For period 4) = 200 - (75 + 135) = 200 - 210 = -10

ATP for Period 5 and 6 = Master Production Schedule for Period 5 - (Customer order for Period 5 + Customer Order For period 6) = 200 - (45 + 53) = 200 - 98 = 102

keosha answered 2 years ago
Next > < Previous

Related Solutions

Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6...
Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 3% -2% 9% 6% -1% -4% 11% Stock Y 1% -4% 7% 12% 3% -2% -1% Consider a portfolio of 20% stock X and 80% stock Y. What is the (population) variance of portfolio returns? Please round your answer to six decimal places. Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6...
Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 5% 6% -2% -4% 6% 10% 7% Stock Y 1% -3% 6% 3% 12% 7% -5% Consider a portfolio of 40% stock X and 60% stock Y. What is the (population) variance of portfolio returns? Please round your answer to six decimal places.
Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6...
Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 5% 6% -2% -4% 6% 10% 7% Stock Y 1% -3% 6% 3% 12% 7% -5% Consider a portfolio of 40% stock X and 60% stock Y. What is the (population) variance of portfolio returns? Please round your answer to six decimal places. Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
Returns on stock X are listed below: Period 1 2 3 4 5 6 7 Stock...
Returns on stock X are listed below: Period 1 2 3 4 5 6 7 Stock X 8% 0% 3% -2% 5% 12% 7% What is the (population) standard deviation of the data? Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123). Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1...
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1 4 4 4 1 2 3 3 2 Which descriptive statistics from your output would you NOT report for Hours spent Exercising? Why not? Write a few sentences describing the data (use APA formatting). This interpretation should not include only the numbers, but rather what the numbers tell you about the data. Create a histogram for the hours spent exercising. You can do this...
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1...
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1 4 4 4 1 2 3 3 2 How many participants were there in the study? What percentage of the sample exercised 4 or more hours? Report the following regarding the number of hours spent exercising, calculating by hand or using the Excel sheet provided to you. Mean: Median: Mode: Range: Variance: 4. Which descriptive statistics from your output would you NOT report for...
Use data below to complete 5 3 0 0 0 5 1 2 0 1 1...
Use data below to complete 5 3 0 0 0 5 1 2 0 1 1 1 1 7 0 2 2 1 2 0 6 4 1 3 2 4 0 1 1 0 0 0 1 3 0 2 1 0 3 0 3 0 1 2 8 2 3 0 0 5 1 1 3 10 1 0 2 0 1 0 Table 1.18 Frequency of Number of Movies Viewed Number of Movies Frequency Relative Frequency Cumulative...
4. (a) Suppose that τσ=(1 5 2 3)(4) and στ=(1 2 4 5)(3) in S5. If...
4. (a) Suppose that τσ=(1 5 2 3)(4) and στ=(1 2 4 5)(3) in S5. If σ1 = 2, find σ and τ. (b) In Sn, show that σ = τ if and only if σ(τ)^(−1) = ε. ε is the identity permutation. Must be written as a proof. (c) Let σ=(1 2 3) and τ=(1 2) in S3. Show that S3={ε,σ,σ^2,τ,τσ,τ(σ)^2} and that σ^3=ε=τ^2 and στ=τ(σ)^2, then fill out the multiplication table for S3.
1) Consider the following requirements for a certain product. Period 1 2 3 4 5 6...
1) Consider the following requirements for a certain product. Period 1 2 3 4 5 6 7 8 Gross requirements 0 200 200 500 0 400 0 400 Beginning inventory = 300 units Setup cost = $300 per setup Lead time = 1 week Holding cost = $5 per unit per week (a) Develop the lot-for-lot MRP table - (complete table below). (b) Calculate the total relevant costs. Answer (Show all mathematical work): a) Period 1 2 3 4 5...
Monthly returns for two stocks are given below: Month 1 2 3 4 5 6 7...
Monthly returns for two stocks are given below: Month 1 2 3 4 5 6 7 8 9 10 11 12 rA 4.10% 1.12% 1.66% −0.18% −4.71% −0.60% −0.91% 1.02% 1.69% −0.51% 1.42% 2.52% rB −3.36% −1.93% −0.45% 0.34% 4.27% 8.48% 1.86% 4.10% 6.41% −5.24% −1.06% 1.40% (a) Calculate the correlation between the returns of these two stocks. Consider a portfolio of the two stocks weighted 60:40 at t = 0. (b) Calculate the returns on the rebalanced portfolio for...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT