Last summer, JF&CS Family Table Food and Volunteer Coordinator Tamar Moskowitz sat down to plan the monthly food distribution. Over the next three hours, she cross-referenced shopping lists, maps, client addresses, and volunteers. With 80 volunteers and almost 150 destinations, the possible number of delivery routes was in the hundreds of thousands! But with the help of an innovative new program, a process that took several hours each month now takes only minutes.
Volunteer Jay Gainsboro noticed Tamar’s hard work and thought, “There’s got to be a better way.” He reached out to colleague George Roberts for help. George is a software developer with the time and inclination for pro bono work. He quickly developed a computer program to enhance Family Table’s ability to match drivers with delivery locations. “I wanted to make sure the food got delivered and make Tamar’s job as easy as possible,” said George. “Not only does this program save us time, but it allows us to give our volunteers the best possible experience when they come to Family Table,” added Tamar.
Over the fall, Tamar and Steve Smith, Database Administrator for JF&CS Volunteer Services, piloted the program alongside the usual process. The program calculates the shortest route between stops based on the longitude and latitude of JF&CS Headquarters in Waltham, the driver’s location, and the recipient’s home. They quickly realized the advantages of being able to tell volunteers how many miles they were driving and to calculate how many miles were driven in total. While the previous routes varied widely, each volunteer now drives significantly fewer miles. The program also offers consistency to drivers who delivered to Brookline one time and Framingham the next under the old process.
This post has been contributed by a third party. The opinions, facts and any media content are presented solely by the author, and JewishBoston assumes no responsibility for them. Want to add your voice to the conversation? Publish your own post here.