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.
Answers: 1
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
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
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
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
A company develops the following Linear Programming problem to minimize the cost of producing two ty...
Mathematics, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00
English, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00
History, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00
Mathematics, 26.02.2021 01:00