# Solver add-in problem

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

 Forum Topic Post Reply Login

### Solver Add-in Problem

Rate this:
(3/5 from 1 vote)
 I.D. 01 02 03 04 05 06 07 08 09 10 A 3 8 9 4 6 5 2 10 1 7 B 5 3 2 6 1 7 9 8 4 10 C 10 8 7 9 1 4 3 6 2 5 D 7 3 2 9 5 4 8 6 1 10 E 7 3 6 8 5 2 9 10 1 4 F 3 9 1 5 6 8 2 7 10 4 G 5 1 10 9 2 3 6 8 4 7 H 6 5 8 3 2 4 7 1 9 10 I 8 9 10 5 4 3 2 1 6 7 J 9 10 3 8 5 4 2 7 1 6

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 1 Order 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. Duncan Posted by duncanwil on 04 Jul 2009
 Displaying page 1 of 1

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