Items / FAN-0009
Decorative Ceiling Fan Flex FAN-0009 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)34MAIN 34
Value (FIFO)8,447.11avg 248.44
ClassAY / FCV 0.71
Turnover13.5xlast issue 6 days ago
Days of cover49lead time 22d
Reorder suggested: 44 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 | 21.25 / 30.4375 | 0.698 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.14 / 5.517 | 2.745 |
| 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.745^2 + 0.698^2 * 7.4^2) | 28.2 |
| Reorder point | d * LT + safety stock | 0.698 * 21.5 + 28.2 | 43.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 255/yr, S = 45.00, h = 20%, price = 237.11 | 44.0 |
| Inventory position | on hand + on order | 34 + 0 | 34 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 257.73 | 21 | 66,763 | yes |
| 22 | 247.42 | 22 | 64,115 | yes |
| 44 | 237.11 | 44 | 61,726 | yes (chosen if cheapest) |
MOQ 11, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 10, 2026 | 34 / 90 | 248.44 | 8,447.11 |
Movement ledger 128 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-539 | MAIN | 3 | 248.44 | -745.33 | 34 | 8,447.11 | June 10, 2026: 3 @ 248.44 |
| Oct. 7, 2026 | issue | SO-261007-689 | MAIN | 5 | 248.44 | -1,242.22 | 37 | 9,192.44 | June 10, 2026: 5 @ 248.44 |
| Oct. 6, 2026 | issue | SO-261006-575 | MAIN | 1 | 248.44 | -248.44 | 42 | 10,434.66 | June 10, 2026: 1 @ 248.44 |
| Oct. 5, 2026 | issue | SO-261005-745 | MAIN | 1 | 248.44 | -248.44 | 43 | 10,683.10 | June 10, 2026: 1 @ 248.44 |
| Sept. 30, 2026 | issue | SO-260930-915 | MAIN | 1 | 248.44 | -248.44 | 44 | 10,931.55 | June 10, 2026: 1 @ 248.44 |
| Sept. 29, 2026 | issue | SO-260929-818 | MAIN | 6 | 248.44 | -1,490.67 | 45 | 11,179.99 | June 10, 2026: 6 @ 248.44 |
| Sept. 22, 2026 | issue | SO-260922-642 | MAIN | 4 | 248.44 | -993.78 | 51 | 12,670.66 | June 10, 2026: 4 @ 248.44 |
| Sept. 13, 2026 | issue | SO-260913-791 | MAIN | 1 | 248.44 | -248.44 | 55 | 13,664.44 | June 10, 2026: 1 @ 248.44 |
| Sept. 10, 2026 | issue | SO-260910-281 | MAIN | 1 | 248.44 | -248.44 | 56 | 13,912.88 | June 10, 2026: 1 @ 248.44 |
| Sept. 8, 2026 | issue | SO-260908-146 | MAIN | 2 | 248.44 | -496.89 | 57 | 14,161.33 | June 10, 2026: 2 @ 248.44 |
| Sept. 2, 2026 | issue | SO-260902-388 | MAIN | 1 | 248.44 | -248.44 | 59 | 14,658.21 | June 10, 2026: 1 @ 248.44 |
| Aug. 26, 2026 | issue | SO-260826-830 | MAIN | 10 | 248.44 | -2,484.44 | 60 | 14,906.66 | June 10, 2026: 10 @ 248.44 |
| Aug. 15, 2026 | issue | SO-260815-247 | MAIN | 5 | 248.44 | -1,242.22 | 70 | 17,391.10 | June 10, 2026: 5 @ 248.44 |
| Aug. 1, 2026 | issue | SO-260801-119 | MAIN | 3 | 248.44 | -745.33 | 75 | 18,633.32 | June 10, 2026: 3 @ 248.44 |
| July 29, 2026 | issue | SO-260729-605 | MAIN | 2 | 248.44 | -496.89 | 78 | 19,378.66 | June 10, 2026: 2 @ 248.44 |
| July 21, 2026 | issue | SO-260721-219 | MAIN | 7 | 248.44 | -1,739.11 | 80 | 19,875.54 | June 10, 2026: 7 @ 248.44 |
| July 4, 2026 | issue | SO-260704-642 | MAIN | 12 | 253.04 | -3,036.46 | 87 | 21,614.65 | May 14, 2026: 9 @ 254.57; June 10, 2026: 3 @ 248.44 |
| June 23, 2026 | issue | SO-260623-310 | MAIN | 11 | 254.57 | -2,800.27 | 99 | 24,651.12 | May 14, 2026: 11 @ 254.57 |
| June 21, 2026 | issue | SO-260621-426 | MAIN | 23 | 254.57 | -5,855.11 | 110 | 27,451.39 | May 14, 2026: 23 @ 254.57 |
| June 11, 2026 | issue | SO-260611-937 | MAIN | 1 | 254.57 | -254.57 | 133 | 33,306.51 | May 14, 2026: 1 @ 254.57 |
| June 10, 2026 | receipt | PO-001567 | MAIN | 90 | 248.44 | 22,359.99 | 134 | 33,561.08 | |
| June 4, 2026 | issue | SO-260604-979 | MAIN | 1 | 254.57 | -254.57 | 44 | 11,201.09 | May 14, 2026: 1 @ 254.57 |
| June 2, 2026 | issue | SO-260602-966 | MAIN | 20 | 254.57 | -5,091.40 | 45 | 11,455.66 | May 14, 2026: 20 @ 254.57 |
| May 22, 2026 | issue | SO-260522-502 | MAIN | 3 | 254.57 | -763.71 | 65 | 16,547.06 | May 14, 2026: 3 @ 254.57 |
| May 17, 2026 | issue | SO-260517-258 | MAIN | 37 | 256.49 | -9,490.08 | 68 | 17,310.77 | April 4, 2026: 19 @ 258.31; May 14, 2026: 18 @ 254.57 |
| May 14, 2026 | receipt | PO-001492 | MAIN | 86 | 254.57 | 21,893.04 | 105 | 26,800.86 | |
| April 27, 2026 | issue | SO-260427-488 | MAIN | 5 | 258.31 | -1,291.53 | 19 | 4,907.82 | April 4, 2026: 5 @ 258.31 |
| April 27, 2026 | issue | SO-260427-488 | EAST | 3 | 258.31 | -774.92 | 24 | 6,199.35 | April 4, 2026: 3 @ 258.31 |
| April 26, 2026 | issue | SO-260426-778 | MAIN | 8 | 258.31 | -2,066.45 | 27 | 6,974.27 | April 4, 2026: 8 @ 258.31 |
| April 24, 2026 | issue | SO-260424-486 | EAST | 12 | 258.31 | -3,099.67 | 35 | 9,040.72 | April 4, 2026: 12 @ 258.31 |
| April 9, 2026 | issue | SO-260409-925 | MAIN | 12 | 258.31 | -3,099.67 | 47 | 12,140.39 | April 4, 2026: 12 @ 258.31 |
| April 4, 2026 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| April 4, 2026 | receipt | PO-001383 | MAIN | 59 | 258.31 | 15,240.07 | 59 | 15,240.07 | |
| March 14, 2026 | issue | SO-260314-540 | MAIN | 7 | 246.73 | -1,727.12 | 0 | 0.00 | Feb. 13, 2026: 7 @ 246.73 |
| March 12, 2026 | issue | SO-260312-165 | MAIN | 9 | 246.73 | -2,220.58 | 7 | 1,727.12 | Feb. 13, 2026: 9 @ 246.73 |
| March 12, 2026 | issue | SO-260312-165 | EAST | 4 | 246.73 | -986.92 | 16 | 3,947.69 | Feb. 13, 2026: 4 @ 246.73 |
| Feb. 27, 2026 | issue | SO-260227-468 | EAST | 3 | 249.38 | -748.15 | 20 | 4,934.62 | Dec. 30, 2025: 1 @ 254.69; Feb. 13, 2026: 2 @ 246.73 |
| Feb. 22, 2026 | issue | SO-260222-307 | MAIN | 6 | 254.69 | -1,528.15 | 23 | 5,682.77 | Dec. 30, 2025: 6 @ 254.69 |
| Feb. 13, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Feb. 13, 2026 | receipt | PO-001225 | MAIN | 22 | 246.73 | 5,428.08 | 29 | 7,210.93 | |
| Feb. 6, 2026 | issue | SO-260206-144 | MAIN | 1 | 254.69 | -254.69 | 7 | 1,782.85 | Dec. 30, 2025: 1 @ 254.69 |
| Feb. 2, 2026 | issue | SO-260202-677 | MAIN | 2 | 254.69 | -509.38 | 8 | 2,037.54 | Dec. 30, 2025: 2 @ 254.69 |
| Jan. 23, 2026 | issue | SO-260123-787 | MAIN | 1 | 254.69 | -254.69 | 10 | 2,546.92 | Dec. 30, 2025: 1 @ 254.69 |
| Jan. 15, 2026 | issue | SO-260115-885 | MAIN | 1 | 254.69 | -254.69 | 11 | 2,801.62 | Dec. 30, 2025: 1 @ 254.69 |
| Jan. 10, 2026 | issue | SO-260110-630 | MAIN | 2 | 254.69 | -509.38 | 12 | 3,056.31 | Dec. 30, 2025: 2 @ 254.69 |
| Jan. 9, 2026 | issue | SO-260109-891 | MAIN | 6 | 253.56 | -1,521.37 | 14 | 3,565.69 | Nov. 24, 2025: 2 @ 251.30; Dec. 30, 2025: 4 @ 254.69 |
| Jan. 3, 2026 | issue | SO-260103-657 | MAIN | 1 | 251.30 | -251.30 | 20 | 5,087.06 | Nov. 24, 2025: 1 @ 251.30 |
| Dec. 30, 2025 | receipt | PO-001105 | MAIN | 18 | 254.69 | 4,584.46 | 21 | 5,338.36 | |
| Dec. 23, 2025 | issue | SO-251223-344 | MAIN | 1 | 251.30 | -251.30 | 3 | 753.89 | Nov. 24, 2025: 1 @ 251.30 |
| Dec. 13, 2025 | issue | SO-251213-471 | MAIN | 1 | 251.30 | -251.30 | 4 | 1,005.19 | Nov. 24, 2025: 1 @ 251.30 |
| Dec. 10, 2025 | issue | SO-251210-321 | MAIN | 2 | 251.30 | -502.60 | 5 | 1,256.49 | Nov. 24, 2025: 2 @ 251.30 |
| Dec. 5, 2025 | issue | SO-251205-187 | MAIN | 1 | 251.30 | -251.30 | 7 | 1,759.09 | Nov. 24, 2025: 1 @ 251.30 |
| Dec. 2, 2025 | issue | SO-251202-396 | MAIN | 1 | 251.30 | -251.30 | 8 | 2,010.38 | Nov. 24, 2025: 1 @ 251.30 |
| Nov. 29, 2025 | issue | SO-251129-924 | MAIN | 2 | 251.30 | -502.60 | 9 | 2,261.68 | Nov. 24, 2025: 2 @ 251.30 |
| Nov. 24, 2025 | receipt | PO-001018 | MAIN | 11 | 251.30 | 2,764.28 | 11 | 2,764.28 | |
| Nov. 21, 2025 | issue | SO-251121-386 | MAIN | 1 | 243.20 | -243.20 | 0 | 0.00 | Aug. 3, 2025: 1 @ 243.20 |
| Nov. 15, 2025 | issue | SO-251115-480 | MAIN | 1 | 243.20 | -243.20 | 1 | 243.20 | Aug. 3, 2025: 1 @ 243.20 |
| Nov. 12, 2025 | issue | SO-251112-303 | MAIN | 1 | 243.20 | -243.20 | 2 | 486.40 | Aug. 3, 2025: 1 @ 243.20 |
| Nov. 3, 2025 | issue | SO-251103-492 | MAIN | 2 | 243.20 | -486.40 | 3 | 729.59 | Aug. 3, 2025: 2 @ 243.20 |
| Oct. 15, 2025 | issue | SO-251015-169 | MAIN | 5 | 243.20 | -1,215.99 | 5 | 1,215.99 | Aug. 3, 2025: 5 @ 243.20 |