This preview shows page 1. Sign up to view the full content.
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 $27,437,450.00. All of the warehouses have been satisfied with the demand that they requested. For regional center C1, out of the 600,000 tons, 333,000 tons have been shipped out and 267,000 tons have not been shipped to the warehouse. For regional center C2, out of the 750,000 tons, 485,000 tons have been shipped out and 265,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. 1). By how much does total cost decrease? 28,323,500.00 - 27,437,450.00 = $886,050 2). By how much does the volume shipped out of C1 increase? 486,000 – 333,000 = 153,000 The volume shipped out of C1 decreased...
View Full Document
This note was uploaded on 09/08/2010 for the course BUS 190 at San Jose State.