solve part a in excel also and show formulas

1. A contractor has two highway construction jobs that need hox-mix asphalt concrete (HMAC) simultaneously. Three asphalt mixing plants can deliver the asphalt concrete to the two job sites. The unit costs (material + hauling) in dollars per ton of HMAC from each plant to each site are: From 1 To Site 1 Site 2 Plant A 130 140 Plant B 135 125 Plant C 145 150 The production capacity at Plants A, B, and Care 200, 150, 300 tons/day, respectively. The demands at the sites 1 and 2 are 200, and 250 tons per day, respectively. The contractor wants to minimize the total cost. (a) Formulate the problem as a linear programming problem. Identify the control variables, objective function and constraints. (5 points) (c) If the demand at job site 2 is decreased from 250 tons per day to 120 tons per day, how much amount should the contractor order from each asphalt phalt plant to each job site? What is the total cost to the contractor per day? number, (5 points)