Question

In: Math

Part II: Linear Programming Model- Forbelt Corporation has a one-year contract to supply motors for all...

Part II: Linear Programming Model- Forbelt Corporation has a one-year contract to supply motors for all refrigerators produced by the Ice Age Corporation. Ice Age manufacturers the refrigerators at four locations around the country: Boston, Dallas, Los Angeles, and St. Paul. Plans call for the following number (in thousands) of refrigerators to be produced at each location: Boston 50 Dallas 70 Los Angeles 60 St. Paul 80 Forbelt’s three plants ae capable of producing the motors. The plans and production capacities (in thousands) are as follows: Denver 100 Atlanta 100 Chicago 150 Because of varying production and transportation costs, the profit that Forbelt earns on each lot of 1000 units depends on which plant produces the lot and which destination it was shipped to. Ship to: Produced At: Boston, Dallas, Los Angeles ,St. Paul Denver 7 , 11 . 8 13 Atlanta 20 17 . 12 10 Chicago 8 18 13 16 With profit maximization as a criterion, Forbelt’s management wants to determine how many motors should be produced at each plant and how many motors should be shipped form each plant to each destination. Find the optimal solution.

* I have the solution to the above problem, I need help with calculating profit (ex, when distribution changes)

Solutions

Expert Solution

Below is the Step by Step Profit Maximization table as per VAM method-

As the DEmand and Supply is not equal - this is unbalanced so we introduce a Dummy Demand City to balance it as shown below-

Estimates of the profit per unit
Shipped to
Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Supply Capacity
Denver        7 11 8 13 0 100
Atlanta    20 17 12 10 0 100
Chicago    8 18 13 16 0 150
Demand 50 70 60 80 90 350

As this is a Profit Maximization requirement we convert it into a relative loss Matrix by Subtracting each element from 20 ( Higest profit ) including itself -

1 2 3 4 5
Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity
A Denver        13 9 12 7 20 100
B Atlanta    0 3 8 10 20 100
C Chicago    12 2 7 4 20 150
Demand 50 70 60 80 90

Here the Smallest number shows the minimum cost ( relatively less loss) thus is a place of maximum profit- So we search for the lowest element and allocate the supply as per the demand in that cell from Capacity and Demand- If the Balance is left in Supply or Demand we leave it as it is and move to other lowest Element cell and allocate the value till we come back and have all the Demand met-

Ref 1 2 3 4 5
Supplying at B1 ( 0) Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity Capacity after Action
A Denver        100
B Atlanta    50 100 50
C Chicago    150
Demand 50 70 60 80 90
Demand After Action 0
Supplying at c2 ( 2) Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity Capacity after Action
A Denver        100
B Atlanta    50 100 50
C Chicago    70 150 80
Demand 50 70 60 80 90
Demand After Action 0 0
Supplying at C4 (4) Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity Capacity after Action
A Denver        100
B Atlanta    50 100 50
C Chicago    70 80 150 0
Demand 50 70 60 80 90
Demand After Action 0 0 0
Ref 1 2 3 4 5
Supplying at B3 (8) Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity Capacity after Action
A Denver        100
B Atlanta    50 50 100 0
C Chicago    70 80 150 0
Demand 50 70 60 80 90
Demand After Action 0 0 10 0
Ref 1 2 3 4 5
Supplying at A3 (12) Produced At               Boston            Dallas              Los Angeles               St. Paul Dummy Capacity Capacity after Action
A Denver        10 100 90
B Atlanta    50 50 100 0
C Chicago    70 80 150 0
Demand 50 70 60 80 90
Demand After Action 0 0 0 0

A ) Network representation of the model

Denvar ---------------10 units-----------> Los Angeles

Atlanta---------------50 units-----------> Los Angeles

Atlanta---------------50 units-----------> Boston

Chicago ---------------70 units-----------> Dallas

Chicago ---------------80 units-----------> St Paul

B ) Optimum Solution in Thousands ( Number of Units Alloted X Profit Rate ) = (50 X 20) + (70 X 18) + (80 X 16) + (50 X 12) + (10 X 8) = $ 4940


Related Solutions

