Workers at Sharing Excess couldn't rely on the company's internal tool to support their jobs, so they had to resort to an external platform, which overcomplicated their process.
I redesigned the internal tool of Sharing Excess to streamline their work process in the warehouse, which increased workers' productivity by at least 50% and minimized human errors by 75%.
Timeline
July - September 2023
Role
UX Designer
UX Research
Collaboration
Quinn - UX Designer
Shash - Developer
Victoria - Product Manager
PREVIEW
An all-in-one platform for every warehouse workflow
Enter data in an organized way that replicates the real-life work process
Eliminate redundant tasks when distributing multiple produces
Get reminded to deliver forgotten food to minimize food waste
CONTEXT
Collecting and delivering food to the community
Sharing Excess is a nonprofit addressing the issue of food insecurity in the United States. They rescue excess food and produces from wholesalers and deliver them to communities and organizations in need.
PROBLEM
The main working tool lacks the primary functions
Receiving and distributing ~30k pounds of food from 9AM to 11AM everyday, Food Sourcing Associates at Sharing Excess are frustrated with working with the data.
Sharing Excess app is the main tool that workers use to record input and output data. However, the app failed to perform the most basic functions.
Workers couldn't record information properly
The Entry form didn't have fields for all important data (e.g., case count, case weight)
⇒ They put all these numbers into "Notes" field
⇒ Disorganized and confusing
Workers had to do redundant, repetitive tasks
Distributing X types of produces to one food bank
= Recording data X times repeatedly
⇒ Time-consuming, hard to manage data
Workers weren't reminded of undistributed food
Sometimes food is forgotten to be distributed, but the app doesn't remind workers about it.
⇒ The food loses quality and can't be delivered
⇒ Food waste
⇒ How the app worked technically didn’t align with users’ work process
⇒ The workers resorted to an external platform - Google Sheets - to do their work
However, the Google Sheets alternative actually prolonged and overcomplicated the process. At the end of the day, workers still had to transfer data from the spreadsheet to the app.
Workers' original work process
How Might We…
…turn the Sharing Excess app into an all-in platform that workers can rely on in their end-to-end process, so they don't have to utilize an external platform?
Solving a complicated workflow that even the users themselves struggle to explain it properly, I needed to work as closely as possible with users throughout the project. Some of the methods I used to get them involved were:
Field Study 🕵️♀️
Experienced a typical work day in the warehouse to identify areas of improvement.
Focus Group 🗣️
Had the workers discuss and share challenges as a team since they collaborated closely.
Co-design workshop 🎨
Brainstormed ideal solutions with the workers and hear how those would benefit them.
There were frustrations that I didn't see until I talked to the users: e.g. no standard naming convention for the process; so many unexpected scenarios that the app couldn't cover.
Working in an environment requiring speed and concentration, they don’t want to be perplexed by how the app works ⇒ something intuitive and self-explanatory even for beginners.
I thought I figured out all of user problems in the research phase. However, as I was working on a problem, another one arose. Sometimes a good solution to this problem can cause unexpected issues in other parts of the app. Therefore, I had to communicate with the users and stakeholders almost on a daily basis to make sure I was on the right track.
Here's an example of how I solved the first problem with the Entry workflow (recording data of collected food)
Enter data in an organized and logical way
Add fields for every piece of data; reorder the fields to replicate the real-life process
⇒ No longer enter information in Notes field
⇒ More organized and faster workflow
"Before Sorting" and "After Sorting" tabs to separate different types of data for comparison
⇒ Avoid confusion and mistakes
Distribute multiple products to an organization effectively
Original app: create one form for each type of product that an organization orders
New app: add multiple types of products into a form for an organization
⇒ Group relevant data together ⇒ Easy to keep track
⇒ Shorten the process and save time
Be reminded to distribute all donated food
Have a separate page for Remaining Produce to list out undistributed food
Display older foods in red
⇒ Ensure they are still in good condition and distributed ASAP
⇒ Minimize food waste and increase the company's environmental and social impacts
We tested the Alpha version of the app with the Food Sourcing Associates in the warehouse in real time for 3 consecutive days, then compared their work performance and productivity before and after using the new app. The official launch was set for October 2023.
1.5 hours ⇒ 0 hour
of transfering data between 2 platforms. Workers don't need Google Sheets anymore.
1-2 minutes ⇒ 30 seconds
entering data for one Entry/Allocation form. Workers can confidently use the internal app in real time.
75%
reduction of human error and data inaccuracy. In-app calculation and Alert messages help workers avoid mistakes.
60%
reduction in food waste. Workers are reminded to distribute food in a timely manner.
Workers' process before the app was redesigned
Workers' process after the app was redesigned
Put myself into users’ shoes
To solve complex problems of the app, I had to work closely with the users, and even build a relationship with them. User research is not only setting up an interview with people, but also “visiting” them and observing their frustrations in real life.
Evaluate my design decisions from multiple perspectives
Every time testing my designs with the workers, I also handed them off to stakeholders and developers. They would let me know if the design was codable or if it might cause any problem.
Take the initiative and Learn along the way
I was nervous to know that another intern and I would be the only designers of the company. I read more books, consulted other UX professionals, and self-studied to gain confidence. Thus I soon worked my way out and took control of the project.