please give the excel solution

1.1 Set up solver to determine how many truckloads of sod to ship from each farm to each nursery in order to minimize the overall shipping costs subject to the following constraints: a. You must ship all of the sod available at each farm without exceeding what is available. b. You must not ship a partial truckload of sod (ship only integer numbers of trucks). c. You must not ship more than the quantity demanded of sod to any nursery, though you can ship less than the quantity demanded. d. You must ship at least 10 truckloads of sod to each nursery (note: you may send all 10 from one farm or a total of 10 from both farms). e. Before solving make the solving method "Simplex LP" and checkmark the "Make Unconstrained Variables Non- negative" option