Q Analytix



a planning tool designed in MS Excel, for businesses that purchase inventory, but do not have the financial resources to purchase SAP, JD Edwards, Movex etc.

Planning Report screen shot

Planning Report - You provide the weekly forecast, and the Planning Report calculates the quantities to purchase, and when to purchase, based on inventory levels and inventory policies.

Planning Report header

Header details - the header contains the product details, master data, inventory levels, and logistic requirements which are used within the planning calculation. These are automatically imported via formulas from the Master Data sheet.

Planning Report body

Main planning table - the Sales Forecast is recorded in weekly buckets, and is used to consume the stock on hand. This provides the Projected Inventory result, as each week, the Sales Forecast continues to consume the stock. When the Projected Inventory is calculated to be below the Safety Stock, a Suggested Purchase is initiated, based on minimum and multiple order quantities.

For more information, please contact on +61 434 677 184

For technical know-how, contact on +61 425 368 156