The owner of Go-Ride Tom Rider projects that within three years demand for riding mowers will exceed supply but approximately 550 units a month. Projected demand as well as 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) Express as a linear programming model
b) Use excel and solve this problem to attain the lowest-cost shipping schedule. What is the smallest shipping cost?
Please comprise the excel sheet as part of the answer. I tried on my own however am thoroughly confused