Need step-by-step solution via Excel Solver. From Chapter 7 of Introduction to Manage Science: A Modeling and Case Studies Approach with Spreadsheets (Fredrick Hillier, 6th Edition.) Please open attached JPG for full question. Many thanks.

WK Qu. 7-12 The university administration would... The university administration would like to add some additional parking locations. To make everyone happy,they would like each building to be within a 5 minute walk of one set of new parking spaces (the spaces will be added in blocks of 10 parking spaces). The university is considering six locations for the new parking spaces, but would like to minimize the overall cost ofthe project. In addition to the walking time requirement, the university would like to add at least 40 new parking spaces [at least 4 blocks of 10}. To help with the decision, the management science department formulated the following linear programming model: Min 405.1(1 + 390x2 + 3?0x3+ 365m + 390x5 + 465.9, s.t.x1 + x2 + x5 + x5 2 1[Residence Hall Aconstraint} x1 + x2 + x3 2 1 [Residence Hall 8 constraint} x4 + x5 + x5 2 1[Science building constraint] x1 + x4 + x5 2 1[Music building constraint] x2 + x3 + x4 2 1[Math building constraint] x3 + x4 + x5 2 1[Business building constraint} x2 + x5 + x5 2 1 [Auditorium constraint] x1 + x4 + x5 2 1 [Arena constraint] x1 + x2 + x3 + x4 + x5 + x5 2 4{Total locations constraint] :1: _ 1, if location j is selected J 0, otherwise a. What is the minimum the university can spend and still meet its goals? (Round your answer to the nearest whole number.} Mirr'l'nuli university goals I I b. Which of the locations will be selected? Location 1 will Location 2 will Location 3 will Location 4 will Location 5 will Location 6 will