Items / FAN-0019
Decorative Ceiling Fan Classic FAN-0019 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)25MAIN 25
Value (FIFO)3,851.94avg 154.08
ClassAY / FCV 0.60
Turnover14.9xlast issue 0 days ago
Days of cover40lead time 22d
Reorder suggested: 26 units (position at or below reorder point: order EOQ), stockout risk low.
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 | 19.00 / 30.4375 | 0.624 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.45 / 5.517 | 2.076 |
| 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 * 2.076^2 + 0.624^2 * 7.4^2) | 21.9 |
| Reorder point | d * LT + safety stock | 0.624 * 21.5 + 21.9 | 35.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 35.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 228/yr, S = 45.00, h = 20%, price = 154.98 | 25.7 |
| Inventory position | on hand + on order | 25 + 0 | 25 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 154.98 | 26 | 36,109 | yes (chosen if cheapest) |
MOQ 11, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 1, 2026 | 17 / 63 | 154.08 | 2,619.32 | |
| Aug. 27, 2026 | 8 / 8 | 154.08 | 1,232.62 |
Movement ledger 119 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-113 | MAIN | 2 | 154.08 | -308.16 | 25 | 3,851.94 | Aug. 1, 2026: 2 @ 154.08 |
| Oct. 15, 2026 | issue | SO-261015-183 | MAIN | 1 | 154.08 | -154.08 | 27 | 4,160.10 | Aug. 1, 2026: 1 @ 154.08 |
| Oct. 1, 2026 | issue | SO-261001-787 | MAIN | 12 | 154.08 | -1,848.93 | 28 | 4,314.18 | Aug. 1, 2026: 12 @ 154.08 |
| Sept. 28, 2026 | issue | SO-260928-795 | MAIN | 2 | 154.08 | -308.16 | 40 | 6,163.11 | Aug. 1, 2026: 2 @ 154.08 |
| Sept. 28, 2026 | issue | SO-260928-795 | EAST | 2 | 154.08 | -308.16 | 42 | 6,471.26 | Aug. 1, 2026: 2 @ 154.08 |
| Sept. 26, 2026 | issue | SO-260926-676 | EAST | 2 | 154.08 | -308.16 | 44 | 6,779.42 | Aug. 1, 2026: 2 @ 154.08 |
| Sept. 14, 2026 | issue | SO-260914-435 | MAIN | 7 | 154.08 | -1,078.54 | 46 | 7,087.57 | Aug. 1, 2026: 7 @ 154.08 |
| Sept. 10, 2026 | issue | SO-260910-266 | EAST | 1 | 154.08 | -154.08 | 53 | 8,166.12 | Aug. 1, 2026: 1 @ 154.08 |
| Aug. 27, 2026 | return | RMA | MAIN | 8 | 154.08 | 1,232.62 | 54 | 8,320.20 | |
| Aug. 20, 2026 | issue | SO-260820-292 | EAST | 16 | 154.08 | -2,465.24 | 46 | 7,087.57 | Aug. 1, 2026: 16 @ 154.08 |
| Aug. 19, 2026 | issue | SO-260819-771 | MAIN | 6 | 153.52 | -921.15 | 62 | 9,552.82 | May 17, 2026: 5 @ 153.41; Aug. 1, 2026: 1 @ 154.08 |
| Aug. 15, 2026 | issue | SO-260815-120 | EAST | 1 | 153.41 | -153.41 | 68 | 10,473.96 | May 17, 2026: 1 @ 153.41 |
| Aug. 1, 2026 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| Aug. 1, 2026 | receipt | PO-001688 | MAIN | 63 | 154.08 | 9,706.90 | 69 | 10,627.38 | |
| July 28, 2026 | issue | SO-260728-712 | EAST | 1 | 153.41 | -153.41 | 6 | 920.48 | May 17, 2026: 1 @ 153.41 |
| July 25, 2026 | issue | SO-260725-833 | EAST | 2 | 153.41 | -306.83 | 7 | 1,073.90 | May 17, 2026: 2 @ 153.41 |
| July 22, 2026 | issue | SO-260722-610 | EAST | 5 | 153.41 | -767.07 | 9 | 1,380.73 | May 17, 2026: 5 @ 153.41 |
| July 14, 2026 | issue | SO-260714-704 | EAST | 10 | 153.41 | -1,534.14 | 14 | 2,147.79 | May 17, 2026: 10 @ 153.41 |
| July 14, 2026 | issue | SO-260714-704 | MAIN | 5 | 153.41 | -767.07 | 24 | 3,681.93 | May 17, 2026: 5 @ 153.41 |
| July 5, 2026 | issue | SO-260705-403 | MAIN | 2 | 153.41 | -306.83 | 29 | 4,449.00 | May 17, 2026: 2 @ 153.41 |
| July 2, 2026 | issue | SO-260702-172 | MAIN | 8 | 153.41 | -1,227.31 | 31 | 4,755.83 | May 17, 2026: 8 @ 153.41 |
| June 21, 2026 | issue | SO-260621-613 | MAIN | 40 | 153.41 | -6,136.56 | 39 | 5,983.14 | May 17, 2026: 40 @ 153.41 |
| June 14, 2026 | issue | SO-260614-497 | MAIN | 1 | 153.41 | -153.41 | 79 | 12,119.70 | May 17, 2026: 1 @ 153.41 |
| May 27, 2026 | issue | SO-260527-170 | EAST | 1 | 153.41 | -153.41 | 80 | 12,273.11 | May 17, 2026: 1 @ 153.41 |
| May 26, 2026 | issue | SO-260526-276 | MAIN | 2 | 151.17 | -302.33 | 81 | 12,426.53 | April 2, 2026: 1 @ 148.92; May 17, 2026: 1 @ 153.41 |
| May 19, 2026 | issue | SO-260519-774 | MAIN | 14 | 154.53 | -2,163.47 | 83 | 12,728.86 | March 30, 2026: 14 @ 154.53 |
| May 17, 2026 | transfer | TRF | MAIN → EAST | 25 | warehouse transfer, no cost effect | ||||
| May 17, 2026 | receipt | PO-001502 | MAIN | 82 | 153.41 | 12,579.94 | 97 | 14,892.33 | |
| May 9, 2026 | issue | SO-260509-659 | MAIN | 1 | 154.53 | -154.53 | 15 | 2,312.39 | March 30, 2026: 1 @ 154.53 |
| May 6, 2026 | issue | SO-260506-118 | MAIN | 16 | 154.53 | -2,472.54 | 16 | 2,466.93 | March 30, 2026: 16 @ 154.53 |
| April 27, 2026 | issue | SO-260427-723 | MAIN | 5 | 154.53 | -772.67 | 32 | 4,939.47 | March 30, 2026: 5 @ 154.53 |
| April 27, 2026 | issue | SO-260427-723 | EAST | 1 | 154.53 | -154.53 | 37 | 5,712.14 | March 30, 2026: 1 @ 154.53 |
| April 22, 2026 | issue | SO-260422-580 | MAIN | 15 | 154.53 | -2,318.01 | 38 | 5,866.67 | March 30, 2026: 15 @ 154.53 |
| April 13, 2026 | issue | SO-260413-257 | MAIN | 5 | 153.41 | -767.06 | 53 | 8,184.68 | Feb. 25, 2026: 1 @ 148.92; March 30, 2026: 4 @ 154.53 |
| April 12, 2026 | issue | SO-260412-495 | EAST | 1 | 148.92 | -148.92 | 58 | 8,951.73 | Feb. 25, 2026: 1 @ 148.92 |
| April 2, 2026 | return | RMA | MAIN | 1 | 148.92 | 148.92 | 59 | 9,100.65 | |
| March 30, 2026 | receipt | PO-001367 | MAIN | 56 | 154.53 | 8,653.89 | 58 | 8,951.73 | |
| March 29, 2026 | issue | SO-260329-421 | EAST | 2 | 148.92 | -297.84 | 2 | 297.84 | Feb. 25, 2026: 2 @ 148.92 |
| March 29, 2026 | issue | SO-260329-421 | MAIN | 2 | 148.92 | -297.84 | 4 | 595.68 | Feb. 25, 2026: 2 @ 148.92 |
| March 28, 2026 | issue | SO-260328-615 | MAIN | 3 | 148.92 | -446.76 | 6 | 893.52 | Feb. 25, 2026: 3 @ 148.92 |
| March 26, 2026 | issue | SO-260326-856 | MAIN | 8 | 148.92 | -1,191.37 | 9 | 1,340.29 | Feb. 25, 2026: 8 @ 148.92 |
| March 15, 2026 | issue | SO-260315-937 | EAST | 3 | 148.92 | -446.76 | 17 | 2,531.65 | Feb. 25, 2026: 3 @ 148.92 |
| March 14, 2026 | issue | SO-260314-367 | MAIN | 3 | 146.83 | -440.50 | 20 | 2,978.41 | Jan. 21, 2026: 1 @ 145.79; Feb. 9, 2026: 1 @ 145.79; Feb. 25, 2026: 1 @ 148.92 |
| Feb. 25, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Feb. 25, 2026 | receipt | PO-001256 | MAIN | 21 | 148.92 | 3,127.33 | 23 | 3,418.92 | |
| Feb. 17, 2026 | issue | SO-260217-136 | MAIN | 3 | 145.79 | -437.38 | 2 | 291.58 | Jan. 21, 2026: 3 @ 145.79 |
| Feb. 9, 2026 | return | RMA | MAIN | 1 | 145.79 | 145.79 | 5 | 728.96 | |
| Feb. 7, 2026 | issue | SO-260207-957 | MAIN | 5 | 145.79 | -728.96 | 4 | 583.17 | Jan. 21, 2026: 5 @ 145.79 |
| Feb. 5, 2026 | issue | SO-260205-377 | MAIN | 4 | 145.79 | -583.17 | 9 | 1,312.13 | Jan. 21, 2026: 4 @ 145.79 |
| Feb. 2, 2026 | issue | SO-260202-786 | MAIN | 2 | 145.79 | -291.58 | 13 | 1,895.29 | Jan. 21, 2026: 2 @ 145.79 |
| Jan. 23, 2026 | issue | SO-260123-176 | MAIN | 1 | 145.79 | -145.79 | 15 | 2,186.88 | Jan. 21, 2026: 1 @ 145.79 |
| Jan. 22, 2026 | issue | SO-260122-698 | MAIN | 1 | 145.79 | -145.79 | 16 | 2,332.67 | Jan. 21, 2026: 1 @ 145.79 |
| Jan. 21, 2026 | receipt | PO-001166 | MAIN | 17 | 145.79 | 2,478.46 | 17 | 2,478.46 | |
| Jan. 18, 2026 | issue | SO-260118-967 | MAIN | 3 | 150.55 | -451.66 | 0 | 0.00 | Dec. 12, 2025: 3 @ 150.55 |
| Jan. 16, 2026 | issue | SO-260116-100 | MAIN | 1 | 150.55 | -150.55 | 3 | 451.66 | Dec. 12, 2025: 1 @ 150.55 |
| Jan. 9, 2026 | issue | SO-260109-784 | MAIN | 2 | 150.55 | -301.10 | 4 | 602.21 | Dec. 12, 2025: 2 @ 150.55 |
| Jan. 7, 2026 | issue | SO-260107-779 | MAIN | 1 | 150.55 | -150.55 | 6 | 903.31 | Dec. 12, 2025: 1 @ 150.55 |
| Jan. 4, 2026 | issue | SO-260104-961 | MAIN | 1 | 150.55 | -150.55 | 7 | 1,053.86 | Dec. 12, 2025: 1 @ 150.55 |
| Dec. 23, 2025 | issue | SO-251223-631 | MAIN | 3 | 150.55 | -451.66 | 8 | 1,204.41 | Dec. 12, 2025: 3 @ 150.55 |
| Dec. 12, 2025 | receipt | PO-001045 | MAIN | 11 | 150.55 | 1,656.07 | 11 | 1,656.07 | |
| Nov. 24, 2025 | issue | SO-251124-774 | MAIN | 1 | 146.86 | -146.86 | 0 | 0.00 | July 14, 2025: 1 @ 146.86 |
| Nov. 15, 2025 | issue | SO-251115-343 | MAIN | 6 | 146.86 | -881.16 | 1 | 146.86 | July 14, 2025: 6 @ 146.86 |
| Nov. 8, 2025 | issue | SO-251108-303 | MAIN | 1 | 146.86 | -146.86 | 7 | 1,028.02 | July 14, 2025: 1 @ 146.86 |
| Oct. 16, 2025 | issue | SO-251016-440 | MAIN | 2 | 146.86 | -293.72 | 8 | 1,174.88 | July 14, 2025: 2 @ 146.86 |
| Oct. 10, 2025 | issue | SO-251010-521 | MAIN | 4 | 146.86 | -587.44 | 10 | 1,468.61 | July 14, 2025: 4 @ 146.86 |
| Oct. 3, 2025 | issue | SO-251003-462 | MAIN | 4 | 146.86 | -587.44 | 14 | 2,056.05 | July 14, 2025: 4 @ 146.86 |
| Sept. 19, 2025 | issue | SO-250919-311 | MAIN | 4 | 146.86 | -587.44 | 18 | 2,643.49 | July 14, 2025: 4 @ 146.86 |
| Sept. 5, 2025 | issue | SO-250905-889 | MAIN | 4 | 146.86 | -587.44 | 22 | 3,230.93 | July 14, 2025: 4 @ 146.86 |
| Aug. 21, 2025 | issue | SO-250821-971 | MAIN | 2 | 146.86 | -293.72 | 26 | 3,818.38 | July 14, 2025: 2 @ 146.86 |
| Aug. 16, 2025 | issue | SO-250816-355 | MAIN | 1 | 146.86 | -146.86 | 28 | 4,112.10 | July 14, 2025: 1 @ 146.86 |
| Aug. 14, 2025 | issue | SO-250814-935 | MAIN | 6 | 146.86 | -881.16 | 29 | 4,258.96 | July 14, 2025: 6 @ 146.86 |
| Aug. 11, 2025 | issue | SO-250811-300 | MAIN | 1 | 146.86 | -146.86 | 35 | 5,140.12 | July 14, 2025: 1 @ 146.86 |
| Aug. 8, 2025 | issue | SO-250808-413 | MAIN | 5 | 146.86 | -734.30 | 36 | 5,286.98 | July 14, 2025: 5 @ 146.86 |
| Aug. 7, 2025 | issue | SO-250807-888 | MAIN | 1 | 146.86 | -146.86 | 41 | 6,021.28 | July 14, 2025: 1 @ 146.86 |
| Aug. 5, 2025 | issue | SO-250805-964 | MAIN | 1 | 146.86 | -146.86 | 42 | 6,168.15 | July 14, 2025: 1 @ 146.86 |
| July 20, 2025 | issue | SO-250720-715 | MAIN | 29 | 147.08 | -4,265.35 | 43 | 6,315.01 | May 21, 2025: 9 @ 147.57; July 14, 2025: 20 @ 146.86 |
| July 14, 2025 | receipt | PO-000709 | MAIN | 63 | 146.86 | 9,252.22 | 72 | 10,580.35 | |
| July 2, 2025 | issue | SO-250702-973 | MAIN | 7 | 147.57 | -1,032.99 | 9 | 1,328.13 | May 21, 2025: 7 @ 147.57 |
| June 27, 2025 | issue | SO-250627-877 | EAST | 1 | 147.57 | -147.57 | 16 | 2,361.13 | May 21, 2025: 1 @ 147.57 |
| June 23, 2025 | issue | SO-250623-864 | MAIN | 2 | 147.57 | -295.14 | 17 | 2,508.70 | May 21, 2025: 2 @ 147.57 |
| June 21, 2025 | issue | SO-250621-736 | MAIN | 27 | 147.57 | -3,984.40 | 19 | 2,803.84 | May 21, 2025: 27 @ 147.57 |
| June 16, 2025 | issue | SO-250616-716 | EAST | 24 | 147.57 | -3,541.69 | 46 | 6,788.24 | May 21, 2025: 24 @ 147.57 |
| June 11, 2025 | issue | SO-250611-287 | MAIN | 1 | 147.57 | -147.57 | 70 | 10,329.94 | May 21, 2025: 1 @ 147.57 |
| May 23, 2025 | issue | SO-250523-582 | MAIN | 11 | 147.57 | -1,623.28 | 71 | 10,477.51 | May 21, 2025: 11 @ 147.57 |
| May 21, 2025 | transfer | TRF | MAIN → EAST | 25 | warehouse transfer, no cost effect | ||||
| May 21, 2025 | receipt | PO-000556 | MAIN | 82 | 147.57 | 12,100.78 | 82 | 12,100.78 | |
| May 14, 2025 | issue | SO-250514-198 | MAIN | 26 | 142.08 | -3,694.11 | 0 | 0.00 | April 3, 2025: 26 @ 142.08 |
| May 12, 2025 | issue | SO-250512-803 | MAIN | 3 | 142.08 | -426.24 | 26 | 3,694.11 | April 3, 2025: 3 @ 142.08 |
| May 11, 2025 | issue | SO-250511-361 | MAIN | 14 | 142.08 | -1,989.14 | 29 | 4,120.35 | April 3, 2025: 14 @ 142.08 |
| May 6, 2025 | issue | SO-250506-707 | MAIN | 2 | 142.08 | -284.16 | 43 | 6,109.49 | April 3, 2025: 2 @ 142.08 |
| May 2, 2025 | issue | SO-250502-770 | MAIN | 1 | 142.08 | -142.08 | 45 | 6,393.65 | April 3, 2025: 1 @ 142.08 |
| April 20, 2025 | issue | SO-250420-585 | MAIN | 10 | 142.08 | -1,420.81 | 46 | 6,535.73 | April 3, 2025: 10 @ 142.08 |
| April 10, 2025 | issue | SO-250410-374 | MAIN | 7 | 145.13 | -1,015.92 | 56 | 7,956.54 | Feb. 26, 2025: 6 @ 145.13; March 20, 2025: 1 @ 145.13 |
| April 4, 2025 | issue | SO-250404-374 | MAIN | 13 | 145.13 | -1,886.70 | 63 | 8,972.46 | Feb. 26, 2025: 13 @ 145.13 |
| April 3, 2025 | receipt | PO-000408 | MAIN | 56 | 142.08 | 7,956.54 | 76 | 10,859.16 | |
| March 20, 2025 | return | RMA | MAIN | 1 | 145.13 | 145.13 | 20 | 2,902.62 | |
| March 13, 2025 | issue | SO-250313-421 | MAIN | 4 | 145.13 | -580.52 | 19 | 2,757.49 | Feb. 26, 2025: 4 @ 145.13 |
| March 11, 2025 | issue | SO-250311-661 | MAIN | 2 | 145.13 | -290.26 | 23 | 3,338.01 | Feb. 26, 2025: 2 @ 145.13 |
| March 10, 2025 | issue | SO-250310-155 | MAIN | 2 | 145.13 | -290.26 | 25 | 3,628.28 | Feb. 26, 2025: 2 @ 145.13 |
| March 3, 2025 | issue | SO-250303-324 | MAIN | 7 | 145.13 | -1,015.92 | 27 | 3,918.54 | Feb. 26, 2025: 7 @ 145.13 |
| Feb. 26, 2025 | receipt | PO-000300 | MAIN | 34 | 145.13 | 4,934.45 | 34 | 4,934.45 | |
| Feb. 25, 2025 | issue | SO-250225-774 | EAST | 3 | 147.23 | -441.69 | 0 | 0.00 | Oct. 1, 2024: 3 @ 147.23 |
| Feb. 12, 2025 | issue | SO-250212-338 | EAST | 1 | 147.23 | -147.23 | 3 | 441.69 | Oct. 1, 2024: 1 @ 147.23 |
| Feb. 12, 2025 | issue | SO-250212-338 | MAIN | 8 | 147.23 | -1,177.85 | 4 | 588.92 | Oct. 1, 2024: 8 @ 147.23 |
| Jan. 20, 2025 | issue | SO-250120-555 | MAIN | 2 | 147.23 | -294.46 | 12 | 1,766.77 | Oct. 1, 2024: 2 @ 147.23 |
| Jan. 19, 2025 | issue | SO-250119-372 | MAIN | 6 | 147.23 | -883.39 | 14 | 2,061.23 | Oct. 1, 2024: 6 @ 147.23 |
| Dec. 23, 2024 | issue | SO-241223-291 | MAIN | 3 | 147.23 | -441.69 | 20 | 2,944.62 | Oct. 1, 2024: 3 @ 147.23 |
| Dec. 22, 2024 | issue | SO-241222-249 | MAIN | 1 | 147.23 | -147.23 | 23 | 3,386.31 | Oct. 1, 2024: 1 @ 147.23 |
| Dec. 16, 2024 | issue | SO-241216-435 | EAST | 1 | 147.23 | -147.23 | 24 | 3,533.54 | Oct. 1, 2024: 1 @ 147.23 |
| Dec. 9, 2024 | issue | SO-241209-819 | EAST | 1 | 147.23 | -147.23 | 25 | 3,680.78 | Oct. 1, 2024: 1 @ 147.23 |
| Nov. 20, 2024 | issue | SO-241120-347 | MAIN | 1 | 147.23 | -147.23 | 26 | 3,828.01 | Oct. 1, 2024: 1 @ 147.23 |
| Nov. 16, 2024 | issue | SO-241116-633 | MAIN | 2 | 147.23 | -294.46 | 27 | 3,975.24 | Oct. 1, 2024: 2 @ 147.23 |
| Oct. 22, 2024 | issue | SO-241022-174 | MAIN | 2 | 147.23 | -294.46 | 29 | 4,269.70 | Oct. 1, 2024: 2 @ 147.23 |
| Oct. 19, 2024 | issue | SO-241019-901 | EAST | 4 | 147.23 | -588.92 | 31 | 4,564.16 | Oct. 1, 2024: 4 @ 147.23 |
| Oct. 14, 2024 | issue | SO-241014-772 | MAIN | 2 | 147.23 | -294.46 | 35 | 5,153.08 | Oct. 1, 2024: 2 @ 147.23 |
| Oct. 4, 2024 | issue | SO-241004-633 | MAIN | 2 | 147.23 | -294.46 | 37 | 5,447.55 | Oct. 1, 2024: 2 @ 147.23 |
| Oct. 2, 2024 | issue | SO-241002-908 | MAIN | 2 | 147.23 | -294.46 | 39 | 5,742.01 | Oct. 1, 2024: 2 @ 147.23 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 41 | 147.23 | 6,036.47 | 41 | 6,036.47 | |