Please help to solve with EXCEL SOLVER and provided all formula, so that I can rebuild the excel on my computer.

use Method of Maximal Covering

[20 marks] A company is planning to open three big shopping malls in some of the counties. They learned that there are already three similar shopping malls in Cook, IL, Will, IL, and Lake, IN (one for each). Suppose that the closest shopping mall fully captures the demand of each county; but if two shopping malls have the same distance to the county, the demand will be equally shared by both. Where should the company open the three shopping malls to maximize the total demand captured? [Hint: You will need to develop a new location model based on some model(s) you learned in the lectures. Additional decision variables to determine if the amount of demand is fully or partially (if half) captured are needed.] B D E F G H I J K L | 5 A 1 Distance Matrix (miles) 2 County 3 Lake, IL 4 McHenry, IL 5 Cook, IL 6 DuPage, IL 7 Kane, IL 8 Will, IL 9 Kendall, IL 10 Kankakee, IL 11 Grundy, IL 12 Lake, IN Lake, IL McHenry, IL Cook, IL DuPage, IL Kane, IL Will, IL Kendall, IL Kankakee, IL Grundy, IL Lake, IN Demand 0 19 35 32 33 55 52 82 72 62 64435 19 0 44 34 26 56 45 84 68 73 26008 35 44 0 16 30 25 36 49 48 29 537674 32 34 16 0 14 23 24 51 41 41 90416 33 26 30 14 0 31 19 60 42 55 40412 55 56 25 23 31 0 22 29 23 33 50227 52 45 36 24 19 22 ol 46 24 54 5454 82 84 49 51 60 29 46 0 29 36 10383 72 68 48 41 42 23 24 29 0 53 3754 62 73 29 41 55 33 54 36 531 0 48457 [20 marks] A company is planning to open three big shopping malls in some of the counties. They learned that there are already three similar shopping malls in Cook, IL, Will, IL, and Lake, IN (one for each). Suppose that the closest shopping mall fully captures the demand of each county; but if two shopping malls have the same distance to the county, the demand will be equally shared by both. Where should the company open the three shopping malls to maximize the total demand captured? [Hint: You will need to develop a new location model based on some model(s) you learned in the lectures. Additional decision variables to determine if the amount of demand is fully or partially (if half) captured are needed.] B D E F G H I J K L | 5 A 1 Distance Matrix (miles) 2 County 3 Lake, IL 4 McHenry, IL 5 Cook, IL 6 DuPage, IL 7 Kane, IL 8 Will, IL 9 Kendall, IL 10 Kankakee, IL 11 Grundy, IL 12 Lake, IN Lake, IL McHenry, IL Cook, IL DuPage, IL Kane, IL Will, IL Kendall, IL Kankakee, IL Grundy, IL Lake, IN Demand 0 19 35 32 33 55 52 82 72 62 64435 19 0 44 34 26 56 45 84 68 73 26008 35 44 0 16 30 25 36 49 48 29 537674 32 34 16 0 14 23 24 51 41 41 90416 33 26 30 14 0 31 19 60 42 55 40412 55 56 25 23 31 0 22 29 23 33 50227 52 45 36 24 19 22 ol 46 24 54 5454 82 84 49 51 60 29 46 0 29 36 10383 72 68 48 41 42 23 24 29 0 53 3754 62 73 29 41 55 33 54 36 531 0 48457