Linear programming formulation for assignment

A question is this type if and only if it asks to formulate an assignment or allocation problem as a linear programming problem with decision variables, objective function, and constraints.

10 questions · Moderate -0.8

7.06a LP formulation: variables, constraints, objective function
Sort by: Default | Easiest first | Hardest first
Edexcel D2 2007 June Q4
16 marks Moderate -0.8
4. A group of students and teachers from a performing arts college are attending the Glasenburgh drama festival. All of the group want to see an innovative modern production of the play 'The Decision is Final'. Unfortunately there are not enough seats left for them all to see the same performance. There are three performances of the play, 1,2 , and 3 . There
AdultStudent
Performance 1\(\pounds 5.00\)\(\pounds 4.50\)
Performance 2\(\pounds 4.20\)\(\pounds 3.80\)
Performance 3\(\pounds 4.60\)\(\pounds 4.00\)
are two types of ticket, Adult and Student. Student tickets will be purchased for the students and Adult tickets for the teachers. The table below shows the price of tickets for each performance of the play. There are 18 teachers and 200 students requiring tickets. There are 94,65 and 80 seats available for performances 1,2 , and 3 espectively.
  1. Complete the table below.
    AdultStudentDummySeats available
    Performance 1£5.00£4.50
    Performance 2£4.20£3.80
    Performance 3£4.60£4.00
    Tickets needed
  2. Explain why a dummy column was added to the table above.
  3. Use the north-west corner method to obtain a possible solution.
  4. Taking the most negative improvement index to indicate the entering square, use the stepping stone method once to obtain an improved solution. You must make your shadow costs and improvement indices clear. After a further iteration the table becomes:
    AdultStudentDummy
    Performance 17321
    Performance 21847
    Performance 380
  5. Demonstrate that this solution gives the minimum cost, and find its value.
    (Total 16 marks)
Edexcel D2 2011 June Q6
9 marks Moderate -0.3
6. Three workers, \(\mathrm { P } , \mathrm { Q }\) and R , are to be assigned to three tasks, A, B and C. Each worker must be assigned to just one task and each task must be assigned to just one worker.
Table 1 shows the cost of using each worker for each task. The total cost is to be minimised. \begin{table}[h]
Task ATask BTask C
Worker P273125
Worker Q263034
Worker R352932
\captionsetup{labelformat=empty} \caption{Table 1}
\end{table}
  1. Formulate the above situation as a linear programming problem. You must define your decision variables and make the objective and constraints clear.
    You are not required to solve the problem. Table 2 shows the profit gained by using each worker for each task. The total profit is to be maximised. \begin{table}[h]
    Task ATask BTask C
    Worker P333731
    Worker Q323640
    Worker R413538
    \captionsetup{labelformat=empty} \caption{Table 2}
    \end{table}
  2. Modify Table 2 in the answer book so that the Hungarian Algorithm could be used to find the maximum total profit. You are not required to solve the problem.
    (2)
    (Total 9 marks)
Edexcel D2 2012 June Q7
7 marks Moderate -0.8
7. Four workers, A, B, C and D, are to be assigned to four tasks, P, Q, R and S. Each worker is to be assigned to exactly one task and each task must be assigned to just one worker. The cost, in pounds, of using each worker for each task is given in the table below. The total cost is to be minimised.
PQRS
A23413444
B21453342
C26433140
D20473546
Formulate the above situation as a linear programming problem. You must define your decision variables and make the objective function and constraints clear.
(Total 7 marks)
Edexcel D2 2013 June Q6
8 marks Moderate -0.8
6. Three workers, Harriet, Jason and Katherine, are to be assigned to three tasks, 1, 2 and 3. Each worker must be assigned to just one task and each task must be done by just one worker. The amount each person would earn, in pounds, while assigned to each task is shown in the table below.
Task 1Task 2Task 3
Harriet251243257
Jason244247255
Katherine249252246
The total income is to be maximised.
  1. Modify the table so it can be used to find the maximum income.
  2. Formulate the above situation as a linear programming problem. You must define your decision variables and make your objective function and constraints clear.
