Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables:Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs.What would be the effect on the solutions if the capacity at each plant were 70 fishes? Fisher1. Hilo2. Kona3. PunaPlant4. Plant 15. Plant 26. Plant 3Demand4. Plant 1$420$510$450Plant5. Plant 2$390$590$3606. BTS Sushi$75$125$68606. Plant 3610470480Restaurant7. Kentucky FriedSushi$63$110$8245Supply5578378. Ken's SushiHouse$81$95$9550

Please note that in the question, 2 plants are mentioned, but details of 3 plants are given. Hence,…

Answered: Suisan Fish Company contracts with…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables:

Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs.
What would be the effect on the solutions if the capacity at each plant were 70 fishes?