Question: Using the data given below, develop a linear programming (goal programming) model to evaluate the jobs. The model should include constraints covering: (i) The total

Using the data given below, develop a linear programming (goal programming) model to evaluate the jobs. The model should include constraints covering:

(i) The total score for the Job 1 (highest) should be close to 2000 but not more.

(ii) The score assigned to Job 16 should be as near as possible to 1200.

(iii) The score for the Job 30 (lowest) should be as close to 400 but not less.

(iv) The differential in scores between the jobs listed above should be at least 300.
(v) The scores should be in conformity to the stipulated rankings of the jobs.

Points by Each Factor Benchmark Jobs 1 A 1628 9 16 40

Points by Each Factor Benchmark Jobs 1 A 1628 9 16 40 45 24 30 35 30 20 24432 70 65 45 40 & & & & &|w B D E 70 50 60 40 50 35 40 20 15 25 28842 70 70 55 40 30 15

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 Understanding Management Questions!

Planning Demand and Supply in a Supply Chain Capacity Planning and Assignment 1 utdallas.edu/~metin Outline Capacity Planning Product-to-plant Assignment utdallas.edu/~metin 2 Deterministic Capacity...

I am stumped and need help desperately! attached is the problem I am stuck on. 6.3 SET COVERING The covering model is one of the basic linear programming model types. As introduced in Chapter 2, the...

For one of them you don't have enough manufacturing hours to do the job. It's deceiving if you look at only the demand and production Chp 14 #30 - Optimize Production Plan Costs - Solver Test.xls The...

1. [20 points] A mattress manufacturer has three production facilities located in Pittsburg (PA), Houston (TX), and Los Angeles (CA). They supply their products to three distribution centers in...

Precision Transfer, Inc. makes more than 300 types of precision gears. The operations to make the different types are similar, but the time and materials required are different. Because all the gears...

I found the result which is : Result (Number of ads to purchase) 18 0 40 3.5 30 0 Satellite Radio (R1) Satellite Radio (R2) Social Media (S1) Social Media (S2) Music Streaming (T1) Music Streaming...

undefined 1. [15 pts.] Five workers are available to perform four jobs. The time it takes each worker to perform each job is given in the following table. The goal is to assign workers to jobs so as...

Note- I need Linear Programing, Excel Model and Senstivity report Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve the technical...

Using excel solver and show calculations Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve the technical skills you have attained....

operations management please help to answer the questions starting image no 6 start from picture no 6 XYZ Co is a gromierot company in the FMCG induaty. I grovites 400 differeat trands mperming 14...

Plot the expected real interest rate since 1979 by subtracting the Michigan survey inflation measure (FRED code: MICH) from the three-month Treasury bill rate (FRED code: TB3MS). Plot as a second...

Two constant-volume gas thermometers are assembled, one with nitrogen and the other with hydrogen. Both contain enough gas so that P3 = 80kPa. (a) What is the difference between the pressures in the...

Locational arbitrage involves: Profiting from differences in interest rates across different countries Using international trade to exploit currency differences Profiting from exchange rate...

Solve for the indicated letter. Where noted, the given formula arises in the technical or scientific area of study. for T 1 (solar heating) Q kAt(T - T) L

7. What is the title of the position that the authors describe as quite often the only person who can truly control costs, time, and quality?

6. Make a list of the typical items found in a labor agreement.

5. What is a labor agreement and what type of contractor (union or nonunion) does it apply to?

Dividend Per Share Seacrest Company has 10,000 shares of cumulative preferred 1% stock, $150 par and 50,000 shares of $15 par common stock. The following amounts were distributed as dividends: Year 1...

Miles' company issues 200,000 shares of a common stock with a par value of $15. The board of directors declares a $0.75 per share cash dividend. What is the dividend on these shares? $150,000...

Issuing Bonds at a Premium On the first day of the fiscal year, a company issues a $6,300,000, 10%, 9-year bond that pays semiannual interest of $315,000 ($6,300,000 x 10% x V), receiving cash of...