Edexcel D2 2014 June Q6
7 marks Moderate -0.8
6. Four workers, A, B, C and D, are to be assigned to four tasks, 1, 2, 3 and 4. Each worker must be assigned to just one task and each task must be done by just one worker. Worker C cannot do task 4 and worker D cannot do task 1. The cost of assigning each worker to each task is shown in the table below. The total cost is to be minimised.
1234
A29153230
B34264032
C282735-
D-213331
Formulate the above situation as a linear programming problem. You must define your decision variables and make the objective function and constraints clear.
Edexcel D2 2014 June Q6
7 marks Moderate -0.8
6. Three warehouses, \(\mathrm { P } , \mathrm { Q }\) and R , supply washing machines to four retailers, \(\mathrm { A } , \mathrm { B } , \mathrm { C }\) and D . The table gives the cost, in pounds, of transporting a washing machine from each warehouse to each retailer. It also shows the number of washing machines held at each warehouse and the number of washing machines required by each retailer. The total cost of transportation is to be minimised.
ABCDSupply
\(P\)1122131725
\(Q\)218191427
\(R\)151091228
Demand18162026
Formulate this transportation problem as a linear programming problem. You must define your decision variables and make the objective function and constraints clear.
You do not need to solve this problem.
(Total 7 marks)
Edexcel D2 Q2
6 marks Moderate -0.5
2. A supplier has three warehouses, \(A , B\) and \(C\), at which there are 42,26 and 32 crates of a particular cereal respectively. Three supermarkets, \(D , E\) and \(F\), require 29, 47 and 24 crates of the cereal respectively. The supplier wishes to minimise the cost in meeting the requirements of the supermarkets. The cost, in pounds, of supplying one crate of the cereal from each warehouse to each supermarket is given in the table below.
\cline { 2 - 4 } \multicolumn{1}{c|}{}\(D\)\(E\)\(F\)
\(A\)192213
\(B\)181426
\(C\)271619
Formulate this information as a linear programming problem.
  1. State your decision variables.
  2. Write down the objective function in terms of your decision variables.
  3. Write down the constraints, explaining what each one represents.
Edexcel D2 Q2
7 marks Easy -1.2
2. A school entrance examination consists of three papers - Mathematics, English and Verbal Reasoning. Three teams of markers are to mark one style of paper each. The table below shows the average time, in minutes, taken by each team to mark one script for each style of paper.
\cline { 2 - 4 } \multicolumn{1}{c|}{}MathsEnglishVerbal
Team 1392
Team 2471
Team 3583
It is desired that the scripts are marked as quickly as possible.
Formulate this information as a linear programming problem.
  1. State your decision variables.
  2. Write down the objective function in terms of your decision variables.
  3. Write down the constraints, explaining what each one represents.
Edexcel D2 2017 June Q4
7 marks Moderate -0.8
4. Four workers, \(\mathrm { A } , \mathrm { B } , \mathrm { C }\) and D , are to be assigned to four tasks, \(1,2,3\) and 4 . Each worker must be assigned to only one task and each task must be done by only one worker. Worker A cannot do task 3 and worker D cannot do task 2
The cost, in pounds, of assigning each worker to each task is shown in the table below.
1234
A5384-20
B87724138
C70515225
D45-8170
The total cost is to be minimised.
Formulate the above situation as a linear programming problem. You must define your decision variables and make the objective function and constraints clear. You do not need to solve this problem.
Edexcel D2 2006 June Q2
Moderate -0.8
Three workers, \(P\), \(Q\) and \(R\), are to be assigned to three tasks, 1, 2 and 3. Each worker is to be assigned to one task and each task must be assigned to one worker. The cost, in hundreds of pounds, of using each worker for each task is given in the table below. The cost is to be minimised.
Cost (in £100s)Task 1Task 2Task 3
Worker \(P\)873
Worker \(Q\)956
Worker \(R\)1044
Formulate the above situation as a linear programming problem, defining the decision variables and making the objective and constraints clear. (Total 7 marks)