Optimal shipping strategy to minimize total shipping cost

Assignment Help Operation Management

Reference no: EM13902310

A company can ship its product from any of its three factories, F1, F2, and F3, to any of its retail outlets, R1, R2, and R3. The capacity, demand, and shipping cost information is provided as follows:

Demand (units) Capacity (units)

R1: 300 F1:250

R2:500 F2:350

R3:200 F3:400

Shipping Cost /unit ($)

R1 R2 R3

F1 1 3 2

F2 3 4 2

F3 2 2 3

The company wants to come up with an optimal shipping strategy to minimize its total shipping cost. Use excel to formulate and solve this problem.

Reference no: EM13902310

Questions Cloud

Decision-making function with any other managerial function : Do you think that decision making is the most important function of management? Explain by comparing the decision-making function with any other managerial function (i.e. planning, organizing, leading, controlling, etc.).

Jobs with little face-to-face communication : Do you think technology will eventually enable top managers to do their jobs with little face-to-face communication? Give examples.

Production schedule-overall lowest net present value cost : A company has received an order for four sophisticated hardware units for an orbiting platform. The purchaser will take delivery of one unit starting 1 year from now, and one unit at the end of each succeeding 3 years (4 units total over four years)...

How about through discrimination or polluting environment : Does Friedman believe that business should make as much profit as possible, even if through fraud and deception? How about through discrimination or polluting the environment? Should a firm embrace value creation for transient shareholders seeking sh..

Optimal shipping strategy to minimize total shipping cost : A company can ship its product from any of its three factories, F1, F2, and F3, to any of its retail outlets, R1, R2, and R3. The capacity, demand, and shipping cost information is provided as follows: The company wants to come up with an optimal shi..

Kind of ethical-social and political issues : Search the ITT Tech Virtual Library and find an article detailing how an organization is using a knowledge management system to make better business decisions. What kind of ethical, social, and political issues are raised by information systems?

Evaluation of objectives in employees performance evaluation : Do you think evaluations of values should revieve equal, more, or less weight that evaluation of objectives (or that the employee accomplished) in employees' performance evaluation. Why?

Investment alternatives to maximize total annual return : The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. How s..

What contract issues are involved : Erwick Construction Company contracted to build a house for Charles. The specifications called for the use of Karlene Pipe for all plumbing. Erwick, however, got a better price on Boynton Pipe and substituted the higher quality Boynton Pipe for Karle..

User Account

All Pages