For each of these cases, on photo prepare for building a model by reading the full case and answering the following questions. 1. Explore the mess by answering the following questions: (a) What do we know? (b) What can we assume? (c) What could the results look like? (d) What information can be brought to bear? (e) What can we ask the client? (f) Are there any similar situations or problems? 2. Formulate one or more problem statements ICEBERGS FOR KUWAITThe cost of desalinating seawater using conventional tech-nology in the Persian Gulf is high (around 0.1£ per cubicmeter) and requires extensive amounts of oil. Some timeago scientists suggested that it could well prove both prac-tically feasible and less expensive to tow icebergs from theAntarctic, a distance of about 9,600 km. Although some ofthe ice would undoubtedly melt in transit, it was thoughtthat a significant proportion of the iceberg would remainintact upon arrival in the Gulf. Bear in mind that since water TABLE 2 Melting Rates (meter/day)expands upon freezing, 1 cubic meter of ice produces only0.85 cubic meter of water.A study was carried out to evaluate the practical pro-blems associated with such a proposal and to quantify thefactors that were likely to influence the economics of such aventure. One factor was the difference in rental costs andcapacities of towing vessels (summarized in Table 1). Notethat each vessel has a maximum iceberg it can tow (mea-sured in cubic meters). It was found that the melting rate ofthe iceberg depends on both the towing speed and thedistance from the South Pole (see Table 2). The data in480 MODELING CASESdistance from the Pole and at the given towing speed.Finally, fuel cost was found to depend on the towing speedand the (current) size of the iceberg (see Table 3).Determine whether it is economically feasible to pro-duce water from icebergs in the Persian Gulf, and if it is,determine the best means to do so."Source: Cross, M. and A.O. Moscardini, 1985. Learning the Art ofMathematical Modeling. Ellis Horward Limited, West Sussex.TABLE 1 Towing Vessel DataShip SizeSmallDaily rental (£)Maximum load(cu meter)Speed1km/hr5 km/hr1,0000.060.080.10Speed1km/hr3 km/hr5 km/hr400500,000TABLE 3 Fuel Costs (£/km)100,0000.120.160.208.410.813.2MediumDistance from Pole (km)2,0003,0006001,000,0000.180.240.30this table represents the rate at which a hypothetical sphe-rical iceberg shrinks in radius over a day at the given10.513.516.5Large80010,000,000Current Volume (cu. meter)1,000,00024,0000.240.320.4010,000,00012.616.219.8 ICEBERGS FOR KUWAITThe cost of desalinating seawater using conventional tech-nology in the Persian Gulf is high (around 0.1£ per cubicmeter) and requires extensive amounts of oil. Some timeago scientists suggested that it could well prove both prac-tically feasible and less expensive to tow icebergs from theAntarctic, a distance of about 9,600 km. Although some ofthe ice would undoubtedly melt in transit, it was thoughtthat a significant proportion of the iceberg would remainintact upon arrival in the Gulf. Bear in mind that since water TABLE 2 Melting Rates (meter/day)expands upon freezing, 1 cubic meter of ice produces only0.85 cubic meter of water.A study was carried out to evaluate the practical pro-blems associated with such a proposal and to quantify thefactors that were likely to influence the economics of such aventure. One factor was the difference in rental costs andcapacities of towing vessels (summarized in Table 1). Notethat each vessel has a maximum iceberg it can tow (mea-sured in cubic meters). It was found that the melting rate ofthe iceberg depends on both the towing speed and thedistance from the South Pole (see Table 2). The data in480 MODELING CASESdistance from the Pole and at the given towing speed.Finally, fuel cost was found to depend on the towing speedand the (current) size of the iceberg (see Table 3).Determine whether it is economically feasible to pro-duce water from icebergs in the Persian Gulf, and if it is,determine the best means to do so."Source: Cross, M. and A.O. Moscardini, 1985. Learning the Art ofMathematical Modeling. Ellis Horward Limited, West Sussex.TABLE 1 Towing Vessel DataShip SizeSmallDaily rental (£)Maximum load(cu meter)Speed1km/hr5 km/hr1,0000.060.080.10Speed1km/hr3 km/hr5 km/hr400500,000TABLE 3 Fuel Costs (£/km)100,0000.120.160.208.410.813.2MediumDistance from Pole (km)2,0003,0006001,000,0000.180.240.30this table represents the rate at which a hypothetical sphe-rical iceberg shrinks in radius over a day at the given10.513.516.5Large80010,000,000Current Volume (cu. meter)1,000,00024,0000.240.320.4010,000,00012.616.219.8

(a) What do we know ? We know that desalinating seawater in the Persian Gulf using…

Answered: 1. Explore the mess by answering the…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...