Reference no: EM131463518
Problem :
New Bedford Steel Coking Coal Supply 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.
| Bids Received from Potential Coking Coal Suppliers |
|
Ashley |
Bedford |
Consol |
Dunby |
Earlam |
Florence |
Gaston |
Hopt |
| Capacity (mtons) |
300 |
600 |
510 |
655 |
575 |
680 |
450 |
490 |
| Union/Nonunion |
U |
U |
N |
U |
N |
U |
N |
N |
| Truck/Rail |
R |
T |
R |
T |
T |
T |
R |
R |
| Volatility (%) |
15 |
16 |
18 |
20 |
21 |
22 |
23 |
25 |
| Price (S/ton) |
49.5 |
50 |
61 |
63.5 |
66.5 |
71 |
72.5 |
80 |
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 50% 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 720 mtons per year.
Questions:
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?
Use both MATLAB Optimisation Toolbox and Excel Solver to solve the problem and perform sensitivity analysis.
|
How do e-businesses generate revenue streams
: What factors should be considered when a firm is developing a Web page? What are the four major factors contained in the definition of e-business?
|
|
What is the difference between internal and external forces
: What is the difference between internal and external forces that affect an e-business? How do they change the way an e-business operates?
|
|
What edition of windows will be used for each server
: What edition of Windows will be used for each server (e.g., Standard, Datacenter)? How will the servers be deployed? Manual or automated?
|
|
What type of business model is travelocity using
: One of the original online travel agency sites, Travelocity, has been bookmarked by millions of people seeking low prices on airline tickets, hotel rooms.
|
|
What will be nbss average cost of supply
: How much coal should Coggins contract for from each supplier-What will be NBSs total cost of supply and what will be NBSs average cost of supply?
|
|
What are some of the reasons ebags has grown to successful
: More than 500 luggage stores in the United States closed in the travel slump that began September 11, 2001. eBags, the online luggage and handbag retailer.
|
|
Provide a history of its use as a weapon of mass destruction
: Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dispersed, signs and symptoms of its use.
|
|
What factors contributed to your level of satisfaction
: Today, more and more people use the Internet to purchase products or services. And yet, many people are reluctant to make online purchases because of identity.
|
|
Discussion of dwecks theory of motivation
: How does your particular style reflect your motivation and learning style? Do you agree with dweck or disagree, and why?
|