Just a quick note, found three great wikipedia articles detailing a workflow with corresponding software for linux/Mac/windoze.

For the uber-l33t linux warriors out there:

http://en.wikibooks.org/wiki/Movie_Making_Manual-Linux_in_film_productio...

For the creative artisans of the mac community:

http://en.wikibooks.org/wiki/Movie_Making_Manual-Mac_in_film_production#...

and for the virii loving windoze users:

http://en.wikibooks.org/wiki/Movie_Making_Manual-Windows_in_film_product...