Question
In: Operations Management
Consider a transportation problem, shipping a product from two sources to two customers. The following table...
Consider a transportation problem, shipping a product from two sources to two customers. The following table shows the data. What is the objective function value, which is the minimum shipping cost (unit in $), while satisfying the demand for each customer and supply for each source? Be careful with data inputs as you run the software program.
|
Customer 1 |
Customer 2 |
Supply |
|
|
Source 1 |
$21/unit |
35 |
17 |
|
Source 2 |
22 |
17 |
33 |
|
Demand |
20 |
30 |
Solutions
Expert Solution
The Initial Cost and Volume Matrix is:
Solver Parameters:
Constraints are no source can supply more than capacity and each customer should receive a minimum of the demand
Optimal Solution:
Minimum Cost is: $933
Source 1 to Customer 1 = 17 and Customer 2 = 0
Source 2 to customer 1 = 3 and customer 2 = 30
********
IF YOU HAVE ANY DOUBT, KINDLY COMMENT. I WOULD LOVE TO HELP YOU!!!
IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!
keosha answered 1 year agoRelated Solutions
Consider a transportation problem, shipping a product from two sources to two customers. The following table...
Consider a transportation problem, shipping a product from two
sources to two customers. The following table shows the data.
Write a LP model for this problem to minimize the shipping cost
(unit in $) while satisfying the demand for each customer and
supply for each source. You don’t need to solve your LP model. I
just need a LP model only.
Customer1
Customer2
Supply
Source 1
$8/unit
15
15
Source 2
11
7
20
Demand
12
23
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a
transportation table and solve for the minimum-cost plan:
PERIOD
1
2
3
Demand
550
700
750
Capacity
Regular
500
500
440
Overtime
50
50
50
Subcontract
120
120
100
Beginning
inventory
100
Costs
Regular
time
$
60 per unit
Overtime
$
80 per unit
Subcontract
$
90 per
unit
Inventory...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a
transportation table and solve for the minimum-cost plan:
PERIOD
1
2
3
Demand
550
700
750
Capacity
Regular
500
500
440
Overtime
50
50
50
Subcontract
120
120
100
Beginning inventory
100
Costs
Regular time
$
60 per unit
Overtime
$
80 per unit
Subcontract
$
90 per unit
Inventory carrying cost
$
1 per unit per
month
Back-order cost
$
3 per unit per
month
Suppose that an inventory...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a
transportation table and solve for the minimum-cost plan:
PERIOD
1
2
3
Demand
550
700
750
Capacity
Regular
500
500
440
Overtime
50
50
50
Subcontract
120
120
100
Beginning inventory
100
Costs
Regular time
$
60 per unit
Overtime
$
80 per unit
Subcontract
$
90 per unit
Inventory carrying cost
$
1 per unit per
month
Back-order cost
$
3 per unit per
month
Suppose that an inventory...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...
Consider the following transportation problem. Formulate this
problem as a linear programming model and solve it using the MS
Excel Solver tool.
Shipment Costs ($), Supply, and
Demand:
Destinations
Sources
1
2
3
Supply
A
6
9
100
130
B
12
3
5
70
C
4
8
11
100
Demand
80
110
60
(4 points) Volume Shipped from Source A __________
(4 points) Volume Shipped from Source B __________
(4 points) Volume Shipped from Source C __________
(3 points) Minimum...
1. Consider the problem of two polluting sources in the region, each of which generated 10...
1. Consider the problem of two polluting sources in the region,
each of which generated 10 units of pollution for a total of 20
units released into the environment. The government determined that
emissions must be reduced by 12 units across the region to achieve
the ”socially desirable level of pollution”. Each firm faces
different abatement cost conditions modelled as follows: for
Polluter 1, marginal abatement cost is MAC1 =
2.6Q1, while the total abatement cost is TAC1 =
1.3(Q1)2....
Problem 1. Consider the following table, which gives a security analysts expected return on two stocks...
Problem 1. Consider the following table, which
gives a security analysts expected return on two stocks for two
particular market returns:
States
Market Return
Aggressive Stock
Defensive Stock
Bad
Good
5%
25%
-2%
38%
6%
12%
a) What are the betas of the two stocks?
b) What is the expected rate of return on each stock if the
market return is equally likely to be 5% or 25%?
c) If the T-bill rate is 6% and the market return is...
Problem IX A,B,C: Consider the following valuations table for five consumers willing to purchase two differently...
Problem IX
A,B,C: Consider the following valuations
table for five consumers willing to purchase two differently
colored T-shirts:
CONSUMER
VALUATION FOR BLUE T-SHIRTS
VALUATION FOR PINK T-SHIRTS
John
50
15
Bob
40
30
Tim
35
35
Jennifer
25
45
Maria
10
50
a) Assuming no production costs, what is the
most profitable way to price these two goods independently? What
are the prices and resulting profit?
b) Assuming no production costs, what is the
most profitable way to price these...
Problem 9-9 Consider the following table, which gives a security analyst’s expected return on two stocks...
Problem 9-9
Consider the following table, which gives a security analyst’s
expected return on two stocks in two particular scenarios for the
rate of return on the market:
Market Return
Aggressive Stock
Defensive Stock
5
%
–3
%
3
%
27
34
11
a. What are the betas of the two stocks?
(Do not round intermediate calculations. Round your answers
to 2 decimal places.)
b. What is the expected rate of return on each
stock if the two scenarios for...
The following table shows the means of transportation to work for the U.S. in 1990 and...
The following table shows the means of transportation to
work for the U.S. in 1990 and 2000. The data values in the
columns of “Percentage in 1990” and “Percentage in 2000” are the
percentages of each travel mode in 1990 and in 2000 respectively
using two independent and random samples. We want to do a
hypothesis test and see whether the travel modes have been
significantly changed from 1990 to 2000.
Table: The means of transportation to work for the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Read at least 2 academically reviewed articles and Write an annotated bibliography paper on Master Budgeting
- Why normalization and referential integrity are important principles when designing relational databases?
- Respond to the following in a minimum of 175 words: Discuss what elements should be present...
- 1) The 3rd bright fringe of a double slit interference pattern is 30.0 cm above the...
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
- You measure the following quantities as A = 1.0 m ± 0.2 m, B = 2.0...
ADVERTISEMENT