Question: (15 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts

(15 marks) A linear optimization model has been

(15 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, denoted as x1,x2, and x3 respectively. The objective function is in dollars; for example each screw gives a profit of $0.17 (or 17 cents) each. There are four operations: milling; cutting; lathework; and packaging. The algebraic formulation is: maximizesubjecttomillingcuttinglatheworkpackaging0.17x1+0.09x2+0.13x32x1+3x2+5x33603x1+4x2+7x35406x1+11x2+0x3600x1+x2+2x3330allvariables0 (a) Solve this model in LINGO or the Excel Solver, and obtain the sensitivity report. (b) Checking the allowable ranges, determine what would happen to the objective function value in each of the following situations (considered independently). (Assume that all proposed changes are feasible.) (i) The price per bolt falls by $0.05. (ii) The price of each nut rises by $0.15. (iii) An extra 100 units of milling becomes available. (iv) The number of units of lathework increases by 288 , but the number of units of milling falls by 40

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

3. ( 15 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, denoted as x1,x2, and x3...

3. (20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, de- noted as x1, x2, and x3...

(20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, denoted as x1, x2, and x3...

20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, de- noted as x1, x2, and x3...

Please Solve Using Lingo 3. (20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, de- noted...

please provide lingo code for part a do not use lingo for part b 3. (20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws,...

3. (20 marks) A linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, de- noted as x1, x2, and x3...

linear optimization model has been made for a metal fabricating shop where the variables are the number of screws, nuts, and bolts made per minute, de- noted as x1, x2, and x3 respectively. The...

CASE 16 Nucor Corporation in 2014: Combating Low-Cost Foreign Imports and Depressed Market Demand for Steel Products Arthur A. Thompson The University of Alabama n 2014, Nucor Corporation, with a...

3- If the temperature increased, what will happen about the dynamic viscosity? 4- What is the shortcoming of this method?

You are going to receive $6,000 at the end of each quarter for the next five years. What is the net present value of these payments at a discount rate of 7 percent, compounded quarterly? $274,266

Once amounts are debited to an equipment account on the balance sheet, the cost is then allocated to an expense on the income statement as that asset is used in operations. This expense is referred...

1) Conduct the Tukey test (at the 5% level of significance) and describe the conclusions you derive from this test ANOVA PersonAge Sum of Squares Mean Square Big Between Groups 256.693 2 128 346 323...