Question

Please help me to solve this problem. It is Decision Modeling subject. I will give you thumbs up if you can help me. I really need the answer. Please answer all questions given. Thank you very much.SOOP3023 Decision Modeling Marrie No S0OP3023 Decision Modeling Matric No QUESTION 7 (16 MARKS) b) Using the stepping stone solution method, find the optimal solution. Prove that multiple Tin is mined and processed at four mines, namely Cheras, Chemor, Serdang, and Tronoh These mines supply tin to plants in three cities; Klang, Taiping, and Butterworth. The supply capacity and demand from the plants are shown in TABLE 7.1 and TABLE 72 optimal solutions exist. State one of the other optimal solutions. (12 marks) TABLE 7.1 TABLE 7.2 Mine Distributor Capacity (tons) 90 50 80 60 Demand (tons 120 100 10 A. B. T 2. Chemor 4. Tronoh The railroad shipping costs per ton (in RM1000s) of tin are shown in TABLE 7.3. Due to a railroad construction, shipments are now prohibited from Cheras to Klang. TABLE 7.3 From 10 a) Set up the initial tableau for this problem and obtain the initial solution using Minimum Cell Cost Method by completing the cells in TABLE 7.4. Compute the total cost of this 4 marks) TABLE 7

0 0
Add a comment Improve this question Transcribed image text
Answer #1

In given problem the cost of 1A cell is missing. So, I have considered it as 0.Please , check that.

For solving this I have considered supply as s1 , s2 ,s3 and s4 where as demand as D1 ,D2 ,D3.Solution is given as follows-

TOTAL number of supply constraints :4 TOTAL number of demand constraints :3 Problem Table is D1 D2 D3 Supply 0 10 590 12 9 4 50 7 3 11 80 9 5 760 Demand 120 100 110 Here Total Demand 330 is greater than Total Supply 280. So We add a dummy supply constraint with 0 unit cost and with allocation 50 Now, The modified table is D1 D2 Supply 0 10 590 12 9 450 7 3 1180 9 5 760 dummy 0 0 50 Demand 120 100 110 The smallest transportation cost is 0 in cell s,D The allocation to this cell is min(90,120) 90 This exhausts the capacity of s, and leaves 120- 90 30 units with D Table-1 D2 D3 Supply 12 80 dummy0 Demand 30 100 110 The smallest transportation cost is 0 in cell sdummwD2The allocation to this cell is min(50,100) 50 This exhausts the capacity of sdummy and leaves 100 - 50 50 units with Table-2 D Supply 12 80 60 Sdummy Demand 30 50 110 The smallest transportation cost is 3 in cell s,D,2 The allocation to this cell is min(80,50) 50 This satisfies the entire demand of D, and leaves 80 50 30 units with Table-3 D Supply 50 30 60 12 3(50) Sdummy 0(50)e 30 110 Demand The smallest transportation cost is 4 in cell s2D3 The allocation to this cell is min(50,110) 50 This exhausts the capacity of s2 and leaves 110 50 60 units with D3Initial feasible solution is Supply 0 (90) 10 5 90 12 94(50) 50 7 (30) 3 (50) 11 80 5 7 (60) 60 50 Sdummy 0 (50) o Demand 120 100 110 The minimum total transportation cost - 0 x 90+4 x 50 7 x 30 3 x 50 7x60 0x 50 980 Here, the number of allocated cells 6, which is one less than to m 1 5 3-17 . This solution is degenerate n - To resolve degeneracy, we make use of an artifical quantity(d) The quantity d is assigned to that unoccupied cell, which has the minimum transportation cost The quantity d is assigned to s,D3, which has the minimum transportation cost-5 Supply 5 (d) 90 4 (50) 50 7 (30) 3 (50) 11 80 7 (60) 60 50 0 (90) 10 12 dummy 0 (50) 0 Demand 120 100 1102. Select the unoccupied cell having the highest negative net cost change i.e. cell sdummyD3 - -9 and draw a closed path from StummyD3. Closed path is StummyD3 Sdummy,D2 -S3D2 S3D SD S,D Closed path and plus/minus allocation for current unoccupied cell dummy3 Supply 0 (90) ()10 14] 5 (d) () 90 12 13 9 (14] 7 (30) 3 (50) + 11 -1] 80 9 [7] 4 (50)50 7 (60) 60 5 17] 0 (50) 0 -9 ) 50 100 4 Summy 0 [-4] Demand 120 110 dummy cell is selected, so stop the procedure for current selected dummy cell

Add a comment
Know the answer?
Add Answer to:
Please help me to solve this problem. It is Decision Modeling subject. I will give you...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • College of Administrative and Financial Sciences Department of Business Administration MGT425 – Spreadsheet Decision Modeling Facility...

    College of Administrative and Financial Sciences Department of Business Administration MGT425 – Spreadsheet Decision Modeling Facility Location Model Supply chain optimization has a big influence in a company’s ability to compete in a global market. In this context, an olive oil producer company intends to analyze its supply chain’s resources efficiency. In a further analysis, the company wants to know the optimal location for its production facility that minimizes the total transportation costs, in order to find possible solutions for...

  • please help me answer these questions, I provided all the information. thank you You are the...

    please help me answer these questions, I provided all the information. thank you You are the financial analyst of the Management and Budgeting Oftice (MBO) for the Procurement Agency of your Municipality The Transport system of your city needs to have an extension/renovation of the existing equipment (eg vehicles, on-board Wi-Fi network, etc.) and infrastructure (e.g. binary for bus, etc). The transport system is totally owned by the municipality, hence it is in charge of investment decision and business activity...

  • I need the answer of Req6, please help me,thank you Problem 12-23 Make or Buy Decision...

    I need the answer of Req6, please help me,thank you Problem 12-23 Make or Buy Decision (LO12-3) Silven Industries, which manufactures and sells a highly successful line of summer lotions and insect repellents, has decided to diversify in order to stabilize sales throughout the year A natural area for the company to consider is the production of winter lotions and creams to prevent dry and chapped skin After considerable research, a winter products line has been developed. However, Silven's president...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT