Balance Ledger Van stock Valuation
Stock value
SAR 1.84M
SKUs
1,842
Below reorder
23
Van stock value
SAR 96K
Stock balance AllBelow reorderZero stock
Part no.DescriptionCategoryOn handReservedAvailableReorder atStatus
13506-0V010Timing chain kitEngine141135OK
04465-33471Front brake pad setBrakes2322110OK
43512-06150Front brake rotorBrakes4225Low
90915-YZZE1Oil filterConsumable128012830OK
08880-83716Engine oil 5W-30 (1L)Consumable6465850OK
87139-0C020Cabin air filterFilters2028Critical
Stock ledger — movements AllIssueReceiptAdjustmentTransfer Olaya — main
DateRefPartMovementQtyBalanceBy
24 Jun 09:40JC-1187Timing chain kitIssue−114M. Salem
24 Jun 08:10GRN-0455Front brake pad setReceipt+2023Stores
23 Jun 16:22ADJ-0091Oil filterAdjust−2128Audit
23 Jun 14:05JC-1184Engine oil 5W-30Issue−664O. Mansour
23 Jun 11:30TRN-0033Front brake rotorTransfer+49Stores
Van stock — mobile technicians
VanTechnicianPart no.DescriptionOn handMin levelValue
Van 01M. Salem90915-YZZE1Oil filter8596.00
Van 01M. Salem08880-83716Engine oil 5W-30 (1L)126264.00
Van 02F. Ahmed04465-33471Front brake pad set32285.00
Van 02F. Ahmed87139-0C020Cabin air filter43120.00
Van stock is replenished via inter-warehouse transfer. Total van stock value: SAR 96,240
Total stock value
SAR 1.84M
At cost (WACC)
Slow-moving items
142
>90 days no movement
Obsolete / write-off
SAR 18,400
Pending approval
Valuation by category
CategorySKUsOn hand qtyValue (SAR)% of total
Engine parts3121,840620,00033.7%
Brakes & suspension2482,100480,00026.1%
Consumables4208,400310,00016.8%
Electrical185640260,00014.1%
Tyres & wheels112180170,0009.2%