Skip to main content
All CollectionsInventoryInventory Report
Inventory Forecasting By Using Inventory Days Of
Inventory Forecasting By Using Inventory Days Of

Check how many days the inventory will run out based on average daily sales

Yansen Yulius avatar
Written by Yansen Yulius
Updated yesterday

Inventory forecasting is the process of using past data, trends, and known upcoming events to predict the inventory levels needed for a future period.

When you can view the inventory forecast, you will identify some fast-moving products, and you may need to quickly restock those fast-moving items. A fast-moving product is a good or item that sells quickly and within a short period of time.

If you want to identify which products are fast-moving or to see the inventory forecast on your DealPOS account, you can use Inventory Days Of to analyze when you should restock the product. Inventory days of can analyze how long it takes to sell one product until it is sold out. To learn more details about Days of Inventory, please refer to the guide below.


I. Inventory Days Of From the Product's Menu

Step 1. Click the Product Menu, Select Variants, and then Input the Variant Name.

Days Of Inventory - Product's Menu


Step 2. Click the Days of Tab

Click the Days of Tab


Description Table

Column

Description

Outlet

The outlet name

Available

The total available inventory of the product

(7 Days Sales)

The total sales of the last 7 days

Qty/Day

Average daily sales of the product

Days of

Estimated time until inventory runs out


II. Days Of Inventory For Specific Product

Step 1. Click the Inventory Menu and select the Days Of Tab

A filter will pop up, then set the filter based on your preferences.

Days of Inventory Filter


Description Table

Column

Description

Show Inventory & Sales for Outlet

Select the outlet

Category

Select the product category

Number of Days

Total sales days for the product

Set ROP for Outlet

Select the outlet to set product's ROP


Step 2. Input the Product's Name

Input the Product's Name


Description Table

Column

Value

Description

Products

Set Alat Makan Reguler

Product's name

Code

AM001R

Product's code

Available

70

Total available inventory of the product

Sold/Day

4.6

Average daily sales of the products

Days of

15.217

Estimated time until inventory runs out

Lead Time

Column will only appear if you select an outlet in 'Set ROP for Outlet' filter

Estimated days for product's inventory/stock preparation

ROP

Column will only appear if you select an outlet in 'Set ROP for Outlet' filter

Minimum threshold of product's inventory/stock

Notes:
​1. Sold/day calculation: total of products sold (Daysproduct sales history,) (based on the 'Number of Days' filter column ) divided by the 'Number of Days' filter column.
​2. Days of calculation: number of 'Available' divided by number of 'Sold/Day'.


Step 3. Set the Lead Time and ROP

To set the product's ROP, first select an outlet in the 'Set ROP for Outlet' column in the filter, the Lead Time and ROP columns will then appear.

Selecting Outlet to Set ROP


You can input the Lead Time and then it will automatically calculate the product's ROP, and then you can directly set the product's ROP as well by clicking the 'Save ROP' button.

Set the Lead Time and ROP

Notes:
ROP calculation: Sold/Day multiply by Lead Time.

Go to the Products menu, the product's ROP has been updated.

Product's ROP automatically updated

III. Days Of Inventory For All Products

Step 1. Click the Inventory Menu and then Select the Days Of Tab.

Pop up filter will appear, set the filter based on your preferences.

Days of Inventory Filter


Description Table

Column

Description

Show Inventory & Sales for Outlet

Select the outlet

Category

Select the product category

Number of Days

Total sales days for the product

Set ROP for Outlet

Select the outlet to set product's ROP

Days of Inventory - All Products


Description Table

Column

Value

Description

Products

Set Alat Makan Reguler

Product's name

Code

AM001R

Product's code

Available

70

Total available inventory of the product

Sold/Day

4.6

Average daily sales of the products

Days of

15.217

Estimated time until inventory runs out

Lead Time

Column will only appear if you select an outlet in 'Set ROP for Outlet' filter

Estimated days for product's inventory/stock preparation

ROP

Column will only appear if you select an outlet in 'Set ROP for Outlet' filter

Minimum threshold of product's inventory/stock


Related Articles


DealPOS is an online point-of-sale (POS) application specifically designed for retail businesses in categories like Fashion, Minimarkets, Electronics, Fresh Food, and Building Material Stores.

With DealPOS, you can manage both online and offline store inventory in real-time on a single platform. You can also sell through omnichannel (offline and online) as DealPOS integrates with marketplaces (Shopee, Tokopedia, TikTok Shop, Lazada) and instant web stores (Shopify and WooCommerce).

dealpos-trial-indonesia
Did this answer your question?