I need help answering Questions 1 to 6 for my study guide in Excel. Snow removal

Question

I need help answering Questions 1 to 6 for my study guide in Excel.

Snow removal and disposal are important and expensive activities in Montreal and many northern cities. Although snow can be cleared from streets and sidewalks by plowing and shoveling, in prolonged subfreezing temperatures, the resulting banks of accumulated snow can impede pedestrian and vehicular traffic and must be removed To allow timely removal and disposal of snow, a city is divided up into several sec tors and snow removal operations are carried out concurrently in each sector. In Mon treal, accumulated snow is loaded into trucks and hauled away to disposal sites (e.g., rivers, quarries, sewer chutes, surface holding areas). The different types of disposal sites can accommodate different amounts of snow due to the physical size of the dis posal facility. The annual capacities for five different snow disposal sites are given in the following table (in 1,000s of cubic meters) Disposal Site 3 2 4 5 Capacity 350 250 500 400 200 The snow transported to various disposal sites is often contaminated by salt and de-icing chemicals. When the snow melts, these contaminants ultimately wind up in lakes, rivers, and the local water supply. The different disposal sites are equipped to remove different amounts of contaminants from the snow they receive. The percentage of contaminants that can be removed from the snow delivered to each disposal site is given in the following table. The amount of contaminant contained in removed snow is relatively constant across sectors Disposal Site 3 20% 4 Contaminant Removed 30% 40% 70% 50%

Explanation / Answer

answer 1 site capacity in 1000s of cubic meter snow removal requirement for each site 1 350 sector 1 2 3 4 5 6 7 8 9 10 2 250 capacity in 1000s of cubic meter 153 152 154 138 127 129 111 110 130 135 3 500 4 400 5 200 answer 3 optimal solution and lowest cost cost of removing snow from each site sector 1 2 3 4 5 6 7 8 9 10 total cost cost in $ 7497 12768 7546 15953 9334.5 29347.5 22144.5 20020 30030 28350 182990.5 lowest cost to site 2 1 1 1&2 3 3 5 3 3 4 answer 3 sector number 4 has to dispose at site number 3 21735 sector number 6 has to dispose at site nimber 4 34765.5 total resultin cost 194190.5 answer4 site 4 5 2 1 3 92064 38080 24262 20104 30765 sector 1,7, 10 8&6 6,2&5 3&4 5&9 answer 1 site capacity in 1000s of cubic meter snow removal requirement for each site 1 350 sector 1 2 3 4 5 6 7 8 9 10 2 250 capacity in 1000s of cubic meter 153 152 154 138 127 129 111 110 130 135 3 500 4 400 5 200 answer 3 optimal solution and lowest cost cost of removing snow from each site sector 1 2 3 4 5 6 7 8 9 10 total cost cost in $ 7497 12768 7546 15953 9334.5 29347.5 22144.5 20020 30030 28350 182990.5 lowest cost to site 2 1 1 1&2 3 3 5 3 3 4 answer 3 sector number 4 has to dispose at site number 3 21735 sector number 6 has to dispose at site nimber 4 34765.5 total resultin cost 194190.5 answer4 site 4 5 2 1 3 92064 38080 24262 20104 30765 sector 1,7, 10 8&6 6,2&5 3&4 5&9 answer 1 site capacity in 1000s of cubic meter snow removal requirement for each site 1 350 sector 1 2 3 4 5 6 7 8 9 10 2 250 capacity in 1000s of cubic meter 153 152 154 138 127 129 111 110 130 135 3 500 4 400 5 200 answer 3 optimal solution and lowest cost cost of removing snow from each site sector 1 2 3 4 5 6 7 8 9 10 total cost cost in $ 7497 12768 7546 15953 9334.5 29347.5 22144.5 20020 30030 28350 182990.5 lowest cost to site 2 1 1 1&2 3 3 5 3 3 4 answer 3 sector number 4 has to dispose at site number 3 21735 sector number 6 has to dispose at site nimber 4 34765.5 total resultin cost 194190.5 answer4 site 4 5 2 1 3 92064 38080 24262 20104 30765 sector 1,7, 10 8&6 6,2&5 3&4 5&9 answer 1 site capacity in 1000s of cubic meter snow removal requirement for each site 1 350 sector 1 2 3 4 5 6 7 8 9 10 2 250 capacity in 1000s of cubic meter 153 152 154 138 127 129 111 110 130 135 3 500 4 400 5 200 answer 3 optimal solution and lowest cost cost of removing snow from each site sector 1 2 3 4 5 6 7 8 9 10 total cost cost in $ 7497 12768 7546 15953 9334.5 29347.5 22144.5 20020 30030 28350 182990.5 lowest cost to site 2 1 1 1&2 3 3 5 3 3 4 answer 3 sector number 4 has to dispose at site number 3 21735 sector number 6 has to dispose at site nimber 4 34765.5 total resultin cost 194190.5 answer4 site 4 5 2 1 3 92064 38080 24262 20104 30765 sector 1,7, 10 8&6 6,2&5 3&4 5&9

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.