Order from us for quality, customized work in due time of your choice.
Mohawk Paper Mills Inc., located in Cohoes, New York, produces up to 200 tons of
Mohawk Paper Mills Inc., located in Cohoes, New York, produces up to 200 tons of paper per day to fill orders from 250 customers. The mill is served by six carriers, and twenty shipments per day are not unusual. The carriers will generally accept shipments to any destination that they serve, subject to daily volume commitments and equipment availability. Each carrier has a different and somewhat complex rate structure. Your team will build a model in Excel and use Solver to determine which carriers to use to ship to customers on a particular day to minimize their total costs in this enhanced transportation problem. Details of the case are in the document:
Motor Carrier Selection at Mohawk.docx
Mohawk Shell.xlsx
Order from us for quality, customized work in due time of your choice.