Solve the Test Problem Manually
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.
The BOM for product A-XXX is shown below. One unit of D-XXX and two units of E-XXX are assembled to make one unit of C-XXX. Two units 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 (Forecast Demand) for Finished Product A-XXX
|
Period
|
Independent Requirements
|
|
Week 6/2014
|
15
|
|
Week 7/2014
|
20
|
|
Week 8/2014
|
30
|
|
Week 9/2014
|
25
|
Relevant Material Master Data
|
Material
|
Lot Size
|
Lead Time
|
Procurement Type
|
Remarks
|
|
A-XXX
|
LFL
|
7 days
|
In-house Production
|
Finished Product
|
|
B-XXX
|
LFL
|
7 days
|
In-house Production
|
Semifinished Product
|
|
C-XXX
|
LFL
|
14days
|
In-house Production
|
Semifinished Product
|
|
D-XXX
|
Fixed Lot of 800
|
7 days
|
External Procurement
|
Raw Material
|
|
E-XXX
|
Fixed Lot of 1000
|
7 days
|
External Procurement
|
Raw Material
|
Q.1 Complete the following MRP explosion manually.
|
Week No.
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
|
Gross Requirements for A-XXX
|
|
|
|
|
|
15
|
20
|
30
|
25
|
|
Projected Available Balance
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipt
|
|
|
|
|
|
|
|
|
|
|
Planned Order Release
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Requirements for B-XXX
|
|
|
|
|
|
|
|
|
|
|
Projected Available Balance
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipt
|
|
|
|
|
|
|
|
|
|
|
Planned Order Release
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Requirements for C-XXX
|
|
|
|
|
|
|
|
|
|
|
Projected Available Balance
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipt
|
|
|
|
|
|
|
|
|
|
|
Planned Order Release
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Requirements for D-XXX
|
|
|
|
|
|
|
|
|
|
|
Projected Available Balance
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipt
|
|
|
|
|
|
|
|
|
|
|
Planned Order Release
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Requirements for E-XXX
|
|
|
|
|
|
|
|
|
|
|
Projected Available Balance
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipt
|
|
|
|
|
|
|
|
|
|
|
Planned Order Release
|
|
|
|
|
|
|
|
|
|
Hint:D-XXX's Gross Requirements are derived from the Planned Order Releases of both B-XXX and C-XXX.