This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 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,079,000.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, 513,000 tons have been shipped out and 237,000 tons have not been shipped to the warehouse. For regional center C3, out of the 400,000 tons, 219,000 tons have been shipped out and 181,000 tons have not been shipped to the warehouse. 1). Does the total increase or decrease? The total has decreased. $28,323,500.00 - $27,079,000.00 = $1244500.00 2). Which centers now ship to W7? Only regional center 2 ships to warehouse 7....
View Full Document