Items / FAN-0003
Ceiling Fan 1400mm Nova FAN-0003 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)4MAIN 4
Value (FIFO)370.90avg 92.73
ClassBY / FCV 0.71
Turnover27.0xlast issue 5 days ago
Days of cover11lead time 22d
Reorder suggested: 26 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 | 10.92 / 30.4375 | 0.359 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 7.71 / 5.517 | 1.397 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(21.5 * 1.397^2 + 0.359^2 * 7.4^2) | 11.5 |
| Reorder point | d * LT + safety stock | 0.359 * 21.5 + 11.5 | 19.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 131/yr, S = 45.00, h = 20%, price = 93.70 | 25.1 |
| Inventory position | on hand + on order | 4 + 0 | 4 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 93.70 | 25 | 12,736 | yes (chosen if cheapest) |
MOQ 5, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 26, 2026 | 4 / 29 | 92.73 | 370.90 |
Movement ledger 105 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-773 | MAIN | 4 | 92.73 | -370.90 | 4 | 370.90 | July 26, 2026: 4 @ 92.73 |
| Oct. 7, 2026 | issue | SO-261007-429 | MAIN | 1 | 92.73 | -92.73 | 8 | 741.81 | July 26, 2026: 1 @ 92.73 |
| Sept. 27, 2026 | issue | SO-260927-589 | MAIN | 2 | 92.73 | -185.45 | 9 | 834.53 | July 26, 2026: 2 @ 92.73 |
| Sept. 25, 2026 | issue | SO-260925-145 | MAIN | 2 | 92.73 | -185.45 | 11 | 1,019.98 | July 26, 2026: 2 @ 92.73 |
| Sept. 17, 2026 | issue | SO-260917-190 | MAIN | 1 | 92.73 | -92.73 | 13 | 1,205.43 | July 26, 2026: 1 @ 92.73 |
| Sept. 12, 2026 | issue | SO-260912-985 | MAIN | 2 | 92.73 | -185.45 | 14 | 1,298.16 | July 26, 2026: 2 @ 92.73 |
| Aug. 31, 2026 | issue | SO-260831-508 | MAIN | 1 | 92.73 | -92.73 | 16 | 1,483.61 | July 26, 2026: 1 @ 92.73 |
| Aug. 30, 2026 | issue | SO-260830-662 | MAIN | 1 | 92.73 | -92.73 | 17 | 1,576.34 | July 26, 2026: 1 @ 92.73 |
| Aug. 29, 2026 | issue | SO-260829-879 | MAIN | 1 | 92.73 | -92.73 | 18 | 1,669.06 | July 26, 2026: 1 @ 92.73 |
| Aug. 22, 2026 | issue | SO-260822-731 | MAIN | 2 | 92.73 | -185.45 | 19 | 1,761.79 | July 26, 2026: 2 @ 92.73 |
| Aug. 13, 2026 | issue | SO-260813-934 | MAIN | 2 | 92.73 | -185.45 | 21 | 1,947.24 | July 26, 2026: 2 @ 92.73 |
| Aug. 11, 2026 | issue | SO-260811-514 | MAIN | 1 | 92.73 | -92.73 | 23 | 2,132.69 | July 26, 2026: 1 @ 92.73 |
| Aug. 2, 2026 | issue | SO-260802-157 | MAIN | 4 | 92.73 | -370.90 | 24 | 2,225.42 | July 26, 2026: 4 @ 92.73 |
| July 31, 2026 | issue | SO-260731-318 | MAIN | 1 | 92.73 | -92.73 | 28 | 2,596.32 | July 26, 2026: 1 @ 92.73 |
| July 26, 2026 | receipt | PO-001675 | MAIN | 29 | 92.73 | 2,689.05 | 29 | 2,689.05 | |
| July 25, 2026 | issue | SO-260725-574 | MAIN | 1 | 90.84 | -90.84 | 0 | 0.00 | May 24, 2026: 1 @ 90.84 |
| July 20, 2026 | issue | SO-260720-441 | MAIN | 4 | 90.84 | -363.35 | 1 | 90.84 | May 24, 2026: 4 @ 90.84 |
| July 17, 2026 | issue | SO-260717-821 | MAIN | 2 | 90.84 | -181.67 | 5 | 454.18 | May 24, 2026: 2 @ 90.84 |
| July 10, 2026 | issue | SO-260710-378 | MAIN | 5 | 90.84 | -454.18 | 7 | 635.85 | May 24, 2026: 5 @ 90.84 |
| July 7, 2026 | issue | SO-260707-648 | MAIN | 1 | 90.84 | -90.84 | 12 | 1,090.04 | May 24, 2026: 1 @ 90.84 |
| June 26, 2026 | issue | SO-260626-729 | MAIN | 7 | 90.84 | -635.85 | 13 | 1,180.87 | May 24, 2026: 7 @ 90.84 |
| June 17, 2026 | issue | SO-260617-792 | MAIN | 5 | 90.84 | -454.18 | 20 | 1,816.73 | May 24, 2026: 5 @ 90.84 |
| June 11, 2026 | issue | SO-260611-941 | MAIN | 11 | 90.84 | -999.20 | 25 | 2,270.91 | May 24, 2026: 11 @ 90.84 |
| June 8, 2026 | issue | SO-260608-632 | MAIN | 3 | 90.84 | -272.51 | 36 | 3,270.11 | May 24, 2026: 3 @ 90.84 |
| June 6, 2026 | issue | SO-260606-315 | MAIN | 1 | 92.86 | -92.86 | 39 | 3,542.62 | April 12, 2026: 1 @ 92.86 |
| June 3, 2026 | issue | SO-260603-892 | MAIN | 4 | 92.86 | -371.44 | 40 | 3,635.47 | April 12, 2026: 4 @ 92.86 |
| May 24, 2026 | receipt | PO-001519 | MAIN | 39 | 90.84 | 3,542.62 | 44 | 4,006.91 | |
| May 23, 2026 | issue | SO-260523-616 | MAIN | 7 | 92.86 | -650.01 | 5 | 464.30 | April 12, 2026: 7 @ 92.86 |
| May 15, 2026 | issue | SO-260515-850 | MAIN | 6 | 92.86 | -557.16 | 12 | 1,114.31 | April 12, 2026: 6 @ 92.86 |
| May 11, 2026 | issue | SO-260511-715 | MAIN | 5 | 92.86 | -464.30 | 18 | 1,671.47 | April 12, 2026: 5 @ 92.86 |
| April 15, 2026 | issue | SO-260415-543 | MAIN | 3 | 92.86 | -278.58 | 23 | 2,135.76 | April 12, 2026: 3 @ 92.86 |
| April 12, 2026 | receipt | PO-001401 | MAIN | 26 | 92.86 | 2,414.34 | 26 | 2,414.34 | |
| April 10, 2026 | issue | SO-260410-724 | MAIN | 11 | 91.92 | -1,011.14 | 0 | 0.00 | March 21, 2026: 11 @ 91.92 |
| April 6, 2026 | issue | SO-260406-824 | MAIN | 1 | 91.92 | -91.92 | 11 | 1,011.14 | March 21, 2026: 1 @ 91.92 |
| March 25, 2026 | issue | SO-260325-581 | MAIN | 1 | 91.92 | -91.92 | 12 | 1,103.06 | March 21, 2026: 1 @ 91.92 |
| March 21, 2026 | issue | SO-260321-668 | MAIN | 8 | 89.65 | -717.21 | 13 | 1,194.98 | Feb. 18, 2026: 5 @ 88.29; March 21, 2026: 3 @ 91.92 |
| March 21, 2026 | receipt | PO-001340 | MAIN | 16 | 91.92 | 1,470.74 | 21 | 1,912.19 | |
| March 12, 2026 | issue | SO-260312-829 | MAIN | 2 | 88.29 | -176.58 | 5 | 441.45 | Feb. 18, 2026: 2 @ 88.29 |
| Feb. 26, 2026 | issue | SO-260226-858 | MAIN | 1 | 88.29 | -88.29 | 7 | 618.03 | Feb. 18, 2026: 1 @ 88.29 |
| Feb. 22, 2026 | issue | SO-260222-895 | MAIN | 1 | 88.29 | -88.29 | 8 | 706.32 | Feb. 18, 2026: 1 @ 88.29 |
| Feb. 18, 2026 | issue | SO-260218-478 | MAIN | 1 | 88.29 | -88.29 | 9 | 794.61 | Feb. 18, 2026: 1 @ 88.29 |
| Feb. 18, 2026 | receipt | PO-001235 | MAIN | 10 | 88.29 | 882.90 | 10 | 882.90 | |
| Feb. 13, 2026 | issue | SO-260213-542 | MAIN | 1 | 89.39 | -89.39 | 0 | 0.00 | Dec. 20, 2025: 1 @ 89.39 |
| Feb. 11, 2026 | issue | SO-260211-242 | MAIN | 1 | 89.39 | -89.39 | 1 | 89.39 | Dec. 20, 2025: 1 @ 89.39 |
| Jan. 28, 2026 | issue | SO-260128-463 | MAIN | 4 | 89.39 | -357.58 | 2 | 178.79 | Dec. 20, 2025: 4 @ 89.39 |
| Jan. 24, 2026 | issue | SO-260124-532 | MAIN | 2 | 89.39 | -178.79 | 6 | 536.36 | Dec. 20, 2025: 2 @ 89.39 |
| Jan. 18, 2026 | issue | SO-260118-532 | MAIN | 1 | 89.07 | -89.07 | 8 | 715.15 | Nov. 23, 2025: 1 @ 89.07 |
| Jan. 8, 2026 | issue | SO-260108-501 | MAIN | 1 | 89.07 | -89.07 | 9 | 804.22 | Nov. 23, 2025: 1 @ 89.07 |
| Dec. 22, 2025 | issue | SO-251222-998 | MAIN | 2 | 89.07 | -178.13 | 10 | 893.28 | Nov. 23, 2025: 2 @ 89.07 |
| Dec. 20, 2025 | receipt | PO-001069 | MAIN | 8 | 89.39 | 715.15 | 12 | 1,071.41 | |
| Dec. 9, 2025 | issue | SO-251209-240 | MAIN | 1 | 89.07 | -89.07 | 4 | 356.26 | Nov. 23, 2025: 1 @ 89.07 |
| Nov. 23, 2025 | receipt | PO-001015 | MAIN | 5 | 89.07 | 445.33 | 5 | 445.33 | |
| Nov. 17, 2025 | issue | SO-251117-720 | MAIN | 1 | 90.51 | -90.51 | 0 | 0.00 | Aug. 9, 2025: 1 @ 90.51 |
| Nov. 4, 2025 | issue | SO-251104-839 | MAIN | 1 | 90.51 | -90.51 | 1 | 90.51 | Aug. 9, 2025: 1 @ 90.51 |
| Nov. 1, 2025 | issue | SO-251101-272 | MAIN | 1 | 90.51 | -90.51 | 2 | 181.02 | Aug. 9, 2025: 1 @ 90.51 |
| Oct. 23, 2025 | issue | SO-251023-747 | MAIN | 2 | 90.51 | -181.02 | 3 | 271.53 | Aug. 9, 2025: 2 @ 90.51 |
| Oct. 22, 2025 | issue | SO-251022-761 | MAIN | 1 | 90.51 | -90.51 | 5 | 452.56 | Aug. 9, 2025: 1 @ 90.51 |
| Oct. 14, 2025 | issue | SO-251014-175 | MAIN | 1 | 90.51 | -90.51 | 6 | 543.07 | Aug. 9, 2025: 1 @ 90.51 |
| Sept. 23, 2025 | issue | SO-250923-565 | MAIN | 2 | 90.51 | -181.02 | 7 | 633.58 | Aug. 9, 2025: 2 @ 90.51 |
| Sept. 21, 2025 | issue | SO-250921-901 | MAIN | 3 | 90.51 | -271.53 | 9 | 814.60 | Aug. 9, 2025: 3 @ 90.51 |
| Sept. 18, 2025 | issue | SO-250918-602 | MAIN | 1 | 90.51 | -90.51 | 12 | 1,086.14 | Aug. 9, 2025: 1 @ 90.51 |
| Sept. 11, 2025 | issue | SO-250911-542 | MAIN | 1 | 90.51 | -90.51 | 13 | 1,176.65 | Aug. 9, 2025: 1 @ 90.51 |
| Aug. 23, 2025 | issue | SO-250823-616 | MAIN | 1 | 90.51 | -90.51 | 14 | 1,267.16 | Aug. 9, 2025: 1 @ 90.51 |
| Aug. 20, 2025 | issue | SO-250820-394 | MAIN | 2 | 90.51 | -181.02 | 15 | 1,357.67 | Aug. 9, 2025: 2 @ 90.51 |
| Aug. 9, 2025 | receipt | PO-000766 | MAIN | 17 | 90.51 | 1,538.69 | 17 | 1,538.69 | |
| July 24, 2025 | issue | SO-250724-545 | MAIN | 9 | 86.83 | -781.43 | 0 | 0.00 | June 2, 2025: 9 @ 86.83 |
| July 17, 2025 | issue | SO-250717-620 | MAIN | 9 | 86.83 | -781.43 | 9 | 781.43 | June 2, 2025: 9 @ 86.83 |
| June 30, 2025 | issue | SO-250630-324 | MAIN | 7 | 86.83 | -607.78 | 18 | 1,562.85 | June 2, 2025: 7 @ 86.83 |
| June 25, 2025 | issue | SO-250625-238 | MAIN | 9 | 86.83 | -781.43 | 25 | 2,170.63 | June 2, 2025: 9 @ 86.83 |
| June 23, 2025 | issue | SO-250623-175 | MAIN | 2 | 86.83 | -173.65 | 34 | 2,952.06 | June 2, 2025: 2 @ 86.83 |
| June 8, 2025 | issue | SO-250608-105 | MAIN | 1 | 86.83 | -86.83 | 36 | 3,125.71 | June 2, 2025: 1 @ 86.83 |
| June 2, 2025 | receipt | PO-000599 | MAIN | 37 | 86.83 | 3,212.53 | 37 | 3,212.53 | |
| May 5, 2025 | issue | SO-250505-390 | EAST | 8 | 86.00 | -688.01 | 0 | 0.00 | April 12, 2025: 8 @ 86.00 |
| May 5, 2025 | issue | SO-250505-390 | MAIN | 5 | 86.00 | -430.01 | 8 | 688.01 | April 12, 2025: 5 @ 86.00 |
| May 4, 2025 | issue | SO-250504-556 | MAIN | 10 | 86.00 | -860.01 | 13 | 1,118.01 | April 12, 2025: 10 @ 86.00 |
| April 27, 2025 | issue | SO-250427-937 | MAIN | 6 | 85.53 | -513.18 | 23 | 1,978.03 | March 14, 2025: 3 @ 85.06; April 12, 2025: 3 @ 86.00 |
| April 14, 2025 | issue | SO-250414-516 | MAIN | 8 | 85.06 | -680.46 | 29 | 2,491.20 | March 14, 2025: 8 @ 85.06 |
| April 12, 2025 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| April 12, 2025 | receipt | PO-000439 | MAIN | 26 | 86.00 | 2,236.03 | 37 | 3,171.66 | |
| March 29, 2025 | issue | SO-250329-115 | MAIN | 1 | 85.06 | -85.06 | 11 | 935.63 | March 14, 2025: 1 @ 85.06 |
| March 22, 2025 | issue | SO-250322-455 | MAIN | 1 | 85.06 | -85.06 | 12 | 1,020.69 | March 14, 2025: 1 @ 85.06 |
| March 19, 2025 | issue | SO-250319-148 | MAIN | 2 | 85.06 | -170.12 | 13 | 1,105.75 | March 14, 2025: 2 @ 85.06 |
| March 15, 2025 | issue | SO-250315-295 | MAIN | 2 | 84.99 | -169.99 | 15 | 1,275.87 | Feb. 3, 2025: 1 @ 84.93; March 14, 2025: 1 @ 85.06 |
| March 15, 2025 | issue | SO-250315-295 | EAST | 3 | 84.93 | -254.79 | 17 | 1,445.85 | Feb. 3, 2025: 3 @ 84.93 |
| March 14, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| March 14, 2025 | receipt | PO-000339 | MAIN | 16 | 85.06 | 1,360.92 | 20 | 1,700.64 | |
| Feb. 27, 2025 | issue | SO-250227-989 | MAIN | 3 | 84.93 | -254.79 | 4 | 339.71 | Feb. 3, 2025: 3 @ 84.93 |
| Feb. 26, 2025 | issue | SO-250226-547 | MAIN | 1 | 84.93 | -84.93 | 7 | 594.50 | Feb. 3, 2025: 1 @ 84.93 |
| Feb. 15, 2025 | issue | SO-250215-354 | MAIN | 3 | 86.29 | -258.87 | 8 | 679.43 | Dec. 8, 2024: 1 @ 89.02; Feb. 3, 2025: 2 @ 84.93 |
| Feb. 13, 2025 | issue | SO-250213-727 | MAIN | 1 | 89.02 | -89.02 | 11 | 938.30 | Oct. 1, 2024: 1 @ 89.02 |
| Feb. 7, 2025 | issue | SO-250207-803 | MAIN | 1 | 89.02 | -89.02 | 12 | 1,027.32 | Oct. 1, 2024: 1 @ 89.02 |
| Feb. 3, 2025 | receipt | PO-000238 | MAIN | 10 | 84.93 | 849.28 | 13 | 1,116.33 | |
| Jan. 16, 2025 | issue | SO-250116-758 | MAIN | 4 | 89.02 | -356.06 | 3 | 267.04 | Oct. 1, 2024: 4 @ 89.02 |
| Jan. 5, 2025 | issue | SO-250105-281 | MAIN | 1 | 89.02 | -89.02 | 7 | 623.10 | Oct. 1, 2024: 1 @ 89.02 |
| Dec. 18, 2024 | issue | SO-241218-795 | MAIN | 1 | 89.02 | -89.02 | 8 | 712.12 | Oct. 1, 2024: 1 @ 89.02 |
| Dec. 10, 2024 | issue | SO-241210-317 | MAIN | 2 | 89.02 | -178.03 | 9 | 801.14 | Oct. 1, 2024: 2 @ 89.02 |
| Dec. 8, 2024 | return | RMA | MAIN | 1 | 89.02 | 89.02 | 11 | 979.16 | |
| Nov. 23, 2024 | issue | SO-241123-218 | MAIN | 1 | 89.02 | -89.02 | 10 | 890.15 | Oct. 1, 2024: 1 @ 89.02 |
| Nov. 15, 2024 | issue | SO-241115-344 | MAIN | 1 | 89.02 | -89.02 | 11 | 979.16 | Oct. 1, 2024: 1 @ 89.02 |
| Oct. 28, 2024 | issue | SO-241028-763 | MAIN | 2 | 89.02 | -178.03 | 12 | 1,068.18 | Oct. 1, 2024: 2 @ 89.02 |
| Oct. 18, 2024 | issue | SO-241018-168 | MAIN | 1 | 89.02 | -89.02 | 14 | 1,246.21 | Oct. 1, 2024: 1 @ 89.02 |
| Oct. 15, 2024 | issue | SO-241015-813 | MAIN | 2 | 89.02 | -178.03 | 15 | 1,335.22 | Oct. 1, 2024: 2 @ 89.02 |
| Oct. 11, 2024 | issue | SO-241011-988 | MAIN | 1 | 89.02 | -89.02 | 17 | 1,513.26 | Oct. 1, 2024: 1 @ 89.02 |
| Oct. 8, 2024 | issue | SO-241008-385 | MAIN | 1 | 89.02 | -89.02 | 18 | 1,602.27 | Oct. 1, 2024: 1 @ 89.02 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 19 | 89.02 | 1,691.28 | 19 | 1,691.28 | |