1. calculate current total demand for water in the network for yeat 1 through year 10 using the data provides in the following table

2. calculate the total utilization for all water manufacturing locations for years 1 though years 10

View Insert Format Tools Table Window Help T Mitg 4630 Case Study 2 Individual Bert Desion Layout References Mallings Review View Table Design Segoe I Sem.. 10 . A- A A E E + BUX, X AA EE . . . Layout REABCDADE Case Study Data Table 1: Source Nodes for Network Note: Your production facilities have more capacity at the beginning of the analysis than the demand modes can consume in your new design, consider that all excess capacity is utilized and that outbound excess quantities are stored at the warehouse as buffer inventory Source Nodes X Location Y Location Production Capacity Type Units S per 1.000 Literie Outbound) Uhers Point of Manufacture S1 Water Production 180 120 3,000,000 Liters $0.75 Point of Manufacture Water Production 90 120 5.000.000 $1.25 Point of Manufacture S3 Water production 120 0 10,000,000 Us $1.00 Sper 1,000 Liter/Mile Table 2: Demand Nodes for Network Demand Type X Location Nodes Colony Site Agricultural Colony 150 Site Colony Location 210 180 120 Yearly Demand Inbound) Uters 1,000,000 CALCULATE 400,000 Yearly increase in Water Consumption 2.00% Units Liters Liters Liters 0 $1.00 SO 50 SO 75 180 2.00% 500,000 2009 50.80 $1.25 650 000 $150 Colony She Ma site Colony She Fuel to Lihers Liters 500.000 CALCULATE 500 000 CALCULATE 1.000.000 - 100% 200% 0% 2.00% 09 200 Liters Liter 50 50 50.85 Colony 300 000 Lihers 2.00% 250 000 5.00% $1.50 Segoe UI Sem... 10 A- A A A B I U abe X2 X? A..A. Paste Paragraph Styles Table 3: Location D2 Yearly Production Demands Demand for Year 1 Units Lettuce 50,000 Tomatoes 100,000 Potatoes 500,000 Strawberries 80,000 Bill of Materials Lvli Lvl2 3 Material Units of Measure Pound Liters QTY 1 4 2 Lettuce Water . Tomato Pound 2 .. Water Liters 1 ... 2 ... ... Potato Water T Pounds Liters 5 1 ... 2 ... . Strawberry Water 1 6 Pounds Liters Table 4: Location D7 Yearly Production Demands 500,000 Lbs of Steel Sheeting Required for Year One of Analysis Units of Measure Steel Sheeting 1.00 lb Lvli Lviz lvl QTY Page 4 of 6 Focus- Paste B I U de X, x? A. - A Paragraph Styles Table 4: Location D7 Yearly Production Demands 500,000 lbs of Steel Sheeting Required for Year One of Analysis Units of Lvl1 Material Measure Steel Sheeting 1.00 Lv2 QTY 2 . 3.00 Iron Oxide Water 5.00 Liters no Table 5: Location D9 Yearly Production Demands 1,500,000 Liters of Rocket Fuel Required for Year One of the Analysis Units of LV! Lvii Lviz Material QTY Measure Rocket Fuel 1.00 Liters Nitrogen Tetroxide Liters Water Liters Nitrogen Liters Liquid Oxygen 0.60 Liters 3 Water 1.50 Liters Hydrogen Peroxide 0.20 Liters 3 Water 0.40 Liters Page 4 of 6 D Focus - + 128% D Module 7 in..par slide iz View Insert Format Tools Table Window Help T Mitg 4630 Case Study 2 Individual Bert Desion Layout References Mallings Review View Table Design Segoe I Sem.. 10 . A- A A E E + BUX, X AA EE . . . Layout REABCDADE Case Study Data Table 1: Source Nodes for Network Note: Your production facilities have more capacity at the beginning of the analysis than the demand modes can consume in your new design, consider that all excess capacity is utilized and that outbound excess quantities are stored at the warehouse as buffer inventory Source Nodes X Location Y Location Production Capacity Type Units S per 1.000 Literie Outbound) Uhers Point of Manufacture S1 Water Production 180 120 3,000,000 Liters $0.75 Point of Manufacture Water Production 90 120 5.000.000 $1.25 Point of Manufacture S3 Water production 120 0 10,000,000 Us $1.00 Sper 1,000 Liter/Mile Table 2: Demand Nodes for Network Demand Type X Location Nodes Colony Site Agricultural Colony 150 Site Colony Location 210 180 120 Yearly Demand Inbound) Uters 1,000,000 CALCULATE 400,000 Yearly increase in Water Consumption 2.00% Units Liters Liters Liters 0 $1.00 SO 50 SO 75 180 2.00% 500,000 2009 50.80 $1.25 650 000 $150 Colony She Ma site Colony She Fuel to Lihers Liters 500.000 CALCULATE 500 000 CALCULATE 1.000.000 - 100% 200% 0% 2.00% 09 200 Liters Liter 50 50 50.85 Colony 300 000 Lihers 2.00% 250 000 5.00% $1.50 Segoe UI Sem... 10 A- A A A B I U abe X2 X? A..A. Paste Paragraph Styles Table 3: Location D2 Yearly Production Demands Demand for Year 1 Units Lettuce 50,000 Tomatoes 100,000 Potatoes 500,000 Strawberries 80,000 Bill of Materials Lvli Lvl2 3 Material Units of Measure Pound Liters QTY 1 4 2 Lettuce Water . Tomato Pound 2 .. Water Liters 1 ... 2 ... ... Potato Water T Pounds Liters 5 1 ... 2 ... . Strawberry Water 1 6 Pounds Liters Table 4: Location D7 Yearly Production Demands 500,000 Lbs of Steel Sheeting Required for Year One of Analysis Units of Measure Steel Sheeting 1.00 lb Lvli Lviz lvl QTY Page 4 of 6 Focus- Paste B I U de X, x? A. - A Paragraph Styles Table 4: Location D7 Yearly Production Demands 500,000 lbs of Steel Sheeting Required for Year One of Analysis Units of Lvl1 Material Measure Steel Sheeting 1.00 Lv2 QTY 2 . 3.00 Iron Oxide Water 5.00 Liters no Table 5: Location D9 Yearly Production Demands 1,500,000 Liters of Rocket Fuel Required for Year One of the Analysis Units of LV! Lvii Lviz Material QTY Measure Rocket Fuel 1.00 Liters Nitrogen Tetroxide Liters Water Liters Nitrogen Liters Liquid Oxygen 0.60 Liters 3 Water 1.50 Liters Hydrogen Peroxide 0.20 Liters 3 Water 0.40 Liters Page 4 of 6 D Focus - + 128% D Module 7 in..par slide iz