ProblemsetQualification Round Sunday, 5 August 2007 Save your answer as : solver.xls Budi, Yuli, Hadi and Vera are football lovers and they really like the local team of Jakarta Persija. This term they are they combine their money to buy tickets for 8 home game of Persija. Each home game they will get two tickets (in total, there are 16 tickets). Each person will get 4 tickets. When Budi and Hadi bought the tickets they area able to negotiate with the committee to get extra 2 free tickets for game between Persija and Semen Padang. The group agree, the one with the extra tickets (will get 5 instead of 4 is this two person, Budi and Hadi). Each person has ranked the games they prefer from 1 to 8, with 1 being most preferred and 8 least preferred, as follow.  The game between Persija and PSMS Medan is the same date as the married of Yuli's sister. So she will not get to go to this match, and will not get the tickets for this game. Determine the games each person should get tickets for that will result in the group greatest degree of satisfaction (if we calculate the rank given will give the smaller sum of number). Create a small table, just like the above table in which contain number 1 means the person will get the ticket for that game, and 0 for not getting the tickets. You could create another table to calculate the degree of satisfaction, if you think it is necessary. Solve this problem using solver only: - Create the necessary cell needed - Determine the target cell - Determine the Required Cells - Determine the constraint - Solve the case. Please cut down in picture the screen of solver after entering all the information needed, and paste it to the second sheet. |
| Copyright © 2007 Bina Nusantara University - All rights reserved |  |
| Term of Use | Privacy Policy | |