Demand Forecasting

Help customers avoid overstocking or going out of stock

The Problem

TradeGecko users are mostly small businesses. They are sellers with popular products but limited resources on their hands - including warehouse space. As such, our customers need to strategize when to order the right item so that they have it in stock to meet the customer demand without wasting precious warehouse space on items that are slow moving.

If not done correctly, this could lead to either overstocking or going out of stock. Our customers need to be able to find the sweet spots for each product. This is called Demand forecasting, and it is one of the top requested features on TradeGecko when it comes to Intelligence / Reporting.

Read about the process

The Process

For this project, the team decided to try out design sprint approach: a five-day process for answering critical business questions through design, prototyping, and testing ideas with customers.

In order to map out what customer pain points and expectations of Demand Forecasting, we decided to visit some of our customers that are based in Singapore. We were able to see customers in action this way.

After the customer meetings, we spent the rest of the week in a design sprint which includes sketching, storyboarding, prototyping and a light user testing with the fore mentioned customers to ensure their pain points were addressed.

See the design

The Design

During the design sprint, we discovered the elements customers needed to do their forecasting, which is the historical sales number and our recommended reorder number based on the forecast algorithm. We first wireframed our design as a prototype to be sent to customers.

After showing the wireframes to our customers, we also realized they needed to see more information such as the available stocks and how many are already in a draft Purchase Order. We also realized that while they want to see the recommended reorder numbers, they want to edit these numbers based on their knowledge of the stock before adding it to a Purchase Order. Once customers have validated the wireframes, we got to work with the high fidelity designs.

Clicking on each product variant will bring up the following graph. We also explain how we calculate the forecast number

Clicking on Add will create a draft Purchase Order (PO) with the product specified. However, if there is already an existing draft PO from the same supplier to be sent to that location, we consolidate the POs.

Customer can view the list of POs created from forecasting by accessing the Purchase Order tab

That's all Folks!

Back to List of work