Calfornia 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 dealership in Newport Beach(NB), Long Beach(LB), Ventura(Ven), San Luis Obispo (SLO), and San Francisco(SF). Production costs and capacities vary from plant to plant, as do shipping costs from the manufacturing plants to the dealerships. The following tables give costs, capacities, and demands for August.
Production costs
Shipping costs
san diego
1065
1005
NB
LB
VEN
280
SLO
SF
200
220
325
500
santa ana
125
125
280
350
400
san jose
975
390
365
300
250
100
Plant capacities and August demand
Plant capacity
August demand 42
San Diego 38
Newport Beach 33
Santa ana 45
Ventura 14
San jose 58
San Luis Obispo 10
San Francisco 22
a. Define decision variables, objective function, and constraints( *there should be total 15 contraints.) Use the problems to give answer for each
b. Develop a production and shipping schedule for the Matey-20 catamaran for this period that minimize the total production and shipping costs.
c. Define shadow prices and range of optimality, use this problem to give example of each
Please upload the excel sheet that you do the problem, and put details as much as possible