Purchase Solution

Linear Programming: Minimize Costs for Four Cargo Ships

Not what you're looking for?

Ask Custom Question

Four cargo ships will be used for shipping goods from one port to four other ports (labeled 1, 2, 3, 4). Any ship can be used for making any one of these four trips. However, because of differences in the ships and cargoes, the total cost of loading, transporting, and unloading the goods for the different ship-port combinations varies considerably, as shown in the following table.

The objective is to assign the four ships to four different ports in such a way as to minimize the total cost for all four shipments. Formulate and solve this problem on a spreadsheet.

Purchase this Solution

Solution Summary

The Solution finds the best result with minimal costs in Linear Programming Problem using EXCEL Solver.

Solution provided by:
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Introduction to Finance

This quiz test introductory finance topics.