SUNACE
SUNACE
Stock & WIP Valuation Demo July 2026 close · $7.32M
July 2026 close · posted live Mon 3 Aug 2026

Finance

Stock & WIP Valuation

Five inventory control accounts, each agreeing to the item codes and works orders behind it, at any moment you look. Every transaction below was written to the ledger as it happened.

Open the month-end pack

Total inventory on the balance sheet

$7,319,913.33

1310 $3.83M · 1320 $115k · 1330 $2.70M · 1340 $630k · 1350 $42k. Every one of those figures is the sum of rows on this page: 239 item codes across six stock points plus 3 works orders, valued as the transactions were posted.

Basis

Weighted average, picked FIFO

Finished goods

At standard cost from the formulation

Overhead

42% of labour recovery

Posting

At the time of each transaction

Composition

1320 Work in Process Control · $114,562.33

Materials issued, labour and plant recovered, overhead applied at 42%, with the balance broken down by works order.

Materials

$100,323

Labour

$10,028

Overhead

$4,212

Works order Grade Started Planned Materials Labour Overhead In WIP Status
WO-2026-0448 SAK-CZP30
SAK-CZP 30 · Ca/Zn one pack, pressure pipe
31 Jul 2026 12,000 $49,160 $7,284 $3,059 $59,503 Awaiting QC
WO-2026-0449 ACE-CAS10
ACE-CAS 10 · calcium stearate, PVC grade
03 Aug 2026 10,000 $21,876 $2,744 $1,152 $25,772 In process
WO-2026-0450 SAK-CZC60
SAK-CZC 60 · Ca/Zn one pack, 70°C cable insulation
03 Aug 2026 8,000 $29,287 $0 $0 $29,287 Materials issued
1320 Work in Process Control $100,323 $10,028 $4,212 $114,562.33

1310 Raw Materials Control · $3,832,049.40

Everything in the Raw Material Store, at weighted average cost.

FamilyCodesKilogramsValue
Fatty acids 23 199,770 $667,138
Metal bases & oxides 25 166,050 $602,466
Co-stabilisers 23 82,630 $566,793
Lubricants & waxes 15 93,620 $485,621
Antioxidants & phosphites 11 37,510 $332,372
Packaging 8 71,280 $325,188
Fillers & pigments 16 146,560 $300,928
Resins & modifiers 5 21,670 $180,142
Tin intermediates 11 23,200 $176,308
Plasticisers 5 29,500 $98,575
Process chemicals 7 31,270 $96,520
Total 149 903,060 $3,832,049.40

1330 Finished Goods Control · $2,701,121.60

Main Store, the Sydney 3PL and customer consignment, at standard cost.

FamilyCodesKilogramsValue
One-pack PVC stabilisers 46 210,950 $1,158,981
Metallic stearates 15 158,550 $608,495
Impact modifiers & process aids 5 33,100 $302,580
Lubricants & waxes 5 48,050 $209,116
Antioxidants & phosphites 4 13,800 $151,402
Organotin stabilisers 4 6,890 $84,886
Speciality additives 4 16,020 $83,819
Liquid mixed-metal stabilisers 3 9,600 $58,636
UV light stabilisers 3 2,510 $43,207
Total 89 499,470 $2,701,121.60

1340 Goods in Transit · $629,840.00

Paid in full to clear customs and receipted here until it lands, then transferred to the Raw Material Store at full landed cost.

ShipmentSupplierETAGoodsLanded cost
SHP-26-0089
Payable on arrival
KLK OLEO (Malaysia) Sdn Bhd 27 Aug 2026 $208,067 $25,900
SHP-26-0090
Prepaid to release the B/L
Kisuma Chemicals B.V. 19 Aug 2026 $173,455 $9,760
SHP-26-0091
Payable on arrival
IMCD Australia Ltd 06 Aug 2026 $62,400 $1,280
SHP-26-0092
Prepaid to release the B/L
Zibo Xiangrun Chemical Co. Ltd 04 Sep 2026 $205,790 $24,580
SHP-26-0093
Payable on arrival
Songwon Industrial Co. Ltd 11 Sep 2026 $178,281 $10,360
SHP-26-0086
Prepaid to release the B/L
Kaneka Belgium N.V. 28 Jul 2026 $0 $11,260

1350 Quarantined Stock · $42,340.00

Batches that failed release and receipts rejected on incoming inspection. On the balance sheet, but never pickable.

BatchGradeMadeKilogramsValue
B26-0441 SAK-CZB65 30 Jul 2026 1,980 $9,148
B25-0734 SAK-CZP40 03 Aug 2025 11,860 $50,642
B25-0738 SAK-CZC60 01 Aug 2025 7,923 $35,891
B25-0760 ACE-CAS30-FG 25 Sep 2025 3,899 $14,036
B25-0854 ACEFEED-CA20 20 Nov 2025 4,934 $16,825
B25-0884 SAK-ORP22 25 Nov 2025 3,942 $25,978
B25-0892 ACE-MGS20-PH 20 Nov 2025 1,938 $9,438
B25-0923 ACE-CAS30-FG 09 Dec 2025 3,919 $14,108
B26-0061 SAK-CZP35 23 Jan 2026 9,864 $51,983
B26-0284 SAK-CZP40 16 May 2026 11,871 $50,689
B26-0303 ACE-CAS40-C 23 Jun 2026 5,897 $19,873
B26-0311 SAK-CZM15 02 Jun 2026 2,943 $13,332
B26-0386 ACE-CAS40-C 16 Jul 2026 5,901 $19,886
B26-0387 ACE-MGS20-PH 13 Jul 2026 1,943 $9,462

Ledger postings

Written at the instant of the transaction: issuing material, releasing a batch, receipting a purchase order, despatching an order.

Nothing posted yet this session. Release the batch on the QC bench, receipt a purchase order or despatch an order and the journal appears here the moment you do it, with the control accounts above moving with it.