Homework Help is Here – Start Your Trial Now!
Business
Accounting
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 Plants Macon Tacoma $2.50 San Diego Dallas Denver St. Louis Tampa Baltimore $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 Demand 8,500 14,000 13,500 13,400 18,000 15,000 $2.65 9,000 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. (Assume all production capacity will be used.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Fill in the table below with the number of locks that should be sent from each of the plants to each of the distributors. Number of Units Shipped From/To Macon Louisville Detroit Phoenix Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore

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 Plants Macon Tacoma $2.50 San Diego Dallas Denver St. Louis Tampa Baltimore $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 Demand 8,500 14,000 13,500 13,400 18,000 15,000 $2.65 9,000 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. (Assume all production capacity will be used.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Fill in the table below with the number of locks that should be sent from each of the plants to each of the distributors. Number of Units Shipped From/To Macon Louisville Detroit Phoenix Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
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 Plants Macon Tacoma $2.50 San Diego Dallas Denver St. Louis Tampa Baltimore $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 Demand 8,500 14,000 13,500 13,400 18,000 15,000 $2.65 9,000 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. (Assume all production capacity will be used.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Fill in the table below with the number of locks that should be sent from each of the plants to each of the distributors. Number of Units Shipped From/To Macon Louisville Detroit Phoenix Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore
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 Plants Macon Tacoma $2.50 San Diego Dallas Denver St. Louis Tampa Baltimore $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 Demand 8,500 14,000 13,500 13,400 18,000 15,000 $2.65 9,000 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. (Assume all production capacity will be used.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Fill in the table below with the number of locks that should be sent from each of the plants to each of the distributors. Number of Units Shipped From/To Macon Louisville Detroit Phoenix Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS