Henry Scott Estes - Food Bank

Henry Scott Estes

MEMORANDUM
To: Yellow Team Members
From: Scott Estes (Yellow Team member)
Date: September 12, 2008
Subject: Service Learning Project Proposal

Project Proposal
My proposal is to provide assistance for Mr. Roy Stoner who operates the local Food Pantry. His food pantry not only supplies food to local residents, but has a store where people can donate clothes, furniture, and other household goods. These donated items can then be purchased at very reasonable rates. His main customers are those of low income families, that cannot afford the basic necessities and many do not qualify for government aid or assistance.
Mr. Stoners Food Pantry is located in Cartersville GA., and mainly serves Bartow County, but since it is centrally located within the four surrounding counties, he does get Paulding, Cherokee, Gordon, and Floyd County patrons as well. His number is 770-123-4567. (Real phone number can be provided on request.)
Types of Services Needed
I have been acquainted with Mr. Stoner for several years, and he has recently asked for assistance with these types of services.
· Create database to track customers
· Create database to track inventory of donations
· Provide training on the use of the databases
· Assist in entering customers or supply inventories into the databases
Currently this information is kept in hardcopy form (files and folders), and is very difficult to keep records updated. The databases can be simple Microsoft Access Databases, and Mr. Stoner has computers and Microsoft Office to run these applications. He can provide a sample list of items that would need to be tracked by these databases. Obliviously the customer database would include such items as name, address, phone, and number of household members. The Inventory/supply database would track items such as donator name and contact information, items donated, estimated value, and value item sold. Once the databases have been created, they can be transferred to Mr. Stoner’s
Yellow Team, 09/12/2008, page 2
computers. Then we would need to provide training for his staff on the proper data entry procedures. After the training, we could then assist in the entering of data into the databases, or assisting with the inventory of his donations.
Time Line
The time line of this project should not take more than a few weeks. The creation of the database to track customers and inventory should take a week or so. Then training of his staff should only take a few hours. Then if needed, the inventory of donations and entering of data should take no less than one to two days.
Project Size
Yellow team has adequate members to complete this project.
· One member to create Customer Database
· One member to create Inventory Database
· One to two members to train users on proper database entry
· One to two members to assist with Inventory
Project Deliverables
This project will delivery a useable database to track the food pantry’s customers and its inventory assets. Even though I have specified Mr. Stoner’s Food Panty, this project could be applied to any local Food Pantry in your area that is in need of a means to track customers and inventory.
Cc: Susan Vanderhall