Items / FAN-0017
Table Fan 300mm Prime FAN-0017 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)16MAIN 16
Value (FIFO)2,754.60avg 172.16
ClassAY / FCV 0.74
Turnover13.7xlast issue 3 days ago
Days of cover13lead time 22d
Reorder suggested: 68 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 | 38.25 / 30.4375 | 1.257 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 28.42 / 5.517 | 5.151 |
| 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 * 5.151^2 + 1.257^2 * 7.4^2) | 52.6 |
| Reorder point | d * LT + safety stock | 1.257 * 21.5 + 52.6 | 79.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 79.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 459/yr, S = 45.00, h = 20%, price = 155.98 | 68.0 |
| Inventory position | on hand + on order | 16 + 0 | 16 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 169.54 | 35 | 78,949 | no |
| 34 | 162.76 | 36 | 75,814 | yes |
| 68 | 155.98 | 68 | 72,909 | yes (chosen if cheapest) |
MOQ 17, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 20, 2026 | 16 / 24 | 172.16 | 2,754.60 |
Movement ledger 132 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-404 | MAIN | 6 | 172.16 | -1,032.97 | 16 | 2,754.60 | Sept. 20, 2026: 6 @ 172.16 |
| Oct. 5, 2026 | issue | SO-261005-684 | MAIN | 8 | 171.34 | -1,370.70 | 22 | 3,787.57 | July 7, 2026: 6 @ 171.06; Sept. 20, 2026: 2 @ 172.16 |
| Sept. 21, 2026 | issue | SO-260921-453 | MAIN | 4 | 171.06 | -684.25 | 30 | 5,158.27 | July 7, 2026: 4 @ 171.06 |
| Sept. 20, 2026 | receipt | PO-001814 | MAIN | 24 | 172.16 | 4,131.90 | 34 | 5,842.52 | |
| Sept. 18, 2026 | issue | SO-260918-690 | MAIN | 18 | 171.06 | -3,079.13 | 10 | 1,710.63 | July 7, 2026: 18 @ 171.06 |
| Sept. 17, 2026 | issue | SO-260917-915 | MAIN | 1 | 171.06 | -171.06 | 28 | 4,789.76 | July 7, 2026: 1 @ 171.06 |
| Sept. 2, 2026 | issue | SO-260902-685 | MAIN | 3 | 171.06 | -513.19 | 29 | 4,960.82 | July 7, 2026: 3 @ 171.06 |
| Aug. 30, 2026 | issue | SO-260830-735 | MAIN | 1 | 171.06 | -171.06 | 32 | 5,474.01 | July 7, 2026: 1 @ 171.06 |
| Aug. 25, 2026 | issue | SO-260825-817 | MAIN | 1 | 171.06 | -171.06 | 33 | 5,645.07 | July 7, 2026: 1 @ 171.06 |
| Aug. 20, 2026 | issue | SO-260820-326 | MAIN | 1 | 171.06 | -171.06 | 34 | 5,816.13 | July 7, 2026: 1 @ 171.06 |
| Aug. 16, 2026 | issue | SO-260816-948 | MAIN | 1 | 171.06 | -171.06 | 35 | 5,987.19 | July 7, 2026: 1 @ 171.06 |
| Aug. 4, 2026 | issue | SO-260804-629 | MAIN | 12 | 171.06 | -2,052.75 | 36 | 6,158.26 | July 7, 2026: 12 @ 171.06 |
| Aug. 2, 2026 | issue | SO-260802-236 | MAIN | 7 | 171.06 | -1,197.44 | 48 | 8,211.01 | July 7, 2026: 7 @ 171.06 |
| July 28, 2026 | issue | SO-260728-402 | MAIN | 57 | 170.09 | -9,695.28 | 55 | 9,408.45 | May 17, 2026: 10 @ 165.53; July 7, 2026: 47 @ 171.06 |
| July 21, 2026 | issue | SO-260721-798 | MAIN | 7 | 165.53 | -1,158.73 | 112 | 19,103.73 | May 17, 2026: 7 @ 165.53 |
| July 7, 2026 | receipt | PO-001630 | MAIN | 102 | 171.06 | 17,448.40 | 119 | 20,262.46 | |
| June 21, 2026 | issue | SO-260621-571 | MAIN | 23 | 165.53 | -3,807.27 | 17 | 2,814.07 | May 17, 2026: 23 @ 165.53 |
| June 17, 2026 | issue | SO-260617-933 | MAIN | 45 | 165.53 | -7,449.01 | 40 | 6,621.34 | May 17, 2026: 45 @ 165.53 |
| May 31, 2026 | issue | SO-260531-472 | EAST | 7 | 165.53 | -1,158.73 | 85 | 14,070.35 | May 17, 2026: 7 @ 165.53 |
| May 30, 2026 | issue | SO-260530-338 | MAIN | 45 | 165.61 | -7,452.62 | 92 | 15,229.08 | March 26, 2026: 2 @ 166.76; April 2, 2026: 3 @ 165.92; May 17, 2026: 40 @ 165.53 |
| May 21, 2026 | issue | SO-260521-425 | MAIN | 32 | 166.76 | -5,336.34 | 137 | 22,681.71 | March 26, 2026: 32 @ 166.76 |
| May 17, 2026 | receipt | PO-001502 | MAIN | 132 | 165.53 | 21,850.42 | 169 | 28,018.04 | |
| May 13, 2026 | issue | SO-260513-242 | MAIN | 19 | 166.76 | -3,168.45 | 37 | 6,167.62 | March 26, 2026: 19 @ 166.76 |
| May 1, 2026 | issue | SO-260501-435 | MAIN | 6 | 166.76 | -1,000.56 | 56 | 9,336.07 | March 26, 2026: 6 @ 166.76 |
| April 26, 2026 | issue | SO-260426-823 | MAIN | 9 | 166.76 | -1,500.84 | 62 | 10,336.63 | March 26, 2026: 9 @ 166.76 |
| April 22, 2026 | issue | SO-260422-798 | MAIN | 27 | 166.61 | -4,498.34 | 71 | 11,837.48 | March 13, 2026: 5 @ 165.92; March 26, 2026: 22 @ 166.76 |
| April 9, 2026 | issue | SO-260409-316 | MAIN | 12 | 165.92 | -1,991.05 | 98 | 16,335.81 | March 13, 2026: 12 @ 165.92 |
| April 8, 2026 | issue | SO-260408-406 | EAST | 5 | 165.92 | -829.61 | 110 | 18,326.87 | March 13, 2026: 5 @ 165.92 |
| April 2, 2026 | return | RMA | MAIN | 3 | 165.92 | 497.76 | 115 | 19,156.47 | |
| March 27, 2026 | issue | SO-260327-796 | MAIN | 15 | 165.92 | -2,488.82 | 112 | 18,658.71 | March 13, 2026: 15 @ 165.92 |
| March 26, 2026 | receipt | PO-001357 | MAIN | 90 | 166.76 | 15,008.44 | 127 | 21,147.53 | |
| March 18, 2026 | issue | SO-260318-154 | EAST | 6 | 165.92 | -995.53 | 37 | 6,139.08 | March 13, 2026: 6 @ 165.92 |
| March 15, 2026 | issue | SO-260315-747 | MAIN | 15 | 164.71 | -2,470.61 | 43 | 7,134.61 | Jan. 21, 2026: 3 @ 161.37; Feb. 18, 2026: 1 @ 161.37; March 13, 2026: 11 @ 165.92 |
| March 13, 2026 | transfer | TRF | MAIN → EAST | 18 | warehouse transfer, no cost effect | ||||
| March 13, 2026 | receipt | PO-001312 | MAIN | 54 | 165.92 | 8,959.74 | 58 | 9,605.22 | |
| March 11, 2026 | issue | SO-260311-822 | MAIN | 2 | 161.37 | -322.74 | 4 | 645.48 | Jan. 21, 2026: 2 @ 161.37 |
| March 7, 2026 | issue | SO-260307-774 | MAIN | 1 | 161.37 | -161.37 | 6 | 968.22 | Jan. 21, 2026: 1 @ 161.37 |
| Feb. 23, 2026 | issue | SO-260223-844 | MAIN | 2 | 161.37 | -322.74 | 7 | 1,129.59 | Jan. 21, 2026: 2 @ 161.37 |
| Feb. 21, 2026 | issue | SO-260221-400 | MAIN | 5 | 161.37 | -806.85 | 9 | 1,452.33 | Jan. 21, 2026: 5 @ 161.37 |
| Feb. 20, 2026 | issue | SO-260220-294 | MAIN | 1 | 161.37 | -161.37 | 14 | 2,259.17 | Jan. 21, 2026: 1 @ 161.37 |
| Feb. 18, 2026 | return | RMA | MAIN | 1 | 161.37 | 161.37 | 15 | 2,420.54 | |
| Feb. 12, 2026 | issue | SO-260212-105 | MAIN | 1 | 161.37 | -161.37 | 14 | 2,259.17 | Jan. 21, 2026: 1 @ 161.37 |
| Feb. 12, 2026 | issue | SO-260212-105 | EAST | 1 | 161.37 | -161.37 | 15 | 2,420.54 | Jan. 21, 2026: 1 @ 161.37 |
| Feb. 10, 2026 | issue | SO-260210-845 | MAIN | 4 | 161.37 | -645.48 | 16 | 2,581.91 | Jan. 21, 2026: 4 @ 161.37 |
| Feb. 4, 2026 | issue | SO-260204-745 | EAST | 1 | 161.37 | -161.37 | 20 | 3,227.39 | Jan. 21, 2026: 1 @ 161.37 |
| Feb. 1, 2026 | issue | SO-260201-642 | EAST | 7 | 161.27 | -1,128.86 | 21 | 3,388.76 | Dec. 24, 2025: 1 @ 160.65; Jan. 21, 2026: 6 @ 161.37 |
| Jan. 23, 2026 | issue | SO-260123-882 | MAIN | 8 | 158.82 | -1,270.55 | 28 | 4,517.62 | Sept. 20, 2025: 5 @ 158.21; Oct. 16, 2025: 1 @ 158.21; Dec. 24, 2025: 2 @ 160.65 |
| Jan. 21, 2026 | receipt | PO-001165 | MAIN | 27 | 161.37 | 4,356.98 | 36 | 5,788.17 | |
| Jan. 7, 2026 | issue | SO-260107-697 | EAST | 1 | 158.21 | -158.21 | 9 | 1,431.19 | Sept. 20, 2025: 1 @ 158.21 |
| Jan. 6, 2026 | issue | SO-260106-487 | EAST | 4 | 160.04 | -640.15 | 10 | 1,589.40 | July 7, 2025: 3 @ 160.65; Sept. 20, 2025: 1 @ 158.21 |
| Jan. 1, 2026 | issue | SO-260101-620 | EAST | 4 | 160.65 | -642.59 | 14 | 2,229.55 | July 7, 2025: 4 @ 160.65 |
| Jan. 1, 2026 | issue | SO-260101-620 | MAIN | 5 | 160.65 | -803.23 | 18 | 2,872.14 | July 7, 2025: 5 @ 160.65 |
| Dec. 30, 2025 | issue | SO-251230-398 | MAIN | 1 | 160.65 | -160.65 | 23 | 3,675.37 | July 7, 2025: 1 @ 160.65 |
| Dec. 24, 2025 | return | RMA | MAIN | 3 | 160.65 | 481.94 | 24 | 3,836.02 | |
| Dec. 24, 2025 | issue | SO-251224-782 | MAIN | 2 | 160.65 | -321.29 | 21 | 3,354.08 | July 7, 2025: 2 @ 160.65 |
| Dec. 15, 2025 | issue | SO-251215-183 | MAIN | 6 | 160.65 | -963.88 | 23 | 3,675.37 | July 7, 2025: 6 @ 160.65 |
| Dec. 8, 2025 | issue | SO-251208-579 | MAIN | 1 | 160.65 | -160.65 | 29 | 4,639.25 | July 7, 2025: 1 @ 160.65 |
| Dec. 3, 2025 | issue | SO-251203-283 | MAIN | 1 | 160.65 | -160.65 | 30 | 4,799.90 | July 7, 2025: 1 @ 160.65 |
| Nov. 27, 2025 | issue | SO-251127-998 | MAIN | 5 | 160.16 | -800.80 | 31 | 4,960.55 | July 7, 2025: 1 @ 158.21; July 7, 2025: 4 @ 160.65 |
| Nov. 22, 2025 | issue | SO-251122-481 | MAIN | 2 | 158.21 | -316.42 | 36 | 5,761.34 | July 7, 2025: 2 @ 158.21 |