Alternative to MS Project 2007 for production scheduling?
- by john c
OK... Im coming to grips with the fact that MS Project 2007 may not be the correct tool for my production scheduling.  
We serve 120 to 150 projects a year with durations from 6 weeks to 12 months.  The task are simple (6 to 8 per project) and the resource pool is stable (15 to 20 people).  It's really an assembly line product but with extremely varied durations.  I need to be able to prioritize the projects for production and run projects concurrently to fully utilize my resources.  What are the feelings of the stackoverflow community.  Am I using the wrong program?  I was really hoping to make this simple for non-programer types to input project data into a form and have the schedule software automated enough to make most of the decisions.  
Is there a better solution available commercially?  I'd like to hold on writing a custom spreadsheet as a last resort but if that's the best route then so be it.
Thank you so much for your input.