7. An Excel file has been uploaded with the relevant information. In rural PEI, there are no fire hydrants in most communities. In the event of a large fire, water has to be shuttled from a water source to the location of the fire. To do this, most departments have trucks that can be used either for pumping water onto a fire, or for shuttling water from the water source to the fire location. Each truck has a maximum pumping capacity (gal/min) and a water capacity (gal). If a truck is shuttling water, there is a time required to fill the truck (they are filled using external pumps at 600 gal/min), and a time required to dump the water out of the truck into an on-site water reservoir. Once a truck is assigned to one task, it remains at that task for the duration of the incident. There is also a mutual aid agreement that all the local departments share that they will respond if required. As they are large trucks, they are limited to a top speed of 60km/hr. If a fire breaks out in St. Peters, and the local department requests assistance from all the departments listed, how can water shuttling/pumping be organized so that the maximum amount of water is put on the fire. Assume that water is required for four hours, and that all trucks are initailly fully loaded with water (i.e.: they do not have to fill up before their first trip to the fire scene). For the trucks that are pumping water, their water load is available immediately, but once they have exhausted their supply, they are dependent on the water being shuttled in by other trucks. L e L L e L R e As water is brought to the scene, it is dumped Pumps such as those shown above are used to into large bags such as the one pictured refill trucks. above. Mote that this is actual data collected from an exercise a few years ago. There is no definitive answer to this problem it will depend on assumptions that you make. You may also have to make some simplifications to the problem. | am looking for the approach to this problem, that your assumptions and simplifications are clear and well explained, and that you solve the problem in the context of these assumptions. | will also be looking for a list of possible factors that could impact on the final result, and the potential impact of these factors on the final result. E3 X =+C3/1000 A B C D E F G H J K L Pump Capacity (Gallons/min) Water Capacity (Gallons) Fill Time (minutes) Dump Time (minutes) JAWN- Belfast 2 350 1500 2.5 1.5 Belfast 3 250 1100 1.833333333 1.1 Cardigan 1 840 1500 2.5 1.5 Cardigan 2 1050 1000 1.666666667 7 Cardigan 3 840 1500 2.5 1.5 8 Central Kings 1 1050 500 0.833333333 0.5 Central Kings 2 250 3000 5 3 10 Eastern Kings 1 840 750 1.25 0.75 11 Eastern Kings 2 840 800 1.333333333 0.8 12 Eastern Kings 3 0 3000 5 3 13 Eastern Kings 4 0 3000 5 3 14 Eastern Kings 5 0 1200 2 1.2 15 Eastern Kings 6 O 800 1.333333333 0.8 16 Georgetown 1 625 1200 2 1.2 17 Georgetown 2 1050 1200 IN 1.2 18 Forestry - Gtown 325 800 1.333333333 0.8 19 Montague 1 1200 400 0.666666667 0.4 20 Montague 2 1050 1000 1.666666667 21 Montague 3 625 0.001666667 0.001 22 Montague 4 1050 1000 1.666666667 23 Morell 1 625 2000 3.333333333 2 24 Morell 2 1250 900 1.5 0.9 25 Morell 3 625 1200 2 1.2 26 Morell 4 400 3500 5.833333333 3.5 27 Mount Stewart 2 840 1200 2 1.2 All trucks +IM NOT DUMB, IM GONNA NOTICE IF AI IS USED, THATS WHY IM ASKING NOT TO USE IT PLEASE DO NOT USE AI PLEASE GIVE EXPLANATION if ai is used i will report the account OPTIMIZATION:IM NOT DUMB, IM GONNA NOTICE IF AI IS USED, THATS WHY IM ASKING NOT TO USE IT PLEASE DO NOT USE AI PLEASE GIVE EXPLANATION if ai is used i will report the account OPTIMIZATION