Explore BrainMass

Explore BrainMass

    Mathematics - Linear Programming : Optimal Solution

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please see attached for data.

    Brooks City has three consolidated high schools, each with a capacity of 1,300 students. The school board has partitioned the city into five busing districts each with different high school populations. The three schools are located in the central, west, and south districts. Some students must be bused outside their districts, and the school board wants to minimize the total bus distance traveled by these students. The average distances from each district to the three schools and the total student population in each district are as follows:

    The school board wants to determine the number of students to bus from each district to each school to minimize the total busing miles traveled. Hint: You have 5 sources and 3 destinations, giving you 5x3 = 15 possible paths.

    a.) Linear programming model showing the objective function and all 8 constraints, with each constraint labeled.
    b.) A copy and paste of the computer solution window.

    © BrainMass Inc. brainmass.com October 9, 2019, 10:52 pm ad1c9bdddf


    Solution Preview

    This model was solved using Excel Solver. Therefore, the computer printout ...

    Solution Summary

    A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.