Homework Help is Here – Start Your Trial Now!
Math
Probability
a. Create a spreadsheet model for this problem and solve it. b. What is the optimal solution?

a. Create a spreadsheet model for this problem and solve it. b. What is the optimal solution?

Algebra for College Students
Algebra for College Students
10th Edition
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Jerome E. Kaufmann, Karen L. Schwitters
Chapter11: Systems Of Equations
Section11.CT: Test
Problem 24CT
See similar textbooks
icon
Related questions
Topic Video
Question
Sentry wants to determine the least expensive way of manufacturing and shipping locks from its plants to the distributors. Because the total demand from distributors exceeds the total production capacity for all the plants, Sentry realizes it will not be able to satisfy all the demand for its product, but wants to make sure each distributor will have the opportunity to fill at least 80% of the orders received. a. Create a spreadsheet model for this problem and solve it. b. What is the optimal solution?
Transcribed Image Text:Sentry wants to determine the least expensive way of manufacturing and shipping locks from its plants to the distributors. Because the total demand from distributors exceeds the total production capacity for all the plants, Sentry realizes it will not be able to satisfy all the demand for its product, but wants to make sure each distributor will have the opportunity to fill at least 80% of the orders received. a. Create a spreadsheet model for this problem and solve it. b. What is the optimal solution?
The Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50, $39.00, and $36.25, respectively, while the annual production capacity at each plant is 18,000, 15,000, 25,000, and 20,000, respectively. Sentry's locks are sold to retailers through wholesale distributors in seven cities across the United States. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year. Unit Shipping Cost to Distributor in St. Louis Plants Tacoma San Diego Dallas Denver Tampa Baltimore Macon $2.50 $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.50 $1.85 $1.90 $2.25 $1.85 $1.90 $1.60 $1.00 $1.85 Detroit $2.30 $2.25 $1.25 $1.50 $2.00 $1.90 8,500 $1.75 12,600 Phoenix $0.90 $2.50 $2.65 $1.60 13,500 $2.00 Demand 14,500 18,000 15,000 9,000
Transcribed Image Text:The Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50, $39.00, and $36.25, respectively, while the annual production capacity at each plant is 18,000, 15,000, 25,000, and 20,000, respectively. Sentry's locks are sold to retailers through wholesale distributors in seven cities across the United States. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year. Unit Shipping Cost to Distributor in St. Louis Plants Tacoma San Diego Dallas Denver Tampa Baltimore Macon $2.50 $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.50 $1.85 $1.90 $2.25 $1.85 $1.90 $1.60 $1.00 $1.85 Detroit $2.30 $2.25 $1.25 $1.50 $2.00 $1.90 8,500 $1.75 12,600 Phoenix $0.90 $2.50 $2.65 $1.60 13,500 $2.00 Demand 14,500 18,000 15,000 9,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS