Yeah, essentially nuendo is great for this.
Cubase will do.
In terms of bpm, I wouldn`t, I`d score to the edit, if thats the way they want you to work. that`s generally the proper way.
However if it`s dance music you are putting to the advert, then really it should be as close to the edit as possible and then they should re cut the edit to the beat.

That`s how I did things when I was doing my degree anyway.