Items / FAN-0008
Pedestal Fan Pro FAN-0008 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)28MAIN 28
Value (FIFO)6,290.07avg 224.65
ClassAY / FCV 0.79
Turnover6.6xlast issue 0 days ago
Days of cover45lead time 22d
Reorder suggested: 22 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 | 18.83 / 30.4375 | 0.619 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 14.93 / 5.517 | 2.706 |
| 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.706^2 + 0.619^2 * 7.4^2) | 27.4 |
| Reorder point | d * LT + safety stock | 0.619 * 21.5 + 27.4 | 40.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 40.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 226/yr, S = 45.00, h = 20%, price = 227.12 | 21.2 |
| Inventory position | on hand + on order | 28 + 0 | 28 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 227.12 | 21 | 52,255 | yes (chosen if cheapest) |
MOQ 10, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 23, 2026 | 28 / 59 | 224.65 | 6,290.07 |
Movement ledger 124 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-190 | EAST | 7 | 224.65 | -1,572.52 | 28 | 6,290.07 | July 23, 2026: 7 @ 224.65 |
| Oct. 12, 2026 | issue | SO-261012-763 | MAIN | 1 | 224.65 | -224.65 | 35 | 7,862.58 | July 23, 2026: 1 @ 224.65 |
| Oct. 10, 2026 | issue | SO-261010-591 | MAIN | 1 | 224.65 | -224.65 | 36 | 8,087.23 | July 23, 2026: 1 @ 224.65 |
| Oct. 8, 2026 | issue | SO-261008-704 | MAIN | 1 | 224.65 | -224.65 | 37 | 8,311.87 | July 23, 2026: 1 @ 224.65 |
| Oct. 3, 2026 | issue | SO-261003-188 | MAIN | 1 | 224.65 | -224.65 | 38 | 8,536.52 | July 23, 2026: 1 @ 224.65 |
| Oct. 2, 2026 | issue | SO-261002-470 | MAIN | 1 | 224.65 | -224.65 | 39 | 8,761.16 | July 23, 2026: 1 @ 224.65 |
| Sept. 29, 2026 | issue | SO-260929-614 | EAST | 3 | 224.65 | -673.94 | 40 | 8,985.81 | July 23, 2026: 3 @ 224.65 |
| Sept. 12, 2026 | issue | SO-260912-897 | MAIN | 2 | 224.65 | -449.29 | 43 | 9,659.74 | July 23, 2026: 2 @ 224.65 |
| Sept. 10, 2026 | issue | SO-260910-353 | MAIN | 4 | 224.65 | -898.58 | 45 | 10,109.03 | July 23, 2026: 4 @ 224.65 |
| Sept. 9, 2026 | issue | SO-260909-648 | MAIN | 1 | 224.65 | -224.65 | 49 | 11,007.61 | July 23, 2026: 1 @ 224.65 |
| Sept. 5, 2026 | issue | SO-260905-327 | EAST | 4 | 224.65 | -898.58 | 50 | 11,232.26 | July 23, 2026: 4 @ 224.65 |
| Aug. 15, 2026 | issue | SO-260815-235 | EAST | 1 | 224.65 | -224.65 | 54 | 12,130.84 | July 23, 2026: 1 @ 224.65 |
| Aug. 10, 2026 | issue | SO-260810-704 | MAIN | 11 | 220.49 | -2,425.39 | 55 | 12,355.49 | May 26, 2026: 7 @ 218.11; July 23, 2026: 4 @ 224.65 |
| Aug. 7, 2026 | issue | SO-260807-710 | MAIN | 4 | 218.11 | -872.46 | 66 | 14,780.87 | May 26, 2026: 4 @ 218.11 |
| Aug. 2, 2026 | issue | SO-260802-389 | MAIN | 5 | 218.11 | -1,090.57 | 70 | 15,653.33 | May 26, 2026: 5 @ 218.11 |
| July 23, 2026 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| July 23, 2026 | receipt | PO-001665 | MAIN | 59 | 224.65 | 13,254.07 | 75 | 16,743.91 | |
| July 22, 2026 | issue | SO-260722-645 | MAIN | 6 | 218.11 | -1,308.69 | 16 | 3,489.84 | May 26, 2026: 6 @ 218.11 |
| July 15, 2026 | issue | SO-260715-237 | MAIN | 9 | 218.11 | -1,963.03 | 22 | 4,798.53 | May 26, 2026: 9 @ 218.11 |
| July 5, 2026 | issue | SO-260705-292 | MAIN | 4 | 218.11 | -872.46 | 31 | 6,761.56 | May 26, 2026: 4 @ 218.11 |
| June 27, 2026 | issue | SO-260627-959 | MAIN | 11 | 218.11 | -2,399.26 | 35 | 7,634.02 | May 26, 2026: 11 @ 218.11 |
| June 26, 2026 | issue | SO-260626-677 | MAIN | 1 | 218.11 | -218.11 | 46 | 10,033.29 | May 26, 2026: 1 @ 218.11 |
| June 20, 2026 | issue | SO-260620-936 | MAIN | 4 | 218.11 | -872.46 | 47 | 10,251.40 | May 26, 2026: 4 @ 218.11 |
| June 14, 2026 | issue | SO-260614-746 | MAIN | 19 | 218.11 | -4,144.18 | 51 | 11,123.86 | May 26, 2026: 19 @ 218.11 |
| June 11, 2026 | issue | SO-260611-381 | MAIN | 2 | 218.11 | -436.23 | 70 | 15,268.04 | May 26, 2026: 2 @ 218.11 |
| June 4, 2026 | issue | SO-260604-719 | MAIN | 4 | 218.11 | -872.46 | 72 | 15,704.27 | May 26, 2026: 4 @ 218.11 |
| May 31, 2026 | issue | SO-260531-257 | MAIN | 14 | 222.51 | -3,115.19 | 76 | 16,576.73 | April 29, 2026: 11 @ 223.71; May 26, 2026: 3 @ 218.11 |
| May 30, 2026 | issue | SO-260530-119 | MAIN | 9 | 223.71 | -2,013.42 | 90 | 19,691.92 | April 29, 2026: 9 @ 223.71 |
| May 29, 2026 | issue | SO-260529-438 | MAIN | 17 | 223.71 | -3,803.12 | 99 | 21,705.34 | April 29, 2026: 17 @ 223.71 |
| May 26, 2026 | receipt | PO-001524 | MAIN | 79 | 218.11 | 17,231.08 | 116 | 25,508.46 | |
| May 18, 2026 | issue | SO-260518-539 | MAIN | 5 | 223.71 | -1,118.57 | 37 | 8,277.38 | April 29, 2026: 5 @ 223.71 |
| May 17, 2026 | issue | SO-260517-878 | MAIN | 4 | 223.71 | -894.85 | 42 | 9,395.95 | April 29, 2026: 4 @ 223.71 |
| May 15, 2026 | issue | SO-260515-290 | MAIN | 6 | 223.71 | -1,342.28 | 46 | 10,290.80 | April 29, 2026: 6 @ 223.71 |
| April 29, 2026 | receipt | PO-001450 | MAIN | 52 | 223.71 | 11,633.08 | 52 | 11,633.08 | |
| April 24, 2026 | issue | SO-260424-982 | MAIN | 3 | 218.44 | -655.31 | 0 | 0.00 | Feb. 26, 2026: 3 @ 218.44 |
| April 23, 2026 | issue | SO-260423-229 | MAIN | 1 | 218.44 | -218.44 | 3 | 655.31 | Feb. 26, 2026: 1 @ 218.44 |
| April 19, 2026 | issue | SO-260419-644 | MAIN | 4 | 218.44 | -873.75 | 4 | 873.75 | Feb. 26, 2026: 4 @ 218.44 |
| April 16, 2026 | issue | SO-260416-985 | MAIN | 2 | 218.44 | -436.87 | 8 | 1,747.50 | Feb. 26, 2026: 2 @ 218.44 |
| April 12, 2026 | issue | SO-260412-780 | MAIN | 4 | 218.44 | -873.75 | 10 | 2,184.37 | Feb. 26, 2026: 4 @ 218.44 |
| April 8, 2026 | issue | SO-260408-987 | MAIN | 3 | 218.44 | -655.31 | 14 | 3,058.12 | Feb. 26, 2026: 3 @ 218.44 |
| April 1, 2026 | issue | SO-260401-771 | MAIN | 6 | 218.44 | -1,310.62 | 17 | 3,713.43 | Feb. 26, 2026: 6 @ 218.44 |
| March 29, 2026 | issue | SO-260329-390 | MAIN | 2 | 218.44 | -436.87 | 23 | 5,024.06 | Feb. 26, 2026: 2 @ 218.44 |
| March 25, 2026 | issue | SO-260325-813 | MAIN | 3 | 218.44 | -655.31 | 25 | 5,460.93 | Feb. 26, 2026: 3 @ 218.44 |
| March 23, 2026 | issue | SO-260323-644 | MAIN | 2 | 218.44 | -436.87 | 28 | 6,116.24 | Feb. 26, 2026: 2 @ 218.44 |
| March 22, 2026 | issue | SO-260322-522 | MAIN | 3 | 217.78 | -653.33 | 30 | 6,553.12 | Aug. 14, 2025: 2 @ 217.44; Feb. 26, 2026: 1 @ 218.44 |
| March 17, 2026 | issue | SO-260317-710 | MAIN | 2 | 217.44 | -434.89 | 33 | 7,206.44 | Aug. 14, 2025: 2 @ 217.44 |
| March 11, 2026 | issue | SO-260311-851 | MAIN | 2 | 217.44 | -434.89 | 35 | 7,641.33 | July 13, 2025: 2 @ 217.44 |
| March 10, 2026 | issue | SO-260310-553 | MAIN | 5 | 217.44 | -1,087.22 | 37 | 8,076.22 | July 13, 2025: 5 @ 217.44 |
| Feb. 26, 2026 | issue | SO-260226-814 | MAIN | 3 | 217.44 | -652.33 | 42 | 9,163.45 | July 13, 2025: 3 @ 217.44 |
| Feb. 26, 2026 | receipt | PO-001260 | MAIN | 31 | 218.44 | 6,771.55 | 45 | 9,815.78 | |
| Feb. 10, 2026 | issue | SO-260210-644 | MAIN | 1 | 217.44 | -217.44 | 14 | 3,044.23 | July 13, 2025: 1 @ 217.44 |
| Feb. 4, 2026 | issue | SO-260204-624 | MAIN | 11 | 217.44 | -2,391.89 | 15 | 3,261.67 | July 13, 2025: 11 @ 217.44 |
| Jan. 27, 2026 | issue | SO-260127-894 | MAIN | 1 | 217.44 | -217.44 | 26 | 5,653.56 | July 13, 2025: 1 @ 217.44 |
| Jan. 22, 2026 | issue | SO-260122-901 | MAIN | 1 | 217.44 | -217.44 | 27 | 5,871.01 | July 13, 2025: 1 @ 217.44 |
| Jan. 19, 2026 | issue | SO-260119-210 | MAIN | 1 | 217.44 | -217.44 | 28 | 6,088.45 | July 13, 2025: 1 @ 217.44 |
| Jan. 10, 2026 | issue | SO-260110-742 | MAIN | 3 | 217.44 | -652.33 | 29 | 6,305.90 | July 13, 2025: 3 @ 217.44 |
| Jan. 1, 2026 | issue | SO-260101-105 | MAIN | 1 | 217.44 | -217.44 | 32 | 6,958.23 | July 13, 2025: 1 @ 217.44 |
| Dec. 28, 2025 | issue | SO-251228-712 | MAIN | 2 | 217.44 | -434.89 | 33 | 7,175.68 | July 13, 2025: 2 @ 217.44 |
| Dec. 25, 2025 | issue | SO-251225-829 | MAIN | 1 | 217.44 | -217.44 | 35 | 7,610.57 | July 13, 2025: 1 @ 217.44 |
| Nov. 11, 2025 | issue | SO-251111-725 | MAIN | 1 | 217.44 | -217.44 | 36 | 7,828.01 | July 13, 2025: 1 @ 217.44 |