How do you do this probleblem step by step?

Analytics Berese 21 (190) Race Neprodogradnikan article on the window Now' ang peranand decided to promote harving Profor one of the engine tres produced by the Mod 1000 This weer ours of the Mod 100 goed each week during the 12 wat page Party pagety considering only two of the many componentended to go of the 1000 ne The Decertant and being to the engine mene. The input as one of one ports and we conne, and there shown in the producteurs diagnow. Prodhur bois by the nded to producer o sembly. Thus, vel 1 and 2 are included in the product structure degram to indicate the three mancang are ved in producing an engre Erone Assembly Department the Subs Department and the Machine Shop The chung lead time required to produce the gearbox and input sa components an indicated in the produced that two lo talent oor how we must be delivered to the contemty Department stockroom before Monday morning or that we are not ud for permiten of in prepare the MRP emple Phe pled to use the worksheets shown and to make the following uption 1. Twenty five your brows are on hand at the beginning of Wook 1, and even par bones are currently on order to be detened at the start of Work 2. 2. Fity mput shattu am on hand at the start of Wook I, and 28 are scheduled for delivery at the beginning of Wenk 2. 3 112 M1000 ml 1 2 4 5 . Od 1812 10 2013 Model 1000 cc Engine Chara Gewbos Ladne Ud per Input Ledtime weeks Uued 2 a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the not requirements and planned order relates for the gear boxes and input shafts. Assume that lot sizing is done using lol-for-1 (L4L). (Leave no cells blank be certain to enter "o" wherever required.) Gear Box Requirements 2 3 4 5 6 8 9 10 11 12 Week 1 Grows regements Schedded reces Projected available balance Net requirements Planned order moet Planned order rose Input Shaft Requirements 10 11 12 Week Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Analytics Berese 21 (190) Race Neprodogradnikan article on the window Now' ang peranand decided to promote harving Profor one of the engine tres produced by the Mod 1000 This weer ours of the Mod 100 goed each week during the 12 wat page Party pagety considering only two of the many componentended to go of the 1000 ne The Decertant and being to the engine mene. The input as one of one ports and we conne, and there shown in the producteurs diagnow. Prodhur bois by the nded to producer o sembly. Thus, vel 1 and 2 are included in the product structure degram to indicate the three mancang are ved in producing an engre Erone Assembly Department the Subs Department and the Machine Shop The chung lead time required to produce the gearbox and input sa components an indicated in the produced that two lo talent oor how we must be delivered to the contemty Department stockroom before Monday morning or that we are not ud for permiten of in prepare the MRP emple Phe pled to use the worksheets shown and to make the following uption 1. Twenty five your brows are on hand at the beginning of Wook 1, and even par bones are currently on order to be detened at the start of Work 2. 2. Fity mput shattu am on hand at the start of Wook I, and 28 are scheduled for delivery at the beginning of Wenk 2. 3 112 M1000 ml 1 2 4 5 . Od 1812 10 2013 Model 1000 cc Engine Chara Gewbos Ladne Ud per Input Ledtime weeks Uued 2 a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the not requirements and planned order relates for the gear boxes and input shafts. Assume that lot sizing is done using lol-for-1 (L4L). (Leave no cells blank be certain to enter "o" wherever required.) Gear Box Requirements 2 3 4 5 6 8 9 10 11 12 Week 1 Grows regements Schedded reces Projected available balance Net requirements Planned order moet Planned order rose Input Shaft Requirements 10 11 12 Week Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release