本帖最后由 syj 于 11-8-2010 11:36 AM 编辑
Terminology: OI = Opening Inventory CI = Closing Inventory P = Purchase S = Sales B = Balance (Number) = Date of transaction
Example: P3 = Purchase made on 3rdof the month.
Scenario: Scenario 1 = OI and Ponly. Scenario 2 = OI and P.S happens throughout the month. Scenario 3 = OI and P.S happens at the beginning of the month. Scenario 4 = OI and P.S happens at the end of the month.
| FIFO (Perpetual) | LIFO (Perpetual) | | Scenario 1 OI = 200 X RM1 = RM200 P3 = 200 X RM2 = RM400 P18 = 200 X RM3 = RM600 CI = Sum of above = RM1,200 | Scenario 1 OI = 200 X RM1 = RM200 P3 = 200 X RM2 = RM400 P18 = 200 X RM3 = RM600 CI = Sum of above = RM1,200 | | Scenario 2 OI = 200 X RM1 = RM200 S2 = 100 (From OI) B2 = 100 X RM1 = RM100 P3 = 200 X RM2 = RM400 S10 = 100 (From OI) B10 = 200 X RM2 = RM400 P18 = 200 X RM3 = RM600 S25 = 100 (From P3) B25 = 100 X RM2 + 200 X RM3 = RM800 CI = B25 = RM8 00 | Scenario 2 OI = 200 X RM1 = RM200 S2 = 100 (From OI) B2 = 100 X RM1 = RM100 P3 = 200 X RM2 = RM400 S10 = 100 (From P3) B10 = 100 X RM1 + 100 X RM2 = RM300 P18 = 200 X RM3 = RM600 S25 = 100 (From P18) B25 = 100 X RM1 + 100 X RM2 + 100 X RM3 = RM600 CI = B25 = RM600 | | Scenario 3 OI = 200 X RM1 = RM200 S2 = 200 (From OI) B2 = Nil P3 = 200 X RM2 = RM400 S10 = 100 (From P3) B10 = 100 X RM2 = RM200 P18 = 200 X RM3 = RM600 B18 = 100 X RM2 + 200 X RM3 = RM800 CI = B18 = RM800 | Scenario 3 OI = 200 X RM1 = RM200 S2 = 200 (From OI) B2 = Nil P3 = 200 X RM2 = RM400 S10 = 100 (From P3) B10 = 100 X RM2 = RM200 P18 = 200 X RM3 = RM600 B18 = 100 X RM2 + 200 X RM3 = RM800 CI = B18 = RM800 | | Scenario 4 OI = 200 X RM1 = RM200 P3 = 200 X RM2 = RM400 P18 = 200 X RM3 = RM600 S25 = 300 (From OI and P3) B25 = 100 X RM2 + 200 X RM3 = RM800 CI = B25 = RM800 | Scenario 4 OI = 200 X RM1 = RM200 P3 = 200 X RM2 = RM400 P18 = 200 X RM3 = RM600 S25 = 300 (From P18 and P3) B25 = 200 X RM1 + 100 X RM2 = RM400 CI = B25 = RM400 |
| FIFO (Periodic) | LIFO (Periodic) | | CI (Unit) = CI + P – S = 200 + 200 + 200 – 200 – 100 = 300 CI = 200 X RM3 + 100 X RM2 = RM800 | CI (Unit) = CI + P – S = 200 + 200 + 200 – 200 – 100 = 300 CI = 200 X RM1 + 100 X RM2 = RM400 |
|