Items / FAN-0002
Wall Fan 400mm Pro FAN-0002 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)17MAIN 17
Value (FIFO)3,923.36avg 230.79
ClassAY / FCV 0.75
Turnover11.4xlast issue 0 days ago
Days of cover18lead time 22d
Reorder suggested: 52 units (position at or below reorder point: order EOQ), stockout risk high.
Demand and forecast
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 28.33 / 30.4375 | 0.931 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 21.23 / 5.517 | 3.849 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(21.5 * 3.849^2 + 0.931^2 * 7.4^2) | 39.3 |
| Reorder point | d * LT + safety stock | 0.931 * 21.5 + 39.3 | 59.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 59.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 340/yr, S = 45.00, h = 20%, price = 229.07 | 25.8 |
| Inventory position | on hand + on order | 17 + 0 | 17 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 229.07 | 26 | 79,014 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 16, 2026 | 17 / 18 | 230.79 | 3,923.36 |
Movement ledger 116 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-322 | MAIN | 1 | 230.79 | -230.79 | 17 | 3,923.36 | Oct. 16, 2026: 1 @ 230.79 |
| Oct. 16, 2026 | receipt | PO-001885 | MAIN | 18 | 230.79 | 4,154.14 | 18 | 4,154.14 | |
| Oct. 11, 2026 | issue | SO-261011-717 | MAIN | 1 | 225.49 | -225.49 | 0 | 0.00 | July 7, 2026: 1 @ 225.49 |
| Oct. 10, 2026 | issue | SO-261010-763 | MAIN | 2 | 231.09 | -462.18 | 1 | 225.49 | July 7, 2026: 2 @ 231.09 |
| Oct. 9, 2026 | issue | SO-261009-614 | MAIN | 1 | 231.09 | -231.09 | 3 | 687.67 | July 7, 2026: 1 @ 231.09 |
| Oct. 7, 2026 | issue | SO-261007-617 | MAIN | 3 | 231.09 | -693.28 | 4 | 918.76 | July 7, 2026: 3 @ 231.09 |
| Sept. 29, 2026 | issue | SO-260929-206 | MAIN | 2 | 231.09 | -462.18 | 7 | 1,612.04 | July 7, 2026: 2 @ 231.09 |
| Sept. 26, 2026 | issue | SO-260926-935 | MAIN | 2 | 231.09 | -462.18 | 9 | 2,074.22 | July 7, 2026: 2 @ 231.09 |
| Sept. 25, 2026 | issue | SO-260925-753 | MAIN | 5 | 231.09 | -1,155.46 | 11 | 2,536.41 | July 7, 2026: 5 @ 231.09 |
| Sept. 24, 2026 | issue | SO-260924-275 | MAIN | 8 | 231.09 | -1,848.74 | 16 | 3,691.87 | July 7, 2026: 8 @ 231.09 |
| Sept. 17, 2026 | issue | SO-260917-818 | MAIN | 1 | 231.09 | -231.09 | 24 | 5,540.60 | July 7, 2026: 1 @ 231.09 |
| Sept. 13, 2026 | issue | SO-260913-739 | MAIN | 5 | 231.09 | -1,155.46 | 25 | 5,771.69 | July 7, 2026: 5 @ 231.09 |
| Sept. 3, 2026 | issue | SO-260903-926 | MAIN | 1 | 231.09 | -231.09 | 30 | 6,927.15 | July 7, 2026: 1 @ 231.09 |
| Aug. 28, 2026 | issue | SO-260828-433 | MAIN | 5 | 231.09 | -1,155.46 | 31 | 7,158.24 | July 7, 2026: 5 @ 231.09 |
| Aug. 23, 2026 | issue | SO-260823-309 | MAIN | 5 | 231.09 | -1,155.46 | 36 | 8,313.70 | July 7, 2026: 5 @ 231.09 |
| Aug. 21, 2026 | issue | SO-260821-469 | MAIN | 2 | 231.09 | -462.18 | 41 | 9,469.16 | July 7, 2026: 2 @ 231.09 |
| Aug. 8, 2026 | issue | SO-260808-507 | MAIN | 2 | 231.09 | -462.18 | 43 | 9,931.35 | July 7, 2026: 2 @ 231.09 |
| Aug. 5, 2026 | issue | SO-260805-114 | MAIN | 21 | 231.09 | -4,852.93 | 45 | 10,393.53 | July 7, 2026: 21 @ 231.09 |
| July 19, 2026 | issue | SO-260719-658 | MAIN | 8 | 231.09 | -1,848.74 | 66 | 15,246.46 | July 7, 2026: 8 @ 231.09 |
| July 19, 2026 | issue | SO-260719-658 | EAST | 8 | 231.09 | -1,848.74 | 74 | 17,095.20 | July 7, 2026: 8 @ 231.09 |
| July 10, 2026 | issue | SO-260710-970 | MAIN | 14 | 231.09 | -3,235.29 | 82 | 18,943.93 | July 7, 2026: 14 @ 231.09 |
| July 9, 2026 | issue | SO-260709-771 | MAIN | 12 | 227.36 | -2,728.27 | 96 | 22,179.22 | May 21, 2026: 8 @ 225.49; July 7, 2026: 4 @ 231.09 |
| July 7, 2026 | return | RMA | MAIN | 1 | 225.49 | 225.49 | 108 | 24,907.48 | |
| July 7, 2026 | receipt | PO-001629 | MAIN | 99 | 231.09 | 22,878.10 | 107 | 24,682.00 | |
| June 27, 2026 | issue | SO-260627-255 | EAST | 2 | 225.49 | -450.97 | 8 | 1,803.90 | May 21, 2026: 2 @ 225.49 |
| June 26, 2026 | issue | SO-260626-545 | EAST | 15 | 225.49 | -3,382.31 | 10 | 2,254.87 | May 21, 2026: 15 @ 225.49 |
| June 19, 2026 | issue | SO-260619-327 | EAST | 5 | 225.49 | -1,127.44 | 25 | 5,637.18 | May 21, 2026: 5 @ 225.49 |
| June 12, 2026 | issue | SO-260612-775 | MAIN | 18 | 225.49 | -4,058.77 | 30 | 6,764.62 | May 21, 2026: 18 @ 225.49 |
| June 7, 2026 | issue | SO-260607-809 | MAIN | 21 | 225.49 | -4,735.23 | 48 | 10,823.39 | May 21, 2026: 21 @ 225.49 |
| June 2, 2026 | issue | SO-260602-662 | MAIN | 3 | 225.49 | -676.46 | 69 | 15,558.62 | May 21, 2026: 3 @ 225.49 |
| May 28, 2026 | issue | SO-260528-516 | EAST | 3 | 225.49 | -676.46 | 72 | 16,235.09 | May 21, 2026: 3 @ 225.49 |
| May 27, 2026 | issue | SO-260527-873 | MAIN | 20 | 225.49 | -4,509.75 | 75 | 16,911.55 | May 21, 2026: 20 @ 225.49 |
| May 21, 2026 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| May 21, 2026 | receipt | PO-001514 | MAIN | 95 | 225.49 | 21,421.29 | 95 | 21,421.29 | |
| May 3, 2026 | issue | SO-260503-154 | EAST | 2 | 224.20 | -448.40 | 0 | 0.00 | April 14, 2026: 2 @ 224.20 |
| May 3, 2026 | issue | SO-260503-154 | MAIN | 46 | 224.20 | -10,313.25 | 2 | 448.40 | April 14, 2026: 46 @ 224.20 |
| April 25, 2026 | issue | SO-260425-140 | MAIN | 9 | 224.20 | -2,017.81 | 48 | 10,761.65 | April 14, 2026: 9 @ 224.20 |
| April 24, 2026 | issue | SO-260424-742 | MAIN | 15 | 220.78 | -3,311.64 | 57 | 12,779.46 | Feb. 22, 2026: 7 @ 216.86; April 14, 2026: 8 @ 224.20 |
| April 18, 2026 | issue | SO-260418-754 | MAIN | 1 | 216.86 | -216.86 | 72 | 16,091.10 | Feb. 22, 2026: 1 @ 216.86 |
| April 15, 2026 | issue | SO-260415-991 | MAIN | 2 | 216.86 | -433.72 | 73 | 16,307.96 | Feb. 22, 2026: 2 @ 216.86 |
| April 14, 2026 | receipt | PO-001408 | MAIN | 65 | 224.20 | 14,573.06 | 75 | 16,741.68 | |
| April 7, 2026 | issue | SO-260407-882 | EAST | 6 | 216.86 | -1,301.17 | 10 | 2,168.62 | Feb. 22, 2026: 6 @ 216.86 |
| April 2, 2026 | issue | SO-260402-461 | MAIN | 4 | 216.86 | -867.45 | 16 | 3,469.79 | Feb. 22, 2026: 4 @ 216.86 |
| March 25, 2026 | issue | SO-260325-541 | MAIN | 17 | 216.86 | -3,686.65 | 20 | 4,337.23 | Feb. 22, 2026: 17 @ 216.86 |
| March 24, 2026 | issue | SO-260324-859 | EAST | 2 | 216.86 | -433.72 | 37 | 8,023.88 | Feb. 22, 2026: 2 @ 216.86 |
| March 19, 2026 | issue | SO-260319-629 | EAST | 6 | 214.35 | -1,286.12 | 39 | 8,457.60 | Aug. 5, 2025: 6 @ 214.35 |
| Feb. 26, 2026 | issue | SO-260226-690 | MAIN | 2 | 214.35 | -428.71 | 45 | 9,743.72 | Aug. 5, 2025: 2 @ 214.35 |
| Feb. 22, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Feb. 22, 2026 | receipt | PO-001250 | MAIN | 39 | 216.86 | 8,457.60 | 47 | 10,172.43 | |
| Feb. 19, 2026 | issue | SO-260219-356 | EAST | 2 | 214.35 | -428.71 | 8 | 1,714.82 | Aug. 5, 2025: 2 @ 214.35 |
| Feb. 16, 2026 | issue | SO-260216-717 | EAST | 5 | 214.35 | -1,071.76 | 10 | 2,143.53 | Aug. 5, 2025: 5 @ 214.35 |
| Feb. 6, 2026 | issue | SO-260206-804 | EAST | 1 | 214.35 | -214.35 | 15 | 3,215.29 | Aug. 5, 2025: 1 @ 214.35 |
| Feb. 3, 2026 | issue | SO-260203-475 | MAIN | 1 | 214.35 | -214.35 | 16 | 3,429.65 | Aug. 5, 2025: 1 @ 214.35 |
| Feb. 1, 2026 | issue | SO-260201-291 | MAIN | 2 | 214.35 | -428.71 | 17 | 3,644.00 | Aug. 5, 2025: 2 @ 214.35 |
| Jan. 31, 2026 | issue | SO-260131-258 | MAIN | 7 | 214.35 | -1,500.47 | 19 | 4,072.71 | Aug. 5, 2025: 7 @ 214.35 |
| Jan. 16, 2026 | issue | SO-260116-383 | MAIN | 1 | 214.35 | -214.35 | 26 | 5,573.18 | Aug. 5, 2025: 1 @ 214.35 |
| Jan. 5, 2026 | issue | SO-260105-244 | EAST | 1 | 214.35 | -214.35 | 27 | 5,787.53 | Aug. 5, 2025: 1 @ 214.35 |
| Jan. 1, 2026 | issue | SO-260101-357 | MAIN | 2 | 214.35 | -428.71 | 28 | 6,001.88 | Aug. 5, 2025: 2 @ 214.35 |
| Dec. 30, 2025 | issue | SO-251230-935 | EAST | 2 | 214.35 | -428.71 | 30 | 6,430.59 | Aug. 5, 2025: 2 @ 214.35 |
| Dec. 23, 2025 | issue | SO-251223-164 | EAST | 1 | 214.35 | -214.35 | 32 | 6,859.29 | Aug. 5, 2025: 1 @ 214.35 |