Sentry wants to determine the least expensive way ofmanufacturing and shipping locks from its plants to thedistributors. Because the total demand from distributorsexceeds the total production capacity for all the plants,Sentry realizes it will not be able to satisfy all the demandfor its product, but wants to make sure each distributor willhave the opportunity to fill at least 80% of the ordersreceived.a. Create a spreadsheet model for this problem andsolve it.b. What is the optimal solution? The Sentry Lock Corporation manufactures a popularcommercial security lock at plants in Macon, Louisville,Detroit, and Phoenix. The per unit cost of production ateach 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 wholesaledistributors in seven cities across the United States. The unitcost of shipping from each plant to each distributor issummarized in the following table along with the forecasteddemand from each distributor for the coming year.Unit Shipping Cost to Distributor inSt. LouisPlantsTacomaSan DiegoDallasDenverTampaBaltimoreMacon$2.50$2.75$1.75$2.00$2.10$1.80$1.65Louisville$1.50$1.85$1.90$2.25$1.85$1.90$1.60$1.00$1.85Detroit$2.30$2.25$1.25$1.50$2.00$1.908,500$1.7512,600Phoenix$0.90$2.50$2.65$1.6013,500$2.00Demand14,50018,00015,0009,000

Name: Sentry wants to determine the least expensive way ofmanufacturing and
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Sentry wants to determine the least expensive way ofmanufacturing and shipping locks from its plants to thedistributors. Because the total demand from distributorsexceeds the total production capacity for all the plants,Sentry realizes it will not b

a) Model: Formulae: Solver input: Answer:

Answered: a. Create a spreadsheet model for this…

Math

Probability

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

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

A company produces and sells 10,125 desks each year. Each production run has a fixed cost of $500 and an additional cost of $15 per desk. To store a desk for a full year costs $8. What is the optimal number of desks the company should make during each production run? Do not include units with your answer.
Q: A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize. Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager has decided that because television ads have been found to be much more effective than radio ads, at least 75% of the time should be allocated to television.Suppose that we have the following data: a) Identify the decision variables, objective function, and constraints in simple verbal expressions. b) Mathematically formulate a linear optimization model. Note: Please clearly state the decision variables, objective function and constraints. The objective function and constraints should be written as a mathematical model using inequality or equality formulas. This question is interested in…
The area of a triangle with sides of length a, b, and c is s(s - a)(s – b)(s - c), where s is half the perimeter of the triangle. We have 60 feet of fence and want to fence a triangular-shaped area. Part A: Formulate the problem as a constrained nonlinear program that will enable us to maximize the area of the fenced area, with constraints. Clearly indicate the variables, objective function, and constraints. Hint: The length of a side of a triangle must be less than or equal to the sum of the lengths of the other two sides. Part B: Solve the Program (provide exact values for all variables and the optimal objective function).
need a CLEAR answer and work with it please!
Write the correct mathematical models for the objective functions and constraints
formulate the LP Model; identify the decision variables used in the model; and determine the optimal solution using graphical method. A marketing research group conducting a telephone survey must contact at least 150 wives and 120 husbands. It costs P100 to make a daytime call and (because of higher labor costs) P150 to make an evening call. On average, daytime calls reach wives 30% of the time, husbands 10% of the time, and neither of these 60% of the time, whereas evening calls reach wives 30% of the time, husbands 30% of the time, and neither of these 40% of the time. Staffing considerations mean that daytime calls must be less than or equal to half of the total calls made. How many should be interviewed at each period to minimize the cost of completing the survey?
An LP model for a marketing research application uses the variable HD to represent the number of homeowners interviewed during the day. The objective function minimizes the cost of interviewing this and other categories. There is a constraint that HD ≥ 140. The solution indicates that interviewing another homeowner during the day will increase costs by $15.00. What does this tell you about the HD variable? a.The objective function coefficient of HD is 15. b.The dual price for the HD constraint is 15. c.The objective function coefficient of HD is −15. d.The dual price for the HD constraint is −15.
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 124 L +137 S 17 L+12 S≤5000 5L+9S≤4500 L≥0 and S≥O (Availability of component A) (Availability of component B) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce 0 LaserStop models and SpeedBuster models. This solution gives the maximum possible profit, which is $. (Type integers or…
Valencia Products makes automobile radar detectors and assembles two models. LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables Maximize Profit 125 L 138 S 18 L+12 Ss5000 6L+8554500 L20 and 520 (Availability of component A) (Availability of component B) GITTE Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and SpeedBuster models. This solution gives the (Type integers or decimals rounded to two decimal places as…
Provide an appropriate response. A company has two different locations to assemble three different models of PCs. The table below summarizes the daily production capacity, the minimum number of each type needed, and the weekly operating costs for each location. Use linear inequalities to find the number of weeks that each location needs to operate in order to fill the orders at minimum cost. Location 1 Location 2 Minimum Numbe: Model 1 60/day 40/day 60/day $16,000 2400 60/day So/day 40/day $12,000 2000 Model 2 1800 Model 3 Week ly Cost Location 1 weeks weeks Location 2 5 p
Use the Simplex method to find the optimal solution to the problem below Investment: An investor has at most $35,000 to invest in government bonds,mutual funds and money market funds. The average yield for government bonds,mutual funds and money market funds, are 3%, 6% and 5% respectively. Theinvestor's policy requires that the total amount invested in mutual and money marketfunds must not exceed the amount invested in government bonds. How much shouldbe invested in each type of investment in order to maximize the return? What is themaximum return?.
R4