Items / FAN-0013
Ceiling Fan 1400mm Prime FAN-0013 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)5MAIN 5
Value (FIFO)555.35avg 111.07
ClassAY / FCV 0.76
Turnover22.3xlast issue 0 days ago
Days of cover6lead time 22d
Reorder suggested: 73 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 | 26.92 / 30.4375 | 0.884 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.49 / 5.517 | 3.714 |
| 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.714^2 + 0.884^2 * 7.4^2) | 37.8 |
| Reorder point | d * LT + safety stock | 0.884 * 21.5 + 37.8 | 56.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 56.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 323/yr, S = 45.00, h = 20%, price = 111.82 | 36.0 |
| Inventory position | on hand + on order | 5 + 0 | 5 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 111.82 | 36 | 36,899 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 22, 2026 | 5 / 80 | 111.07 | 555.35 |
Movement ledger 116 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-261 | MAIN | 1 | 111.07 | -111.07 | 5 | 555.35 | July 22, 2026: 1 @ 111.07 |
| Oct. 15, 2026 | issue | SO-261015-671 | MAIN | 1 | 111.07 | -111.07 | 6 | 666.42 | July 22, 2026: 1 @ 111.07 |
| Oct. 14, 2026 | issue | SO-261014-657 | MAIN | 2 | 111.07 | -222.14 | 7 | 777.49 | July 22, 2026: 2 @ 111.07 |
| Oct. 13, 2026 | issue | SO-261013-458 | MAIN | 1 | 111.07 | -111.07 | 9 | 999.64 | July 22, 2026: 1 @ 111.07 |
| Oct. 12, 2026 | issue | SO-261012-772 | MAIN | 11 | 111.07 | -1,221.78 | 10 | 1,110.71 | July 22, 2026: 11 @ 111.07 |
| Oct. 10, 2026 | issue | SO-261010-796 | MAIN | 2 | 111.07 | -222.14 | 21 | 2,332.48 | July 22, 2026: 2 @ 111.07 |
| Sept. 29, 2026 | issue | SO-260929-973 | MAIN | 3 | 111.07 | -333.21 | 23 | 2,554.63 | July 22, 2026: 3 @ 111.07 |
| Sept. 21, 2026 | issue | SO-260921-811 | MAIN | 2 | 111.07 | -222.14 | 26 | 2,887.84 | July 22, 2026: 2 @ 111.07 |
| Sept. 17, 2026 | issue | SO-260917-945 | MAIN | 2 | 111.07 | -222.14 | 28 | 3,109.98 | July 22, 2026: 2 @ 111.07 |
| Sept. 11, 2026 | issue | SO-260911-984 | MAIN | 3 | 111.07 | -333.21 | 30 | 3,332.12 | July 22, 2026: 3 @ 111.07 |
| Sept. 10, 2026 | issue | SO-260910-366 | MAIN | 1 | 111.07 | -111.07 | 33 | 3,665.33 | July 22, 2026: 1 @ 111.07 |
| Sept. 4, 2026 | issue | SO-260904-202 | MAIN | 7 | 111.07 | -777.49 | 34 | 3,776.40 | July 22, 2026: 7 @ 111.07 |
| Aug. 20, 2026 | issue | SO-260820-128 | MAIN | 13 | 111.07 | -1,443.92 | 41 | 4,553.90 | July 22, 2026: 13 @ 111.07 |
| Aug. 9, 2026 | issue | SO-260809-210 | MAIN | 16 | 111.07 | -1,777.13 | 54 | 5,997.82 | July 22, 2026: 16 @ 111.07 |
| Aug. 6, 2026 | issue | SO-260806-235 | MAIN | 2 | 111.07 | -222.14 | 70 | 7,774.95 | July 22, 2026: 2 @ 111.07 |
| Aug. 2, 2026 | issue | SO-260802-834 | MAIN | 3 | 111.07 | -333.21 | 72 | 7,997.09 | July 22, 2026: 3 @ 111.07 |
| July 25, 2026 | issue | SO-260725-853 | MAIN | 46 | 108.78 | -5,004.08 | 75 | 8,330.30 | May 19, 2026: 40 @ 108.51; June 25, 2026: 1 @ 108.51; July 22, 2026: 5 @ 111.07 |
| July 22, 2026 | receipt | PO-001661 | MAIN | 80 | 111.07 | 8,885.66 | 121 | 13,334.39 | |
| July 5, 2026 | issue | SO-260705-919 | MAIN | 6 | 108.51 | -651.03 | 41 | 4,448.73 | May 19, 2026: 6 @ 108.51 |
| June 30, 2026 | issue | SO-260630-622 | MAIN | 8 | 108.51 | -868.04 | 47 | 5,099.76 | May 19, 2026: 8 @ 108.51 |
| June 25, 2026 | return | RMA | MAIN | 1 | 108.51 | 108.51 | 55 | 5,967.81 | |
| June 25, 2026 | issue | SO-260625-644 | MAIN | 20 | 108.51 | -2,170.11 | 54 | 5,859.30 | May 19, 2026: 20 @ 108.51 |
| June 7, 2026 | issue | SO-260607-990 | MAIN | 23 | 108.51 | -2,495.63 | 74 | 8,029.41 | May 19, 2026: 23 @ 108.51 |
| June 5, 2026 | issue | SO-260605-230 | MAIN | 1 | 108.51 | -108.51 | 97 | 10,525.04 | May 19, 2026: 1 @ 108.51 |
| May 25, 2026 | issue | SO-260525-514 | MAIN | 23 | 107.73 | -2,477.75 | 98 | 10,633.55 | April 8, 2026: 18 @ 107.51; May 19, 2026: 5 @ 108.51 |
| May 25, 2026 | issue | SO-260525-514 | EAST | 2 | 107.51 | -215.03 | 121 | 13,111.30 | April 8, 2026: 2 @ 107.51 |
| May 19, 2026 | receipt | PO-001506 | MAIN | 103 | 108.51 | 11,176.08 | 123 | 13,326.33 | |
| May 8, 2026 | issue | SO-260508-629 | MAIN | 21 | 107.51 | -2,257.76 | 20 | 2,150.25 | April 8, 2026: 21 @ 107.51 |
| May 4, 2026 | issue | SO-260504-358 | MAIN | 14 | 107.51 | -1,505.18 | 41 | 4,408.02 | April 8, 2026: 14 @ 107.51 |
| May 1, 2026 | issue | SO-260501-957 | MAIN | 9 | 107.51 | -967.61 | 55 | 5,913.19 | April 8, 2026: 9 @ 107.51 |
| April 26, 2026 | issue | SO-260426-849 | MAIN | 8 | 107.71 | -861.64 | 64 | 6,880.81 | March 6, 2026: 2 @ 108.28; April 8, 2026: 6 @ 107.51 |
| April 24, 2026 | issue | SO-260424-205 | EAST | 22 | 108.28 | -2,382.23 | 72 | 7,742.45 | March 6, 2026: 22 @ 108.28 |
| April 21, 2026 | issue | SO-260421-242 | EAST | 1 | 108.28 | -108.28 | 94 | 10,124.68 | March 6, 2026: 1 @ 108.28 |
| April 8, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| April 8, 2026 | receipt | PO-001392 | MAIN | 70 | 107.51 | 7,525.88 | 95 | 10,232.96 | |
| April 3, 2026 | issue | SO-260403-356 | EAST | 6 | 108.28 | -649.70 | 25 | 2,707.08 | March 6, 2026: 6 @ 108.28 |
| March 20, 2026 | issue | SO-260320-301 | MAIN | 7 | 108.28 | -757.98 | 31 | 3,356.78 | March 6, 2026: 7 @ 108.28 |
| March 10, 2026 | issue | SO-260310-226 | EAST | 4 | 108.28 | -433.13 | 38 | 4,114.77 | March 6, 2026: 4 @ 108.28 |
| March 6, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| March 6, 2026 | receipt | PO-001290 | MAIN | 42 | 108.28 | 4,547.90 | 42 | 4,547.90 | |
| March 5, 2026 | issue | SO-260305-596 | MAIN | 9 | 109.25 | -983.23 | 0 | 0.00 | Jan. 22, 2026: 9 @ 109.25 |
| Feb. 22, 2026 | issue | SO-260222-592 | MAIN | 9 | 109.25 | -983.23 | 9 | 983.23 | Jan. 22, 2026: 9 @ 109.25 |
| Feb. 13, 2026 | issue | SO-260213-573 | MAIN | 3 | 109.25 | -327.74 | 18 | 1,966.45 | Jan. 22, 2026: 3 @ 109.25 |
| Jan. 26, 2026 | issue | SO-260126-787 | MAIN | 1 | 105.89 | -105.89 | 21 | 2,294.19 | Oct. 27, 2025: 1 @ 105.89 |
| Jan. 25, 2026 | issue | SO-260125-741 | MAIN | 4 | 105.89 | -423.54 | 22 | 2,400.08 | July 23, 2025: 3 @ 105.89; Oct. 27, 2025: 1 @ 105.89 |
| Jan. 22, 2026 | receipt | PO-001170 | MAIN | 21 | 109.25 | 2,294.19 | 26 | 2,823.62 | |
| Jan. 17, 2026 | issue | SO-260117-242 | MAIN | 1 | 105.89 | -105.89 | 5 | 529.43 | July 23, 2025: 1 @ 105.89 |
| Jan. 10, 2026 | issue | SO-260110-577 | MAIN | 4 | 105.89 | -423.54 | 6 | 635.31 | July 23, 2025: 4 @ 105.89 |
| Jan. 5, 2026 | issue | SO-260105-559 | MAIN | 1 | 105.89 | -105.89 | 10 | 1,058.85 | July 23, 2025: 1 @ 105.89 |
| Jan. 4, 2026 | issue | SO-260104-241 | MAIN | 2 | 105.89 | -211.77 | 11 | 1,164.74 | July 23, 2025: 2 @ 105.89 |
| Dec. 30, 2025 | issue | SO-251230-816 | MAIN | 1 | 105.89 | -105.89 | 13 | 1,376.51 | July 23, 2025: 1 @ 105.89 |
| Dec. 24, 2025 | issue | SO-251224-108 | MAIN | 2 | 105.89 | -211.77 | 14 | 1,482.40 | July 23, 2025: 2 @ 105.89 |
| Dec. 20, 2025 | issue | SO-251220-653 | MAIN | 1 | 105.89 | -105.89 | 16 | 1,694.17 | July 23, 2025: 1 @ 105.89 |
| Dec. 7, 2025 | issue | SO-251207-340 | MAIN | 1 | 105.89 | -105.89 | 17 | 1,800.05 | July 23, 2025: 1 @ 105.89 |
| Nov. 6, 2025 | issue | SO-251106-992 | MAIN | 1 | 105.89 | -105.89 | 18 | 1,905.94 | July 23, 2025: 1 @ 105.89 |
| Nov. 2, 2025 | issue | SO-251102-181 | MAIN | 3 | 105.89 | -317.66 | 19 | 2,011.82 | July 23, 2025: 3 @ 105.89 |
| Oct. 27, 2025 | return | RMA | MAIN | 2 | 105.89 | 211.77 | 22 | 2,329.48 | |
| Oct. 24, 2025 | issue | SO-251024-979 | MAIN | 1 | 105.89 | -105.89 | 20 | 2,117.71 | July 23, 2025: 1 @ 105.89 |
| Oct. 22, 2025 | issue | SO-251022-250 | MAIN | 5 | 105.89 | -529.43 | 21 | 2,223.59 | July 23, 2025: 5 @ 105.89 |
| Oct. 3, 2025 | issue | SO-251003-130 | MAIN | 4 | 105.89 | -423.54 | 26 | 2,753.02 | July 23, 2025: 4 @ 105.89 |