PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.
PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
100%
PLEASE SHOW HOW TO DO THIS WITH EXCEL.
Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.
![Plant
Denver
Jacksonville
Warehouse
Davenport
Cincinnati
Demand (number
of bracelets)
Shipping Costs ($ per bracelet)
Warehouse
Davenport
$2.00
$3.00
Chicago
$3.00
$5.00
Shipping Costs ($ per bracelet)
Retail Outlet
200
Orlando
$7.00
$5.00
Cincinnati
150
$3.00
$1.00
Houston
$4.00
$7.00
350
Supply (number of
bracelets)
700
400
Little Rock
$7.00
$6.00
300](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F78a4b551-5048-4c5d-9abd-e95b71e4d3a2%2F528ae562-3875-4e18-8b10-4af4571bb35f%2Fzfc6eai_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Plant
Denver
Jacksonville
Warehouse
Davenport
Cincinnati
Demand (number
of bracelets)
Shipping Costs ($ per bracelet)
Warehouse
Davenport
$2.00
$3.00
Chicago
$3.00
$5.00
Shipping Costs ($ per bracelet)
Retail Outlet
200
Orlando
$7.00
$5.00
Cincinnati
150
$3.00
$1.00
Houston
$4.00
$7.00
350
Supply (number of
bracelets)
700
400
Little Rock
$7.00
$6.00
300
![Fitness Bracelet Distribution. Orion Fitness produces bracelets with an embedded chip that
tracks its wearer's activities. Orion has plants in Denver and Jacksonville. Bracelets produced a
either plant may be shipped to either of the firm's two regional warehouses, which are located
Davenport and Cincinnati. These regional warehouses subsequently supply retail outlets in
Chicago, Orlando, Houston, and Little Rock. The file Orion contains data on each plant's supply
(number of bracelets), each retail outlet's demand (number of bracelets), and the shipping costs
per bracelet) for the shipping channels.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F78a4b551-5048-4c5d-9abd-e95b71e4d3a2%2F528ae562-3875-4e18-8b10-4af4571bb35f%2Fk49gkgm_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Fitness Bracelet Distribution. Orion Fitness produces bracelets with an embedded chip that
tracks its wearer's activities. Orion has plants in Denver and Jacksonville. Bracelets produced a
either plant may be shipped to either of the firm's two regional warehouses, which are located
Davenport and Cincinnati. These regional warehouses subsequently supply retail outlets in
Chicago, Orlando, Houston, and Little Rock. The file Orion contains data on each plant's supply
(number of bracelets), each retail outlet's demand (number of bracelets), and the shipping costs
per bracelet) for the shipping channels.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning