Format: Fed free to work on Excel format provided in the Workbooke for this module, but make sure to report on questions asked for in this assigament in addition to the calculations paline doxunicat lioks are not geing to be accepted. o. Late submissions require instructor approval but are not gaaranted Please see fate submission policy on sythbis; grading See resubmission policy in sylabus for details 1. The Center-of-Gravity Problem: McDonald's has 7 restaurants in a resort area. They are considering locating a central warehouse that would deliver products to each store. The number next to each restaarant warelouse that would detiver products to each store. The number next to each resticipated number of deliveries that would need to be made each month. gives the a) What is the simple grid solution to this problem? Assume R is constant for cach focation: This assumption allows is to ignore R. (it cancels out). Aiternatively (and cqutratentiy), set Reil. b) Perform two iterations of the exact grid method. What is this solution? Why night management have a problem with this solution? (Hint: For the second iteration: after you complete the initial iteration, you can bise the new distance calculation on the X and Y values you have found in your first iteration and use those values in the di formatation? 2. The K-Median and Max-Covering Problems: Trust fric makes deliveries to ins customers which are located in 6 clusters. The table below provides the driving times (in hours) between 5 potential warehouse locations flabeled 1 through 5) and the 6 customer clusters (babeled A through F). Trovel is limited to the road network. Travel time between warehouses and castomers: Number of customers per cluster: a. The VP of Logistics is primarily concerned with transportation costs to customers. Assuming a transportation rate that is linear with travel time, which problem woold we solve to choose 1 location which would minimize the total transportation cost? b. Solve the problem using the method youve identificd in part whit is is food location? c. The VP of Pinance, instead, sogests a solution that nuximizes the number of cistomers that are within 15 hours but does so with only 2 warehooses. Which problen would we solve to give this VP an appropriate solution? d. Solve the problem using the method youre identined in pate 8 what are good locunons