please answer all the questions correctly

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. Warehouse Production Plant Sacramento Ventura Elk Grove $0.75 $7.00 Santa Ana $8.25 $2.15 Storage Capacity 375 700 Warehouse Retail Location Sacramento Ventura Demand for Retail San Jose $1.25 $5.50 300 Anaheim $7.00 $1.75 550 San Diego $12.00 $6.00 200 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 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 type your answer... The total shipping cost from the warehouses to the retail locations is type your answer... The overall total shipping costs is type your answer... The number of lots shipped from Sacramento warehouse to the retail location in Anaheim is type your answer... The number of lots left in the Sacramento warehouse is type your answer... The number of lots left in the Ventura warehouse is type your answer... 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 benet the company? choose your answer... V . This is because the shadow price for the constraint is choose your answer... V which means that the company choose your answer... V type your answer... dollars for every additional unit added to the righthand-side, up to type your answer... maximum quantity. Otherwise, we need to solve for a new solution. If you must increase the demand of one 0fthe 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 benet the company? choose your answer... V .This is because the shadow price for the constraint is choose your answer... V which means that the company choose your answer... V type your answer... dollars 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