PLEASE SOLVE THIS USING EXCEL. PLEASE DO NOT WRITE IT ON PAPER. PLEASE HELP UNDERSTAND THE SOLUTION STEP BY STEP

PLEASE USE EXCEL OR DO NOT SOLVE IT

There are two prison facilities located out the city of Des Moines, are supposed to transport the prisoners by prison buses from 5 secret facilities. Each prison must have felony charged criminals enrolment of between 35% and 45%. Criminals who are not tried for felony dwell in two facilities, while the one's charged with felony are locked up in the other three facilities. The table below contains round-trip travel distances and other pertinent information: Prison 1 2 Max. Prisoner Enrolled 1500 2000 Roundtrip from prison facility to: Felony criminals Non-felony criminals 1 2 3 4 5 20 12 10 5 3 15 21 11 6 5 Total Prisoner Population: 500 450 300 1000 1000 a. Develop a network flow diagram for this problem b. Solve the model in SOLVER The numbers under felony criminals and non-felony criminals are round-trip travel distances