{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Executive Summary Final

Executive Summary Final - made Spread Sheet was use to...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
12/06/2007 Linear Programming Computer Project Executive Summary Problem 12-37 A. Problem Description This problem is to figure out the best possible shipment schedule that will have the lowest cost. The company WaySafe has 3 regional centers and 11 district warehouses. The data given is shown is kilotons so to find out the cost the kilotons should be converted to tons. This is because the shipping cost is in dollar per ton per mile. B. List of Methodologies / Tools Used Linear programming was used to apply the basic knowledge of the process in solving the problem. Solver program was use to find the optimal solution of the shipping schedule. This program was very useful because by inputting all the constraints, regulations and other data, the problem could be solved even after the change to the data is
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: made. Spread Sheet was use to input data and organize the cost and display the process. Also the spread sheet allows the process to be clearer and easily compared. C. Principal Results With all the restraints applied, the total shipping cost came out to $28,323,500.00. All of the warehouses have been satisfied with the demand that they requested. For regional center C1, out of the 500,000 tons, 486,000 tons have been shipped out and 14,000 tons have not been shipped to the warehouse. For regional center C2, out of the 750,000 tons, 332,000 tons have been shipped out and 418,000 tons have not been shipped to the warehouse. For regional center C3, out of the 400,000 tons, 400,000 tons have been shipped out and none have left unshipped....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online