Q 5 Level 0 G M P 1 Problem 2. One unit of A is made of the units of Bone unit of , and two units of D. Bis composed of two units of E and one unit of D. is made of one ? unit of and two units of E. Els made of one unit of items, and have one week lead times A and have lead times of two weeks. Assume that loont (LL) lot sizing is used for items A, B, and lots of size 10, 50, and 200 are uned for its C, D, and respectively. Items C, E, and F 4 have on-hand beginning inventories of 10, 50, and 150 respectively, all other items have to beginning inventory. We are scheduled to receive 10 units of Ain Week 2,50 units of Ein Week 1, and also 50 units of Fin Week 1. There are no other scheduled moeipts. If 30 units of A are required in Week 3, 6 the low-level-coded bill of materials to find the necessay banned order releases for all components 7 Insert your formula in B the blue celle 9 Pad Remember that all 5 6 100 formas begin with 10 her A GOB Giments 30 11 OHJO Scheduled receipts 10 12 LT:2 Projected available balance D 10 10 10 10 10 10 O SS.IO Nequirements 20 14 QUAL Planned order recipe 20 15 Praneanet 20 16 Chand CARBON 17 m C DOS Guirements OH 110 Scheduled mcente ch 10 LT1 Projected to balance 30 5310 Nat muimente 21 Planned order met 21 Planned 1 34 25 26 27 D 0 0 0 0 10 OHIO LT: SSO OLAL 0 Gross requirement Schedad cil Projected available balance muirements Planned one recept Planned 30 LO 40 D OHIO LDE 550 also 0 GROSSO die Pedale Netcom Planned receipts 0 | 0 0 0 M 1 OR LTE VO 100 100 100 Gros quais Bicheduled receipt Pred available balance |tampsian Planned Order celle planned 200 OH 150 LT SO OL Cos 400 Scheduled Predavate balance 2001002000 200 Planned decepte 100 Planner 11 11 Q 5 Level 0 G M P 1 Problem 2. One unit of A is made of the units of Bone unit of , and two units of D. Bis composed of two units of E and one unit of D. is made of one ? unit of and two units of E. Els made of one unit of items, and have one week lead times A and have lead times of two weeks. Assume that loont (LL) lot sizing is used for items A, B, and lots of size 10, 50, and 200 are uned for its C, D, and respectively. Items C, E, and F 4 have on-hand beginning inventories of 10, 50, and 150 respectively, all other items have to beginning inventory. We are scheduled to receive 10 units of Ain Week 2,50 units of Ein Week 1, and also 50 units of Fin Week 1. There are no other scheduled moeipts. If 30 units of A are required in Week 3, 6 the low-level-coded bill of materials to find the necessay banned order releases for all components 7 Insert your formula in B the blue celle 9 Pad Remember that all 5 6 100 formas begin with 10 her A GOB Giments 30 11 OHJO Scheduled receipts 10 12 LT:2 Projected available balance D 10 10 10 10 10 10 O SS.IO Nequirements 20 14 QUAL Planned order recipe 20 15 Praneanet 20 16 Chand CARBON 17 m C DOS Guirements OH 110 Scheduled mcente ch 10 LT1 Projected to balance 30 5310 Nat muimente 21 Planned order met 21 Planned 1 34 25 26 27 D 0 0 0 0 10 OHIO LT: SSO OLAL 0 Gross requirement Schedad cil Projected available balance muirements Planned one recept Planned 30 LO 40 D OHIO LDE 550 also 0 GROSSO die Pedale Netcom Planned receipts 0 | 0 0 0 M 1 OR LTE VO 100 100 100 Gros quais Bicheduled receipt Pred available balance |tampsian Planned Order celle planned 200 OH 150 LT SO OL Cos 400 Scheduled Predavate balance 2001002000 200 Planned decepte 100 Planner 11 11