Refer to the Icebergs for Kuwait case. Review the problem statement and influence chart that were generated
Fantastic news! We've Found the answer you've been seeking!
Question:
Refer to the Icebergs for Kuwait case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercises. (If this has not yet been done, develop the problem statement and influence chart as preliminary steps.) Design a spreadsheet to estimate the economic value of the freshwater produced by towing the largest possible iceberg using the largest available boat.
Transcribed Image Text:
ICEBERGS FOR KUWAIT The cost of desalinating seawater using conventional tech- nology in the Persian Gulf is high (around 0.1£ per cubic meter) and requires extensive amounts of oil. Some time ago scientists suggested that it could well prove both practically feasible and less expensive to tow icebergs from the Ant- arctic, a distance of about 9,600 km. Although some of the ice would undoubtedly melt in transit, it was thought that a significant proportion of the iceberg would remain intact upon arrival in the Gulf. Bear in mind that since water expands upon freezing, 1 cubic meter of ice produces only 0.85 cubic meter of water. A study was carried out to evaluate the practical pro- blems associated with such a proposal and to quantify the factors that were likely to influence the economics of such a venture. One factor was the difference in rental costs and capacities of towing vessels (summarized in Table 1). Note that each vessel has a maximum iceberg it can tow (mea- sured in cubic meters). It was found that the melting rate of the iceberg depends on both the towing speed and the distance from the South Pole (see Table 2). The data in from the Pole and at the given towing speed. Finally, fuel cost was found to depend on the towing speed and the (current) size of the iceberg (see Table 3). Determine whether it is economically feasible to produce water from icebergs in the Persian Gulf, and if it is, deter- mine the best means to do so. TABLE 1 Towing Vessel Data Ship Size Daily rental (£) Maximum load (cu. meter) Speed 1 km/hr 3 km/hr 5 km/hr 1,000 TABLE 2 Melting Rates (meter/day) 0.06 0.08 0.10 Speed 1 km/hr 3 km/hr 5 km/hr Small 400 500,000 TABLE 3 Fuel Costs (£/km) 100,000 8.4 10.8 13.2 Medium 0.12 0.16 0.20 600 1,000,000 Distance from Pole (km) 2,000 3,000 0.18 0.24 0.30 this table represents the rate at which a hypothetical sphe- rical iceberg shrinks in radius over a day at the given distance 10.5 13.5 16.5 Large Current Volume (cu. meter) 1,000,000 10,000,000 800 24,000 0.24 0.32 0.40 10,000,000 12.6 16.2 19.8 ICEBERGS FOR KUWAIT The cost of desalinating seawater using conventional tech- nology in the Persian Gulf is high (around 0.1£ per cubic meter) and requires extensive amounts of oil. Some time ago scientists suggested that it could well prove both practically feasible and less expensive to tow icebergs from the Ant- arctic, a distance of about 9,600 km. Although some of the ice would undoubtedly melt in transit, it was thought that a significant proportion of the iceberg would remain intact upon arrival in the Gulf. Bear in mind that since water expands upon freezing, 1 cubic meter of ice produces only 0.85 cubic meter of water. A study was carried out to evaluate the practical pro- blems associated with such a proposal and to quantify the factors that were likely to influence the economics of such a venture. One factor was the difference in rental costs and capacities of towing vessels (summarized in Table 1). Note that each vessel has a maximum iceberg it can tow (mea- sured in cubic meters). It was found that the melting rate of the iceberg depends on both the towing speed and the distance from the South Pole (see Table 2). The data in from the Pole and at the given towing speed. Finally, fuel cost was found to depend on the towing speed and the (current) size of the iceberg (see Table 3). Determine whether it is economically feasible to produce water from icebergs in the Persian Gulf, and if it is, deter- mine the best means to do so. TABLE 1 Towing Vessel Data Ship Size Daily rental (£) Maximum load (cu. meter) Speed 1 km/hr 3 km/hr 5 km/hr 1,000 TABLE 2 Melting Rates (meter/day) 0.06 0.08 0.10 Speed 1 km/hr 3 km/hr 5 km/hr Small 400 500,000 TABLE 3 Fuel Costs (£/km) 100,000 8.4 10.8 13.2 Medium 0.12 0.16 0.20 600 1,000,000 Distance from Pole (km) 2,000 3,000 0.18 0.24 0.30 this table represents the rate at which a hypothetical sphe- rical iceberg shrinks in radius over a day at the given distance 10.5 13.5 16.5 Large Current Volume (cu. meter) 1,000,000 10,000,000 800 24,000 0.24 0.32 0.40 10,000,000 12.6 16.2 19.8
Expert Answer:
Answer rating: 100% (QA)
Design a spreadsheet trestimate the economic value of the freshwater produs alt by tswing t... View the full answer
Related Book For
Business Analytics The Art of Modeling with Spreadsheets
ISBN: 9781119386490
5th edition
Authors: Stephen G. Powell , Kenneth R. Baker.
Posted Date:
Students also viewed these computer network questions
-
Refer to the Icebergs for Kuwait case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercises in Chapter 2. (If this has...
-
Refer to the Icebergs for Kuwait case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
Refer to the Icebergs for Kuwait case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
Give the eccentricities of conic sections with one focus at the origin of the polar coordinate plane, along with the directrix for that focus. Find a polar equation for each conic section. e = 1/2, r...
-
Continuing from your short run results in the previous problem, what do you think will happen in the long run as these adjustments work their way through the economy?
-
Universities tend to be highly integrated-many departments all belong to the same organization. There is not a technical reason why a university could not consist of freestanding departments linked...
-
As a coil moves to the right at constant speed, it passes over the north pole of a magnet and then moves beyond it. Which graph best represents the current in the loop for the time of the motion? A...
-
The following situations involve accounting principles and assumptions. 1. Julia Company owns buildings that are worth substantially more than they originally cost. In an effort to provide more...
-
What is the discounted return on investment for problem 3.3 using a discount rate of 15% per annum assuming the cash flows are received at the middle of the year? What is the discounted profit to...
-
Big Guy Inc. purchased 80% of the outstanding voting shares of Humble Corp. for $360,000 on July 1, 2017. On that date, Humble Corp. had common shares and retained earnings worth $180,000 and...
-
1. (50 pts) Glass capillary tubes of various diameters are inserted vertically through the surface of tap water at 20C. The contact angle between the water and the glass is 11.5. Use the surface...
-
Assume Bill Jones invested $ 2,739.97 into an account exactly one year ago. The account has an interest rate of 3.4 % p.a. How much does Bill have in his account today (that is, exactly one year...
-
Why did Crenshaw make and begin using the term intersectionality ? According to Crenshaw, in describing the DeGraffenreid lawsuit, how did legal interpretations obscure lived experiences of...
-
1. (5pts) Use Newton's 2nd law to calculate the percentage of an object's volume that is above water, while floating at rest in freshwater. The object's average density is 640 kg/m3.
-
Explain potential forms of discrimination based on labor laws and regulations when conducting a performance appraisal.
-
5. A centrifuge rotor rotating at 8500 rpm is shut off and eventually brought uniformly to rest by a frictionless torque of 1.10 mN. If the mass of the rotor is 2.90 kg and it can be approximated as...
-
Bridgeport Co. provided the following information on selected transactions during 2024: Purchase of land by issuing bonds Proceeds from issuing bonds Purchases of inventory Purchases of treasury...
-
Rosalie owns 50% of the outstanding stock of Salmon Corporation. In a qualifying stock redemption, Salmon distributes $80,000 to Rosalie in exchange for one-half of her shares, which have a basis of...
-
Refer to the ERP Decision case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet that will assist the Board in understanding the likely costs and benefits of...
-
The dataset German Credit.xlsx contains data on prior applicants for credit, including whether they proved to have good or bad credit. a. How many records are in this dataset? b. How many fields are...
-
Refer to the Racquetball Racket case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
Describe the link between the size of an organization and the formalization process.
-
Identify and describe the major features of the Strategic Management model.
-
Identify and describe the meaning of the term's formalization and informal.
Study smarter with the SolutionInn App