Inventory Cost Analysis Report

Foodics provides you with different types of analyses to enhance your knowledge of your business operations and to help you make informed decisions. Inventory Cost Analysis report gives insights regarding inventory items with respect to different metrics, such as ideal cost and cost variance.  

1. Click Reports on the side menu.

2. Click Analysis.

3. Click Inventory Cost Analysis button to open the standard report.

Main columns of the Inventory Cost Analysis report are:

• Ideal Cost: Cost of consumption - Cost of return.
• Waste From Order: Cost of the wasted quantities from the cashier (return or void).
• Quantity Adjustment: Cost of deducted quantities from quantity adjustment transaction.
• Count Variance: Cost of inventory count variance.
• Actual Cost: Ideal Cost + Waste + Quantity Adjustment - Count Variance.
• Ideal Percentage: Ideal Cost / Net Sales * 100.
• Actual Percentage: Actual Cost / Net Sales * 100.
• Variance Cost: Actual Cost - Ideal Cost.
• Variance Percentage: Actual % - Ideal % = Variance Cost / Net Sales * 100.
• Diversion: Variance Cost / Ideal Cost * 100.