Question

In: Operations Management

The demand for a perishable item over the next four months is 400, 300, 420, and...

The demand for a perishable item over the next four months is 400, 300, 420, and 380 tons, respectively. The supply capacities for the same months are 500,600, 200, and 300 tons The purchase price per ton varies from month to month and is estimated at $100, $140, $120, and $150, respectively. Because the item is perishable, a current month's supply must be consumed within 3 months (starting with current month). The storage cost per ton per month is $3. The nature of the item does not allow back-ordering. Solve the problem as a transportation model, and determine the optimum delivery schedule for the item over the next 4 months.

A) Formulate the problem as a transportation problem by hand

B) Using the initial solution with the lowest cost use the method of multiplier to fond the optimal solution

Solutions

Expert Solution

(a)

The transportation table is as follows:

TOTAL number of supply constraints : 4
TOTAL number of demand constraints : 4
Problem Table is

Month1 Month2 Month3 Month4 Supply
S1 150 120 140 100 500
S2 150 120 140 100 600
S3 150 120 140 100 200
S4 150 120 140 100 300
Demand 380 420 300 400

(b)

Solution with the lowest cost method is as follows:

Here Total Demand = 1500 is less than Total Supply = 1600. So We add a dummy demand constraint with 0 unit cost and with allocation 100.
Now, The modified table is

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100 0 500
S2 150 120 140 100 0 600
S3 150 120 140 100 0 200
S4 150 120 140 100 0 300
Demand 380 420 300 400 100



The smallest transportation cost is 0 in cell S1Ddummy

The allocation to this cell is min(500,100) = 100.
This satisfies the entire demand of Ddummy and leaves 500 - 100 = 400 units with S1

Table-1

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100 0(100) 400
S2 150 120 140 100 0 600
S3 150 120 140 100 0 200
S4 150 120 140 100 0 300
Demand 380 420 300 400 0



The smallest transportation cost is 100 in cell S1Month4

The allocation to this cell is min(400,400) = 400.
Table-2

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120 140 100 0 600
S3 150 120 140 100 0 200
S4 150 120 140 100 0 300
Demand 380 420 300 0 0



The smallest transportation cost is 100 in cell S4Month4

The allocation to this cell is min(300,0) = 0.
This satisfies the entire demand of Month4 and leaves 300 - 0 = 300 units with S4

Table-3

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120 140 100 0 600
S3 150 120 140 100 0 200
S4 150 120 140 100 0 300
Demand 380 420 300 0 0



The smallest transportation cost is 120 in cell S2Month2

The allocation to this cell is min(600,420) = 420.
This satisfies the entire demand of Month2 and leaves 600 - 420 = 180 units with S2

Table-4

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120(420) 140 100 0 180
S3 150 120 140 100 0 200
S4 150 120 140 100 0 300
Demand 380 0 300 0 0



The smallest transportation cost is 140 in cell S4Month3

The allocation to this cell is min(300,300) = 300.
Table-5

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120(420) 140 100 0 180
S3 150 120 140 100 0 200
S4 150 120 140(300) 100 0 0
Demand 380 0 0 0 0



The smallest transportation cost is 140 in cell S3Month3

The allocation to this cell is min(200,0) = 0.
This satisfies the entire demand of Month3 and leaves 200 - 0 = 200 units with S3

Table-6

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120(420) 140 100 0 180
S3 150 120 140 100 0 200
S4 150 120 140(300) 100 0 0
Demand 380 0 0 0 0



The smallest transportation cost is 150 in cell S3Month1

The allocation to this cell is min(200,380) = 200.
This exhausts the capacity of S3 and leaves 380 - 200 = 180 units with Month1

Table-7

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150 120(420) 140 100 0 180
S3 150(200) 120 140 100 0 0
S4 150 120 140(300) 100 0 0
Demand 180 0 0 0 0



The smallest transportation cost is 150 in cell S2Month1

The allocation to this cell is min(180,180) = 180.
Table-8

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100(400) 0(100) 0
S2 150(180) 120(420) 140 100 0 0
S3 150(200) 120 140 100 0 0
S4 150 120 140(300) 100 0 0
Demand 0 0 0 0 0



Initial feasible solution is

Month1 Month2 Month3 Month4 Ddummy Supply
S1 150 120 140 100 (400) 0 (100) 500
S2 150 (180) 120 (420) 140 100 0 600
S3 150 (200) 120 140 100 0 200
S4 150 120 140 (300) 100 0 300
Demand 380 420 300 400 100



The minimum total transportation cost =100×400+0×100+150×180+120×420+150×200+140×300=189400

Here, the number of allocated cells = 6, which is two less than to m + n - 1 = 4 + 5 - 1 = 8
This solution is degenerate

PLEASE LIKE THIS ANSWER, IT HELPS ME A LOT. THANK YOU!!!


Related Solutions

A local firm manufactures children's toys. The project demand over the next four months for one...
A local firm manufactures children's toys. The project demand over the next four months for one particular model of toy robot is Month Workdays Forecasted Demand July 23 3825 August 16 7245 September 20 2770 October 22 4440 Assume that a normal workday is 8 hours. Hiring cost are $350 per worker and firing cost (including severance) are 850 per worker. Holding cost are $4 per aggergate unit held per month. Assume that it requires an average of 1 hour...
A company currently has 100 items in inventory. The demand for the next four months is...
A company currently has 100 items in inventory. The demand for the next four months is 500, 800, 900, and 300 units. Determine the monthly production rate if a level strategy is selected with the goal of ending the fourth month with 400 units in inventory. a. 500 units/month b. 700 units/month c. 900 units/month d. 1100 units/month
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table. Circuit September October November December IC341 650 875 790 1100 IC256 900 350 1200 1300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 integrated circuits to be stored. Holding costs for both types is $0.05 per unit per month. Because workers are...
During the next four months Capps Shoes Company must meet the following demand for pair of...
During the next four months Capps Shoes Company must meet the following demand for pair of shoes: 2000 shoes in month 1, 3000 shoes in month 2, 4000 shoes in month 3, and 5000 shoes in month 4. At the beginning of month 1, 500 shoes are on hand. This company has 100 workers. A worker is paid $11.5 per hour in month 1, $11 per hour in month 2, $10.5 per hour in month 3, and $10 per hour...
Budgeted sales in Acer Corporation over the next four months are given below: September October November...
Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted Sales $140,000 $150,000 $170,000 $130,000 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder...
1. Budgeted sales at O’Brien Vineyards over the next four months are given below: July August...
1. Budgeted sales at O’Brien Vineyards over the next four months are given below: July August September October Budgeted sales $100,000 $160,000 $180,000 $120,000 All of the company's sales are on account. Collections for sales on account follow a pattern as follows: 70% of a month's credit sales are collected in the month of sale, 25% are collected in the month following sale, and the remainder is uncollectible. There is a $20,000 accounts receivable balance that will be collected in...
Please keep each answer to 400 words or fewer. Aim to be over 300 for each....
Please keep each answer to 400 words or fewer. Aim to be over 300 for each. Footnote as necessary, I will grade primarily on relative mastery of the material and on critical thinking and analysis, but yes, quality of writing and grammar matter. Make sure to think! The obvious is easy enough given that this is a take-home, so fire some brain neurons, please. QUESTION: What would MacKay or Keynes — pick only one, please — argue about the recent...
The PROCOM Corporation is planning its financing for the next six months. PROCOM makes one item,...
The PROCOM Corporation is planning its financing for the next six months. PROCOM makes one item, which it sells through the retail shop in the front of the factory. The planning process was started with profit-and loss computations. Profit is revenue less expenses and revenue is quantity times the unit price. Expenses are made up fixed costs and variable costs. Fixed costs include: rent, salaries, and utilities. Variable costs depend directly on the quantity. These costs are materials and labor....
An investor is very confident that a stock will change significantly over the next few months;...
An investor is very confident that a stock will change significantly over the next few months; however, the direction of the price changes is unknown. Which pair of strategies is most likely to produce a profit if the stock price moves as expected? I. Short butterfly spread 2. Bearish calendar spread 3. Long at-the-money straddle 4. Short strangle A. 2 and 3 b. 2 and 4 C. 1 and 4 D. 1 and 3
A company is planning its production schedule over the next six months (it is currently the...
A company is planning its production schedule over the next six months (it is currently the end of month 2). The demand (in units) for its product over that timescale is as shown below: Month 3 4 5 6 7 8 Demand 5000 6000 6500 7000 8000 9500 The company currently has in stock: 1000 units which were produced in month 2; 2000 units which were produced in month 1; 500 units which were produced in month 0. The company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT