add backend functionality to calculate prep_sheet