California Catamarans builds the Matey-20 catamaran boat in three locations: San Diego, Santa Ana, and San Jose. It ships the boats to its company-owned dealerships in Newport Beach, Ventura, and San Francisco. Production costs and capacities vary from plant to plan, as do shipping costs from the manufacturing plants to the dealerships. The following tables give cost, capacities and demands for August. Develop a production and shipping schedule for the Matey-20 catamaran for this period that minimizes the total production and shipping costs. First write down the model, then use Excel Solver to solve it. Cost Plant Production Cost per Boat Shipping cost per boat to Newport Beach Shipping cost per boat to Ventura Shipping cost per boat to San Francisco San Diego $1065 $200 $280 $500 Santa Ana $1005 $125 $280 $400 San Jose $975 $390 $300 $100 Plant Capacities to produce number of boats in August San Diego 38 Santa Ana 45 San Jose 58 Demand in number of boats in August Newport Beach 52 Ventura 37 San Francisco 32 Also, need a explanation on how to get the Decision variable