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

Another question on Engineering

question
Engineering, 04.07.2019 18:20
Have a greater impact on maintenance productivity than any other support group. (clo5) a)-the top management b)-inventory and purchasing c)-sub-contracting d)-cmms
Answers: 2
question
Engineering, 04.07.2019 18:20
Acertain flow of air (at stp) has a velocity distribution given by v i (in ft/s). if this flow is going through a 4 ft square area in the yz-plane (centered at the origin), what is the mass flow rate (in lbm/s)?
Answers: 2
question
Engineering, 04.07.2019 18:20
For each of the following process: a) sketch the p-v diagram, b)sketch t-s diagram, c) sketch t-v diagram, d) sketch the boundary work on one of the diagrams (a, b or c) and e) sketch the reversible heat transfer on one of the diagrams (a, b or c): 1- isobaric process from compressed liquid to superheated vapor 2- isothermal process from compressed liquid to superheated vapor 3- isentropic process from compressed liquid to superheated vapor
Answers: 3
question
Engineering, 04.07.2019 18:20
Amixture of slurry and mud is to be pumped through a horizontal pipe of diameter 500 mm. the fluid behaves as a bingham plastic with a yield stress of 30 pa and viscosity 0.04 pa.s. describe the effects of the shear stress through a transverse section of the pipe by plotting the variation in shear stress and velocity profile: (i) just before the slurry starts to move (ii) as the slurry flows when the pressure gradient is double that in part (i)
Answers: 3
You know the right answer?
A company develops the following Linear Programming problem to minimize the cost of producing two ty...
Questions
question
Mathematics, 18.12.2020 04:40
question
Mathematics, 18.12.2020 04:40
question
Mathematics, 18.12.2020 04:40
question
History, 18.12.2020 04:40