This paper circulates around the core theme of The We Haul Trucking Company hauls gravel from two quarries together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
The We Haul Trucking Company hauls gravel from two quarries to five construction sites. Quarries A and B charges $17 and $21 per ton, respectively, for gravel; they each have 400 tons of gravel available per week. We Haul has contracted to deliver 110, 227, 82, 148, and 193 tons of gravel per week to construction sites, 1, 2, 3, 4, and 5, respectively. We Haul figures that it costs them $0.10 per ton per mile of gravel hauled due to wear and tear on their trucks. The table below lists the distances (in miles) between the quarries and the construction sites.Construction site (miles)12345Quarry A7723174231Quarry B5816332715Formulate a mathematical linear programming model to determine the cost minimizing way to fulfill the gravel contracts. Type the model in worksheet 1 of your excel file.