a. Formulat in Y model tor thes preles. enployes needed in exah 4 hour time period. minimuls ataline requirements. 1. formulate an tip modei for this procilem monk. 4. Draw a netwon flow medel for this problem. in teral and uplosd the norkshet. Question 4: [15 points] The U.S. Department of Transportation (DOT) is planning to build a new interstate to run from Detroit to Charleston. A number of different routes have been proposed and are summarized in following figure, where node 1 represents Detroit and node 12 represents Charleston. The numbers on the arcs indicate the estimated construction costs of the various links (in millions of dollars). It is estimated that all of the routes will require approximately the same total driving time to make the trip from Detroit to Charleston. Thus, the DOT is interested in identifying the least costly alternative. Create a spreadsheet model for this problem and solve it using Solver. Report the optimal solution and the value of the objective function in your report. In addition, save your work in Excel and upload the worksheet. Question 5: [25 points] very large logistical problem arises in officer mobilization for the U.S. Marine Corps. During an international emergency, officers have to be mobilized from their current positions into billets required for the emergency. Based on rank, training and experience, each officer is qualified for some of the billets. Problems involving tens of thousands of officers and billets have to be solved in minutes to provide a rapid mobilization plan. A data set of consisting of 10 officer groups and 4 emergency billets is given in "Mobilization - Shell.xisx." a. Determine a mobilization plan that meets, as much as possible, the demand for officers at the billets while minimizing the total miles traveled, in so doing. you should also make sure that the shortage in the number of officers does not exceed 25% for any of the billets. Create a spreadsheet model for this problem and solve it using Solver. Report the (actual) total miles that officers need to travel? b. Now that you have found the optimal solution for the given number of officers, you have been asked to address the shortage issue. How many more officers are needed to address this issue? And to which officer group(s) should these new officers be added to fully meet the emergency billet demands? Explain your reasoning