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 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: maximizesubjecttomillingcuttinglathework6x1+11x2+0x3packaging0:17x1+0:09x2+0:13x32x1+3x2+5x33x1+4x2+7x3600x1+x2+2x3360540330 all variables 0 (a) Solve this model in LINGO or the Excel Solver, and obtain the sensitivity re-port. (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...

Jim Kovacs Company makes supplies for schools. Sales in 20XX were $4,460,000. The cost of goods sold were $2,490,000. Assets were as follows: Cash Accounts receivable Inventory Net plant and...

Overall, would it be more profitable for a business to follow the economic model or the socioeconomic model of social responsibility?

the - - - task force is a federal interagency group dedicated to fair and accurate home appraisals for everyone. a . property appraisal and valuation equity b . professional appraisers for valuation...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...