Modelling Herschel observations of hot molecular gas emission from embedded low-mass protostars