Reference no: EM131134166
"Transco" is a small company that produces a single product in two plants and serves customers in five different regions. The company has been using a make-to-order policy of producing the product only in the quantities needed to fill the orders that have come in from the various regions. However, because of the problems caused by the sporadic production schedule, management has decided to smooth out the production rate and ship the product to one or more storage warehouses, which then will use inventory to fill the incoming regional orders.
Management can use three warehouse locations currently under consideration. For each location, there is a fixed monthly cost associated with leasing and operating the warehouse there.
Furthermore, each potential warehouse location has a maximum capacity for monthly shipments restricted primarily by the number of trucking docks at the site. The product costs $400 to produce at plant 1 and $300 to produce at plant
2. The shipping cost from each plant to each potential warehouse location is shown in the first table below. The fixed leasing and operating cost (ifopen), the shipping costs, and the capacity (maximum monthly shipments) of each potential warehouse location are shown in the second table below. The monthly demand in each of the customer regions is expected to be 200, 225, 100, 150, and 175 units, respectively. Management wants to determine how the product should be distributed from the plants to the warehouse(s), then to the customers at a minimum cost.
Shipping Cost (per unit) Capacity
|
|
WH #1
|
WH #2
|
WH #3
|
(units/month)
|
|
Plant1
|
$25
|
$50
|
$75
|
500
|
|
Plant2
|
$50
|
$75
|
$25
|
400
|
Shipping Costs and Capacity of the Plants
Fixed Cost Shipping Cost (per unit) Capacity
|
|
(per month)
|
Region1
|
Region2
|
Region3
|
Region4
|
Region5
|
(units/mo.)
|
|
WH#1
|
$50,000
|
$30
|
$70
|
$75
|
$55
|
$40
|
700
|
|
WH#2
|
$30,000
|
$55
|
$30
|
$45
|
$45
|
$70
|
500
|
|
WH#3
|
$70,000
|
$70
|
$30
|
$50
|
$60
|
$55
|
1000
|
Fixed Cost, Shipping Costs, and Capacity of the Warehouses
Phase One:
1. Analyze the provided information in the above case and use your own words to provide a summary of the case including any assumption or observations you might have.
2. Based on your understanding of the Transportation Model, Formulate this case as a spreadsheet model and solve it using SOLVER module on Excel. Comment on the obtained results using your own words.
Phase Two:
1. Conduct a complete what-if (sensitivity) analysis on the above case. You are expected to apply all the techniques to be learnt in chapter 5 in this section.
2. Provide a summary of your findings along with your supported recommendations to the decision makers of Transco.
|
Calculate for a basis of 1 m3 of gas fed to the condenser
: Suppose the volumetric flow rate of the gas leaving the condenser is 20.0m3/h Calculate the rate (kg/h) at which acetone is vaporized in the solvent recovery unit.
|
|
Specify the key characteristics of social law
: Compare and contrast the major characteristics of Social Law with 1 other family of law of your choosing.- specify the key characteristics of Social Law
|
|
The reduction of the fixed cost of an alternative
: In breakeven analysis, the reduction of the fixed cost of an alternative, while leaving all other costs of alternatives the same. Which of the following is generally not a reason businesses focus on short-term cost reduction instead of long-term cost..
|
|
Were you surprised to read about the african lions
: Were you surprised to read about the "African Lions"; Algeria, Botswana, Egypt, Libya, Mauritius, Morocco, South Africa, and Tunisia? What surprised you most?
|
|
Formulate this case as a spreadsheet model and solve it
: Based on your understanding of the Transportation Model, Formulate this case as a spreadsheet model and solve it using SOLVER module on Excel. Comment on the obtained results using your own words
|
|
Unethical to help a friend revise a report
: 1. If your boss writes in a flowery, formal tone and relies on outdated expressions, should you follow that style also? 2. Is it unethical to help a friend revise a report when you know that the friend will be turning that report in for a grade?
|
|
What percentage of the dissolved salt crystallizes
: If a saturated solution of NaHCO3 at 60°C is cooled and comes to equilibrium at 30°C, what percentage of the dissolved salt crystallizes?
|
|
Types of business entities and their defining characteristic
: For this case study craft a professional email, appropriate in format, tone and content, to send to your clients Fred and Sally, with your preliminary thoughts on the issues within. Your email should illustrate the issues and relevant law, apply t..
|
|
What is the likely impact of the affordable care act
: What is the likely impact of the Affordable Care Act (ACA) on healthcare access, cost, and quality? Political issues What are the key differences in how political leaders are viewing the ACA?
|