Most American shoppers say they are willing to pay more for their retail club memberships — a sentiment that bodes well for Costco (COST).