module 5

Using the Simplex (Linear Programing Method) from MS Excel, determine the optimal allocation of inventory and the corresponding total transportation cost for the Stevenson & Sons distribution problem described in Module #5, considering that, as a result of a fleet enhancement, the maximum shipment size has been increased to 150 bags for shipments originating exclusively from the Chattanooga plant.
NOTE: Use the file WB8.xlsx as a base.
Submit the Excel file with your calculations, along with a Word file(1 short paragraph) with your comments.