Solve it on excel - A ==== *-|14Problem 3.PlantsMaconLouisvilleDetroitPhoenixThe 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,Oand 20,000, respectively. Sentry's locks are sold to retailers through wholesale distributors in sevencities across the United States. The unit cost of shipping from each plant to each distributor issummarized in the following table along with the forecasted demand from each distributor for thecoming year.Demand$2.50Paragraph$2.308.500Tacoma San Diego Dallas Denver$2.75$1.90SI$0.9014,50021$1.500Unit Shipping Cost to Distributor in$1.85$1.60$2.00C$1.251 Normal 1 No Spac... Heading 1 Heading 213,500 12.60035MAGANDANSt. Louis Tampavar der en beteken dat e para a me$1.5018,000C$1.80Create a spreadsheet model for this problem and solve it.b. What is the optimal solution?$1.90$2.25Styles15,000Baltimore$1.85$2.00$2.659,000Sentry wants to determine the least expensive way of manufacturing and shipping locks from itsplants to the distributors. Because the total demand from distributors exceeds the total productioncapacity for all the plants, Sentry realizes it will not be able to satisfy all the demand for its productbut wants to make sure each distributor will have the opportunity to fill at least 80% of the ordersreceived.GSCA3808

Introduction:- Excel is sheet which is made up of column and rows.

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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Selection allows us to create more robust programs. O True O False
You have five medicine jars. With the exception of tainted tablets kept in a single container(weight 9gms), each pill weighs 10 gms. How could you identify which jar had the tainted pills with just one measurement, given a scale? (computer science puzzle)
How do I minimize this DFA?
(b) Reorder the following efficiencies from poor to best. 4n 4n! n4 4,000 4n log(4n)
Alert: Don't submit AI generated answer. Alert: Don't submit hand written solution strictly.
Solve C using nonlinear equations in MATLAB
Show and use the scipy.stats.binom function to answer the following. Round your answers to 2 decimal places. This code should be shown in Python for the following problems. A fair coins is flipped 5 times. What is the probability of getting 2 tails? A fair die is thrown 4 times. What is the probability of getting 2 threes?
Give an example of hard real-time problem. What makes it real-time, what hard? (Short answer is ok)
-Give 100 dollars commission to a random employee
Can someone make a code that minimizes 4 different functions with equations, maximizes 4 different functions with 10 types of constraints with equations? Can it be in matlab or python please? I need to adapt it to my code please? and plot 3D pareto front
Please label each part!!
Perform and solve using matlab software. Write the complete syntax or command.