Please provide all solver formulas

Two new STEM focused public schools, located in expansive suburban campuses, are to transport students by bus from five nearby communities. Minority enrollment must be between 35% and 45% in each school. Non- minority students live in two communities and minority students live in three other communities. Round trip travel distances and other relevant data are shown in the table below: Roundtrip Miles from Schools to: Maximum Minority Communities Non-minority Communities School Enrollment 1 2 3 4 5 1 1500 20 12 10 5 3 2 2000 15 21 11 6 5 Student Population: 500 450 300 1000 1000 (a) Construct a balanced and properly labeled network diagram for representing this busing problem and formulate (i.e. define all decision variables precisely and construct the objective function and all constraints in algebraic format) a linear optimization model related to your network diagram, for finding the best plan for transporting the students to these schools. (b) Solve your model in part (a) using Excel/Solver and interpret the results clearly