Question
Below is the Bill of Materials (BOM) and Master Production Schedule (MPS) for a chair. The number in the parenthesis indicates the quantity needed and
Below is the Bill of Materials (BOM) and Master Production Schedule (MPS) for a chair. The number in the parenthesis indicates the quantity needed and the lead time is shown in weeks.
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Quantity Needed | 0 | 0 | 0 | 45 | 65 | 75 | 90 | 85 |
Determine the timing of the Planned Receipts and Planned Order Releases for the chairs assuming Scheduled receipts of 25 units in week 2 and 40 units in week 4 and a Projected On-hand Inventory of 20 units. Assume a L4L lot sizing rule with a lead time period of 2 weeks.
Item: Chairs Lot Size: L4L Description: Lead Time: 2 week | ||||||||
| Week | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
Gross Requirements |
|
|
|
|
|
|
|
|
Scheduled Receipts |
|
|
|
|
|
|
|
|
Projected Available Balance |
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
Planned Receipts |
|
|
|
|
|
|
|
|
Planned Order Releases |
|
|
|
|
|
|
|
|
Determine the timing of the Planned Receipts and Planned Order Releases for the leg assemblies assuming Scheduled receipts of 35 units in week 1 and a Projected On-hand Inventory on 40 units. Assume an Economic Order Quantity lot sizing rule where the EOQ is 100.
Item: Leg Assembly Lot Size: EOQ = 100 Description: Lead Time: 2 week | ||||||||
| Week | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
Gross Requirements |
|
|
|
|
|
|
|
|
Scheduled Receipts |
|
|
|
|
|
|
|
|
Projected Available Balance |
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
Planned Receipts |
|
|
|
|
|
|
|
|
Planned Order Releases |
|
|
|
|
|
|
|
|
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