Question
Calculate Planned Order Releases for materials A-XXX, B-XXX, C-XXX, D-XXX, and E-XXX. Relevant data on independent requirements (forecast), BOM, and material master data are given
Calculate Planned Order Releases for materials A-XXX, B-XXX, C-XXX, D-XXX, and E-XXX. Relevant data on independent requirements (forecast), BOM, and material master data are given below.Assume ZERO on hand available inventory for all materials at the beginning.No Safety stock needed.
Note that material D-xxx shows up twice in the BOM.
The BOM for product A-XXX is shown below. One of D-XXX and two of E-XXX are assembled to make one unit of C-XXX. Two of C-XXX and one of D-XXX are needed to make one subassembly of B-XXX. Four units of B-XXX are further assembled to make one unit of the product A-XXX.
Independent requirements (demand) for product A-XXX are given below:
| Period | Independent Requirements |
| Week 49/Current year | 15 |
| Week 50/Current year | 10 |
| Week 51/Current year | 20 |
| Week 52/Current year | 25 |
Some Relevant Material Master Data
| Material | Lot Size | Lead time | Procurement type | Material type |
| A-XXX | LFL (Lot for Lot) | 5 days (to simplify, 5 working days == 1 week) | In-house production | Finished Product |
| B-XXX | LFL | 5 days | In-house production | Semi-finished Product |
| C-XXX | LFL | 10 days | In-house production | Semi-finished Product |
| D-XXX | Fixed Lot of 300 | 5 days | External Procurement | Raw Material |
| E-XXX | Fixed Lot of 500 | 5 days | External Procurement | Raw Material |
MRP CALCULATIONS
| Week No. | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 |
| Gross Independent Requirements for A-XXX | 15 | 10 | 20 | 25 | |||||
| Projected On Hand A-xxx | |||||||||
| Planned Order Receipt A-xxx | |||||||||
| Planned Order Release A-xxx | |||||||||
| Gross dependent Requirements for B-XXX | |||||||||
| Projected On Hand B-xxx | |||||||||
| Planned Order Receipt B-xxx | |||||||||
| Planned Order Release B-xxx | |||||||||
| Gross dependent Requirements for C-XXX | |||||||||
| Projected On Hand C-xxx | |||||||||
| Planned Order Receipt C-xxx | |||||||||
| Planned Order Release C-xxx | |||||||||
| Gross dependent Requirements for D-XXX D is needed twice in BOM | |||||||||
| Projected On Hand D-xxx | |||||||||
| Planned Order Receipt D-xxx (FL Procurement:300) | |||||||||
| Planned Order Release D-xxx | |||||||||
| Gross dependent Requirements for E-XXX | |||||||||
| Projected On Hand E-xxx | |||||||||
| Planned Order Receipt E-xxx (FL procurement: 500) |
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
Apple Blossom Cologne Company Audit Case
Authors: Jack Paul
5th Edition
0072844507, 978-0072844504
