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
| 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 |
| Dec. 21, 2025 | issue | SO-251221-688 | EAST | 1 | 214.35 | -214.35 | 33 | 7,073.65 | Aug. 5, 2025: 1 @ 214.35 |
| Nov. 23, 2025 | issue | SO-251123-418 | MAIN | 1 | 214.35 | -214.35 | 34 | 7,288.00 | Aug. 5, 2025: 1 @ 214.35 |
| Nov. 17, 2025 | issue | SO-251117-780 | MAIN | 3 | 214.35 | -643.06 | 35 | 7,502.35 | Aug. 5, 2025: 3 @ 214.35 |
| Nov. 5, 2025 | issue | SO-251105-669 | EAST | 1 | 214.35 | -214.35 | 38 | 8,145.41 | Aug. 5, 2025: 1 @ 214.35 |
| Oct. 30, 2025 | issue | SO-251030-140 | MAIN | 2 | 214.35 | -428.71 | 39 | 8,359.76 | Aug. 5, 2025: 2 @ 214.35 |
| Oct. 26, 2025 | issue | SO-251026-876 | MAIN | 1 | 214.35 | -214.35 | 41 | 8,788.47 | Aug. 5, 2025: 1 @ 214.35 |
| Oct. 20, 2025 | issue | SO-251020-717 | MAIN | 1 | 214.35 | -214.35 | 42 | 9,002.82 | Aug. 5, 2025: 1 @ 214.35 |
| Oct. 19, 2025 | issue | SO-251019-394 | MAIN | 2 | 214.35 | -428.71 | 43 | 9,217.17 | Aug. 5, 2025: 2 @ 214.35 |
| Oct. 10, 2025 | issue | SO-251010-670 | EAST | 1 | 214.35 | -214.35 | 45 | 9,645.88 | Aug. 5, 2025: 1 @ 214.35 |
| Oct. 3, 2025 | issue | SO-251003-265 | EAST | 3 | 214.35 | -643.06 | 46 | 9,860.23 | Aug. 5, 2025: 3 @ 214.35 |
| Sept. 21, 2025 | issue | SO-250921-297 | MAIN | 8 | 214.35 | -1,714.82 | 49 | 10,503.29 | Aug. 5, 2025: 8 @ 214.35 |
| Sept. 17, 2025 | issue | SO-250917-419 | MAIN | 1 | 214.35 | -214.35 | 57 | 12,218.12 | Aug. 5, 2025: 1 @ 214.35 |
| Sept. 16, 2025 | issue | SO-250916-869 | MAIN | 2 | 214.35 | -428.71 | 58 | 12,432.47 | Aug. 5, 2025: 2 @ 214.35 |
| Sept. 11, 2025 | issue | SO-250911-430 | MAIN | 6 | 214.35 | -1,286.12 | 60 | 12,861.17 | Aug. 5, 2025: 6 @ 214.35 |
| Aug. 26, 2025 | issue | SO-250826-427 | MAIN | 6 | 214.35 | -1,286.12 | 66 | 14,147.29 | Aug. 5, 2025: 6 @ 214.35 |
| Aug. 19, 2025 | issue | SO-250819-393 | MAIN | 1 | 214.35 | -214.35 | 72 | 15,433.41 | Aug. 5, 2025: 1 @ 214.35 |
| Aug. 5, 2025 | transfer | TRF | MAIN → EAST | 21 | warehouse transfer, no cost effect | ||||
| Aug. 5, 2025 | receipt | PO-000759 | MAIN | 73 | 214.35 | 15,647.76 | 73 | 15,647.76 | |
| July 22, 2025 | issue | SO-250722-756 | EAST | 2 | 215.14 | -430.29 | 0 | 0.00 | May 17, 2025: 2 @ 215.14 |
| July 21, 2025 | issue | SO-250721-422 | EAST | 8 | 215.14 | -1,721.14 | 2 | 430.29 | May 17, 2025: 8 @ 215.14 |
| July 14, 2025 | issue | SO-250714-962 | EAST | 20 | 215.14 | -4,302.85 | 10 | 2,151.43 | May 17, 2025: 20 @ 215.14 |
| July 13, 2025 | issue | SO-250713-761 | MAIN | 2 | 215.14 | -430.29 | 30 | 6,454.28 | May 17, 2025: 2 @ 215.14 |
| July 6, 2025 | issue | SO-250706-343 | MAIN | 12 | 215.14 | -2,581.71 | 32 | 6,884.56 | May 17, 2025: 12 @ 215.14 |
| June 22, 2025 | issue | SO-250622-885 | MAIN | 18 | 215.14 | -3,872.57 | 44 | 9,466.27 | May 17, 2025: 18 @ 215.14 |
| June 21, 2025 | issue | SO-250621-295 | MAIN | 1 | 215.14 | -215.14 | 62 | 13,338.84 | May 17, 2025: 1 @ 215.14 |
| June 11, 2025 | issue | SO-250611-676 | EAST | 1 | 215.14 | -215.14 | 63 | 13,553.98 | May 17, 2025: 1 @ 215.14 |
| June 4, 2025 | issue | SO-250604-142 | MAIN | 41 | 214.34 | -8,787.94 | 64 | 13,769.13 | April 2, 2025: 10 @ 211.85; May 17, 2025: 31 @ 215.14 |
| May 24, 2025 | issue | SO-250524-994 | MAIN | 23 | 211.85 | -4,872.61 | 105 | 22,557.07 | April 2, 2025: 23 @ 211.85 |
| May 17, 2025 | transfer | TRF | MAIN → EAST | 31 | warehouse transfer, no cost effect | ||||
| May 17, 2025 | receipt | PO-000542 | MAIN | 95 | 215.14 | 20,438.55 | 128 | 27,429.68 | |
| May 15, 2025 | issue | SO-250515-135 | MAIN | 8 | 211.85 | -1,694.82 | 33 | 6,991.13 | April 2, 2025: 8 @ 211.85 |
| May 4, 2025 | issue | SO-250504-372 | MAIN | 17 | 211.85 | -3,601.49 | 41 | 8,685.95 | April 2, 2025: 17 @ 211.85 |
| April 24, 2025 | issue | SO-250424-667 | MAIN | 3 | 211.85 | -635.56 | 58 | 12,287.44 | April 2, 2025: 3 @ 211.85 |
| April 5, 2025 | issue | SO-250405-791 | MAIN | 25 | 212.59 | -5,314.64 | 61 | 12,923.00 | March 6, 2025: 21 @ 212.73; April 2, 2025: 4 @ 211.85 |
| April 2, 2025 | receipt | PO-000401 | MAIN | 65 | 211.85 | 13,770.41 | 86 | 18,237.64 | |
| March 23, 2025 | issue | SO-250323-373 | MAIN | 5 | 212.73 | -1,063.63 | 21 | 4,467.23 | March 6, 2025: 5 @ 212.73 |
| March 17, 2025 | issue | SO-250317-287 | MAIN | 3 | 212.73 | -638.18 | 26 | 5,530.86 | March 6, 2025: 3 @ 212.73 |
| March 16, 2025 | issue | SO-250316-569 | MAIN | 7 | 212.73 | -1,489.08 | 29 | 6,169.04 | March 6, 2025: 7 @ 212.73 |
| March 12, 2025 | issue | SO-250312-532 | MAIN | 5 | 214.68 | -1,073.41 | 36 | 7,658.11 | Oct. 1, 2024: 2 @ 217.62; March 6, 2025: 3 @ 212.73 |
| March 6, 2025 | receipt | PO-000321 | MAIN | 39 | 212.73 | 8,296.29 | 41 | 8,731.52 | |
| March 5, 2025 | issue | SO-250305-894 | MAIN | 2 | 217.62 | -435.23 | 2 | 435.23 | Oct. 1, 2024: 2 @ 217.62 |
| March 1, 2025 | issue | SO-250301-279 | MAIN | 1 | 217.62 | -217.62 | 4 | 870.47 | Oct. 1, 2024: 1 @ 217.62 |
| Feb. 9, 2025 | issue | SO-250209-168 | MAIN | 1 | 217.62 | -217.62 | 5 | 1,088.08 | Oct. 1, 2024: 1 @ 217.62 |
| Feb. 8, 2025 | issue | SO-250208-502 | MAIN | 10 | 217.62 | -2,176.16 | 6 | 1,305.70 | Oct. 1, 2024: 10 @ 217.62 |
| Jan. 22, 2025 | issue | SO-250122-476 | MAIN | 4 | 217.62 | -870.47 | 16 | 3,481.86 | Oct. 1, 2024: 4 @ 217.62 |
| Jan. 21, 2025 | issue | SO-250121-850 | MAIN | 5 | 217.62 | -1,088.08 | 20 | 4,352.33 | Oct. 1, 2024: 5 @ 217.62 |
| Dec. 22, 2024 | issue | SO-241222-502 | MAIN | 7 | 217.62 | -1,523.32 | 25 | 5,440.41 | Oct. 1, 2024: 7 @ 217.62 |
| Nov. 29, 2024 | issue | SO-241129-976 | MAIN | 2 | 217.62 | -435.23 | 32 | 6,963.73 | Oct. 1, 2024: 2 @ 217.62 |
| Nov. 26, 2024 | issue | SO-241126-933 | MAIN | 2 | 217.62 | -435.23 | 34 | 7,398.96 | Oct. 1, 2024: 2 @ 217.62 |
| Nov. 23, 2024 | issue | SO-241123-754 | MAIN | 1 | 217.62 | -217.62 | 36 | 7,834.19 | Oct. 1, 2024: 1 @ 217.62 |
| Nov. 18, 2024 | issue | SO-241118-433 | MAIN | 1 | 217.62 | -217.62 | 37 | 8,051.81 | Oct. 1, 2024: 1 @ 217.62 |
| Oct. 26, 2024 | issue | SO-241026-904 | MAIN | 2 | 217.62 | -435.23 | 38 | 8,269.43 | Oct. 1, 2024: 2 @ 217.62 |
| Oct. 15, 2024 | issue | SO-241015-717 | MAIN | 3 | 217.62 | -652.85 | 40 | 8,704.66 | Oct. 1, 2024: 3 @ 217.62 |
| Oct. 13, 2024 | issue | SO-241013-124 | MAIN | 4 | 217.62 | -870.47 | 43 | 9,357.51 | Oct. 1, 2024: 4 @ 217.62 |
| Oct. 3, 2024 | issue | SO-241003-977 | MAIN | 1 | 217.62 | -217.62 | 47 | 10,227.98 | Oct. 1, 2024: 1 @ 217.62 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 48 | 217.62 | 10,445.59 | 48 | 10,445.59 | |