Items / FAN-0005
Ceiling Fan 1200mm Plus FAN-0005 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)11MAIN 8, EAST 3
Value (FIFO)1,771.29avg 161.03
ClassBY / FCV 0.73
Turnover29.3xlast issue 0 days ago
Days of cover25lead time 22d
Reorder suggested: 22 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 13.50 / 30.4375 | 0.444 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.80 / 5.517 | 1.777 |
| 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.777^2 + 0.444^2 * 7.4^2) | 14.6 |
| Reorder point | d * LT + safety stock | 0.444 * 21.5 + 14.6 | 24.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 24.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 162/yr, S = 45.00, h = 20%, price = 159.12 | 21.4 |
| Inventory position | on hand + on order | 11 + 0 | 11 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 159.12 | 21 | 26,441 | yes (chosen if cheapest) |
MOQ 7, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 6, 2026 | 11 / 39 | 161.03 | 1,771.29 |
Movement ledger 109 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-913 | MAIN | 1 | 161.03 | -161.03 | 11 | 1,771.29 | Aug. 6, 2026: 1 @ 161.03 |
| Oct. 14, 2026 | issue | SO-261014-541 | MAIN | 1 | 161.03 | -161.03 | 12 | 1,932.31 | Aug. 6, 2026: 1 @ 161.03 |
| Oct. 10, 2026 | issue | SO-261010-676 | EAST | 2 | 161.03 | -322.05 | 13 | 2,093.34 | Aug. 6, 2026: 2 @ 161.03 |
| Oct. 7, 2026 | issue | SO-261007-414 | MAIN | 1 | 161.03 | -161.03 | 15 | 2,415.39 | Aug. 6, 2026: 1 @ 161.03 |
| Oct. 3, 2026 | issue | SO-261003-167 | MAIN | 2 | 161.03 | -322.05 | 16 | 2,576.42 | Aug. 6, 2026: 2 @ 161.03 |
| Sept. 16, 2026 | issue | SO-260916-819 | MAIN | 1 | 161.03 | -161.03 | 18 | 2,898.47 | Aug. 6, 2026: 1 @ 161.03 |
| Sept. 4, 2026 | issue | SO-260904-258 | EAST | 8 | 161.03 | -1,288.21 | 19 | 3,059.50 | Aug. 6, 2026: 8 @ 161.03 |
| Aug. 25, 2026 | issue | SO-260825-911 | MAIN | 6 | 161.03 | -966.16 | 27 | 4,347.70 | Aug. 6, 2026: 6 @ 161.03 |
| Aug. 14, 2026 | issue | SO-260814-922 | MAIN | 6 | 161.03 | -966.16 | 33 | 5,313.86 | Aug. 6, 2026: 6 @ 161.03 |
| Aug. 11, 2026 | issue | SO-260811-505 | MAIN | 1 | 152.73 | -152.73 | 39 | 6,280.02 | May 18, 2026: 1 @ 152.73 |
| Aug. 6, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| Aug. 6, 2026 | receipt | PO-001699 | MAIN | 39 | 161.03 | 6,280.02 | 40 | 6,432.74 | |
| Aug. 4, 2026 | issue | SO-260804-627 | EAST | 1 | 152.73 | -152.73 | 1 | 152.73 | May 18, 2026: 1 @ 152.73 |
| July 23, 2026 | issue | SO-260723-384 | EAST | 2 | 152.73 | -305.45 | 2 | 305.45 | May 18, 2026: 2 @ 152.73 |
| July 19, 2026 | issue | SO-260719-909 | EAST | 1 | 152.73 | -152.73 | 4 | 610.90 | May 18, 2026: 1 @ 152.73 |
| July 16, 2026 | issue | SO-260716-176 | EAST | 1 | 152.73 | -152.73 | 5 | 763.63 | May 18, 2026: 1 @ 152.73 |
| July 15, 2026 | issue | SO-260715-306 | EAST | 1 | 152.73 | -152.73 | 6 | 916.35 | May 18, 2026: 1 @ 152.73 |
| July 12, 2026 | issue | SO-260712-409 | EAST | 9 | 152.73 | -1,374.53 | 7 | 1,069.08 | May 18, 2026: 9 @ 152.73 |
| July 12, 2026 | issue | SO-260712-409 | MAIN | 4 | 152.73 | -610.90 | 16 | 2,443.61 | May 18, 2026: 4 @ 152.73 |
| July 6, 2026 | issue | SO-260706-365 | MAIN | 1 | 152.73 | -152.73 | 20 | 3,054.51 | May 18, 2026: 1 @ 152.73 |
| June 27, 2026 | issue | SO-260627-868 | MAIN | 5 | 152.73 | -763.63 | 21 | 3,207.23 | May 18, 2026: 5 @ 152.73 |
| June 25, 2026 | issue | SO-260625-252 | MAIN | 9 | 152.73 | -1,374.53 | 26 | 3,970.86 | May 18, 2026: 9 @ 152.73 |
| June 19, 2026 | issue | SO-260619-772 | MAIN | 13 | 152.73 | -1,985.43 | 35 | 5,345.39 | May 18, 2026: 13 @ 152.73 |
| June 4, 2026 | issue | SO-260604-700 | MAIN | 3 | 152.70 | -458.10 | 48 | 7,330.82 | April 16, 2026: 1 @ 152.65; May 18, 2026: 2 @ 152.73 |
| June 3, 2026 | issue | SO-260603-307 | MAIN | 3 | 152.65 | -457.94 | 51 | 7,788.92 | April 16, 2026: 3 @ 152.65 |
| May 28, 2026 | issue | SO-260528-647 | MAIN | 19 | 152.65 | -2,900.28 | 54 | 8,246.85 | April 16, 2026: 19 @ 152.65 |
| May 18, 2026 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| May 18, 2026 | receipt | PO-001504 | MAIN | 50 | 152.73 | 7,636.27 | 73 | 11,147.13 | |
| May 5, 2026 | issue | SO-260505-260 | MAIN | 5 | 152.65 | -763.23 | 23 | 3,510.86 | April 16, 2026: 5 @ 152.65 |
| May 3, 2026 | issue | SO-260503-605 | MAIN | 6 | 152.65 | -915.88 | 28 | 4,274.09 | April 16, 2026: 6 @ 152.65 |
| April 16, 2026 | receipt | PO-001412 | MAIN | 34 | 152.65 | 5,189.97 | 34 | 5,189.97 | |
| April 3, 2026 | issue | SO-260403-220 | MAIN | 2 | 154.70 | -309.40 | 0 | 0.00 | March 18, 2026: 2 @ 154.70 |
| April 2, 2026 | issue | SO-260402-486 | MAIN | 17 | 154.70 | -2,629.86 | 2 | 309.40 | March 18, 2026: 17 @ 154.70 |
| March 26, 2026 | issue | SO-260326-700 | EAST | 1 | 154.70 | -154.70 | 19 | 2,939.26 | March 18, 2026: 1 @ 154.70 |
| March 25, 2026 | issue | SO-260325-402 | MAIN | 1 | 154.70 | -154.70 | 20 | 3,093.96 | March 18, 2026: 1 @ 154.70 |
| March 23, 2026 | issue | SO-260323-643 | MAIN | 1 | 154.46 | -154.46 | 21 | 3,248.66 | Feb. 20, 2026: 1 @ 154.46 |
| March 18, 2026 | receipt | PO-001332 | MAIN | 21 | 154.70 | 3,248.66 | 22 | 3,403.12 | |
| March 4, 2026 | issue | SO-260304-710 | EAST | 2 | 154.46 | -308.93 | 1 | 154.46 | Feb. 20, 2026: 2 @ 154.46 |
| March 4, 2026 | issue | SO-260304-710 | MAIN | 10 | 154.46 | -1,544.63 | 3 | 463.39 | Feb. 20, 2026: 10 @ 154.46 |
| Feb. 27, 2026 | issue | SO-260227-895 | MAIN | 1 | 155.09 | -155.09 | 13 | 2,008.02 | Jan. 11, 2026: 1 @ 155.09 |
| Feb. 24, 2026 | issue | SO-260224-965 | MAIN | 1 | 155.09 | -155.09 | 14 | 2,163.12 | Jan. 11, 2026: 1 @ 155.09 |
| Feb. 23, 2026 | issue | SO-260223-294 | MAIN | 2 | 155.09 | -310.19 | 15 | 2,318.21 | Jan. 11, 2026: 2 @ 155.09 |
| Feb. 20, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Feb. 20, 2026 | receipt | PO-001246 | MAIN | 13 | 154.46 | 2,008.02 | 17 | 2,628.40 | |
| Feb. 10, 2026 | issue | SO-260210-887 | MAIN | 2 | 155.09 | -310.19 | 4 | 620.37 | Jan. 11, 2026: 2 @ 155.09 |
| Feb. 1, 2026 | issue | SO-260201-772 | MAIN | 1 | 155.09 | -155.09 | 6 | 930.56 | Jan. 11, 2026: 1 @ 155.09 |
| Jan. 30, 2026 | issue | SO-260130-551 | EAST | 2 | 155.09 | -310.19 | 7 | 1,085.65 | Jan. 11, 2026: 2 @ 155.09 |
| Jan. 16, 2026 | issue | SO-260116-940 | EAST | 1 | 155.09 | -155.09 | 9 | 1,395.84 | Jan. 11, 2026: 1 @ 155.09 |
| Jan. 12, 2026 | issue | SO-260112-921 | EAST | 1 | 155.09 | -155.09 | 10 | 1,550.93 | Jan. 11, 2026: 1 @ 155.09 |
| Jan. 11, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Jan. 11, 2026 | receipt | PO-001135 | MAIN | 11 | 155.09 | 1,706.03 | 11 | 1,706.03 | |
| Jan. 5, 2026 | issue | SO-260105-643 | MAIN | 1 | 152.05 | -152.05 | 0 | 0.00 | Oct. 20, 2025: 1 @ 152.05 |
| Jan. 1, 2026 | issue | SO-260101-270 | MAIN | 2 | 152.05 | -304.11 | 1 | 152.05 | Oct. 20, 2025: 2 @ 152.05 |
| Dec. 31, 2025 | issue | SO-251231-694 | MAIN | 1 | 152.05 | -152.05 | 3 | 456.16 | Oct. 20, 2025: 1 @ 152.05 |
| Dec. 27, 2025 | issue | SO-251227-942 | MAIN | 1 | 152.05 | -152.05 | 4 | 608.21 | Oct. 20, 2025: 1 @ 152.05 |
| Nov. 17, 2025 | issue | SO-251117-815 | EAST | 2 | 152.05 | -304.11 | 5 | 760.27 | Oct. 20, 2025: 2 @ 152.05 |
| Nov. 5, 2025 | issue | SO-251105-942 | EAST | 1 | 152.05 | -152.05 | 7 | 1,064.38 | Oct. 20, 2025: 1 @ 152.05 |
| Oct. 25, 2025 | issue | SO-251025-209 | MAIN | 2 | 152.05 | -304.11 | 8 | 1,216.43 | Oct. 20, 2025: 2 @ 152.05 |
| Oct. 20, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 20, 2025 | receipt | PO-000935 | MAIN | 10 | 152.05 | 1,520.54 | 10 | 1,520.54 | |