EX8-15 (Algo) The National Oceanic Research Institute is... The National Oceanic Research Institute is planning a research study on global warming In Antarctica. The 16-month network schedule is presented below. It is followed by budgets for each activity. Create a time-phased budget for the research project. Global Warming Antarctic Research Project Months.... (8000) 7 G9 6 Plane bransporto 13 2 15 10 K 15 5 C 7 o Hire 5 2 7 Ship 0 Purchase o apple 15 L 16 0 Travel 15 1 16 clothing 3 10 7 105 15 0 3 0 Prelimy plan 0 3 3 0 Detail plan 32 5 7 E 8 6 Thai 13 1 14 14 15 0 equipment 141 15 6 H11 Geleskom 0 Sect equipment 51 0 6 1114 0 equipment 113 14 5 11 5 Global Warming Antarctic Research Project Activity Time Phased Work Packages by Month ($eee) Task Duration Budget 1 2 3 4 A Preliminary plan 3 12 4 4 4 B Detail plan 2 7 3 4 CHire staff 2 17 9 D Select equipment 1 9 9 E Train 1 4 4 F Purchase clothing 3 13 4 B 9 G Plane transportation 2 72 7 65 H Get custom equipment 5 36 5 5 12 10 I Additional equipment 3 26 12 7 7 Test equipment 1 9 9 K Ship all supplies 5 17 4 4 L Travel 1 10 10 Total budget 232 9 4 9 Enter the appropriate values for budget and cumulative budget in the following table. Global Warming Antarctic Research Project Activity Time-Phased Work pckages by Month (5000) Duration Budget 1 2 3 4 5 6 7 8 Task 9 10 11 12 13 14 15 16 3 12 7 Preliminary plan Detailplan Hire staff Select equipment 2 2 17 1 9 1 4 3 3 13 72 2 5 36 Train Purchase clothing Plane transportation Get custom equipment Additional equipment Test equipment Ship all supplies Travel Total budget 3 26 This is a numeric cell, so please enter numbers only. 232