The Allied Company has factories with production capacities as follows:
Factory #1 23
Factory #2 20
Factory #3 15
The forecast demand for the four regional warehouses ar as follows:
Region# 1 14
Region# 2 12
Region# 3 10
Region# 4 18
The shipping cost (per unit) from each of the factories to each of the
regional warehouses is as follows:
REGIONAL WAREHOUSES
#1 #2 #3
#4
FACTORY
#1 $18 $21 $6
$20
#2 $10 $30 $26
$8
#3 $16 $19 $14 $17
Goal is determine the “least cost allocation” that satisfies the
regional demands and does not exceed the available factory capacities.
Formulate the cost and shipping schedule matrices that needed to solve
this transportation problem. Indicate your decision variables ,
constraints and ohjective cell. Find the least cost?
At would you change if the unit costs were unit profits and you wanted
to make the most profit you could? What is the greatest profit?
Is the problem balanced or unbalanced
What if the demand for Region 2 incresed by 10 ( to 22 units) what would
you need to do to solve this problem ? what is the least shipping cost
/solution with this change
Four subcontractors have submitted bids for three projects. Each
contractor can only be awarded at most one project- and each project of
course can only be done once. The table below gives the amounts fo the
bids in $10,000’s.
CONTRACTOR
1 2
3 4
Project
1 $14 $11 $ 13
$12
2 $18 no bid
$14 $22
3 $6 $8
$11 $7
Assign each project to only one contractor so the that the total cost of
doing all three projects is a s little as possible. Formulate the cost
and project assignment matrices that are needed to solve this. Indicate
your decision variables, constraints and objective cell .
Using What’s Best! What is the least cost”
Is this a balanced or unbalanced problem?
If you the contractors could work on no more than 2 projects what would
you do to solve? What is the least expensive way of assigning the
project?
Why does quantitative analyst have a difficult time in leading and
motivating an organization towards its goals? Where does he/she lie
on the management grid? Where should he/she be?
Business Homework Solutions
#108616
Variables/Constraints
The Allied Company has factories with production capacities as follows:
Factory #1 23
Factory #2 20
Factory #3 15
The forecast demand for the four regional warehouses ar as follows:
Region# 1 14
Region# 2 12
Region# 3 10
Region# 4 18
The shipping cost (per unit) from each of the factories to each of the regional warehouses is as follows:
REGIONAL WAREHOUSES
#1 #2 #3 #4
FACTORY
#1 $18 $21 $6 $20
#2 $10 $30 $26 $8
#3 $16 $19 $14 $17
Goal is determine the “least cost allocation” that satisfies the regional demands and does not exceed the available factory capacities. Formulate the cost and shipping schedule matrices that needed to solve this transportation problem. Indicate your decision variables , constraints and ohjective cell. Find the least cost?
At would you change if the unit costs were unit profits and you wanted to make the most profit you could? What is the greatest profit?
Is the problem balanced or unbalanced
What if the demand for Region 2 incresed by 10 ( to 22 units) what would you need to do to solve this problem ? what is the least shipping cost /solution with this change
Four subcontractors have submitted bids for three projects. Each contractor can only be awarded at most one project- and each project of course can only be done once. The table below gives the amounts fo the bids in $10,000’s.
CONTRACTOR
1 2 3 4
Project
1 $14 $11 $ 13 $12
2 $18 no bid $14 $22
3 $6 $8 $11 $7
Assign each project to only one contractor so the that the total cost of doing all three projects is a s little as possible. Formulate the cost and project assignment matrices that are needed to solve this. Indicate your decision variables, constraints and objective cell .
Using What’s Best! What is the least cost”
Is this a balanced or unbalanced problem?
If you the contractors could work on no more than 2 projects what would you do to solve? What is the least expensive way of assigning the project?
Why does quantitative analyst have a difficult time in leading and motivating an organization towards its goals? Where does he/she lie on the management grid? Where should he/she be?
Unbalanced Assignment problem with MS Excel solver
What is this?
By OTA - Overall OTA Rating
Jai Advani, PhD - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$59.85)
Included in Download
- Plain text response
- Attached file(s):
- 108616_Solution_Prob2.xls
- 108616_Solution_Prob 1.xls
- 108616_Answer.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Quantitative Methods - fill in the blank: 1. In an unbalanced transportation model, supply does not equal demand and supply constraints have _____________ signs. 2. The ______________is the marginal economic value of ...
- What is a balanced transportation problem? Describe the approach you would use to solve an unbalanced problem. - What is a balanced transportation problem? Describe the approach you would use to solve an unbalanced problem.
- Question 1-1 - Find the value of Y in the optimal solution to this linear programming problem. Max 2X + 3Y s.t. 4X + 9Y < 72 10X + 1 ...
- Quantitative Methods - True and false 1. In a media selection problem, maximization of audience exposure may not result in maximization of total profit. 2. In an unbalanced transportation model, supply does not equa ...
- Using Solver Function in Excel - I dont know how to set the constraints and solve the problem using Excel Solver. (See attached file for full problem description) --- Better Fitness Inc. Case ---
