ArBizls Auto has two plants, two warehouses, and three customers. The plants are in Tekirdağ and Adana, the warehouses are in Ankara and Bursa, and the customers are in Ağrı, İzmit, and Eskişehir. Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Tekirdağ can produce 150 cars per week, and Adana can produce 100 cars per week. Ağrı requires 80 cars per week, İzmit requires 70, and Eskişehir requires 60. It costs $10,000 to produce a car at each plant. The costs of shipping a car between various cities are listed in the table below. Assume that during a week, at most 50 cars can be shipped from a warehouse to any city. Answer to the following questions to determine how to meet ArBizls's weekly demands at minimum cost. ww w m Ankara Bursa Ağrı İzmit Eskişehir ww.w Tekirdağ $1.253 $637 Adana $1.398 $841 Ankara $1.059 $996 $1.691 Bursa $2.786 $802 $250 a) Build an appropriate LP model to find a shipment plan that minimizes total cost. Do not forget to write the necessary definitions (i.e. variables) related to your model. b) Prepare a spreadsheet for your model. Solve the model in excel using Solver, and then generate answer and sensitivity reports. c) Interpret the findings in these reports (explain the optimum solution, binding/non-binding constraints, reduced costs, and shadow prices along with the related allowable increase and decrease ranges)
ArBizls Auto has two plants, two warehouses, and three customers. The plants are in Tekirdağ and Adana, the warehouses are in Ankara and Bursa, and the customers are in Ağrı, İzmit, and Eskişehir. Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Tekirdağ can produce 150 cars per week, and Adana can produce 100 cars per week. Ağrı requires 80 cars per week, İzmit requires 70, and Eskişehir requires 60. It costs $10,000 to produce a car at each plant. The costs of shipping a car between various cities are listed in the table below. Assume that during a week, at most 50 cars can be shipped from a warehouse to any city. Answer to the following questions to determine how to meet ArBizls's weekly demands at minimum cost. ww w m Ankara Bursa Ağrı İzmit Eskişehir ww.w Tekirdağ $1.253 $637 Adana $1.398 $841 Ankara $1.059 $996 $1.691 Bursa $2.786 $802 $250 a) Build an appropriate LP model to find a shipment plan that minimizes total cost. Do not forget to write the necessary definitions (i.e. variables) related to your model. b) Prepare a spreadsheet for your model. Solve the model in excel using Solver, and then generate answer and sensitivity reports. c) Interpret the findings in these reports (explain the optimum solution, binding/non-binding constraints, reduced costs, and shadow prices along with the related allowable increase and decrease ranges)
Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
Related questions
Topic Video
Question
Transcribed Image Text:ArBizls Auto has two plants, two warehouses, and three customers. The plants are in Tekirdağ and
Adana, the warehouses are in Ankara and Bursa, and the customers are in Ağrı, İzmit, and Eskişehir.
Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Tekirdağ
can produce 150 cars per week, and Adana can produce 100 cars per week. Ağrı requires 80 cars per
week, İzmit requires 70, and Eskişehir requires 60. It costs $10,000 to produce a car at each plant. The
costs of shipping a car between various cities are listed in the table below. Assume that during a week,
at most 50 cars can be shipped from a warehouse to any city. Answer to the following questions to
determine how to meet ArBizls's weekly demands at minimum cost.
ww w m
Ankara
Bursa
Ağrı
İzmit Eskişehir
ww.w
Tekirdağ
$1.253
$637
Adana
$1.398
$841
Ankara
$1.059
$996
$1.691
Bursa
$2.786
$802
$250
a) Build an appropriate LP model to find a shipment plan that minimizes total cost. Do not forget
to write the necessary definitions (i.e. variables) related to your model.
b) Prepare a spreadsheet for your model. Solve the model in excel using Solver, and then
generate answer and sensitivity reports.
c) Interpret the findings in these reports (explain the optimum solution, binding/non-binding
constraints, reduced costs, and shadow prices along with the related allowable increase and
decrease ranges)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, calculus and related others by exploring similar questions and additional content below.Recommended textbooks for you
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning