Reference no: EM132252334
For problems in which you use the online templates, you have 4 options:
Submit the Excel file with your homework.
Attach screenshots of the Excel file to your homework submission.
Type/write the information you input into the blue cells in Excel on your homework file (e.g., weights used, cost functions for plotting lines, etc). This is not to say EVERY piece of information from Excel, just enough so that I can follow your logic.
Do not submit any information regarding the templates used. In this case you run the risk of losing the majority of points for an incorrect problem. If you provide me with at least some information, I can identify where the issue was for partial credit.
A production facility needs to be supplied with two grades of steel (i.e., they have two products they purchase and must have shipped to them). Over the course of a year, the company uses 3,285,000 lbs of Grade 1 steel and 365,000 lbs of Grade 2 steel. Grade 1 steel costs $0.01 per lb and Grade 2 steel costs $10 per lb. NOTE: These are the costs to purchase the steel, NOT transportation cost. Holding costs at the production facility are 25% of the purchase cost per lb (i.e., each grade of steel has its own holding cost). As per their contract with the supplier, the production facility owns the steel in transport and therefore the company assesses these holding costs during transportation as well. Finally, assume that any shipment you receive contains a % of grade 1 and 2 steel that is equal to their respective %s of annual demand. The production facility is reviewing a few options of transport for their steel: Option 1: Ship by rail with carrier 1 In this option, one train consists of a minimum of 30 cars up to a maximum of 90 cars. Each car has a capacity of 10,000 lbs. Given the distance from the production facility to the supplier, to ship steel, it will cost $15,000 as a fixed fee for each train plus $400 per car that is on the train. This method results in a 15 day lead time. Option 2: Ship by truck with carrier 2 With this carrier, you have 2 choices and both result in a 5 day lead time: - Use their fleet of small trucks and ship 10,000-40,000 lbs at a time for $0.09 per lb. In addition, you will be assessed a cost of $600 per truck used. - Use their fleet of large trucks and ship 40,000 to 60,000 lbs at a time for $0.06 per lb. In addition, you will be assessed a cost of $900 per truck used.
A new production facility is being built. This facility will use water in very large quantities as it is a necessary raw material for their ultimate product. Discuss one disadvantage and one advantage of using EACH OF THE 5 modes of transportation to transport water to this facility. Make a recommendation and justify this recommendation for mode of transporation.