Items / FAN-0004
Table Fan 300mm Nova FAN-0004 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)19MAIN 14, EAST 5
Value (FIFO)3,535.78avg 186.09
ClassAY / FCV 0.81
Turnover13.9xlast issue 9 days ago
Days of cover19lead time 22d
Reorder suggested: 60 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 | 30.33 / 30.4375 | 0.997 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.64 / 5.517 | 4.467 |
| 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 * 4.467^2 + 0.997^2 * 7.4^2) | 45.1 |
| Reorder point | d * LT + safety stock | 0.997 * 21.5 + 45.1 | 66.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 66.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 364/yr, S = 45.00, h = 20%, price = 183.42 | 29.9 |
| Inventory position | on hand + on order | 19 + 0 | 19 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 183.42 | 30 | 67,815 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 12, 2026 | 19 / 19 | 186.09 | 3,535.78 |
Movement ledger 117 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Oct. 12, 2026 | receipt | PO-001872 | MAIN | 19 | 186.09 | 3,535.78 | 19 | 3,535.78 | |
| Oct. 7, 2026 | issue | SO-261007-942 | MAIN | 2 | 179.18 | -358.36 | 0 | 0.00 | May 29, 2026: 2 @ 179.18 |
| Oct. 6, 2026 | issue | SO-261006-100 | MAIN | 2 | 179.18 | -358.36 | 2 | 358.36 | May 29, 2026: 2 @ 179.18 |
| Oct. 5, 2026 | issue | SO-261005-310 | MAIN | 3 | 179.18 | -537.54 | 4 | 716.72 | May 29, 2026: 3 @ 179.18 |
| Oct. 4, 2026 | issue | SO-261004-292 | MAIN | 1 | 179.18 | -179.18 | 7 | 1,254.27 | May 29, 2026: 1 @ 179.18 |
| Oct. 1, 2026 | issue | SO-261001-763 | MAIN | 1 | 179.18 | -179.18 | 8 | 1,433.45 | May 29, 2026: 1 @ 179.18 |
| Sept. 28, 2026 | issue | SO-260928-787 | MAIN | 12 | 179.18 | -2,150.17 | 9 | 1,612.63 | May 29, 2026: 12 @ 179.18 |
| Sept. 6, 2026 | issue | SO-260906-982 | MAIN | 3 | 179.18 | -537.54 | 21 | 3,762.80 | May 29, 2026: 3 @ 179.18 |
| Sept. 5, 2026 | issue | SO-260905-632 | MAIN | 6 | 179.18 | -1,075.09 | 24 | 4,300.35 | May 29, 2026: 6 @ 179.18 |
| Aug. 26, 2026 | issue | SO-260826-657 | MAIN | 5 | 179.18 | -895.91 | 30 | 5,375.43 | May 29, 2026: 5 @ 179.18 |
| Aug. 24, 2026 | issue | SO-260824-421 | MAIN | 2 | 179.18 | -358.36 | 35 | 6,271.34 | May 29, 2026: 2 @ 179.18 |
| Aug. 23, 2026 | issue | SO-260823-438 | MAIN | 1 | 179.18 | -179.18 | 37 | 6,629.70 | May 29, 2026: 1 @ 179.18 |
| Aug. 20, 2026 | issue | SO-260820-480 | MAIN | 4 | 179.18 | -716.72 | 38 | 6,808.88 | May 29, 2026: 4 @ 179.18 |
| Aug. 17, 2026 | issue | SO-260817-212 | MAIN | 3 | 179.18 | -537.54 | 42 | 7,525.61 | May 29, 2026: 3 @ 179.18 |
| Aug. 13, 2026 | issue | SO-260813-469 | MAIN | 5 | 179.18 | -895.91 | 45 | 8,063.15 | May 29, 2026: 5 @ 179.18 |
| July 29, 2026 | issue | SO-260729-150 | MAIN | 7 | 179.18 | -1,254.27 | 50 | 8,959.06 | May 29, 2026: 7 @ 179.18 |
| July 15, 2026 | issue | SO-260715-850 | MAIN | 21 | 179.18 | -3,762.80 | 57 | 10,213.32 | May 29, 2026: 21 @ 179.18 |
| July 7, 2026 | issue | SO-260707-747 | MAIN | 14 | 179.18 | -2,508.54 | 78 | 13,976.13 | May 29, 2026: 14 @ 179.18 |
| July 3, 2026 | issue | SO-260703-402 | MAIN | 5 | 179.18 | -895.91 | 92 | 16,484.66 | May 29, 2026: 5 @ 179.18 |
| June 6, 2026 | issue | SO-260606-640 | MAIN | 16 | 177.82 | -2,845.15 | 97 | 17,380.57 | May 10, 2026: 8 @ 176.46; May 29, 2026: 8 @ 179.18 |
| June 4, 2026 | issue | SO-260604-444 | MAIN | 40 | 176.46 | -7,058.52 | 113 | 20,225.72 | May 10, 2026: 40 @ 176.46 |
| May 29, 2026 | receipt | PO-001530 | MAIN | 105 | 179.18 | 18,814.02 | 153 | 27,284.23 | |
| May 15, 2026 | issue | SO-260515-149 | MAIN | 20 | 176.46 | -3,529.26 | 48 | 8,470.22 | May 10, 2026: 20 @ 176.46 |
| May 14, 2026 | issue | SO-260514-819 | MAIN | 7 | 176.46 | -1,235.24 | 68 | 11,999.48 | May 10, 2026: 7 @ 176.46 |
| May 10, 2026 | issue | SO-260510-802 | MAIN | 26 | 176.46 | -4,588.04 | 75 | 13,234.72 | May 10, 2026: 26 @ 176.46 |
| May 10, 2026 | receipt | PO-001479 | MAIN | 101 | 176.46 | 17,822.75 | 101 | 17,822.75 | |
| April 25, 2026 | issue | SO-260425-547 | MAIN | 39 | 174.86 | -6,819.45 | 0 | 0.00 | April 2, 2026: 39 @ 174.86 |
| April 17, 2026 | issue | SO-260417-804 | MAIN | 51 | 175.18 | -8,934.40 | 39 | 6,819.45 | March 2, 2026: 21 @ 175.65; April 2, 2026: 30 @ 174.86 |
| April 2, 2026 | receipt | PO-001375 | MAIN | 69 | 174.86 | 12,065.18 | 90 | 15,753.85 | |
| March 17, 2026 | issue | SO-260317-677 | MAIN | 3 | 175.65 | -526.95 | 21 | 3,688.67 | March 2, 2026: 3 @ 175.65 |
| March 8, 2026 | issue | SO-260308-585 | MAIN | 18 | 175.65 | -3,161.71 | 24 | 4,215.62 | March 2, 2026: 18 @ 175.65 |
| March 2, 2026 | receipt | PO-001274 | MAIN | 42 | 175.65 | 7,377.33 | 42 | 7,377.33 | |
| Feb. 23, 2026 | issue | SO-260223-266 | MAIN | 11 | 175.92 | -1,935.13 | 0 | 0.00 | Jan. 29, 2026: 11 @ 175.92 |
| Feb. 17, 2026 | issue | SO-260217-740 | MAIN | 3 | 175.92 | -527.76 | 11 | 1,935.13 | Jan. 29, 2026: 3 @ 175.92 |
| Feb. 4, 2026 | issue | SO-260204-331 | MAIN | 6 | 175.92 | -1,055.53 | 14 | 2,462.90 | Jan. 29, 2026: 6 @ 175.92 |
| Feb. 2, 2026 | issue | SO-260202-458 | MAIN | 1 | 175.92 | -175.92 | 20 | 3,518.43 | Jan. 29, 2026: 1 @ 175.92 |
| Jan. 29, 2026 | receipt | PO-001184 | MAIN | 21 | 175.92 | 3,694.35 | 21 | 3,694.35 | |
| Jan. 25, 2026 | issue | SO-260125-229 | MAIN | 4 | 174.10 | -696.39 | 0 | 0.00 | Oct. 12, 2025: 3 @ 174.10; Jan. 24, 2026: 1 @ 174.10 |
| Jan. 24, 2026 | return | RMA | MAIN | 1 | 174.10 | 174.10 | 4 | 696.39 | |
| Jan. 24, 2026 | issue | SO-260124-731 | MAIN | 2 | 174.10 | -348.20 | 3 | 522.29 | Oct. 12, 2025: 2 @ 174.10 |
| Jan. 20, 2026 | issue | SO-260120-330 | MAIN | 1 | 174.10 | -174.10 | 5 | 870.49 | Oct. 12, 2025: 1 @ 174.10 |
| Jan. 2, 2026 | issue | SO-260102-812 | MAIN | 7 | 174.10 | -1,218.69 | 6 | 1,044.59 | Oct. 12, 2025: 7 @ 174.10 |
| Dec. 31, 2025 | issue | SO-251231-650 | MAIN | 3 | 174.10 | -522.29 | 13 | 2,263.28 | Oct. 12, 2025: 3 @ 174.10 |
| Dec. 30, 2025 | issue | SO-251230-716 | MAIN | 1 | 174.10 | -174.10 | 16 | 2,785.57 | Oct. 12, 2025: 1 @ 174.10 |
| Dec. 15, 2025 | issue | SO-251215-149 | MAIN | 1 | 174.10 | -174.10 | 17 | 2,959.67 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 16, 2025 | issue | SO-251116-473 | MAIN | 1 | 174.10 | -174.10 | 18 | 3,133.77 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 8, 2025 | issue | SO-251108-519 | MAIN | 2 | 174.10 | -348.20 | 19 | 3,307.86 | Oct. 12, 2025: 2 @ 174.10 |
| Nov. 7, 2025 | issue | SO-251107-110 | MAIN | 1 | 174.10 | -174.10 | 21 | 3,656.06 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 6, 2025 | issue | SO-251106-180 | MAIN | 1 | 174.10 | -174.10 | 22 | 3,830.16 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 5, 2025 | issue | SO-251105-590 | MAIN | 1 | 174.10 | -174.10 | 23 | 4,004.26 | Oct. 12, 2025: 1 @ 174.10 |
| Oct. 25, 2025 | issue | SO-251025-457 | MAIN | 8 | 174.46 | -1,395.72 | 24 | 4,178.35 | May 31, 2025: 4 @ 174.83; Oct. 12, 2025: 4 @ 174.10 |
| Oct. 23, 2025 | issue | SO-251023-276 | MAIN | 2 | 174.83 | -349.66 | 32 | 5,574.07 | May 31, 2025: 2 @ 174.83 |
| Oct. 12, 2025 | receipt | PO-000913 | MAIN | 28 | 174.10 | 4,874.75 | 34 | 5,923.73 | |
| Oct. 3, 2025 | issue | SO-251003-422 | MAIN | 1 | 174.83 | -174.83 | 6 | 1,048.99 | May 31, 2025: 1 @ 174.83 |
| Sept. 20, 2025 | issue | SO-250920-516 | MAIN | 2 | 174.83 | -349.66 | 7 | 1,223.82 | May 31, 2025: 2 @ 174.83 |
| Sept. 9, 2025 | issue | SO-250909-954 | MAIN | 16 | 174.83 | -2,797.30 | 9 | 1,573.48 | May 31, 2025: 16 @ 174.83 |
| Aug. 30, 2025 | issue | SO-250830-608 | MAIN | 3 | 174.83 | -524.49 | 25 | 4,370.78 | May 31, 2025: 3 @ 174.83 |
| Aug. 30, 2025 | issue | SO-250830-608 | EAST | 3 | 174.83 | -524.49 | 28 | 4,895.27 | May 31, 2025: 3 @ 174.83 |
| Aug. 29, 2025 | issue | SO-250829-149 | EAST | 4 | 174.83 | -699.32 | 31 | 5,419.76 | May 31, 2025: 4 @ 174.83 |