Material Valuation — NexavionERP
Inventory/Material Valuation & Cost Management
Ana Kowalski
ana@meridianco.com
Log Out

Material Valuation & Cost Management

One Jamaica book of JMD 112,400,000, with USD equipment shown beside it

Inventory ValueJMD 112,400,000
Jamaica book
Excess & Obsolete ExposureJMD 6,300,000
▼ JMD 400,000 vs last month
Inventory Turns5.8×
▲ 0.2× vs last quarter
Valuation
Jamaica book JMD 112,400,000. USD equipment is listed and is outside that total. ONT Starter Kit 160 × JMD 6,900 = JMD 1,104,000.
0 selected
SKUItemMethodQuantityUnit CostValueVarianceEntity
SKU-ONT-14ONT Starter KitStandard160JMD 6,900JMD 1,104,000JMD 0Seiretsu Jamaica
SKU-FBR-4848-core fiber cableFIFO50 kmJMD 185,000JMD 9,250,000JMD 0Seiretsu Jamaica
SKU-SIM-100SIM Starter PackWeighted Average4,000JMD 420JMD 1,680,000JMD 0Seiretsu LLC
SKU-SPL-1161:8 fiber splitterStandard400JMD 1,250JMD 500,000JMD 18,000Seiretsu Jamaica
SKU-DRP-04Drop cable 2-coreStandard-4JMD 2,400JMD -9,600JMD 0Seiretsu Jamaica
SKU-MIFI-02MiFi hotspotWeighted Average24JMD 3,600JMD 86,400JMD 0Seiretsu Jamaica Seiretsu LLC
SKU-SCR-02Scrap housingsStandard15JMD 300JMD 4,500JMD 0Seiretsu Jamaica
SKU-CPE-09Customer CPEStandard12JMD 0JMD 0JMD 0Seiretsu Jamaica
SKU-HND-08HandsetStandard80USD 128USD 10,240USD 0Seiretsu LLC
SKU-OLT-04OLT line cardStandard6USD 3,100USD 18,600USD 1,200Seiretsu Jamaica
—Other Jamaica stockWeighted Average——JMD 99,784,700JMD 0Seiretsu Jamaica Seiretsu LLC
No records match this filter.
Variance accounting
Posted with the cost books
Purchase Price Variance5100JMD 840,000
Usage Variance5200JMD 210,000
Cost books
Statutory, group and management. Difference is management minus statutory.
ItemStatutoryGroupManagementDifferenceStatusEntity
ONT Starter KitJMD 6,900JMD 6,900JMD 7,140JMD 240ActiveSeiretsu Jamaica
48-core fiber cableJMD 185,000JMD 185,000JMD 191,000JMD 6,000ActiveSeiretsu Jamaica
SIM Starter PackJMD 420JMD 420JMD 455JMD 35ActiveSeiretsu LLC
1:8 fiber splitterJMD 1,250JMD 1,250JMD 1,250JMD 0ActiveSeiretsu Jamaica
HandsetUSD 128USD 128USD 134USD 6ReviewSeiretsu LLC
No records match this filter.
Books
StatutoryOpen
GroupOpen
ManagementReview
Landed cost
GR-220 base JMD 2,220,000 is 12 km at JMD 185,000. Freight, duty, insurance and handling bring landed cost to JMD 2,588,000. GCT at 15% on that base is JMD 333,000 and is not inside the landed cost.
ReceiptItemBase CostFreightDutyInsuranceHandlingLanded CostAllocation Basis
GR-22048-core fiber cableJMD 2,220,000JMD 180,000JMD 120,000JMD 40,000JMD 28,000JMD 2,588,000Value
GR-244ONT Starter KitJMD 207,000JMD 12,000JMD 8,000JMD 3,000JMD 2,400JMD 232,400QuantityAdjusted after receipt
GR-251SIM Starter PackJMD 168,000JMD 22,000JMD 14,000JMD 6,000JMD 4,000JMD 214,000Weight
No records match this filter.
FIFO layers · 48-core fiber cable · Kingston Main Warehouse
Consumed oldest first, in policy order. 15 km plus 25 km is the 40 km on hand. JMD 2,970,000 plus JMD 4,430,000 is JMD 7,400,000.
LayerReceipt DateQuantity RemainingUnit CostValue
L-220-112 Jan 202615 kmJMD 198,000JMD 2,970,000
L-220-203 Mar 202625 kmJMD 177,200JMD 4,430,000
L-18818 Jun 202610 kmJMD 185,000JMD 1,850,000
No records match this filter.
Revaluation
No silent restatement. The entry is the management-book difference of JMD 240 on 160 ONT Starter Kits, JMD 38,400.
Entry No.ItemReasonAmountJournal
RV-18ONT Starter KitRetrospective cost changeJMD 38,400JE-8841
RV-1448-core fiber cableRetrospective cost changeJMD 300,000JE-8790
No records match this filter.
Ageing
Buckets sum to JMD 112,400,000
Turns
Book turns 5.8×
Kingston Main Warehouse6.4×
Montego Bay Depot5.1×
Mandeville Field Store4.6×
Portmore Retail Counter7.2×
Technician Van — Spalding Route9.0×
Value by location
These five locations are the JMD 112,400,000 book
LocationValue
Kingston Main WarehouseJMD 62,400,000
Montego Bay DepotJMD 28,600,000
Mandeville Field StoreJMD 12,200,000
Portmore Retail CounterJMD 6,800,000
Technician Van — Spalding RouteJMD 2,400,000
No records match this filter.
Value by category
Working lots such as ONT Starter Kit sit inside ONTs and CPE
CategoryValue
Fiber and cableJMD 48,600,000
ONTs and CPEJMD 22,800,000
SIM and eSIMJMD 8,400,000
SplittersJMD 6,200,000
OtherJMD 26,400,000
No records match this filter.
Excess and obsolete by location
Exposure JMD 6,300,000
LocationExposure
Kingston Main WarehouseJMD 3,400,000
Montego Bay DepotJMD 1,600,000
Mandeville Field StoreJMD 800,000
Portmore Retail CounterJMD 400,000
Technician Van — Spalding RouteJMD 100,000
No records match this filter.
Excess and obsolete by category
The five categories sum to JMD 6,300,000
CategoryExposure
Fiber and cableJMD 2,800,000
ONTs and CPEJMD 1,500,000
SIM and eSIMJMD 900,000
SplittersJMD 700,000
OtherJMD 400,000
No records match this filter.
Nexavion AI● Online
Ask about anything in Inventory — try: