Volunteer Meal Capacity Planning

My idea is to provide a meal capacity planner base for volunteers who are involved in providing food to people in need.

Comment

Inspiration

I decided to use the non-profit use case (Meal Capacity Planning) provided by Airtable as I found it more relevant and would make wider social impact.

What it does

Volunteer meal capacity planning supports the following user stories:

  1. As a Volunteer I want to be able to know the number of available meals So that I can provide suffiencient food to the needy people.
  2. As a Volunteer I want to be able to know the number of people who are in need of meals So that I can manage the meals inventory
  3. As a Volunteer I want to be able to understand the over or under utilization of meals.

How I built it

I used the prebuilt template available in Airtable and customised it to solve the meal capacity planning challenges faced by Volunteer organisations. The meals were categorised based on meal type - veg, non-veg, vegan, fruits, and desserts. I used following blocks to bring clarity in the solution.

  1. Meals served daily count - to identify the number of meals server every day. It also captured the no of meals served from each food bank.
  2. Meals Available - to get the inventory available based on each meal type (veg, non-veg, vegan, fruits, desserts), meals available in the foodbank and meals out for delivery out of the foodbank.
  3. Inventory In Log - captured the inventory in more detail based on date, individual meal type added on that date and quantity added to each foodbank.
  4. ** Inventory Discard Log** - captured the meals which is expired and the quantity should be reduced from the number of available meals for delivery.
  5. Volunteer Data Tracker - is used to capture the volunteer contact information
  6. Foodbank Sites Data - is used to define the foodbank location type and map with meals available for each food bank and discarded meals.
  7. Meals Donation Scheduler - provided the meals schedule based on Meals Delivery Calender. This brings in efficiency in food delivery and tracking.
  8. ** Meals Supply Chain Survey** - is added to get the feedback from needy people using the volunteer organisations for meal

Challenges I ran into

I used the airtable for the first time. Though it's very good and easy to use, I strugged to link the various tables in order to get formula working for few tables.

Accomplishments that I'm proud of

I came across Airtable and came across so many interesting use cases. I'm sure that I'm going to use it in future hackathons.

What I learned

Rapid prototyping using Airtable and innovative templates available.

What's next for Volunteer Meal Capacity Planning

Discovery more feature of airtable and make the prototype more robust and get ready for production level.

Built With

Share this project:

Updates