Home > Forum Home > Planning and Managing Projects > Solver add-in problem Share

Solver add-in problem

Excel Help for Solver Add-in Problem in Planning and Managing Projects


Forum TopicPost Reply Login

Solver Add-in Problem

Rate this:
(3/5 from 1 vote)
Confused
I.D.01020304050607080910
A38946521017
B53261798410
C10879143625
D73295486110
E73685291014
F39156827104
G51109236847
H65832471910
I89105432167
J91038542716


ok i've been working on this one for ages and i can't seem to crack it.
i have customer ID's listed down the far left hand colum
the rooms names are featured along the top row.
the customers have been asked to order their preferences for rooms from 1-10, 1 being the most preferred.
each customer must not be allocated a room worse than their 6th preference
and customers F and I must receive their first preferences, and the problem must be solved using the solver add-in.

any help would be greatly, greatly, greatly appreciated!
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
Hi Nicole, I realise this is an old problem and you might have solved it yourself or have had it solved elsewhere but I have attempted this problem. My solution is as follows. Room 1 not assigned, room 2 =G, room 3 = F, room 4 = not assigned, room 5 assigned to B AND C, room 6 not assigned, room 7 = A, room 8 = H AND I, room 9 D AND E, room 10 = J. I didn't see a constraint that says unoccupied and double occupancy are banned and SOLVER gives me the above. I would love to see the correct answer IN CASE THE ABOVE IS RUBBISH!
I will share my Excel fille too if you want.
 Duncan
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Solver add-in problem in the