Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Lot size: 110 (units) Lead time: 2 (weeks) Quantity on Hand: 70 (units) Week 1 2 3 4 5 6 7 8 9 10 Forecast
Lot size: | 110 | (units) | ||||||||
Lead time: | 2 | (weeks) | ||||||||
Quantity on Hand: | 70 | (units) | ||||||||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Forecast | 35 | 35 | 35 | 35 | 35 | 35 | 25 | 25 | 25 | 25 |
Customer orders | 22 | 35 | 10 | 13 | 0 | 0 | 12 | 0 | 0 | 0 |
Gross Requirement | 35 | 35 | 35 | 35 | 35 | 35 | 25 | 25 | 25 | 25 |
Projected on Hand | 35 | 0 | 75 | 40 | 5 | 80 | 55 | 30 | 5 | 90 |
Net requirement | 0 | 0 | -40 | -5 | 30 | -45 | -30 | -5 | 20 | -65 |
MPS Quantity | 0 | 0 | 110 | 0 | 0 | 110 | 0 | 0 | 0 | 110 |
MPS Start | 110 | 0 | 0 | 110 | 0 | 0 | 0 | 110 | 0 | 0 |
ATP | 13 | -58 | 87 | -13 | -12 | 98 | -12 | 0 | 0 | 110 |
Order | Units | Period | ATP | New ATP | ||||||
1 | 40 | 3 | 87 | 47 | ||||||
2 | 80 | 4 | 0 | -80 | ||||||
3 | 90 | 6 | 98 | 8 | ||||||
4 | 60 | 3 | 87 | 27 | ||||||
5 | 20 | 5 | 0 | -20 | ||||||
6 | 20 | 9 | 0 | -20 | How do I determine which one to accept and reject? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started