Inventory Control - Usage Based Template

This Excel inventory template can be used to analyze the profitability of a business by comparing sales to inventory usage. Control inventory by recording stock transactions and measuring sales, cost of sales & gross profits based on any user defined date range. The sum of all stock usage and stock adjustment transactions is used as cost of sales for this purpose.

• Suitable for businesses that requires inventory usage measurement
• Create stock codes for all inventory items
• Record purchases, inventory usage and inventory adjustments
• Inventory valuation on an average cost basis
• Includes stock count feature & calculation of stock count variances
• Automated calculation of theoretical inventory balances
• Includes unique dashboard for analysis of inventory movements
• Analysis of sales, cost of sales and gross profit for any date range