Question
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
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 plant, 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.
Please attach the excel file for the formula! Thank you!
Plant Capacities to produce number of boats in August Demand in number of boats in August (Hint: this is but one step further than the beef example. Here, we want minimize the combined cost of production and shipping; therefore, for example, the total cost from San Diego to Newport Beach will be 1065+200 )Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started