c) Conclude the inventory database tables: Table Q4(C-1), Table Q4(C-2), and Table Q4(C- [5] 3) for Item A, C and D respectively, and Figure Q4(C) for provided BOM below. A B D (2) D (3) F Week No. 1 2 3 4 5 6 Gross requirements A 80 Gross requirements C 50 Figure Q4(C) For A (LT = 1 week; lot for lot) Table Q4(C-1) 1 2 3 4 5 6 Week No. Gross requirements Scheduled receipt Projected on-hand inventory Planned receipt Planned order release For C (LT = 2 weeks; lot size = 70) Table Q4(C-2) 1 2 3 4 5 6 70 Week No. Gross requirements Scheduled receipt Projected on-hand inventory (17) Planned receipt Planned order release For D (LT = 2 weeks; lot size = 100) Table Q4(C-3) 1 2 3 4 un 6 100 Week No. Gross requirements Scheduled receipt Projected on-hand inventory (25) Planned receipt Planned order release