How to plan a seasonal collection drive on a Gantt chart

Plan a seasonal food collection on a Gantt chart: supermarket and school permissions as waits, posters and crates, a volunteer rota for the collection weekend, the sorting surge and the thank-you notes.

A collection weekend has a date that cannot move, and the permissions needed to hold it come from other people. This guide shows how to put the replies, the preparation and the sorting that follows on a Gantt chart and check that the chain fits before the weekend.

The short version

  • Fix the Start of the first task and let the later dates follow from the dependencies.
  • Give each shop and school reply a plain wait task with the duration you expect.
  • Use milestones for the confirmations so posters and crates cannot be placed before them.
  • If the weekend date is agreed, fix its Start and read the conflict flag for the chain before it.
  • Link sorting to the collection with a start-to-start lag so it starts while crates are still arriving.

Put the permissions in as waits and check that the weekend date holds

A seasonal collection drive is built around one date. Shops and schools have to agree to host collections, crates and posters have to be in place, volunteers have to be rostered and briefed, and then the donations arrive in a rush that the warehouse has to sort. Most of the early work is waiting for replies, and the late work cannot start until the weekend is over.

A Gantt chart in QueryChart schedules forward from the earliest fixed Start. Give "Agree appeal goals and the wanted items list" a fixed Start on the day you begin. "Ask supermarkets for in-store collection" and "Ask schools to host collection crates" each lead to a plain wait, "Wait for supermarket replies" and "Wait for school replies", whose durations you replace with how long replies take you. The milestones "Supermarket slots confirmed" and "Schools confirmed" gate the posters and crates. If the weekend date is already agreed, fix the Start of "Collection weekend" as well and read the conflict flag to see whether the chain before it fits.

The example below is the winter food appeal template: 23 tasks in five groups and about 34 working days in its illustrative numbers. The supermarket replies take until day 13, so "Put posters up and place school crates" runs on days 14 to 16 and "Collection weekend" falls on days 17 and 18. The volunteer work runs beside the waits, with "Recruit extra weekend volunteers" starting a day into "Build the weekend volunteer rota". After the weekend "Sort and date-check donations" starts a day into "Bring crates and store donations to the food bank". The durations are illustrative and you replace them with your own.

After the example, a flowchart shows the routine the donations go through once they reach the warehouse: donation intake. A Gantt chart says when the sorting surge happens and cannot show the checks made on each load. Permissions to collect in shops and schools, rules about donated food and what to keep or discard differ by country and by organisation, so the plan holds your own durations and your own advisers decide the rest. A timeline schedules the work. It is not legal or food safety advice.

For waits and gaps in general see /guides/gantt-chart-buffer-time and /guides/gantt-chart-delays. For the chart itself see /templates/winter-food-appeal-gantt-chart, for the routine at the warehouse door see /templates/food-bank-donation-intake-process, and for a plan driven by deliveries see /guides/food-bank-relocation-gantt-chart.

A seasonal collection drive, built in stages

Twenty-three tasks in five groups. Durations are illustrative working days. Open the spreadsheet panel to see the rows behind each stage.

  1. Goals and the permissions

    "Agree appeal goals and the wanted items list" (2 working days) leads to "Ask supermarkets for in-store collection" (1) and "Ask schools to host collection crates" (1). "Wait for supermarket replies" (10) and "Wait for school replies" (8) are plain waits. "Schools confirmed" is a milestone on day 11 and "Supermarket slots confirmed" on day 13.

  2. Crates, posters and schools

    "Order crates, trolleys and bags" (1) leads to "Wait for crates and bags to arrive" (6), and "Design and print posters" (4) runs beside it. "Put posters up and place school crates" (3) waits for the confirmations and runs on days 14 to 16. "Schools collect donations in class" (8) runs until day 24.

  3. The volunteer rota

    "Build the weekend volunteer rota" (3) starts early and "Recruit extra weekend volunteers" (6) starts a day into it. "Brief volunteers and hand out vests" (1) falls on day 10, which leaves several days of slack before the weekend.

  4. The collection weekend

    "Collection weekend" (2) starts on day 17 once posters are up and volunteers are briefed. Fix its Start if the date is already agreed. "Bring crates and store donations to the food bank" (2) waits for the school collection and runs on days 25 and 26.

  5. Sorting and thanks

    "Sort and date-check donations" (5) starts a day into the delivery and ends with the milestone "Donations shelved" on day 30. "Write thank-you notes to stores and schools" (2) starts two days into the sorting. "Count totals and report to trustees" (2) leads to "Send thank-you notes with the totals" (2) and the milestone "Appeal closed" on day 34.

