Engineering
Engineering, 25.02.2020 00:38, usisman8153

A company develops the following Linear Programming problem to minimize the cost of producing two types of steel pins commonly used the construction industry. The objective function is the profit for the company (in dollars per production batch). The company would like to maximize the profit in solving this problem. Objective:Maximize Z= 60X1 + 50 X2 Subject to:X2 + X1 <= 220 0.1 X1-0.12 X2 >= 0 X1 - X2 <= 120 X1, X2 >= 0 (non-negativity conditions) For each task below, use screen captures of your setup using Excel Solver. Show the formulas of the cells to make out task simpler in grading. Task 1:Solve the problem graphically. State the solution found for the two decision variables. State the value of the objective function for the optimal solution found. In the graphical solution, label the corner points. Task 2:Solve the problem using Excel Solver. State the exact solution found by Excel for the two decision variables. State the value of the objective function for the optimal solution found. Task 3:Since the number of pins to be produced needs to be an integer solution, solve the problem with Excel to obtain an integer solution. State the value of the objective function for the optimal solution found.

answer
Answers: 1

Other questions on the subject: Engineering

image
Engineering, 04.07.2019 18:10, demarcuswiseman
Calculate the bore of a cylinder that has a stroke of 18 inches and an extension time of 6 seconds at a flow rate of 4 gal/min.
Answers: 3
image
Engineering, 04.07.2019 18:10, katelynn73
Atmospheric air has a temperature (dry bulb) of 80° f and a wet bulb temperature of 60° f when the barometric pressure is 14.696 psia. determine the specific humidity, grains/lb dry air. a. 11.4 c. 55.8 d. 22.5 b. 44.1
Answers: 1
image
Engineering, 04.07.2019 18:20, sanchez626
Aheavily insulated piston-cylinder device contains 0.02 m3 of steam at 300 kpa and 200 °c. 1.2 mpa. d this process. team is now compressed in a reversible manner to a pressure of etermine the entropy change and the work done on the steam during this process
Answers: 1
image
Engineering, 04.07.2019 19:20, nikkiebartels
Afan that can provide air speeds up to 60 m/s is to be used in a low-speed wind tunnel with atmospheric air at 35 c. if one wishes to use the wind tunnel to study flat-plate boundary layer behavior up to reynolds numbes of re 10, what is the minimum plate length that should be used? at what distance from the leading edge would transition occur if the critical reynolds nurnber were rer, e = 5 × 105?
Answers: 2
Do you know the correct answer?
A company develops the following Linear Programming problem to minimize the cost of producing two ty...

Questions in other subjects:

Konu
Mathematics, 19.05.2021 20:30
Konu
Mathematics, 19.05.2021 20:30
Konu
Mathematics, 19.05.2021 20:30