M6.2 A severe drought has swept across Arizona and New Mexico, resulting in additional forest fires. Local fire stations have requested help from some other southwestern states. The table below shows the number of crews available from five fire stations (in Colorado and Utah) and the demand for crews from seven fire stations (in Arizona and New Mexico). The weekly cost of the crew (in thousands of dollars) is shown in the table and is based on how far they travel and the living expenses in the area): FIRE CREWS NEEDED IN ARIZONA AND NEW MEXICO Crew AZ-1 AZ-2 AZ-3 NM-1 NM-2 NM-3 NM-4 C0-1 CO-2 CO-3 UT-1 UT-2 CREWS NEEDED IN AZ & NM $17.2 $12.8 $12.4 $18.2 $19.3 $14.3 $11.3 $13.8 $19.4 $20.2 $13.9 $10.6 $9.4 $18.2 $19.5 $13.5 $14.0 $11.3 $17.9 $20.2 $14.7 $12.7 $13.1 $20.5 $18.7 $16.5 $13.2 $128 $16.5 $213 $18.7 $20.4 $14.5 $22.7 $23.5 CREWS AVAILABLE IN CO& UT 12 14 14 14 12 9 7 6 6 11 7 9 7 Formulate a model that will determine the number of crews that should be sent from each fire station (CO, UT) to each affected area (AZ, NM) that minimizes total cost. SOLUTION: The optimal solution, the value of the cost, should be $778.70 (or if you converted it 778,700). This is an unbalanced problem. (Hint:count the crews available and compare them to the crews needed to determine the which group (supply or demand) will have the inequality). Questions a) How many crews are sent from CO-2 to AZ-2? b) How many crews are sent from UT-1 to NM-3? c) Which supplying location (CO or UT) did not send all their crews to the AZ or NM locations? Use the Alt LP Template.xlsx provided to you in the Module Documents & Files. Solve the problem using Excel Solver, place the answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. You do not need to submit the formulation for this