The routine the donations go through

Donation intake as a flowchart. The Gantt chart says when the sorting surge happens and this chart shows how each load is handled when it arrives.

  1. Receiving a load

    "Donation offered at drop-off or for collection" leads to "Greet the donor and agree where the goods go" and "Weigh the load and log it on the intake sheet".

  2. The acceptance check

    "Packaging and dates look acceptable?" has three branches. Yes moves the goods on, Unsure leads to "Warehouse Lead accepts the item?" and No leads to "Return or redirect the item and tell the donor why", which ends at "Note the declined items on the intake log". Your own written procedure sets what counts as acceptable.

  3. Sorting and storing

    "Move accepted goods to the sorting bay" leads to "Sort by category and date". "Chilled or frozen items?" sends a Yes to "Move to the fridge or freezer straight away" and a No to "Shelve in dry stock, oldest dates at the front". Both lead to "Update the stock record with quantities".

  4. Checks and thanks

    "Weights on the sheet match the stock record?" sends a No to "Recount the load and correct the sheet" and a Yes to "Add the gift to the donor record". "Donor asked for a receipt?" leads to "Issue the receipt or acknowledgement letter" or straight to "Send a thank-you message", and the flow ends at "Donation stocked and donor thanked".

Food bank donation intake process flowchart

How it works

  1. Open the collection drive chart

    Open the template and replace each duration with how long replies, deliveries and sorting take in your own food bank. Put the person responsible for each task in People.

  2. Fix the first Start

    Give "Agree appeal goals and the wanted items list" a fixed Start on the day you begin. The plan is scheduled forward, so every later date is a result of the chain until you fix one.

  3. Set the reply waits

    Replace the durations of the supermarket and school waits with how long replies usually take. Hover over a task to see the dates it produces.

  4. Check the weekend

    If the collection weekend is already agreed, fix the Start of "Collection weekend" and read the conflict flag. A flag means the permissions, posters or rota do not fit before it.

  5. Find what sets the date

    Turn on Critical path in the View menu. If the supermarket wait is lit, ask earlier or choose different stores. If the volunteer tasks are lit, start the rota sooner.

  6. Share the plan with the team

    Share the chart as a link so coordinators, volunteers and trustees can see their part and add comments. Export a PDF for people who are not in the chart.

Mistakes to avoid

  • Printing posters before the slots are confirmed

    Posters that name a shop or a date can be wrong if the reply comes late. Link the poster task to the confirmation milestones.

  • Planning sorting as if it starts on the weekend

    Crates from schools can arrive after the weekend. Link the sorting to the delivery task so the surge starts when the goods do.

  • Leaving the rota until the permissions arrive

    The rota does not depend on the replies. Start it beside the waits so the briefing is done before the weekend.

  • Using the template durations as facts

    Reply times, briefing and sorting times are illustrative. Permissions to collect and rules about donated food differ by country and by organisation, and the chart is not advice.

Open the collection drive Gantt chart

Open the template, fix the first Start and check that the permissions and the rota fit before the collection weekend.

Open the collection drive Gantt chart

Related guides

Frequently asked questions

Can QueryChart work backwards from the collection weekend?

No. Scheduling is forward only. Fix the Start of the first task, and fix the Start of the collection weekend if the date is agreed, then read the conflict flag to see whether the chain before it fits.

How do I show a shop that has not replied yet?

Add a plain task for the wait and give it the duration you expect. In the example the supermarket wait is 10 working days and the school wait is 8.

Can recruiting volunteers start before the rota is finished?

Yes. Link them with a start-to-start dependency and a lag. In the example recruiting starts one day after the rota starts.

Can I paste my own appeal plan?

Yes. Paste your table into the spreadsheet panel with one row per task and the group, duration and dependencies in columns. You can then edit it as a chart.

The template behind this guide

Winter food appeal Gantt chart template: collection weekend and sorting surge — An editable Gantt chart for a seasonal donated-goods drive: supermarket and school permissions, collection points and posters, the volunteer rota for the collection weekend, the sorting surge and thank-yous.