You're going to need something expensive or unauthorized

The MPEG2 codec and the AVCHD container are both proprietary and licensed. Anything based on FFMPEG like Mplayer can handle the codec, but I don't know much about free apps that support AVCHD. That might be difficult. If it's been edited, can you talk whoever did the editing into rendering it out to some other intermediate format for you instead of AVCHD?
If you're on windows, there's a trial version of Vegas here. Vegas definitely does AVCHD and MPEG2, and you can render out to h263, h264, WMV, MPEG2, or any number of other things.
http://www.sonycreativesoftware.com/download/trials/vegaspro I've never used it without a license key so I don't know if it just works and then quits after 30 days or if it watermarks everything until you pay for it.
Quicktime Pro can probably convert it to something useful, if you want to spend about $30
Have I mentioned before how much AVCHD sucks ass?

--- TheWAMstore --- A WAM Video Supermarket - 26,000 Titles