A Linear Programming Problem Using Excel Example 1

We explain how to use Excel Solver to solve a linear Programming Problem. the problem we use as an example is the following.
A Company hauls gravel to a construction​ site, using a small truck and a large truck. The carrying capacity and operating cost per load are given in the accompanying table. The company must deliver a minimum of 120 cubic meters per day to satisfy his contract with the builder. The union contract with his drivers requires that the total number of loads per day is a minimum of 6. How many loads should be made in each truck per day to minimize the total​ cost?