Can you show screen shots of the formulas used to get the correct answer please.

Question

Can you show screen shots of the formulas used to get the correct answer please. Thanks. One of the main products of P&T; Company is canned peas. The peas are prepared at three canneries (near Bellingham, Washington; Eugene, Oregon; and Albert Lea, Minnesota) and are then shipped by truck to four distributing warehouses in Sacremento, California; Salt Lake City, Utah; Rapid City, South Dakota; and Albuquerque, New Mexico. Because shipping costs are a major expense, management has begun a study to reduce them. For the upcoming season, an estimate has been made of what the output will be from each cannery, and how much each warehouse will require to satisfy its customers. The shipping costs from each cannery to each warehouse has also been determined. This is summarized in the next table Warehouse Shipping Cost/Truckload Canary 1 Canary2 Canary 3 Requirement of Each Warehouse2 Warehouse3 Warehouse4 Output of Each Canary 464 513 654 867 75 352 690 880 125 952 680 388 685 100 80 65 70 Warehouse Use Linear Programming Model to compute the best arrangement for shipping to keep the cost at minimum

Explanation / Answer

The solver SOlution to the transportation is given below

Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Output Total Canary1 0 20 0 55 75 75 canary2 80 45 0 0 125 125 canary3 0 0 70 30 100 100 Demand 80 65 70 85 Total 80 65 70 85 Total Cost 152535 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Output Canary1 464 513 654 867 75 canary2 352 416 690 880 125 canary3 952 680 388 685 100 Demand 80 65 70 85

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.