stocksense

Items / IND-0005

Contactor 25A Elite IND-0005 · Industrial Controls · Volta Electricals Pvt Ltd

On hand (EA)11MAIN 8, EAST 3
Value (FIFO)1,750.90avg 159.17
ClassBY / FCV 0.82
Turnover7.9xlast issue 21 days ago
Days of cover54lead time 7d

Demand and forecast

Monthly demand and forecast for IND-00050.03.67.210.714.3Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 6.0Nov 24: 0.0Dec 24: 0.0Jan 25: 0.0Feb 25: 10.0Mar 25: 0.0Apr 25: 0.0May 25: 0.0Jun 25: 0.0Jul 25: 4.0Aug 25: 0.0Sep 25: 0.0Oct 25: 6.0Nov 25: 13.0Dec 25: 8.0Jan 26: 0.0Feb 26: 7.0Mar 26: 5.0Apr 26: 0.0May 26: 13.0Jun 26: 0.0Jul 26: 9.0Aug 26: 0.0Sep 26: 13.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.43756.17 / 30.43750.203
Daily demand sdmonthly sd / sqrt(30.4375)5.05 / 5.5170.915
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(7.0 * 0.915^2 + 0.203^2 * 1.5^2)4.0
Reorder pointd * LT + safety stock0.203 * 7.0 + 4.05.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days5.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 74/yr, S = 45.00, h = 20%, price = 162.8414.3
Inventory positionon hand + on order11 + 011

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

From qtyUnit costOrder qtyAnnual costFeasible
0162.841412,507yes (chosen if cheapest)

MOQ 1, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 3, 202611 / 11159.171,750.90

Movement ledger 28 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 3, 2026transferTRFMAIN → EAST 3 warehouse transfer, no cost effect
Oct. 3, 2026receiptPO-001848MAIN 11 159.171,750.90111,750.90
Sept. 25, 2026issueSO-260925-339MAIN 13 158.76-2,063.8900.00 May 10, 2026: 2 @ 160.42; July 11, 2026: 11 @ 158.46
July 11, 2026receiptPO-001642MAIN 11 158.461,743.05132,063.89
July 6, 2026issueSO-260706-844MAIN 6 160.42-962.542320.85 May 10, 2026: 6 @ 160.42
July 6, 2026issueSO-260706-844EAST 3 160.42-481.2781,283.38 May 10, 2026: 3 @ 160.42
May 10, 2026transferTRFMAIN → EAST 3 warehouse transfer, no cost effect
May 10, 2026receiptPO-001481MAIN 11 160.421,764.65111,764.65
May 2, 2026issueSO-260502-626MAIN 13 159.92-2,078.9000.00 Jan. 1, 2026: 2 @ 155.81; March 25, 2026: 11 @ 160.66
March 25, 2026receiptPO-001356MAIN 11 160.661,767.29132,078.90
March 20, 2026issueSO-260320-232MAIN 5 155.81-779.042311.61 Jan. 1, 2026: 5 @ 155.81
Feb. 10, 2026issueSO-260210-894MAIN 7 158.16-1,107.1571,090.65 Nov. 9, 2025: 3 @ 161.31; Jan. 1, 2026: 4 @ 155.81
Jan. 1, 2026receiptPO-001112MAIN 11 155.811,713.88142,197.80
Dec. 25, 2025issueSO-251225-715MAIN 8 161.31-1,290.463483.92 Nov. 9, 2025: 8 @ 161.31
Nov. 9, 2025receiptPO-000990MAIN 11 161.311,774.39111,774.39
Nov. 3, 2025issueSO-251103-722MAIN 9 158.82-1,429.4100.00 Oct. 24, 2025: 9 @ 158.82
Nov. 3, 2025issueSO-251103-722EAST 4 157.02-628.0891,429.41 Feb. 10, 2025: 2 @ 155.22; Oct. 24, 2025: 2 @ 158.82
Oct. 24, 2025transferTRFMAIN → EAST 2 warehouse transfer, no cost effect
Oct. 24, 2025receiptPO-000949MAIN 11 158.821,747.06132,057.49
Oct. 19, 2025issueSO-251019-196EAST 1 155.22-155.222310.44 Feb. 10, 2025: 1 @ 155.22
Oct. 19, 2025issueSO-251019-196MAIN 5 155.22-776.093465.65 Feb. 10, 2025: 5 @ 155.22
July 10, 2025issueSO-250710-593MAIN 4 154.03-616.1281,241.74 Oct. 21, 2024: 1 @ 150.47; Feb. 10, 2025: 3 @ 155.22
Feb. 10, 2025transferTRFMAIN → EAST 3 warehouse transfer, no cost effect
Feb. 10, 2025receiptPO-000257MAIN 11 155.221,707.39121,857.86
Feb. 5, 2025issueSO-250205-449MAIN 10 150.47-1,504.681150.47 Oct. 21, 2024: 10 @ 150.47
Oct. 21, 2024receiptPO-000011MAIN 11 150.471,655.14111,655.14
Oct. 15, 2024issueSO-241015-627MAIN 6 154.70-928.1900.00 Oct. 1, 2024: 6 @ 154.70
Oct. 1, 2024receiptPO-000005MAIN 6 154.70928.196928.19