Linear Programming / Transportation Problem : Minimizing Cost

The Widgit Company has agreed to supply its best customer with three widgits during each of the next 3 weeks, even though producing them will require some overtime work. The relevant production data are as follows:

Week Maximum Production,
Regular Time Maximum Production,
Overtime Production Cost per Unit,
Regular Time
1 2 2 $300
2 3 2 $500
3 1 2 $400

The cost per unit produced with overtime for each week is $100 more than for regular time. The cost of storage is $50 per unit for each week it is stored. There is already an inventory of two widgets on hand currently, but the company does not want to retain any widgets in inventory after the 3 weeks.
Management wants to know how many units should be produced in each week to minimize the total cost of meeting the delivery schedule.
Formulate this problem as a transportation problem by constructing the appropriate parameter table.

Hello!
The solution is in the attached Excel file.

The first table, which shows the different production costs in each of the weeks is equivalent to the cost table from a transportation problem, in which the unit costs of transporting goods from each specific source to each specific destination are shown. In our table, ...

Solution Summary

An LP / transportation problem is solved. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.

... The linear programming model for the transportation problem is summarized ...Minimize Z = 12 x1 A + 15 x1B + 17 x1C + 14 x2 A + 9 x2 B + 10 x2C + 13 x3 A + 20 ...

... a. Formulate a linear programming (LP) model to ... Network Design Problem Statement: Objective is to ...minimizing the total cost (transportation cost and fixed ...

... Destination B Demand Constraint] * x4A + 7 * x4B 2. Canning Transport is to ... Give the network model and the linear programming model for this problem. ...

... of the decision maker is to minimize cost. ... False: In transportation model demand constraint for a ... 9. In maximization linear programming problem profit is ...

... to solve linear programming problems. ... _____ 5. In a balanced transportation model, supply equals demand such that all constraints can be treated as ...

... what the network diagram and linear programming model should look like to minimize the cost of transportation so I ... A linear programming problem is solved. ...

Linear Programming - Transportation Problem, North West corner. ... Bath and how should these be distributed if the total transportation cost is to be minimized. ...

... 3. An optimal solution to a linear programming problem can be ... 9. The assignment problem can be considered to be a transportation problem, but the ...