model and solve the following problem in excel The Metalco Company desires to blend a new alloy of 40 percent tin, 35 percent zinc, and 25percent lead from several available alloys having the following properties:AlloyPropertyPercentage of tinPercentage of zincPercentage of leadCost ($/lb)6010302515604545(b) Solve this model by the simplex method.504010301088 84 94205055577-70The objective is to determine the proportions of these alloys that should be blended to producethe new alloy at a minimum cost.(a) Formulate a linear programming model for this problem.****

For this question, first, I would formulate the LP, then, I would solve this problem using the…

Answered: (a) Formulate a linear programming…

Business

Operations Management

(a) Formulate a linear programming model for this problem. (b) Solve this model by the simplex method.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: (b) Solve the linear program formulated in part (a). How many service facilities are required? Where…

A: Prepare an excel sheet as shown below:Note that in excel the colored values represents the cities…

Q: Pls solve using excel

A: Find the given details below:

Q: TMA will ship x televisions from Location I to city A and y televisions from Location I to city B.…

A: Here, I have stated all the data in the below table, Here, the total costs would be minimized, To…

Q: Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic…

A: Linear regression aims to determine how the independent variables collectively contribute to…

Q: Port Ormond Carpet Company manufactures carpets. Fiber is placed in process in the Spinning…

A: Please find the attached balance sheet in step-2

Q: How does an optimal frontier graph draw a risk-free line?

A: A productive outskirts graph, also known as an efficient frontier graph, is a graph that plots the…

Q: Solve the linear programming problem by the method of corners. Maximize P= x+ 6y subject to x + y s4…

A: Linear programming is a method that is used to achieve the best outcome (such as maximum profit or…

Q: Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the…

A: Given Information: Cabinet Maker 1 Cabinet Maker 2 Cabinet Maker 3 Hours required to…

Q: Baton Rouge's Mt. Cedar Hospital is a large, private, 600-bed facility complete with…

A: Based on the given information, the decision variables are X1 and X2. Here, the revenue details are…

Q: Foodie Goodie is a small food processing plant. It produces three kinds of snacks: sunflower seeds,…

A: If all the equipment produces sunflower seeds, it can produce 6 kg a day- In a week, the maximum…

Q: Refer to the table below. If the marginal cost to provide the park is $3/hectare, Consumer Group 1…

A: Social efficiency occurs at the quantity of output where the sum of the consumer surplus and the…

Q: Futura Company purchases the 79,000 starters that it installs in its standard line of farm tractors…

A: o determine the financial advantage or disadvantage of making the 79,000 starters in-house instead…

Q: TMA manufactures 37-in. high definition LCD televisions in two separate locations, Locations I and…

A: Decision Variables: Suppose-x be the no. of LCD televisions to be shipped from the locations -1 to…

Q: NTS is a Swiss intermodal operator located in Lausanne. When customers need to transport goods…

A: Once the optimal solution is found, it will indicate how many containers should be transported from…

Q: a) Formulate a linear programming model to determine the optimal product mix that will maximize…

Q: A factory works 8 hours a day, producing three products namely A, B and C. each of these products is…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: A fertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to…

A: VA1 = tons shipped to customer A from warehouse 1VA2 = tons shipped to customer A from warehouse…

Q: Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: The Burroughs garment company manufactures men's shirts and women’s blouses for Walmark Discount…

Q: Darren Mack owns the "Gas n' Go" convenience store and gas station. After hearing a marketing…

A: Given-

Q: A company currently ships products from 5 plants to 4 warehouses. The company is considering the…

A: Find the Given details below: Given details: Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Demand…

Q: Iron Triangle” c

A: An iron triangle is a term used to portray a relationship that develops between congressional…

Question

model and solve the following problem in excel

The Metalco Company desires to blend a new alloy of 40 percent tin, 35 percent zinc, and 25
percent lead from several available alloys having the following properties:
Alloy
Property
Percentage of tin
Percentage of zinc
Percentage of lead
Cost ($/lb)
60
10
30
25
15
60
45
45
(b) Solve this model by the simplex method.
50
40
10
30
10
88 84 94
20
50
555
77-70
The objective is to determine the proportions of these alloys that should be blended to produce
the new alloy at a minimum cost.
(a) Formulate a linear programming model for this problem.
****

