Items / FAN-0015
Ceiling Fan 1400mm Eco FAN-0015 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)29MAIN 29
Value (FIFO)7,327.66avg 252.68
ClassAY / FCV 0.67
Turnover14.8xlast issue 7 days ago
Days of cover35lead time 22d
Reorder suggested: 23 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 | 25.33 / 30.4375 | 0.832 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.07 / 5.517 | 3.093 |
| 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.093^2 + 0.832^2 * 7.4^2) | 32.0 |
| Reorder point | d * LT + safety stock | 0.832 * 21.5 + 32.0 | 50.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 50.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 304/yr, S = 45.00, h = 20%, price = 262.17 | 22.8 |
| Inventory position | on hand + on order | 29 + 0 | 29 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 262.17 | 23 | 80,842 | yes (chosen if cheapest) |
MOQ 14, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 25, 2026 | 29 / 51 | 252.68 | 7,327.66 |
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. 9, 2026 | issue | SO-261009-366 | MAIN | 9 | 252.68 | -2,274.10 | 29 | 7,327.66 | Aug. 25, 2026: 9 @ 252.68 |
| Oct. 6, 2026 | issue | SO-261006-287 | MAIN | 1 | 252.68 | -252.68 | 38 | 9,601.77 | Aug. 25, 2026: 1 @ 252.68 |
| Sept. 30, 2026 | issue | SO-260930-191 | MAIN | 8 | 252.68 | -2,021.42 | 39 | 9,854.45 | Aug. 25, 2026: 8 @ 252.68 |
| Sept. 26, 2026 | issue | SO-260926-919 | MAIN | 5 | 254.36 | -1,271.78 | 47 | 11,875.87 | June 8, 2026: 1 @ 261.07; Aug. 25, 2026: 4 @ 252.68 |
| Sept. 23, 2026 | issue | SO-260923-836 | EAST | 2 | 261.07 | -522.13 | 52 | 13,147.65 | June 8, 2026: 2 @ 261.07 |
| Sept. 14, 2026 | issue | SO-260914-508 | MAIN | 1 | 261.07 | -261.07 | 54 | 13,669.78 | June 8, 2026: 1 @ 261.07 |
| Sept. 5, 2026 | issue | SO-260905-315 | EAST | 2 | 261.07 | -522.13 | 55 | 13,930.85 | June 8, 2026: 2 @ 261.07 |
| Aug. 31, 2026 | issue | SO-260831-516 | EAST | 7 | 261.07 | -1,827.46 | 57 | 14,452.98 | June 8, 2026: 7 @ 261.07 |
| Aug. 25, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| Aug. 25, 2026 | receipt | PO-001746 | MAIN | 51 | 252.68 | 12,886.58 | 64 | 16,280.45 | |
| Aug. 21, 2026 | issue | SO-260821-241 | MAIN | 2 | 261.07 | -522.13 | 13 | 3,393.86 | June 8, 2026: 2 @ 261.07 |
| Aug. 13, 2026 | issue | SO-260813-230 | MAIN | 8 | 261.07 | -2,088.53 | 15 | 3,916.00 | June 8, 2026: 8 @ 261.07 |
| Aug. 10, 2026 | issue | SO-260810-304 | MAIN | 11 | 261.07 | -2,871.73 | 23 | 6,004.53 | June 8, 2026: 11 @ 261.07 |
| July 26, 2026 | issue | SO-260726-592 | MAIN | 8 | 261.07 | -2,088.53 | 34 | 8,876.26 | June 8, 2026: 8 @ 261.07 |
| July 19, 2026 | issue | SO-260719-198 | MAIN | 8 | 261.07 | -2,088.53 | 42 | 10,964.79 | June 8, 2026: 8 @ 261.07 |
| July 13, 2026 | issue | SO-260713-896 | MAIN | 1 | 261.07 | -261.07 | 50 | 13,053.32 | June 8, 2026: 1 @ 261.07 |
| July 6, 2026 | issue | SO-260706-270 | MAIN | 3 | 261.07 | -783.20 | 51 | 13,314.39 | June 8, 2026: 3 @ 261.07 |
| July 6, 2026 | issue | SO-260706-270 | EAST | 22 | 261.07 | -5,743.46 | 54 | 14,097.59 | June 8, 2026: 22 @ 261.07 |
| July 2, 2026 | issue | SO-260702-415 | MAIN | 4 | 261.07 | -1,044.27 | 76 | 19,841.05 | June 8, 2026: 4 @ 261.07 |
| July 1, 2026 | issue | SO-260701-577 | EAST | 3 | 261.07 | -783.20 | 80 | 20,885.31 | June 8, 2026: 3 @ 261.07 |
| June 25, 2026 | issue | SO-260625-567 | MAIN | 1 | 261.07 | -261.07 | 83 | 21,668.51 | June 8, 2026: 1 @ 261.07 |
| June 19, 2026 | issue | SO-260619-915 | MAIN | 27 | 261.07 | -7,048.79 | 84 | 21,929.58 | June 8, 2026: 27 @ 261.07 |
| June 8, 2026 | transfer | TRF | MAIN → EAST | 25 | warehouse transfer, no cost effect | ||||
| June 8, 2026 | receipt | PO-001559 | MAIN | 111 | 261.07 | 28,978.37 | 111 | 28,978.37 | |
| June 1, 2026 | issue | SO-260601-920 | MAIN | 8 | 263.37 | -2,106.94 | 0 | 0.00 | April 19, 2026: 8 @ 263.37 |
| May 22, 2026 | issue | SO-260522-802 | MAIN | 12 | 263.37 | -3,160.41 | 8 | 2,106.94 | April 19, 2026: 12 @ 263.37 |
| May 17, 2026 | issue | SO-260517-766 | MAIN | 22 | 263.37 | -5,794.09 | 20 | 5,267.35 | April 19, 2026: 22 @ 263.37 |
| May 10, 2026 | issue | SO-260510-309 | MAIN | 7 | 263.37 | -1,843.57 | 42 | 11,061.44 | April 19, 2026: 7 @ 263.37 |
| May 10, 2026 | issue | SO-260510-309 | EAST | 13 | 263.37 | -3,423.78 | 49 | 12,905.01 | April 19, 2026: 13 @ 263.37 |
| April 27, 2026 | issue | SO-260427-172 | EAST | 8 | 263.37 | -2,106.94 | 62 | 16,328.79 | April 19, 2026: 8 @ 263.37 |
| April 21, 2026 | issue | SO-260421-433 | MAIN | 27 | 257.22 | -6,945.01 | 70 | 18,435.73 | Feb. 16, 2026: 20 @ 255.67; Feb. 21, 2026: 1 @ 251.39; April 19, 2026: 6 @ 263.37 |
| April 19, 2026 | transfer | TRF | MAIN → EAST | 21 | warehouse transfer, no cost effect | ||||
| April 19, 2026 | receipt | PO-001423 | MAIN | 76 | 263.37 | 20,015.94 | 97 | 25,380.75 | |
| April 3, 2026 | issue | SO-260403-671 | MAIN | 15 | 255.67 | -3,835.07 | 21 | 5,364.81 | Feb. 16, 2026: 15 @ 255.67 |
| March 25, 2026 | issue | SO-260325-301 | MAIN | 11 | 255.67 | -2,812.38 | 36 | 9,199.88 | Feb. 16, 2026: 11 @ 255.67 |
| March 25, 2026 | issue | SO-260325-301 | EAST | 5 | 251.39 | -1,256.93 | 47 | 12,012.26 | Feb. 1, 2026: 5 @ 251.39 |
| March 18, 2026 | issue | SO-260318-351 | MAIN | 5 | 251.39 | -1,256.93 | 52 | 13,269.19 | Feb. 1, 2026: 5 @ 251.39 |
| Feb. 22, 2026 | issue | SO-260222-107 | MAIN | 3 | 251.39 | -754.16 | 57 | 14,526.11 | Feb. 1, 2026: 3 @ 251.39 |
| Feb. 21, 2026 | return | RMA | MAIN | 1 | 251.39 | 251.39 | 60 | 15,280.27 | |
| Feb. 21, 2026 | issue | SO-260221-757 | MAIN | 2 | 251.39 | -502.77 | 59 | 15,028.88 | Feb. 1, 2026: 2 @ 251.39 |
| Feb. 20, 2026 | issue | SO-260220-671 | MAIN | 1 | 251.39 | -251.39 | 61 | 15,531.65 | Feb. 1, 2026: 1 @ 251.39 |
| Feb. 18, 2026 | issue | SO-260218-338 | MAIN | 1 | 251.39 | -251.39 | 62 | 15,783.04 | Feb. 1, 2026: 1 @ 251.39 |
| Feb. 17, 2026 | issue | SO-260217-935 | EAST | 1 | 251.39 | -251.39 | 63 | 16,034.42 | Feb. 1, 2026: 1 @ 251.39 |
| Feb. 16, 2026 | receipt | PO-001232 | MAIN | 46 | 255.67 | 11,760.88 | 64 | 16,285.81 | |
| Feb. 11, 2026 | issue | SO-260211-374 | MAIN | 3 | 251.39 | -754.16 | 18 | 4,524.93 | Feb. 1, 2026: 3 @ 251.39 |
| Feb. 1, 2026 | issue | SO-260201-567 | MAIN | 2 | 251.39 | -502.77 | 21 | 5,279.09 | Feb. 1, 2026: 2 @ 251.39 |
| Feb. 1, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Feb. 1, 2026 | receipt | PO-001190 | MAIN | 23 | 251.39 | 5,781.86 | 23 | 5,781.86 | |
| Jan. 26, 2026 | issue | SO-260126-796 | MAIN | 3 | 254.55 | -763.66 | 0 | 0.00 | Dec. 13, 2025: 3 @ 254.55 |
| Jan. 24, 2026 | issue | SO-260124-432 | MAIN | 1 | 254.55 | -254.55 | 3 | 763.66 | Dec. 13, 2025: 1 @ 254.55 |
| Jan. 22, 2026 | issue | SO-260122-589 | MAIN | 1 | 254.55 | -254.55 | 4 | 1,018.21 | Dec. 13, 2025: 1 @ 254.55 |
| Jan. 21, 2026 | issue | SO-260121-703 | MAIN | 3 | 254.55 | -763.66 | 5 | 1,272.76 | Dec. 13, 2025: 3 @ 254.55 |
| Jan. 15, 2026 | issue | SO-260115-285 | MAIN | 4 | 254.55 | -1,018.21 | 8 | 2,036.42 | Dec. 13, 2025: 4 @ 254.55 |
| Jan. 5, 2026 | issue | SO-260105-656 | MAIN | 1 | 254.55 | -254.55 | 12 | 3,054.63 | Dec. 13, 2025: 1 @ 254.55 |
| Dec. 30, 2025 | issue | SO-251230-435 | MAIN | 1 | 254.55 | -254.55 | 13 | 3,309.18 | Dec. 13, 2025: 1 @ 254.55 |
| Dec. 13, 2025 | receipt | PO-001048 | MAIN | 14 | 254.55 | 3,563.73 | 14 | 3,563.73 | |
| Dec. 4, 2025 | issue | SO-251204-145 | EAST | 1 | 243.55 | -243.55 | 0 | 0.00 | Aug. 22, 2025: 1 @ 243.55 |
| Dec. 3, 2025 | issue | SO-251203-550 | EAST | 2 | 243.55 | -487.11 | 1 | 243.55 | Aug. 22, 2025: 2 @ 243.55 |
| Nov. 18, 2025 | issue | SO-251118-989 | EAST | 1 | 243.55 | -243.55 | 3 | 730.66 | Aug. 22, 2025: 1 @ 243.55 |
| Nov. 12, 2025 | issue | SO-251112-751 | EAST | 5 | 243.55 | -1,217.76 | 4 | 974.21 | Aug. 22, 2025: 5 @ 243.55 |