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:10
Water at 55c flows across a flat plate whose surface temperature is held constant at 95c. if the temperature gradient at the plate's surface for a given value of x is 18 c/mm, find a) local heat transfer coefficient. b) heat flux
Answers: 3
question
Engineering, 04.07.2019 18:10
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
question
Engineering, 04.07.2019 18:10
Which one from below is not one of the reasons of planning failures? (clo3) a)-planner is careless. b-planner spend less time in the field but more time on the desk c)-planner is not qualified d)-planner does not have sufficient time to properly plan
Answers: 3
question
Engineering, 04.07.2019 18:10
Which from the following instrument is commonly used to detect the high pitch butzing sound in bearings? [clo4] a)-digital ultrasonic meter b)-infrared camera c)-spectroscopic d)-vibrometer
Answers: 2
You know the right answer?
A company develops the following Linear Programming problem to minimize the cost of producing two ty...
Questions
question
Mathematics, 26.02.2021 01:00
question
English, 26.02.2021 01:00
question
Mathematics, 26.02.2021 01:00
question
History, 26.02.2021 01:00
question
Mathematics, 26.02.2021 01:00
question
Mathematics, 26.02.2021 01:00
Questions on the website: 13722363