One unit of A is made of two units of B, three units of C, and two units of D. B
ID: 463706 • Letter: O
Question
One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 40 and 180 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 12; D has an on-hand inventory of 50; all other items have zero beginning inventory. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts.
If 18 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.)
Please provide formula used as well
Here is the uploaded screenshot as well: http://i64.tinypic.com/29urnh2.png
If 18 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.)
Please provide formula used as well
Here is the uploaded screenshot as well: http://i64.tinypic.com/29urnh2.png
Period Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 7 Item A OH = 0 LT= SS = 0 Q=L4L Item B OH=0 LT=2 SS = 0 Q=L4L Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Gross requirements Item C Scheduled receipts OH 12 Projected on hand LT= SS = 0 Net requirements Q=L4L Planned order receipts Planned order releases Item E OH=0 LT=2 SS = 0 Q = 40 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Item F OH = 0 LT= SS = 0 Q= 180 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Item D OH 50 LT=1 SS = 0 Q=L4L Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases
Explanation / Answer
MPS for End-Product A:
Week number
0
1
2
3
4
5
6
7
8
Quantity
0
0
0
0
0
0
0
0
18
Item A
OH =0
LT=1
SS=0
Q=L4L
Gross reqmts.
0
0
0
0
0
0
0
0
18
Scheduled receipts
0
0
0
0
0
0
0
0
0
Projected on hand
0
0
0
0
0
0
0
0
0
Net reqmts.
0
0
0
0
0
0
0
0
18
Planned-order receipts
0
0
0
0
0
0
0
0
18
Planned-order releases
0
0
0
0
0
0
0
18
0
Item B
OH =0
LT=2
SS=0
Q=L4L
Gross reqmts.
0
0
0
0
0
0
0
36
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
Projected on hand
0
0
0
0
0
0
0
0
0
Net reqmts.
0
0
0
0
0
0
0
36
0
Planned-order receipts
0
0
0
0
0
0
0
36
0
Planned-order releases
0
0
0
0
0
36
0
0
0
Item C
OH =12
LT=1
SS=0
Q=L4L
Gross reqmts.
0
0
0
0
0
0
0
54
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
Projected on hand
0
0
0
0
0
0
0
0
0
Net reqmts.
0
0
0
0
0
0
0
42
0
Planned-order receipts
0
0
0
0
0
0
0
42
0
Planned-order releases
0
0
0
0
0
0
42
0
0
Item E
OH =0
LT=2
SS=0
Q=40
Gross reqmts.
0
0
0
0
0
0
0
0
0
Scheduled receipts
0
0
20
0
0
0
0
0
0
Projected on hand
0
0
20
0
0
0
0
0
Net reqmts.
0
0
20
0
0
0
0
0
0
Planned-order receipts
0
0
40
0
0
0
0
0
0
Planned-order releases
40
0
0
0
0
0
0
0
0
Item F
OH =0
LT=1
SS=0
Q=180
Gross reqmts.
Scheduled receipts
Projected on hand
Net reqmts.
Planned-order receipts
Planned-order releases
Item D
OH =50
LT=1
SS=0
Q=L4L
Gross reqmts.
Scheduled receipts
Projected on hand
Net reqmts.
Planned-order receipts
Planned-order releases
F and D have not been completed.
Net reqmts = Gross reqmts - On Hand Inventory - Scheduled Receipts.
Week number
0
1
2
3
4
5
6
7
8
Quantity
0
0
0
0
0
0
0
0
18
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.