KINDLY SOLVE USING DETAILED STEPS SO I CAN LEARN. PLEASE DON'T COPY PASTE EXISTING CHEGG SOLUTIONS.

USE EXCEL SOLVER FOR PART 2 AND EXPLAIN STEPS

Paula must haul gravel to three construction sites. She can purchase as much an as 21 tons of this material from a gravel pit in the northern part of the city and up to 19 tons from another pit in the southern part of the city. She requires 11 tons, 9 tons, and 16 tons to sties 1, 2, and 3 respectively. The purchase price per tone at each gravel pit and the cost of hauling per ton are given in the following table: Hauling cost per ton at site Pit Site 1 Site 2 Site 3 Price/ton North $35 $55 $45 $111 South $31 $54 $48 $112 Paula wishes to determine how much to haul from each pit to each site to minimize the total cost for purchasing and hauling gravel. 1. Formulate a LP model by defining all variables in detail and develop the objective function and showcase all constraints. 2. Use Excel/Solver to solve the model. 3. Find the amount of gravel that Paula should purchase from each pit and what would be the resulting cost of her hauling plan? 4. Paula is thinking to increase the amount of gravel to the three sites. In this case, which site should she pick to receive more gravel, and by what amount? 5. Explain the effect of this modification (part 4) on the overall cost of hauling