Part a (worth 60 pts): Formulate a linear programming model (identify and define decision variables, objective...
Part a (worth 60 pts): Formulate a linear programming model (identify and define decision variables, objective function and constraints) that can be used to determine the amount (in pounds) of Brazilian Natural and Colombian Mild that will maximize the total contribution to profit. For “Part a” you do NOT need to solve this problem using Excel, you just need to do the LP formulation in the standard mathematical format. Part b (bonus worth 20 pts): Solve the LP problem that...
Part II: Graphical questions a. Using the bond supply/bond demand model, graphically illustrate and explain the...
Part II: Graphical questions a. Using the bond supply/bond demand model, graphically illustrate and explain the impact on i and q if the     liquidity of stocks increased due to a new online processing option while simultaneously government reduced       subsidies for capital projects by firms. The answers that posted in Chegg is not correct, please I need accurate work b. Using the loanable funds model, graphically illustrate and explain the impact on i and q resulting from an increase...
Every linear programming problem involves optimizing a: Select one: a. linear function subject to several linear...
Every linear programming problem involves optimizing a: Select one: a. linear function subject to several linear constraints b. linear regression model subject to several linear constraints c. linear function subject to several non-linear constraints d. non-linear function subject to several linear constraints
Non-negativity is always present in a linear programming problem. A) True B) False In all linear...
Non-negativity is always present in a linear programming problem. A) True B) False In all linear programming problems, the maximization or minimization of some quantity is the objective. A) True B) False All linear programming problems have at least one feasible solution. A) True B) False The point (0,0) is always part of the feasible region. A) True B) False The optimal solution for a linear programming problem occurs when the objective function intersects with at least one of the...
Below given is the linear programming model at a manufacturing firm which produces and sells for...
Below given is the linear programming model at a manufacturing firm which produces and sells for different bags: small bags, medium bags, standard bags, and deluxe bags. DECISION VARIABLES: xi- Number of bags for group i to produce, i=1(small bag), 2(medium bag), 3(standard bag), 4(deluxe bag). OBJECTIVE FUNCTION: Maximize profit, z = 6.5x1 + 7.5x 2 +10x3 + 9x4 CONSTRAINTS: 0.55x1 + 0.6x 2 + 0.7x3 + x4 ≤ 630 (Cutting and dyeing) 0.425x1 + 0.45x 2 + 0.5x3 +...
A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem....
A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem. Demand in period 1 is 100 units, and in period 2, demand is 150 units. The manager has 125 hours of regular employment available for $10/hour each period. In addition, 50 hours of overtime are available for $15/hour each period. Holding costs are $2 per unit each period. a. How many hours of regular employment should be used in period 1? (Assume demand must...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool. Shipment Costs ($), Supply, and Demand: Destinations Sources 1 2 3 Supply A 6 9 100 130 B 12 3 5 70 C 4 8 11 100 Demand 80 110 60 (4 points) Volume Shipped from Source A __________ (4 points) Volume Shipped from Source B __________ (4 points) Volume Shipped from Source C __________ (3 points) Minimum...
​Formulate the linear programming model for the issue​ algebraically by stating the: 1) Definition of Decision...
​Formulate the linear programming model for the issue​ algebraically by stating the: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. ​​Set up and solve the problem using Excel. Provide your answers and recommendations to the Manager of the company General organization and formatting. 1. Richelieu Specialty Paints Richelieu Specialty Paints is a company run by Amanda Richelieu. She is an artist and earned a BA degree with a major in Art and Design. The company was...
Given the following linear programming model, answer the questions that follow. You are given the result...
Given the following linear programming model, answer the questions that follow. You are given the result of a computer program. The results are Maximize 9 X1 + 12 X2 + 10 X3 Subject to: Machine Constraint:   3 X1 + 4 X2 + 3 X3 < 160 Labor Constraint:        6 X1 + 10 X2 + 4 X3 < 288 Materials Constraint: 2 X1 + 2 X2 + 7 X3 < 200 Product 2 Constraint: X1 < 16 OPTIMAL SOLUTION Objective Function Value...
Given the following linear programming model, answer the questions that follow. You are given the result...
Given the following linear programming model, answer the questions that follow. You are given the result of a computer program. The results are Maximize 9 X1 + 12 X2 + 10 X3 Subject to: Machine Constraint:   3 X1 + 4 X2 + 3 X3 < 160 Labor Constraint:        6 X1 + 10 X2 + 4 X3 < 288 Materials Constraint: 2 X1 + 2 X2 + 7 X3 < 200 Product 2 Constraint: X1 < 16 OPTIMAL SOLUTION Objective Function Value...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT