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 un 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.