stocksense

Items / TLS-0012

Crimping Tool Pro TLS-0012 · Tools & Testers · ToolMasters Industrial

On hand (EA)4MAIN 4
Value (FIFO)751.48avg 187.87
ClassCY / FCV 0.66
Turnover4.0xlast issue 9 days ago
Days of cover77lead time 5d

Demand and forecast

Monthly demand and forecast for TLS-00120.00.81.72.53.3Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 2.0Nov 24: 3.0Dec 24: 3.0Jan 25: 3.0Feb 25: 0.0Mar 25: 3.0Apr 25: 1.0May 25: 0.0Jun 25: 0.0Jul 25: 0.0Aug 25: 3.0Sep 25: 1.0Oct 25: 2.0Nov 25: 0.0Dec 25: 2.0Jan 26: 2.0Feb 26: 2.0Mar 26: 0.0Apr 26: 3.0May 26: 3.0Jun 26: 2.0Jul 26: 0.0Aug 26: 1.0Sep 26: 2.0

actual forecast 90% prediction interval

No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.

Policy numbers explained

MetricFormulaSubstitutedResult
Daily demand dmonthly mean / 30.43751.58 / 30.43750.052
Daily demand sdmonthly sd / sqrt(30.4375)1.04 / 5.5170.188
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(5.0 * 0.188^2 + 0.052^2 * 1.2^2)0.5
Reorder pointd * LT + safety stock0.052 * 5.0 + 0.50.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days0.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 19/yr, S = 45.00, h = 20%, price = 188.456.7
Inventory positionon hand + on order4 + 04

Price break evaluation (annual cost at each tier's EOQ)

From qtyUnit costOrder qtyAnnual costFeasible
0188.4573,832yes (chosen if cheapest)

MOQ 1, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 24, 20264 / 6187.87751.48

Movement ledger 26 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 7, 2026issueSO-261007-100MAIN 3 187.02-561.064751.48 May 13, 2026: 1 @ 185.32; Sept. 24, 2026: 2 @ 187.87
Sept. 24, 2026receiptPO-001826MAIN 6 187.871,127.2271,312.54
Sept. 19, 2026issueSO-260919-356MAIN 2 185.32-370.641185.32 May 13, 2026: 2 @ 185.32
Aug. 29, 2026issueSO-260829-942MAIN 1 185.32-185.323555.96 May 13, 2026: 1 @ 185.32
June 7, 2026issueSO-260607-180MAIN 2 185.32-370.644741.28 May 13, 2026: 2 @ 185.32
May 13, 2026receiptPO-001489MAIN 6 185.321,111.9261,111.92
May 7, 2026issueSO-260507-694MAIN 3 182.27-546.8200.00 Feb. 12, 2026: 3 @ 182.27
April 7, 2026issueSO-260407-975MAIN 3 182.27-546.823546.82 Feb. 12, 2026: 3 @ 182.27
Feb. 12, 2026receiptPO-001221MAIN 6 182.271,093.6461,093.64
Feb. 10, 2026issueSO-260210-225MAIN 2 175.61-351.2300.00 Oct. 15, 2025: 2 @ 175.61
Jan. 19, 2026issueSO-260119-819MAIN 2 175.61-351.232351.23 Oct. 15, 2025: 2 @ 175.61
Dec. 14, 2025issueSO-251214-457MAIN 2 175.61-351.234702.46 Oct. 15, 2025: 2 @ 175.61
Oct. 15, 2025receiptPO-000921MAIN 6 175.611,053.6961,053.69
Oct. 11, 2025issueSO-251011-405MAIN 2 180.56-361.1100.00 March 24, 2025: 2 @ 180.56
Sept. 14, 2025issueSO-250914-496MAIN 1 180.56-180.562361.11 March 24, 2025: 1 @ 180.56
Aug. 29, 2025issueSO-250829-883MAIN 3 180.56-541.673541.67 March 24, 2025: 3 @ 180.56
April 6, 2025issueSO-250406-896MAIN 1 169.68-169.6861,083.34 Dec. 5, 2024: 1 @ 169.68
March 24, 2025receiptPO-000375MAIN 6 180.561,083.3471,253.01
March 19, 2025issueSO-250319-801MAIN 3 169.68-509.031169.68 Dec. 5, 2024: 3 @ 169.68
Jan. 29, 2025issueSO-250129-941MAIN 3 172.35-517.044678.71 Oct. 31, 2024: 1 @ 177.69; Dec. 5, 2024: 2 @ 169.68
Dec. 5, 2024receiptPO-000080MAIN 6 169.681,018.0671,195.75
Dec. 1, 2024issueSO-241201-431MAIN 3 177.69-533.061177.69 Oct. 31, 2024: 3 @ 177.69
Nov. 13, 2024issueSO-241113-400MAIN 3 178.13-534.404710.74 Oct. 1, 2024: 1 @ 179.03; Oct. 31, 2024: 2 @ 177.69
Oct. 31, 2024receiptPO-000017MAIN 6 177.691,066.1171,245.14
Oct. 26, 2024issueSO-241026-273MAIN 2 179.03-358.061179.03 Oct. 1, 2024: 2 @ 179.03
Oct. 1, 2024receiptPO-000004MAIN 3 179.03537.083537.08