Here is an operations management problem that I have been struggling with.

Material Planning Requirement Each unit of X-photo frame is consisting of one unit of A-grooved wooden decorative front frame and one unit of B-back panel. B is consisting of two units of C-triangle ring to hang and two units of D-screws to attach triangle rings. Items C-triangle ring to hang, and D-screws to attach triangle rings have on-hand inventories of 15 and 25 units, respectively. There are 3 units of X on-hand. A and B-back panel have no inventory on-hand. Lot-for-lot (L4L) is used for Items X - photo frame, A-grooved wooden front frame, and B-back panel. C- triangle ring to hang and D-screws to attach triangle rings requires a minimum lot size of 50 units. Lead times are one week for Items X, A, and B, and two weeks for Items C and D. The gross requirements for X is 75 in week 6. Item On-hand Inventory Lead Time Order quantity 1 week L4L 1 week L4L 1 week L4L 1 week Box of 50 1 week Box of 50 Question 5 (45 points) - Using the above info, fill out the Material Planning Requirement chart below. (Leave the cells blank, whenever zero (0) is required.) Period: Item: X OH: 3 LT: 1 Gross requirements Scheduled receipts Projected available balance Net requirements S:0 Q: L4L Planned order receipts Planned order releases Item: A OH: 0 Gross requirements Scheduled receipts LT: 1 SS: 0 Q: L4 Projected available balance Net requirements Planned order receipts Planned order releases Item: B OH: 0 LT: 1 SS:0 Q: L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Item: C OH: 15 LT: 1 SS: 0 Q: 50 Net requirements Planned order receipts Planned order releases Item: D OH: 25 LT: 1 SS:0 Q: 50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases