I have parts 1-4, struggling on parts 5-7.

The A-CAT Corporation Case asks you to help Sunita Maron with her Material Requirements Planning dilemma. Your assignment for your Final Case Study is to successfully accomplish the following:

1. Create a Bill of Material for product P0110

2. Create a Time-Phased Product Structure

3. Create a Gross Requirements Plan for all 5 Parts, using the Master Schedule and working backwards (so for example, you can order something in Week 0, Week -1, Week -2, etc.

4. Create a Net Requirements Plan for all 5 parts

5. Calculate Setup and Holding costs where you maximize Setup costs

6. Calculate Setup and Holding costs where you maximize Holding costs.

7. Attempt to Minimize the total costs of your inventory management plan.

Parts 1 and 2 can be done in whatever software you are most comfortable with you can even draw it and take a picture if you would like. Parts 3 and 4 should be done and submitted in Excel. Parts 5, 6 and 7 should be done and submitted in Excel.

AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments ab Wraa Tact General Autasum - 24 7 X Cut I copy Paste Format Mainter Clipboard - Calibri - 12 - A BIUS Bad Neutral E Mange Carter Normal Conditional Format Good Formating Table Styles Insort Dalto format Clear Sort & Find & File - 5 Edining Fant sligment - Number Ideas 115 x 240 A B D E F G K L M N O 0 R - 1 2 3 3 4 Bill of Material 5 6 7 B P0110 2 POX 2 POY 4 P1X1 P1X2 10 11 12 13 Items on 14 2 Component For 1 P0110 PO110 1 POX POY 2 PIX1 B P1X2 6 Hand Value 240 48000 500 32500 340 11900 500 2500 600 9000 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Part 1 Part 2 Part 3 Part 4 Part 5 # | -- + 100% Type here to search O e 101 PM 5/28,000 11 AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments === ab Wraa Tact General Autasum - 24 7 X Cut - Format Pintor Clipboard - Calin - 12 - A BIU, SP 4 Hasta Bad Neutral E Mange Carter Normal Conditional format as Good Formatting Tale $ -% -9 Insort Dalto Tomat Clear Sort & Find & File - Select - Edining Fan ligiment - Number Styles Ideas F33 > A C D E IF H 1 K L M N O R s 1 2 3 4 Time-Phased Prodcut Structure 5 6 7 B Component Lead Time P0110 POX POY 1 P1X1 1 PIXZ P1X1 POX P1X2 P0110 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 A POY 1 2 3 4 S 6 7 8 (Weeks) Part 1 Part 2 Part 3 Part 4 Part 5 H |-- + 100% Type here to search O 101 PM 5/28,000 11 AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments Calibri 12. AA === ab Wraa Tact General Autasum - 24 7 Bad X Cut In copy. Paste Format Mainter Clipboard - BIU Normal Conditional format as Good Formatting Table CO E Mange Carter Neutral Insort Daloto format Clear Sort & Find & File - Select - Edining ligiment - Number Hers F3 > G B E F G H J K L M N 0 P R 5 1 2 Gross Requirement Plan 3 4 5 6 7 B -2 -1 0 Weeks 2 350 3 P0110 4 4501 450 8 Lead Time 5252 Weeks 225 6 450 525 1050 450 IPOX 1 Week 1 400 300 600 900 600 900 800 POY Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date 1050 1 Werk 5 300 225 450 1050 450 1050 4200 400 800 700 800 700 2800 2400 2100 1800 350 700 600 700 600 2400 3600 18001 2700 300 300 600 900 600 900 3600 1800 2700 1350 Pixi 300 3200 2800 2400 2100 600 900 500 2400 3600 1800 2700 450 900 450 1800 4200 1350 3150 1 Week 3600 2400 27001 1800 3200 P1X2 3150 1 Week 2400 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Part 1 Part 2 Part 3 Part 4 | Part 5 + " -- + 100% + 1:02 PM 5/28,000 Type here to search O 11 AutoSave On - Save Filc Home Insert Draw Page Layout Formulas Data Review Vicw Help Search Share Comments utasu Calibri - 12 - A === ab Wraa Tact General Bad AY O 4 Hasta X Cut In copy Format Painter Clipboard - BIU. E Mange Carter Normal Conditional Format Good Formating Tale Neutral Insort Dalto format Clear Sort & Find & Filip - 5lt Fant ligiment Number Edining Hess C4 > > G 4 L F G 11 1 M N R: 1 1 2 3 Net Requirement Plan 5 6 7 9 9 10 PO110 POX P1X1 P1X2 240 500 340 5001 GOO -2 -1 1 300 PO110 Lead Time: 2 240 450 0 450 0 210 240 240 Week Go Raquirements PRO On Hers Necuirements Order Received Order Telese inn 0 160 150 300 2501 ol 320 350 4301 300 0 200 300 1180 7 225 0 225 225 450 450 525 300 223 1001 350 1 12 13 14 15 16 17 19 19 2n 21 22 23 24 POX Lead Time: 1 000 900 Week Cross Requirements Projected Un Hand Ner ReoAMAYIS ort friel SUO SOU -1 320 180 0 0 570 100 0 520 520 600 500 600 900 900 0 go 000 600 LUO ol 600 600 900 900 900 450 ol 450 150 1050 1050 0 1050 1050 0 Order Release -3 7 1 600 4 900 26 POY 4150 10501 Lead Time: 1 340 390 Week Greens Projected Unland Net Requirements Order Recared Urder cloace -1 320 20 0 o 680 700 U 680 680 GUOI 0 900 600 o GLO 600 yol 900 900 0 450 450 29 29 JU 31 32 1050 1050 600 900 10.0 1 d 7 2400 300 JGUD 1900 P1X1 Lead Time: 1 34 35 500 Week Gross Hequirements Projected On Hand Ne Real Order Received Onder Release -1 2060 0 1500 2100 2400 3600 2400 0 2400 2400 2600 3500 SUU hann 3600 3600 1800 4200 0 1200 42001 0 1 RON 1900 4200 37 0 1500 7.4001 5 1 2700 4 1350 1800 PIX2 Lead Time: 1 Week Gross equirements Projected Un Hand Not Requirements 2700 GLO 30 40 11 42 43 44 45 46 47 GOU 1500l 0 9801 999 18001 18001 0 1800 1800 2700 7700 2700 1800 1800 1800 2700 2700 27001 1350 1350 1350 0 31.50 3150 0 Order Fisad 950 3150 Part 1 Part 2 Part 3 Part 4 Part 5 + " -- + 319 Type here to search O 1:02 PM 5/28/2000 . 11 AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments ab Wraa Tact General Autasum - 24 7 X Cut I copy Paste Format Mainter Clipboard - Calibri - 12 - A BIUS Bad Neutral E Mange Carter Normal Conditional Format Good Formating Table Styles Insort Dalto format Clear Sort & Find & File - 5 Edining Fant sligment - Number Ideas 115 x 240 A B D E F G K L M N O 0 R - 1 2 3 3 4 Bill of Material 5 6 7 B P0110 2 POX 2 POY 4 P1X1 P1X2 10 11 12 13 Items on 14 2 Component For 1 P0110 PO110 1 POX POY 2 PIX1 B P1X2 6 Hand Value 240 48000 500 32500 340 11900 500 2500 600 9000 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Part 1 Part 2 Part 3 Part 4 Part 5 # | -- + 100% Type here to search O e 101 PM 5/28,000 11 AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments === ab Wraa Tact General Autasum - 24 7 X Cut - Format Pintor Clipboard - Calin - 12 - A BIU, SP 4 Hasta Bad Neutral E Mange Carter Normal Conditional format as Good Formatting Tale $ -% -9 Insort Dalto Tomat Clear Sort & Find & File - Select - Edining Fan ligiment - Number Styles Ideas F33 > A C D E IF H 1 K L M N O R s 1 2 3 4 Time-Phased Prodcut Structure 5 6 7 B Component Lead Time P0110 POX POY 1 P1X1 1 PIXZ P1X1 POX P1X2 P0110 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 A POY 1 2 3 4 S 6 7 8 (Weeks) Part 1 Part 2 Part 3 Part 4 Part 5 H |-- + 100% Type here to search O 101 PM 5/28,000 11 AutoSave On - Savel- Filc Home Insert Draw Page Layout Fomulas Data Review Vicw Help Search Share Comments Calibri 12. AA === ab Wraa Tact General Autasum - 24 7 Bad X Cut In copy. Paste Format Mainter Clipboard - BIU Normal Conditional format as Good Formatting Table CO E Mange Carter Neutral Insort Daloto format Clear Sort & Find & File - Select - Edining ligiment - Number Hers F3 > G B E F G H J K L M N 0 P R 5 1 2 Gross Requirement Plan 3 4 5 6 7 B -2 -1 0 Weeks 2 350 3 P0110 4 4501 450 8 Lead Time 5252 Weeks 225 6 450 525 1050 450 IPOX 1 Week 1 400 300 600 900 600 900 800 POY Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date Required Date Order Release Date 1050 1 Werk 5 300 225 450 1050 450 1050 4200 400 800 700 800 700 2800 2400 2100 1800 350 700 600 700 600 2400 3600 18001 2700 300 300 600 900 600 900 3600 1800 2700 1350 Pixi 300 3200 2800 2400 2100 600 900 500 2400 3600 1800 2700 450 900 450 1800 4200 1350 3150 1 Week 3600 2400 27001 1800 3200 P1X2 3150 1 Week 2400 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Part 1 Part 2 Part 3 Part 4 | Part 5 + " -- + 100% + 1:02 PM 5/28,000 Type here to search O 11 AutoSave On - Save Filc Home Insert Draw Page Layout Formulas Data Review Vicw Help Search Share Comments utasu Calibri - 12 - A === ab Wraa Tact General Bad AY O 4 Hasta X Cut In copy Format Painter Clipboard - BIU. E Mange Carter Normal Conditional Format Good Formating Tale Neutral Insort Dalto format Clear Sort & Find & Filip - 5lt Fant ligiment Number Edining Hess C4 > > G 4 L F G 11 1 M N R: 1 1 2 3 Net Requirement Plan 5 6 7 9 9 10 PO110 POX P1X1 P1X2 240 500 340 5001 GOO -2 -1 1 300 PO110 Lead Time: 2 240 450 0 450 0 210 240 240 Week Go Raquirements PRO On Hers Necuirements Order Received Order Telese inn 0 160 150 300 2501 ol 320 350 4301 300 0 200 300 1180 7 225 0 225 225 450 450 525 300 223 1001 350 1 12 13 14 15 16 17 19 19 2n 21 22 23 24 POX Lead Time: 1 000 900 Week Cross Requirements Projected Un Hand Ner ReoAMAYIS ort friel SUO SOU -1 320 180 0 0 570 100 0 520 520 600 500 600 900 900 0 go 000 600 LUO ol 600 600 900 900 900 450 ol 450 150 1050 1050 0 1050 1050 0 Order Release -3 7 1 600 4 900 26 POY 4150 10501 Lead Time: 1 340 390 Week Greens Projected Unland Net Requirements Order Recared Urder cloace -1 320 20 0 o 680 700 U 680 680 GUOI 0 900 600 o GLO 600 yol 900 900 0 450 450 29 29 JU 31 32 1050 1050 600 900 10.0 1 d 7 2400 300 JGUD 1900 P1X1 Lead Time: 1 34 35 500 Week Gross Hequirements Projected On Hand Ne Real Order Received Onder Release -1 2060 0 1500 2100 2400 3600 2400 0 2400 2400 2600 3500 SUU hann 3600 3600 1800 4200 0 1200 42001 0 1 RON 1900 4200 37 0 1500 7.4001 5 1 2700 4 1350 1800 PIX2 Lead Time: 1 Week Gross equirements Projected Un Hand Not Requirements 2700 GLO 30 40 11 42 43 44 45 46 47 GOU 1500l 0 9801 999 18001 18001 0 1800 1800 2700 7700 2700 1800 1800 1800 2700 2700 27001 1350 1350 1350 0 31.50 3150 0 Order Fisad 950 3150 Part 1 Part 2 Part 3 Part 4 Part 5 + " -- + 319 Type here to search O 1:02 PM 5/28/2000 . 11