The owner of Go-Ride, Tom Rider, projects that within three years, demand for riding mowers will exceed supply bu approximately 550 units a month. Projected demand and current capacities and unit costs are: From Plant A to warehouse 1 = 10, warehouse 2 = 27, warehouse 3 = 7, warehouse 4 = 14, supply in mowers per month 250
From Plant B to warehouse 1 = 12, warehouse 2 = 20, warehouse 3 = 8, warehouse 4 = 30. Supply in mowers per month = 270
Demand in mowers per month from warehouse 1 = 340, warehouse 2 = 140, warehouse 3=140, warehouse 4 = 450
a. Formulate as a linear programming model
b. use excel and solve this problem to obtain the lowest-cost shipping schedule. what is the minimum shipping cost?
please include the excel sheet as part of the answer. I tried on my own, but am thoroughly confused