Cost And Management Accounting Formats (AS Level): AVCO Inventory Valuation Table (Copy)
AVCO Inventory Valuation Table
Standard AVCO Inventory Valuation Table (Perpetual Method – Exam Preferred)
AVCO Inventory Valuation (Perpetual Method)
| Date | Receipts | Issues | Balance |
|---|---|---|---|
| Units @ Cost | Units @ Cost | Units @ Average Cost | |
| Opening Balance | 100 @ $5 = 500 | 100 @ $5.00 = 500 | |
| Purchase | 200 @ $7 = 1,400 | 300 @ $6.33 = 1,900 | |
| Issue | 150 @ $6.33 = 950 | 150 @ $6.33 = 950 |
- New Average Calculated After Every Purchase
- Same Average Used For All Issues Until Next Purchase
- Inventory Updated After Each 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
AVCO Perpetual Method With Clear Average Working (High-Scoring)
Average Cost Calculation
| Details | Units | Value |
|---|---|---|
| Existing Inventory | 100 | 500 |
| New Purchase | 200 | 1,400 |
| Total | 300 | 1,900 |
Average Cost Per Unit = 1,900 ÷ 300 = $6.33
AVCO Inventory Valuation (Perpetual)
| Date | Receipts | Issues | Balance |
|---|---|---|---|
| 300 @ $6.33 | |||
| Issue | 150 @ $6.33 = 950 | 150 @ $6.33 = 950 |
- Average Must Be Recalculated Only After Purchase
- Do Not Recalculate After Issues
AVCO Perpetual With Multiple Purchases And Issues
AVCO Inventory Valuation (Multiple Layers)
| Date | Receipts | Issues | Balance |
|---|---|---|---|
| Opening | 80 @ $4 = 320 | 80 @ $4.00 | |
| Purchase | 120 @ $6 = 720 | 200 @ $5.20 | |
| Issue | 100 @ $5.20 = 520 | 100 @ $5.20 | |
| Purchase | 100 @ $8 = 800 | 200 @ $6.60 | |
| Issue | 150 @ $6.60 = 990 | 50 @ $6.60 |
- New Average Calculated After Each Purchase
- Same Rate Used For All Issues Until Next Purchase
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
AVCO Inventory Valuation Table (Periodic Method)
AVCO Inventory Valuation (Periodic Method)
| Details | Units | Amount |
|---|---|---|
| Opening Inventory | xxxx | xxxx |
| Purchases | xxxx | xxxx |
| Goods Available For Sale | xxxx | xxxx |
| Average Cost Per Unit | xxxx ÷ xxxx | |
| Closing Inventory | xxxx | xxxx |
- Single Average Calculated At End Of Period
- No Issue Entries Shown
- Closing Inventory And Cost Of Sales Use Same Average
AVCO Periodic Average Cost Working
Average Cost Calculation (Periodic)
| Total Cost Of Goods Available | Total Units Available |
|---|---|
| xxxx | xxxx |
Average Cost Per Unit = Total Cost ÷ Total Units
Cost Of Sales Working (AVCO – Periodic)
Cost Of Sales Calculation
| Details | Amount |
|---|---|
| Goods Available For Sale | xxxx |
| Less: Closing Inventory | (xxxx) |
| Cost Of Sales | xxxx |
- Closing Inventory Taken From AVCO Valuation
- Must Link With 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
AVCO Inventory Valuation Without Dates (Accepted)
AVCO Inventory Valuation (Short Format)
| Receipts | Issues | Balance |
|---|---|---|
| xxxx @ $x | xxxx @ $avg | |
| xxxx @ $avg | xxxx @ $avg |
- Accepted In Short Questions
- Average Must Be Clearly Shown
Presentation Rules For AVCO (Exam Scoring)
- Perpetual: Recalculate Average After Purchases Only
- Periodic: One Average At End Of Period
- Same Average Used For Issues And Closing Inventory
- Show Units And Values
- Round Consistently (2 d.p. If Required)
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 (AVCO)
- Recalculating Average After Issues
- Using FIFO Logic With AVCO
- Mixing Periodic And Perpetual Methods
- Not Showing Average Working
- Using Different Rates For Same Issue
Compact AVCO Inventory Template (Emergency)
Total Cost ÷ Total Units = Average Cost
Issues = Units × Average
Closing Inventory = Units × Average
One-Glance Exam Template
AVCO
Average Cost
Consistent Rate
Clear Working