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
| 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 | |
| Oct. 16, 2025 | issue | SO-251016-476 | EAST | 1 | 150.15 | -150.15 | 0 | 0.00 | June 25, 2025: 1 @ 150.15 |
| Oct. 12, 2025 | issue | SO-251012-737 | EAST | 1 | 150.15 | -150.15 | 1 | 150.15 | June 25, 2025: 1 @ 150.15 |
| Sept. 23, 2025 | issue | SO-250923-874 | EAST | 3 | 150.15 | -450.46 | 2 | 300.30 | June 25, 2025: 3 @ 150.15 |
| Sept. 22, 2025 | issue | SO-250922-100 | EAST | 2 | 150.15 | -300.30 | 5 | 750.76 | June 25, 2025: 2 @ 150.15 |
| Sept. 12, 2025 | issue | SO-250912-483 | EAST | 1 | 150.15 | -150.15 | 7 | 1,051.06 | June 25, 2025: 1 @ 150.15 |
| Aug. 25, 2025 | issue | SO-250825-326 | EAST | 3 | 150.15 | -450.46 | 8 | 1,201.21 | June 25, 2025: 3 @ 150.15 |
| Aug. 20, 2025 | issue | SO-250820-189 | EAST | 4 | 150.15 | -600.61 | 11 | 1,651.67 | June 25, 2025: 4 @ 150.15 |
| Aug. 20, 2025 | issue | SO-250820-189 | MAIN | 4 | 150.15 | -600.61 | 15 | 2,252.28 | June 25, 2025: 4 @ 150.15 |
| Aug. 4, 2025 | issue | SO-250804-542 | MAIN | 2 | 150.15 | -300.30 | 19 | 2,852.88 | June 25, 2025: 2 @ 150.15 |
| July 17, 2025 | issue | SO-250717-859 | EAST | 1 | 150.15 | -150.15 | 21 | 3,153.19 | June 25, 2025: 1 @ 150.15 |
| July 10, 2025 | issue | SO-250710-668 | MAIN | 11 | 150.15 | -1,651.67 | 22 | 3,303.34 | June 25, 2025: 11 @ 150.15 |
| July 2, 2025 | issue | SO-250702-653 | MAIN | 7 | 150.15 | -1,051.06 | 33 | 4,955.01 | June 25, 2025: 7 @ 150.15 |
| June 29, 2025 | issue | SO-250629-790 | MAIN | 15 | 150.19 | -2,252.89 | 40 | 6,006.07 | April 22, 2025: 3 @ 150.35; June 25, 2025: 12 @ 150.15 |
| June 25, 2025 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| June 25, 2025 | receipt | PO-000666 | MAIN | 52 | 150.15 | 7,807.89 | 55 | 8,258.96 | |
| June 23, 2025 | issue | SO-250623-632 | EAST | 11 | 150.35 | -1,653.90 | 3 | 451.06 | April 22, 2025: 11 @ 150.35 |
| June 23, 2025 | issue | SO-250623-632 | MAIN | 4 | 150.35 | -601.42 | 14 | 2,104.96 | April 22, 2025: 4 @ 150.35 |
| June 15, 2025 | issue | SO-250615-518 | MAIN | 5 | 150.35 | -751.77 | 18 | 2,706.38 | April 22, 2025: 5 @ 150.35 |
| May 24, 2025 | issue | SO-250524-597 | MAIN | 8 | 150.35 | -1,202.84 | 23 | 3,458.16 | April 22, 2025: 8 @ 150.35 |
| May 17, 2025 | issue | SO-250517-264 | MAIN | 2 | 150.35 | -300.71 | 31 | 4,660.99 | April 22, 2025: 2 @ 150.35 |
| May 12, 2025 | issue | SO-250512-567 | MAIN | 4 | 150.35 | -601.42 | 33 | 4,961.70 | April 22, 2025: 4 @ 150.35 |
| May 4, 2025 | issue | SO-250504-835 | MAIN | 13 | 150.35 | -1,954.61 | 37 | 5,563.12 | April 22, 2025: 13 @ 150.35 |
| April 22, 2025 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| April 22, 2025 | receipt | PO-000470 | MAIN | 50 | 150.35 | 7,517.73 | 50 | 7,517.73 | |
| April 19, 2025 | issue | SO-250419-834 | MAIN | 7 | 150.64 | -1,054.50 | 0 | 0.00 | March 28, 2025: 7 @ 150.64 |
| April 12, 2025 | issue | SO-250412-962 | MAIN | 14 | 150.64 | -2,109.00 | 7 | 1,054.50 | March 28, 2025: 14 @ 150.64 |
| March 28, 2025 | receipt | PO-000388 | MAIN | 21 | 150.64 | 3,163.51 | 21 | 3,163.51 | |
| March 8, 2025 | issue | SO-250308-700 | MAIN | 3 | 149.23 | -447.70 | 0 | 0.00 | Feb. 6, 2025: 3 @ 149.23 |
| March 4, 2025 | issue | SO-250304-695 | MAIN | 4 | 149.23 | -596.93 | 3 | 447.70 | Feb. 6, 2025: 4 @ 149.23 |
| March 1, 2025 | issue | SO-250301-408 | MAIN | 2 | 149.23 | -298.46 | 7 | 1,044.63 | Feb. 6, 2025: 2 @ 149.23 |
| Feb. 27, 2025 | issue | SO-250227-550 | MAIN | 1 | 149.23 | -149.23 | 9 | 1,343.09 | Feb. 6, 2025: 1 @ 149.23 |
| Feb. 21, 2025 | issue | SO-250221-759 | MAIN | 4 | 149.72 | -598.86 | 10 | 1,492.32 | Oct. 1, 2024: 1 @ 151.16; Feb. 6, 2025: 3 @ 149.23 |
| Feb. 16, 2025 | issue | SO-250216-807 | MAIN | 4 | 151.16 | -604.66 | 14 | 2,091.19 | Oct. 1, 2024: 4 @ 151.16 |
| Feb. 6, 2025 | receipt | PO-000243 | MAIN | 13 | 149.23 | 1,940.02 | 18 | 2,695.84 | |
| Feb. 4, 2025 | issue | SO-250204-802 | MAIN | 1 | 151.16 | -151.16 | 5 | 755.82 | Oct. 1, 2024: 1 @ 151.16 |
| Jan. 18, 2025 | issue | SO-250118-650 | MAIN | 5 | 151.16 | -755.82 | 6 | 906.98 | Oct. 1, 2024: 5 @ 151.16 |
| Jan. 16, 2025 | issue | SO-250116-969 | MAIN | 1 | 151.16 | -151.16 | 11 | 1,662.80 | Oct. 1, 2024: 1 @ 151.16 |
| Jan. 10, 2025 | issue | SO-250110-304 | MAIN | 2 | 151.16 | -302.33 | 12 | 1,813.97 | Oct. 1, 2024: 2 @ 151.16 |
| Dec. 18, 2024 | issue | SO-241218-272 | MAIN | 1 | 151.16 | -151.16 | 14 | 2,116.30 | Oct. 1, 2024: 1 @ 151.16 |
| Dec. 15, 2024 | issue | SO-241215-625 | MAIN | 1 | 151.16 | -151.16 | 15 | 2,267.46 | Oct. 1, 2024: 1 @ 151.16 |
| Nov. 30, 2024 | issue | SO-241130-530 | MAIN | 1 | 151.16 | -151.16 | 16 | 2,418.62 | Oct. 1, 2024: 1 @ 151.16 |
| Nov. 11, 2024 | issue | SO-241111-346 | MAIN | 1 | 151.16 | -151.16 | 17 | 2,569.79 | Oct. 1, 2024: 1 @ 151.16 |
| Nov. 3, 2024 | issue | SO-241103-719 | MAIN | 1 | 151.16 | -151.16 | 18 | 2,720.95 | Oct. 1, 2024: 1 @ 151.16 |
| Oct. 29, 2024 | issue | SO-241029-130 | MAIN | 2 | 151.16 | -302.33 | 19 | 2,872.12 | Oct. 1, 2024: 2 @ 151.16 |
| Oct. 27, 2024 | issue | SO-241027-101 | MAIN | 1 | 151.16 | -151.16 | 21 | 3,174.44 | Oct. 1, 2024: 1 @ 151.16 |
| Oct. 19, 2024 | issue | SO-241019-521 | MAIN | 1 | 151.16 | -151.16 | 22 | 3,325.61 | Oct. 1, 2024: 1 @ 151.16 |
| Oct. 14, 2024 | issue | SO-241014-140 | MAIN | 1 | 151.16 | -151.16 | 23 | 3,476.77 | Oct. 1, 2024: 1 @ 151.16 |
| Oct. 5, 2024 | issue | SO-241005-319 | MAIN | 2 | 151.16 | -302.33 | 24 | 3,627.94 | Oct. 1, 2024: 2 @ 151.16 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 26 | 151.16 | 3,930.26 | 26 | 3,930.26 | |