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, latest 60 shown - show all
| 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 |