Expert Solution

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!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduce the question:

VIEW

Step 2: Formulate the LP:

VIEW

Step 3: Use solver tool:

VIEW

Step 4: Use 2 phase simplex method:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 23 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Crestline Manufacturing must decide whether to invest in process option X or option Y. Process X includes automated assembly equipment and requires three employees. On the other hand, process Y includes semi-automated assembly equipment and requires six employees. Process X incurs a fixed cost of $900,000 and a variable cost of $25 per unit. Machine Y incurs a fixed cost of $600,000 and a variable cost of $30 per unit. Solve the following and show all the steps: a) What is the break-even quantity between these two processes? Provide a rough plot of your analysis and show the break-even point on the plot. b) If predicted demand for next year is 80,000 panel folds, which process option do you recommend? How much cost does the recommended process save?
Formulate but do not solve the problem.The management of Hartman Rent-A-Car has allocated $2.25 million to buy a fleet of new automobiles consisting of compact, intermediate-size, and full-size cars. Compacts cost $18,000 each, intermediate-size cars cost $27,000 each, and full-size cars cost $36,000 each. If Hartman purchases twice as many compacts as intermediate-size cars and the total number of cars to be purchased is 100, determine how many cars of each type will be purchased. (Assume that the entire budget will be used. Let x, y, and z denote the number of compact, intermediate-sized, and full-size cars purchased, respectively.) = 2,250,000 = x = 100
Solve the linear programming problem by the method of corners. Мaximize P %3D х + 5у х + у < 4 2х + у S 5 x 2 0, y 2 0 subject to The maximum is P = at (x, y) =
Show your solution when necessary and provide a brief description on how you arrive with the answer. Capture your answer well.
A health Centre will be built to serve 7 communities. The geographical location of the communities and their population is shown in the table below. Communities A, X =2.5 (km), Y=4.5(km), Population( 000's)=2 Communities B, X =2.5 (km), Y=2.5(km), Population( 000's)=5 Communities C, X =5.5 (km), Y=4.5(km), Population( 000's)=10 Communities D, X =5 (km), Y=2(km), Population( 000's)=7 Communities E, X =8 (km), Y=5(km), Population( 000's)=10 Communities F, X =7 (km), Y=2(km), Population( 000's)=20 Communities G, X =9 (km), Y=2.5(km), Population( 000's)=14 There is a possibility of building the Centre in two communities, community C and F. Based on the Demand-Distance criterion what is your recommendation for the site of the Centre. The distances to be measured based on Rectilinear method. Based on…
Please find and solve the attached optimization Problem
Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 600 550 350 Outside vendor 900 650 450 Combination 700 600 400 a. If the demand probabilities are 0.4, 0.25, and 0.35, which decision alternative will minimize the expected cost of the data processing operation? Own Staff What is the expected annual cost associated with that recommendation? If required, round your answer to the nearest thousand of dollars. Expected annual cost = $ ___________
Problem 2 The University of South Wisconsin has had steady enrollments over the past five years. The school has its one bookstore, called University Book Store, but there are also three private bookstores in town: Bill’s Book Store, College Book Store, and Battle’s Book Store. The university is concerned about the large number of students who are switching to one of the private stores. As a result, South Wisconsin’s president, Andy Lange, has decided to give a student three hours of university credit to look into the problem. The following matrix of transition probabilities was obtained: University Bill’s College Battle’s University 0.5 0.2 0.2 0.1 Bill’s 0.1 0.6 0.2 0.1 College 0.1 0.1 0.7 0.1 Battle’s 0.05 0.1 0.1 0.75 At the present time, market shares for University, College, Battle’s and Bill’s book stores are 0.3, 0.3, 0.2, 0.2. What will the market share…
Valencia products makes automobile radar detectors and assembles two models. Laser stop 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 = 123 L + 139 S 19 L + 11 S < 4,000 (availability of component A) 6 L + 9 S < 35000 (availability of component B) L > 0 and S > 0 The optimal solution is to produce how many Laser stop models ? And how many Speedbuster models ? The maximum possible profit is ? Component A is or is not a binding…
How would you write the optimal solution for these?
Don't give answer in image