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)

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
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.
 Posted by on
 Displaying page 1 of 1 

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