All workers will be made redundant at the end of August as BP ended the contract for the vessel.