Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Problem 2 : The forecast for each week is 30 units. The starting inventory is 12. The production lot size is 70 (MPS) when the
Problem 2:
- The forecast for each week is 30 units.
- The starting inventory is 12.
- The production lot size is 70 (MPS) when the projected on-hand inventory is negative.
- Calculate the Projected on-hand inventory (POI)
- Calculate the Available to Promise (ATP)
Given the following Master Schedule:
Week | Customer order |
1 | 34 |
2 | 29 |
3 | 28 |
4 | 35 |
5 | 32 |
6 | 33 |
7 | 35 |
8 | 35 |
Week | ||||||||
Begining inventory= 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Forecast | ||||||||
Customer Orders | ||||||||
Projected On-Hand Hand Inventory | ||||||||
MPS | ||||||||
ATP |
Note:
The ATP quantities can be presented to the Marketing Department to promise customers the number of units to be manufactured by a specific date.
Formula: Week 1 ATP = Beginning Inventory + MPS Customer Order
Week 2 ATP = MPS Customer Order
Week 3 ATP = MPS (Wk3 + Wk4)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started