Transportation Costs between production and warehouse facilities
Not what you're looking for?
Please use Microsoft Excel Solver tool
There are production facilities in Battle Creek, Cherry Creek, and Dee Creek with annual capacities of 500 units, 400 units, and 600 units, respectively. The annual demands at warehouses in Worchester, Dorchester, and Rochester are 300 units, 700 units, and 400 units, respectively. The table below gives the unit transportation costs between the production facilities and the warehouses.
Worchester Dorchester Rochester
Battle Creek $20/unit $30/unit $13/unit
Cherry Creek $10/unit $5/unit $17/unit
Dee Creek $15/unit $12/unit $45/unit
How much of the demand at each of the warehouses must be met by each of the production facilities?
Decision Variables
Xbw = # of units to be transported from Battle Creek to Worchester
Xcw = # of units to be transported from Cherry Creek to Worchester
Xdw = # of units to be transported from Dee Creek to Worchester
Xbd = # of units to be transported from Battle Creek to Dorchester
Xcd = # of units to be transported from Cherry Creek to Dorchester
Xdd = # of units to be transported from Dee Creek to Dorchester
Xbr = # of units to be transported from Battle Creek to Rochester
Xcr = # of units to be transported from Cherry Creek to Rochester
Xdr = # of units to be transported from Dee Creek to Rochester
Objective Function
Minimize total annual transportation cost ($):
= 20*Xbw + 10*Xcw + 15*Xdw + 30*Xbd + 5*Xcd + 12*Xdd + 13*Xbr + 17*Xcr + 45*Xdr
Constraints
Demand Constraints
Xbw + Xcw + Xdw ≥ 300 (demand at Worchester)
Xbd + Xcd + Xdd ≥ 700 (demand at Dorchester)
Xbr + Xcr + Xdr ≥ 400 (demand at Rochester)
Capacity Constraints
Xbw + Xbd + Xbr ≤ 500 (capacity at Battle Creek)
Xcw + Xcd + Xcr ≤ 400 (capacity at Cherry Creek)
Xdw + Xdd + Xdr ≤ 600 (capacity at Dee Creek)
Non-Negativity Constraints
Xbw, Xcw, Xdw, Xbd, Xcd, Xdd, Xbr, Xcr, and Xdr are ≥ 0
Integer Constraints
Xbw, Xcw, Xdw, Xbd, Xcd, Xdd, Xbr, Xcr, and Xdr are integers
Purchase this Solution
Solution Summary
Transportation costs between production and warehouse facilities are provided.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.