New Bedford Steel (NBS) is a small steel manufacturing company. Coking coal is a necessary raw...

 

Transcribed Image Text:

New Bedford Steel (NBS) is a small steel manufacturing company. Coking coal is a necessary raw material in the production of steel, and NBS procures 1.0-1.5 million tons of coking coal per year. It is now time to plan for the 1997 production, and Stephen Coggins, coal supply manager for NBS, has solicited and received bids from the following eight suppliers for next year. He has organized the information about the bids in the following table. Capacity (mtons) Union/ Nommion Truck/ Rail Volatility (%) Price (S/ton) Bids Received from Potential Coking Coal Suppliers Ashley Bedford Consol Dunby Earlam Florence Gaston Hopt 300 U R 15 600 U T 16. 510 654 N R 18 U T 20 49.50 50.00 61.00 63.50 575 N I 21 66.30 680 22 71.00 450 N R B 72.50 490 1. How much coal should Coggins contract for from each supplier? 2. What will be NBS's total cost of supply? 3. What will be NBS's average cost of supply? N R 25 80.00 Based on market forecasts and 1996 production characteristics, NBS is planning to accept bids for 1,225 mtons (1,225 million tons) of coking coal. This coal must have an average volatility of at least 19% (volatility is the percent of volatile or burnable matter in the coal). Also, as a hedge against adverse labor relations, NBS has decided to procure at least 60% of its coking coal from union mines (United Mine Workers). Finally, Steve Coggins needs to keep in mind that capacity for bringing in coal by rail is limited to roughly 650 mtons per year, and capacity for bring in coal by truck is limited to 730 mtons per year. Questions: Use both MATLAB Optimisation Toolbox and Excel Solver to solve the problem New Bedford Steel (NBS) is a small steel manufacturing company. Coking coal is a necessary raw material in the production of steel, and NBS procures 1.0-1.5 million tons of coking coal per year. It is now time to plan for the 1997 production, and Stephen Coggins, coal supply manager for NBS, has solicited and received bids from the following eight suppliers for next year. He has organized the information about the bids in the following table. Capacity (mtons) Union/ Nommion Truck/ Rail Volatility (%) Price (S/ton) Bids Received from Potential Coking Coal Suppliers Ashley Bedford Consol Dunby Earlam Florence Gaston Hopt 300 U R 15 600 U T 16. 510 654 N R 18 U T 20 49.50 50.00 61.00 63.50 575 N I 21 66.30 680 22 71.00 450 N R B 72.50 490 1. How much coal should Coggins contract for from each supplier? 2. What will be NBS's total cost of supply? 3. What will be NBS's average cost of supply? N R 25 80.00 Based on market forecasts and 1996 production characteristics, NBS is planning to accept bids for 1,225 mtons (1,225 million tons) of coking coal. This coal must have an average volatility of at least 19% (volatility is the percent of volatile or burnable matter in the coal). Also, as a hedge against adverse labor relations, NBS has decided to procure at least 60% of its coking coal from union mines (United Mine Workers). Finally, Steve Coggins needs to keep in mind that capacity for bringing in coal by rail is limited to roughly 650 mtons per year, and capacity for bring in coal by truck is limited to 730 mtons per year. Questions: Use both MATLAB Optimisation Toolbox and Excel Solver to solve the problem

Answer rating: 100% (QA)

How much coal should Coggins contract for from each supplier Use both M... View the full answer