subject
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.

ansver
Answers: 1

Other questions on the subject: Engineering

image
Engineering, 04.07.2019 18:10, 19deleonl
Coiled springs ought to be very strong and stiff. si3n4 is a strong, stiff material. would you select this material for a spring? explain.
Answers: 2
image
Engineering, 04.07.2019 18:10, leomessifanboy678
The filament of an incandescent lamp has a temperature of 2000k. calculate the fraction of radiation emitted in the visible light band if the filament is approximated as blackbody
Answers: 2
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:20, hayleymckee
Steam enters a converging nozzle at 3.0 mpa and 500°c with a at 1.8 mpa. for a nozzle exit area of 32 cm2, determine the exit velocity, mass flow rate, and exit mach number if the nozzle: negligible velocity, and it exits (a) is isentropic (b) has an efficiency of 94 percent
Answers: 2
You know the right answer?
A company develops the following Linear Programming problem to minimize the cost of producing two ty...

Questions in other subjects:

Konu
Mathematics, 20.11.2019 05:31
Konu
Mathematics, 20.11.2019 05:31