add new methods for Lynn's lot reports