Question

In: Operations Management

Given the following information set up the problem in a transportation table and solve for the...

Given the following information set up the problem in a transportation table and solve for the minimum-cost plan:

PERIOD
1 2 3
Demand 550 700 750
Capacity
Regular 500 500 440
Overtime 50 50 50
Subcontract 120 120 100
Beginning inventory 100
Costs
Regular time $ 60 per unit
Overtime $ 80 per unit
Subcontract $ 90 per unit
Inventory carrying cost $ 1 per unit per month
Back-order cost $ 3 per unit per month


Suppose that an inventory carrying cost is increased $2 per unit per period. What will the additional cost of the optimal plan be? (Omit the "$" sign in your response.)

Additional cost           $

I've asked this question a couple of times and it has been incorrect. So.. the answer is not 440 haha.. good luck! Thanks for your help!

Solutions

Expert Solution

The transportation model for aggregate plan is as follows:

(the net demand in month 1 = 550 – 100 (inventory) = 450 units

The optimal Solution is as follows:

In month 1,

Regular production = 500 (340 units in month 1 and store 160 units to satisfy month 3 demand)

OT = 50 (30 in month 1 and store 20 units to satisfy month 2 demand)

Subcontract = 90 for month 1

In month 2,

Regular production = 500 (500 units in month 2)

OT = 50 in month 2)

Subcontract = 120 for month 2

In month 3,

Regular production = 440 units in month 3)

OT = 50 in month 3

Subcontract = 100 for month 3

Total optimal cost = $126,650

If the inventory cost is increased by $2 per unit, the optimal solution remain same, but the inventory holding cost will increase.

Additional cost = 160 units x 2 months x ($2 - $1) + 30 units x 1 month x ($2 - $1) = $350

Additional Cost = $350


Related Solutions

Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a transportation table and solve for the minimum-cost plan: PERIOD 1 2 3   Demand    550       700      750         Capacity                 Regular    500       500      440           Overtime    50       50      50           Subcontract    120       120      100         Beginning inventory    100            Costs           Regular time $   60 per unit     Overtime $   80 per unit     Subcontract $   90 per unit       Inventory...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a transportation table and solve for the minimum-cost plan: PERIOD 1 2 3 Demand 550 700 750 Capacity Regular 500 500 440 Overtime 50 50 50 Subcontract 120 120 100 Beginning inventory 100 Costs Regular time $ 60 per unit Overtime $ 80 per unit Subcontract $ 90 per unit Inventory carrying cost $ 1 per unit per month Back-order cost $ 3 per unit per month Suppose that an inventory...
Set up and solve the given BVP heat problem. Suppose there is a rod of length...
Set up and solve the given BVP heat problem. Suppose there is a rod of length L coinciding on the x-axis from 0 ≤ x ≤ L with insulated ends, and with an initial temperature profile of f(x). Solve the Heat Equation
Problem Description: Part I: Solve the transportation problem for the information provided and find the minimum...
Problem Description: Part I: Solve the transportation problem for the information provided and find the minimum cost of transportation. Identify which warehouse has excess capacity or which store has unmet demand.Part II: Include the following additional constraints and the compute the incremental cost of each additional constraint. (a) All the supply from Warehouse A MUST be shipped. (b) At least 10000 units must be shipped from Warehouse B to Store 3. Per unit transportation cost Ware house Store 1 2...
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...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using the excel sleeve, provide the optimal transport cost. Imagine that we have three bakeries and three stores. the three stores require 23 dozen, 17 dozen, and 20 dozen loaves of bread, respectively, while the three bakeries can supply 18 dozen, 15 dozen, and 22 dozen loaves, respectively. The unit transportation costs are provided in the table below: Store 1 Store 2 Store 3 Bakery...
Create a transportation problem Select an initial feasible solution ( any method). Solve the transportation problem...
Create a transportation problem Select an initial feasible solution ( any method). Solve the transportation problem using the method of multipliers.
5.       Solve the following differential equation using the given initial conditions (Use convolution and set up the...
5.       Solve the following differential equation using the given initial conditions (Use convolution and set up the integral but do not integrate.)               y'’ − 2y’ + 2y = 18e−t sin3t;         y(0) = 0, y’(0) = 3
Solve the following transportation problem: A company has refinery plants that produce gasoline with the following...
Solve the following transportation problem: A company has refinery plants that produce gasoline with the following capacities Houston: 27000 gallons per day New Mexico: 35000 gallons per day The company supplies the following states: California: 32000 gallons per day Louisiana: 12000 gallons per day Mississippi: 15000 gallons per day Following are the transportation costs per gallon between each refinery and each customer. Distribution centers Plants California Louisiana Mississippi Houston 0.75 0.40 0.65 New Mexico 0.50 0.70 0.80 Build a transportation...
Solve the following transportation problem: A company has refinery plants that produce gasoline with the following...
Solve the following transportation problem: A company has refinery plants that produce gasoline with the following capacities Houston: 27000 gallons per day New Mexico: 35000 gallons per day The company supplies the following states: California: 32000 gallons per day Louisiana: 12000 gallons per day Mississippi: 15000 gallons per day Following are the transportation costs per gallon between each refinery and each customer. Distribution centers Plants California Louisiana Mississippi Houston 0.75 0.40 0.65 New Mexico 0.50 0.70 0.80 Build a transportation...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT