Chief executive says supermarket needs significant investment to get it ‘firing on all cylinders’