Cost And Management Accounting Formats (AS Level): FIFO Inventory Valuation Table (Perpetual Method) (Copy)
FIFO Inventory Valuation Table (Perpetual Method)
Standard FIFO Inventory Valuation Table (Perpetual – Exam Preferred)
FIFO Inventory Valuation (Perpetual Method)
| Date | Receipts (Units @ Cost) | Issues (Units @ Cost) | Balance (Units @ Cost) |
|---|---|---|---|
| Opening Balance | 100 @ $5 | 100 @ $5 | |
| Purchase | 200 @ $6 | 100 @ $5, 200 @ $6 | |
| Issue | 100 @ $5 | 200 @ $6 | |
| Issue | 50 @ $6 | 150 @ $6 |
- Oldest Inventory Issued First
- Balance Always Shown At Latest Costs
- Inventory Updated After Every Transaction
Written And Compiled By Sir Hunain Zia (AYLOTI), World Record Holder With 154 Total A Grades, 7 Distinctions And 11 World Records For Educate A Change AS Level Accounting Full Scale Course
FIFO Perpetual Table With Amount Column (High-Scoring)
FIFO Inventory Valuation (Perpetual With Values)
| Date | Receipts | Issues | Balance |
|---|---|---|---|
| Units | Units | Units | |
| Opening | 100 @ $5 = 500 | 100 @ $5 = 500 | |
| Purchase | 200 @ $6 = 1,200 | 100 @ $5 = 500200 @ $6 = 1,200 | |
| Issue | 100 @ $5 = 500 | 200 @ $6 = 1,200 | |
| Issue | 50 @ $6 = 300 | 150 @ $6 = 900 |
- Always Show Units And Values
- Issues Must Match Oldest Layer
- Closing Inventory Clearly Visible
FIFO Perpetual With Multiple Purchases And Issues
FIFO Inventory Valuation (Perpetual – Multiple Layers)
| Date | Receipts | Issues | Balance |
|---|---|---|---|
| Opening | 80 @ $4 | 80 @ $4 | |
| Purchase | 120 @ $5 | 80 @ $4, 120 @ $5 | |
| Issue | 80 @ $4 | 120 @ $5 | |
| Purchase | 100 @ $6 | 120 @ $5, 100 @ $6 | |
| Issue | 100 @ $5 | 20 @ $5, 100 @ $6 |
- Multiple Layers Must Be Shown Separately
- Never Average Costs Under FIFO
Written And Compiled By Sir Hunain Zia (AYLOTI), World Record Holder With 154 Total A Grades, 7 Distinctions And 11 World Records For Educate A Change AS Level Accounting Full Scale Course
FIFO Perpetual Table Without Dates (Accepted)
FIFO Inventory Valuation (Perpetual – No Dates)
| Receipts | Issues | Balance |
|---|---|---|
| 100 @ $5 | 100 @ $5 | |
| 200 @ $6 | 100 @ $5, 200 @ $6 | |
| 100 @ $5 | 200 @ $6 | |
| 50 @ $6 | 150 @ $6 |
- Used When Dates Not Given
- Sequence Must Be Logical
Cost Of Goods Issued (COGI) Working (Linked Format)
COGI Calculation (FIFO – Perpetual)
| Issue | Units | Rate | Amount |
|---|---|---|---|
| Issue 1 | 100 | $5 | 500 |
| Issue 2 | 50 | $6 | 300 |
| Total COGI | 800 |
- Total COGI Transferred To Cost Of Sales
- Must Match Issues In Inventory Table
Written And Compiled By Sir Hunain Zia (AYLOTI), World Record Holder With 154 Total A Grades, 7 Distinctions And 11 World Records For Educate A Change AS Level Accounting Full Scale Course
Closing Inventory Valuation (FIFO – Perpetual)
Closing Inventory
| Units | Rate | Amount |
|---|---|---|
| 150 | $6 | 900 |
- Closing Inventory Taken From Final Balance Column
- Shown In Statement Of Financial Position
Presentation Rules For FIFO (Perpetual) – Exam Scoring
- FIFO = Oldest Issued First
- Inventory Updated After Every Transaction
- Separate Cost Layers Clearly
- Units And Values Both Required
- Final Balance Must Be Clear
Written And Compiled By Sir Hunain Zia (AYLOTI), World Record Holder With 154 Total A Grades, 7 Distinctions And 11 World Records For Educate A Change AS Level Accounting Full Scale Course
Common Examiner Errors To Avoid (FIFO Perpetual)
- Issuing Latest Cost Instead Of Oldest
- Mixing Periodic And Perpetual Methods
- Missing Inventory Layers
- Not Updating Balance After Issue
- Incorrect Carry Forward Of Quantities
Compact FIFO Perpetual Template (Emergency)
| Receipts | Issues | Balance |
|---|---|---|
| xxxx @ $x | xxxx @ $x | |
| xxxx @ $x | xxxx @ $x |
One-Glance Exam Template
FIFO Perpetual
Oldest Out First
Update Every Time
