Wholesaler Inventory Forecasting

To help a sunglasses wholesale manager their inventory better, Tim Gilbert created a web-interface to automatically ingest PDF reports from the manufacturer, pull in order data from a merchant account API, and create adjustable forecasts of demand for each existing product based on its prior performance or for new products based on comparison to similar past released products, and generate suggested weekly orders to maintain an appropriate level of stock to meet expected demand. He also create an exponentially-weight-moving average in order to rank product sales where even top-sellers might not have sales in a given week. Marco created a dashboard to review and amend suggested order quantities.

Historical sales and projections

 

Review of suggested order quantities

 

Moving-average sales ranks