An idiot, a fool, someone who's being ridiculous. Not Kermit, just someone whose brain has apparently left the building. It's affectionate enough to say to a friend but pointed enough to sting.
"You forgot the tickets? You absolute muppet."