Items / FAN-0024
Decorative Ceiling Fan Lite FAN-0024 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)14MAIN 14
Value (FIFO)3,387.71avg 241.98
ClassAY / FCV 0.63
Turnover23.7xlast issue 9 days ago
Days of cover31lead time 22d
Reorder suggested: 28 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.92 / 30.4375 | 0.457 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.77 / 5.517 | 1.590 |
| 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 * 1.590^2 + 0.457^2 * 7.4^2) | 16.6 |
| Reorder point | d * LT + safety stock | 0.457 * 21.5 + 16.6 | 26.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 26.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 167/yr, S = 45.00, h = 20%, price = 219.51 | 28.0 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 238.60 | 18 | 40,666 | no |
| 14 | 229.06 | 18 | 39,056 | yes |
| 28 | 219.51 | 28 | 37,516 | yes (chosen if cheapest) |
MOQ 7, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 13, 2026 | 12 / 25 | 241.98 | 2,903.75 | |
| Oct. 16, 2026 | 2 / 2 | 241.98 | 483.96 |
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 | return | RMA | MAIN | 2 | 241.98 | 483.96 | 14 | 3,387.71 | |
| Oct. 7, 2026 | issue | SO-261007-841 | MAIN | 1 | 241.98 | -241.98 | 12 | 2,903.75 | Aug. 13, 2026: 1 @ 241.98 |
| Oct. 4, 2026 | issue | SO-261004-567 | MAIN | 4 | 241.98 | -967.92 | 13 | 3,145.73 | Aug. 13, 2026: 4 @ 241.98 |
| Oct. 2, 2026 | issue | SO-261002-942 | MAIN | 2 | 241.98 | -483.96 | 17 | 4,113.65 | Aug. 13, 2026: 2 @ 241.98 |
| Sept. 17, 2026 | issue | SO-260917-302 | MAIN | 1 | 241.98 | -241.98 | 19 | 4,597.61 | Aug. 13, 2026: 1 @ 241.98 |
| Sept. 15, 2026 | issue | SO-260915-766 | MAIN | 1 | 241.98 | -241.98 | 20 | 4,839.59 | Aug. 13, 2026: 1 @ 241.98 |
| Sept. 8, 2026 | issue | SO-260908-142 | MAIN | 3 | 241.98 | -725.94 | 21 | 5,081.57 | Aug. 13, 2026: 3 @ 241.98 |
| Sept. 5, 2026 | issue | SO-260905-883 | MAIN | 1 | 241.98 | -241.98 | 24 | 5,807.51 | Aug. 13, 2026: 1 @ 241.98 |
| Aug. 13, 2026 | receipt | PO-001718 | MAIN | 25 | 241.98 | 6,049.48 | 25 | 6,049.48 | |
| Aug. 9, 2026 | issue | SO-260809-969 | MAIN | 1 | 233.44 | -233.44 | 0 | 0.00 | May 28, 2026: 1 @ 233.44 |
| Aug. 8, 2026 | issue | SO-260808-151 | MAIN | 3 | 233.44 | -700.31 | 1 | 233.44 | May 28, 2026: 3 @ 233.44 |
| Aug. 7, 2026 | issue | SO-260807-634 | MAIN | 5 | 233.44 | -1,167.18 | 4 | 933.74 | May 28, 2026: 5 @ 233.44 |
| July 29, 2026 | issue | SO-260729-257 | MAIN | 1 | 233.44 | -233.44 | 9 | 2,100.92 | May 28, 2026: 1 @ 233.44 |
| July 27, 2026 | issue | SO-260727-330 | MAIN | 12 | 233.44 | -2,801.23 | 10 | 2,334.36 | May 28, 2026: 12 @ 233.44 |
| July 24, 2026 | issue | SO-260724-548 | MAIN | 6 | 233.44 | -1,400.61 | 22 | 5,135.59 | May 28, 2026: 6 @ 233.44 |
| July 13, 2026 | issue | SO-260713-864 | MAIN | 2 | 233.44 | -466.87 | 28 | 6,536.20 | May 28, 2026: 2 @ 233.44 |
| July 12, 2026 | issue | SO-260712-898 | MAIN | 1 | 233.44 | -233.44 | 30 | 7,003.07 | May 28, 2026: 1 @ 233.44 |
| July 7, 2026 | issue | SO-260707-428 | MAIN | 1 | 233.44 | -233.44 | 31 | 7,236.51 | May 28, 2026: 1 @ 233.44 |
| June 24, 2026 | issue | SO-260624-257 | MAIN | 9 | 233.44 | -2,100.92 | 32 | 7,469.95 | May 28, 2026: 9 @ 233.44 |
| June 16, 2026 | issue | SO-260616-318 | MAIN | 8 | 233.44 | -1,867.49 | 41 | 9,570.87 | May 28, 2026: 8 @ 233.44 |
| June 13, 2026 | issue | SO-260613-285 | MAIN | 6 | 233.44 | -1,400.61 | 49 | 11,438.35 | May 28, 2026: 6 @ 233.44 |
| May 28, 2026 | receipt | PO-001527 | MAIN | 55 | 233.44 | 12,838.97 | 55 | 12,838.97 | |
| May 11, 2026 | issue | SO-260511-183 | MAIN | 4 | 232.58 | -930.33 | 0 | 0.00 | March 28, 2026: 4 @ 232.58 |
| May 8, 2026 | issue | SO-260508-566 | MAIN | 26 | 232.58 | -6,047.16 | 4 | 930.33 | March 28, 2026: 26 @ 232.58 |
| April 25, 2026 | issue | SO-260425-776 | MAIN | 1 | 232.58 | -232.58 | 30 | 6,977.49 | March 28, 2026: 1 @ 232.58 |
| April 15, 2026 | issue | SO-260415-723 | MAIN | 24 | 235.87 | -5,661.00 | 31 | 7,210.07 | March 3, 2026: 17 @ 237.23; March 28, 2026: 7 @ 232.58 |
| March 28, 2026 | receipt | PO-001363 | MAIN | 38 | 232.58 | 8,838.15 | 55 | 12,871.07 | |
| March 15, 2026 | issue | SO-260315-474 | MAIN | 6 | 237.23 | -1,423.38 | 17 | 4,032.92 | March 3, 2026: 6 @ 237.23 |
| March 8, 2026 | issue | SO-260308-370 | MAIN | 10 | 231.89 | -2,318.90 | 23 | 5,456.30 | Feb. 4, 2026: 10 @ 231.89 |
| March 3, 2026 | receipt | PO-001281 | MAIN | 23 | 237.23 | 5,456.30 | 33 | 7,775.19 | |
| March 1, 2026 | issue | SO-260301-910 | MAIN | 1 | 231.89 | -231.89 | 10 | 2,318.90 | Feb. 4, 2026: 1 @ 231.89 |
| Feb. 14, 2026 | issue | SO-260214-917 | MAIN | 1 | 231.89 | -231.89 | 11 | 2,550.79 | Feb. 4, 2026: 1 @ 231.89 |
| Feb. 13, 2026 | issue | SO-260213-218 | MAIN | 1 | 231.89 | -231.89 | 12 | 2,782.68 | Feb. 4, 2026: 1 @ 231.89 |
| Feb. 6, 2026 | issue | SO-260206-780 | MAIN | 4 | 229.78 | -919.13 | 13 | 3,014.57 | Jan. 4, 2026: 3 @ 229.08; Feb. 4, 2026: 1 @ 231.89 |
| Feb. 4, 2026 | receipt | PO-001196 | MAIN | 14 | 231.89 | 3,246.46 | 17 | 3,933.70 | |
| Jan. 30, 2026 | issue | SO-260130-960 | MAIN | 1 | 229.08 | -229.08 | 3 | 687.24 | Jan. 4, 2026: 1 @ 229.08 |
| Jan. 28, 2026 | issue | SO-260128-451 | MAIN | 1 | 229.08 | -229.08 | 4 | 916.32 | Jan. 4, 2026: 1 @ 229.08 |
| Jan. 26, 2026 | issue | SO-260126-772 | MAIN | 3 | 229.08 | -687.24 | 5 | 1,145.40 | Jan. 4, 2026: 3 @ 229.08 |
| Jan. 19, 2026 | issue | SO-260119-770 | MAIN | 3 | 229.08 | -687.24 | 8 | 1,832.64 | Jan. 4, 2026: 3 @ 229.08 |
| Jan. 12, 2026 | issue | SO-260112-742 | MAIN | 1 | 229.08 | -229.08 | 11 | 2,519.87 | Jan. 4, 2026: 1 @ 229.08 |
| Jan. 4, 2026 | receipt | PO-001119 | MAIN | 12 | 229.08 | 2,748.95 | 12 | 2,748.95 | |
| Jan. 1, 2026 | issue | SO-260101-465 | MAIN | 1 | 225.24 | -225.24 | 0 | 0.00 | Nov. 17, 2025: 1 @ 225.24 |
| Dec. 16, 2025 | issue | SO-251216-852 | MAIN | 1 | 225.24 | -225.24 | 1 | 225.24 | Nov. 17, 2025: 1 @ 225.24 |
| Dec. 14, 2025 | issue | SO-251214-652 | MAIN | 2 | 225.24 | -450.48 | 2 | 450.48 | Nov. 17, 2025: 2 @ 225.24 |
| Dec. 13, 2025 | issue | SO-251213-543 | MAIN | 1 | 225.24 | -225.24 | 4 | 900.96 | Nov. 17, 2025: 1 @ 225.24 |
| Dec. 12, 2025 | issue | SO-251212-241 | MAIN | 1 | 225.24 | -225.24 | 5 | 1,126.20 | Nov. 17, 2025: 1 @ 225.24 |
| Nov. 28, 2025 | issue | SO-251128-394 | MAIN | 1 | 225.24 | -225.24 | 6 | 1,351.44 | Nov. 17, 2025: 1 @ 225.24 |
| Nov. 17, 2025 | receipt | PO-001005 | MAIN | 7 | 225.24 | 1,576.67 | 7 | 1,576.67 | |
| Nov. 16, 2025 | issue | SO-251116-682 | MAIN | 2 | 223.84 | -447.68 | 0 | 0.00 | Oct. 19, 2025: 2 @ 223.84 |
| Nov. 2, 2025 | issue | SO-251102-766 | MAIN | 1 | 223.84 | -223.84 | 2 | 447.68 | Oct. 19, 2025: 1 @ 223.84 |
| Oct. 24, 2025 | issue | SO-251024-952 | MAIN | 1 | 223.84 | -223.84 | 3 | 671.52 | Oct. 19, 2025: 1 @ 223.84 |
| Oct. 23, 2025 | issue | SO-251023-739 | MAIN | 5 | 223.84 | -1,119.20 | 4 | 895.36 | Oct. 19, 2025: 5 @ 223.84 |
| Oct. 22, 2025 | issue | SO-251022-385 | MAIN | 1 | 223.84 | -223.84 | 9 | 2,014.55 | Oct. 19, 2025: 1 @ 223.84 |
| Oct. 19, 2025 | receipt | PO-000933 | MAIN | 10 | 223.84 | 2,238.39 | 10 | 2,238.39 | |
| Oct. 14, 2025 | issue | SO-251014-215 | MAIN | 1 | 226.44 | -226.44 | 0 | 0.00 | July 25, 2025: 1 @ 226.44 |
| Oct. 10, 2025 | issue | SO-251010-410 | MAIN | 1 | 226.44 | -226.44 | 1 | 226.44 | July 25, 2025: 1 @ 226.44 |
| Sept. 26, 2025 | issue | SO-250926-574 | MAIN | 1 | 227.73 | -227.73 | 2 | 452.88 | May 26, 2025: 1 @ 227.73 |
| Sept. 25, 2025 | issue | SO-250925-340 | MAIN | 2 | 227.73 | -455.45 | 3 | 680.60 | May 26, 2025: 2 @ 227.73 |
| Sept. 23, 2025 | issue | SO-250923-501 | MAIN | 4 | 226.44 | -905.75 | 5 | 1,136.05 | May 24, 2025: 4 @ 226.44 |
| Sept. 19, 2025 | issue | SO-250919-912 | MAIN | 1 | 226.44 | -226.44 | 9 | 2,041.80 | May 24, 2025: 1 @ 226.44 |