Put it into excel

Supply Chain Distribution A Step Above Company manufactures both the Step One and Next Step product lines out of two plants one plant is located on the Southwest coast in Phoenix, Arizona and the other plant is located on the Northeast coast in Lansing, Michigan. Each plant is expected to produce half of the forecasted demand for each product line in the coming year. (Note: The Phoenix plant will produce one more pair of Next Step shoes than the Lansing plant.) There are a total of 4 distribution hubs that each plant can ship their supply of both product lines. The required demand at each distribution hub is as follows: The cost to ship each pair of shoes to each Distribution Hub from both plants is as follows: Team Analysis - Distribution The following questions need to be answered to determine the distribution schedule for the projected demand of both product lines for the upcoming year: 1) How many pairs of Step One shoes will be shipped from each plant to each distribution hub? 2) What is the total minimum shipping cost for the projected demand of the Step One shoes? 3) How many pairs of Next Step shoes will be shipped from each plant to each distribution hub? 4) What is the total minimum shipping cost for the projected demand of the Next Step shoes