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 8 months 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 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...
We consider data in the following table, summarizing sales of a product (in thousands). For each...
We consider data in the following table, summarizing sales of a
product (in thousands). For each of the questions, justify your
answer. Year Quarter Sales 2015 1 2 3 4 4.95 4.25 6.15 6.65 2016 1
2 3 4 5.85 5.35 6.95 7.55 2017 1 2 3 4 6.15 5.75 7.65 7.95 (3.1)
Assuming the given time-series shows evidence of seasonality,
Determine the estimate sales values. (5) (3.2) What is the value of
the root mean squared error for the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- in laws and public affairs, what are the implications of delegated legislation in one double spaced...
- Brandtly Industries invests a large sum of money in R&D; as a result, it retains and...
- for input matrix a , write a function to return the element in row 2 column...
- You want to make a one-year investment in a fixed-income security. You have two investment choices:...
- Scrappers Supplies tracks the number of units purchased and sold throughout each accounting period but applies...
- in law and pubic affairs what are the statutory interpretation, write in one double spaced page...
- Assume that you contribute $260 per month to a retirement plan for 20 years. Then you...
ADVERTISEMENT