QAD 2017 Enterprise Edition > User Guides > Periodic Costing > Periodic Costing Overview > Concepts > Calculation Comparisons
  
Calculation Comparisons
When you use Periodic Costing, the calculation method used for determining the cost of inventory items can have significant effects on related calculations of COGS and gross margin. Examples of each method are provided in the following topics. The data in Example Data applies to each example, to help you to distinguish the calculations:

Example Data
 
Beginning Balance
Qty QOH
Unit Cost
Value
 
200
12
2400
 
 
 
 
Receipts
Qty Received
Unit Cost
Value
May 1
400
13
5200
May 8
300
13.7
4110
May 14
350
14.2
4970
Total Received
1050
13.6
14280
 
 
 
 
Goods for Sale
1250
13.34
16680
 
 
 
 
Issues
Qty Issued
Unit Cost
Value
May 22
-870
 
 
Total Issued
-870
 
 
 
 
 
 
End Balance
QTY OH
Unit Cost
Value
 
380
 
 
WAVG Example

WAVG Example
 
Beginning Balance
Qty QOH
Unit Cost
Value
 
200
12
2400
 
 
 
 
Receipts
Qty Received
Unit Cost
Value
May 1
400
13
5200
May 8
300
13.7
4110
May 14
350
14.2
4970
Total Received
1050
13.6
14280
 
 
 
 
Goods for Sale
1250
13.34
16680
 
 
 
 
Issues
Qty Issued
Unit Cost
Value
May 22
-870
13.34
-11605.8
Total Issued
-870
13.34
-11605.8
 
 
 
 
End Balance
QTY OH
Unit Cost
Value
 
380
13.34
50692
FIFO Theoretical

FIFO Theoretical Example
 
 
Beginning Balance
Qty QOH
Unit Cost
Value
 
200
12
2400
 
 
 
 
Receipts
Qty Received
Unit Cost
Value
May 1
400
13
5200
May 14
300
13.7
4110
May 31
350
14.2
4970
Total Received
1050
13.6
14280
Goods for Sale
1250
13.34
16680
 
 
 
 
Issues
Qty Issued
Unit Cost
Value
May 22
-870
 
-11299
Total Issued
-870
 
-11299
 
 
 
 
End Balance
QTY OH
Unit Cost
Value
 
380
14.16
5381
Beginning Balance
0
12
0
May 1
0
13
0
May 14
30
13.7
411
May 31
350
14.2
4970
FIFO QAD Solution

FIFO QAD Solution
 
Beginning Balance
Qty QOH
Unit Cost
Value
 
200
12
2400
 
 
 
 
Receipts
Qty Received
Unit Cost
Value
May 1
400
13
5200
May 14
300
13.7
4110
May 31
350
14.2
4970
Total Received
1050
13.6
14280
Goods for Sale
1250
13.34
16680
 
 
 
 
Issues
Qty Issued
Unit Cost
Value
May 22
-870
 
-11512
Total Issued
-870
 
-11512
 
 
 
 
End Balance
QTY OH
Unit Cost
Value
 
380
13.6
5168
Beginning Balance
0
12
0
Period Bucket
380
13.6
5168