Cost Guide in Foodics Console

Costs of items and products in Foodics Console appear in multiple locations, each with specific meanings and calculation methods. This article explains the main locations where costs are displayed and how to interpret them.

1. Inventory Levels Report for Items

The cost shown in this report represents the current cost of the item. It is calculated as follows:

• If no branch is selected: The average cost across all branches and warehouses is displayed.
• If a specific branch or warehouse is selected: The cost for the selected branch or warehouse is shown.

Why is this cost important?

• It determines the cost applied when the item is consumed through orders, production, transfers, or wastage.
• The cost is calculated based on the average cost. For example:
  • Purchase of 5 units for 100 SAR.
  • Purchase of 10 units for 120 SAR.
  • Average cost = (100 + 120) ÷ (5 + 10) = 14.67 SAR per unit.

How to understand how this cost was calculated?

• Go to the Inventory History and filter by branch or warehouse.
  
• If the item settings are based on transactional cost (not fixed), the cost is calculated from previous transactions.

2. Product Page

The cost shown on the product page depends on the product settings:

• If the cost is based on ingredients: The cost reflects the current cost of the product's ingredients as an average across all branches and warehouses.
• If the cost is fixed: A fixed cost entered in the product settings is displayed.

What if the cost is unexpectedly high or low?

• Check the cost of the product ingredients.
• Use the Inventory Levels Report to filter by branches and warehouses to identify any issues.
• Adjust the quantities and costs in the relevant branch or warehouse using inventory count and cost adjustment features. (check this Article to give you the correct steps)

3. Item Page

• This page shows the production cost for the item if it is being produced.
• The cost reflects the current average cost of the item's ingredients across all branches and warehouses.
  

Why might this differ from the cost in the Inventory Levels Report?

• The cost in the Inventory Levels Report reflects the average of past production transactions.
• The cost on the Item Page reflects the current cost if the item were to be produced now, based on the current ingredient costs.

4. Sales by Product Page

• This page displays the cost of products that have been sold.
• It is based on the cost at the time of sale and may not match the current product cost displayed on the Product Page or in the Product Cost Report.
  

5. Product Cost Report

• This report shows the average current cost of the product across all branches (if all branches are selected).
• It may differ from the cost on the Product Page, which reflects the average cost across both branches and warehouses.
  

Key Points

• Differences in costs between reports and pages occur due to variations in calculation methods (branches only vs. branches and warehouses).
• To resolve discrepancies, review cost details at the branch or warehouse level.
• Use inventory adjustments or cost modifications to ensure data accuracy.

By following this guide, you can better understand cost calculations in Foodics Console and effectively address any issues.