Waste of public money revealed in report