Can you solve this question using an Excel solver?

1st dropdown (Sacramento, Ventura), 2nd dropdown (Positive, zero, negative), 3rd(Losses, saves), 4th(San Jose, San Diego, Anaheim), 5th(Positive, zero, negative), 6th((Losses, saves).

For dollar amount, answer in two (2) decimal points (e.g. 24.21). For quantity, answer in whole number (e.g. 1234). Maxwell Manufacturing has two production plants, one is in Elk Grove and the other one is in Santa Ana. The company is specialized in making felt tip marking pens. Once the products are manufactured, they are shipped to their close-by warehouses for storage. The first warehouse is located in the city of Sacramento and can store up to 375 lots. The second warehouse is located in the city of Ventura and can store up to 700 lots. The shipping cost per lot among the locations are given in the two tables below. The products from the two warehouse locations then can be requested to be shipped to different retail locations. Maxwell has three retail stores, one is in San Jose, one is in Anaheim and one is in San Diego. The demands for the three locations are 300,550 and 200. The company is interesting in saving costs. Use Excel Solver to model the above problem and answer the following: The total shipping cost from the plants to the warehouses is The total shipping cost from the warehouses to the retail locations is The overall total shipping costs is The number of lots shipped from Sacramento warehouse to the retail location in Anaheim is The number of lots left in the Sacramento warehouse is The number of lots left in the Ventura warehouse is If you can change the capacity of one of the warehouses (e.g. add 1 unit to the right-hand-side), which one would you recommend to change in this problem that would most benefit the company? .This is because the shadow price for the constraint is which means that the company dollars for every additional unit added to the right-hand-side, up to maximum quantity. Otherwise, we need to solve for a new solution. If you must increase the demand of one of the retail locations (e.g. add 1 unit to the right-hand-side), which one would you recommend the company to avoid increasing in this problem that would most benefit the company? This is because the shadow price for the constraint is which means that the company tollars for every additional unit added to the right-hand-side. NOTE: -You should have 2 sets of decision variables: the quantities being shipped from production plants to the two warehouses and the quantities being shipped from the warehouses to the retail locations. (Hint: use a comma to separate the 2 sets of decision variables in the "By changing variable cells" in Solver Parameters). -Quantities shipped to the warehouse must be met, no more or less. -At the minimum, demands from the different retail locations must be met. -Quantities shipped from the different warehouses cannot be more than their available quantities