Items / FAN-0030
Ceiling Fan 1200mm Prime FAN-0030 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)21MAIN 21
Value (FIFO)5,264.96avg 250.71
ClassCZ / NCV -
Turnover0.0xlast issue 504 days ago
Days of cover-lead time 22d
NRV 187.8042 is below cost: lower-of-cost-or-NRV write-down 1,321.08.
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 | 0.00 / 30.4375 | 0.000 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.00 / 5.517 | 0.000 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(21.5 * 0.000^2 + 0.000^2 * 7.4^2) | 0.0 |
| Reorder point | d * LT + safety stock | 0.000 * 21.5 + 0.0 | 0.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 0/yr, S = 45.00, h = 20%, price = 274.12 | 1.0 |
| Inventory position | on hand + on order | 21 + 0 | 21 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 274.12 | 1 | 27 | yes (chosen if cheapest) |
MOQ 19, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 5, 2025 | 21 / 100 | 250.71 | 5,264.96 |
Movement ledger 44 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Jan. 23, 2026 | adjustment | Cycle count | MAIN | -1 | 250.71 | -250.71 | 21 | 5,264.96 | April 5, 2025: 1 @ 250.71 |
| May 30, 2025 | issue | SO-250530-843 | MAIN | 13 | 250.71 | -3,259.26 | 22 | 5,515.68 | April 5, 2025: 13 @ 250.71 |
| May 27, 2025 | issue | SO-250527-725 | MAIN | 5 | 250.71 | -1,253.56 | 35 | 8,774.94 | April 5, 2025: 5 @ 250.71 |
| May 22, 2025 | issue | SO-250522-602 | MAIN | 7 | 250.71 | -1,754.99 | 40 | 10,028.50 | April 5, 2025: 7 @ 250.71 |
| May 22, 2025 | issue | SO-250522-602 | EAST | 1 | 250.71 | -250.71 | 47 | 11,783.49 | April 5, 2025: 1 @ 250.71 |
| May 9, 2025 | issue | SO-250509-448 | MAIN | 2 | 250.71 | -501.43 | 48 | 12,034.20 | April 5, 2025: 2 @ 250.71 |
| May 5, 2025 | issue | SO-250505-231 | MAIN | 44 | 250.71 | -11,031.35 | 50 | 12,535.63 | April 5, 2025: 44 @ 250.71 |
| April 24, 2025 | issue | SO-250424-970 | MAIN | 3 | 250.71 | -752.14 | 94 | 23,566.98 | April 5, 2025: 3 @ 250.71 |
| April 23, 2025 | issue | SO-250423-501 | MAIN | 20 | 259.73 | -5,194.51 | 97 | 24,319.12 | March 13, 2025: 17 @ 261.32; April 5, 2025: 3 @ 250.71 |
| April 17, 2025 | issue | SO-250417-231 | EAST | 13 | 261.32 | -3,397.11 | 117 | 29,513.64 | March 13, 2025: 13 @ 261.32 |
| April 5, 2025 | receipt | PO-000414 | MAIN | 100 | 250.71 | 25,071.26 | 130 | 32,910.75 | |
| April 1, 2025 | issue | SO-250401-567 | MAIN | 4 | 261.32 | -1,045.26 | 30 | 7,839.49 | March 13, 2025: 4 @ 261.32 |
| March 28, 2025 | issue | SO-250328-208 | MAIN | 16 | 261.32 | -4,181.06 | 34 | 8,884.75 | March 13, 2025: 16 @ 261.32 |
| March 22, 2025 | issue | SO-250322-290 | MAIN | 14 | 261.06 | -3,654.82 | 50 | 13,065.81 | Oct. 1, 2024: 4 @ 260.41; March 13, 2025: 10 @ 261.32 |
| March 19, 2025 | issue | SO-250319-493 | MAIN | 4 | 260.41 | -1,041.66 | 64 | 16,720.63 | Oct. 1, 2024: 4 @ 260.41 |
| March 13, 2025 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| March 13, 2025 | receipt | PO-000337 | MAIN | 60 | 261.32 | 15,678.97 | 68 | 17,762.28 | |
| Feb. 24, 2025 | issue | SO-250224-822 | MAIN | 3 | 260.41 | -781.24 | 8 | 2,083.31 | Oct. 1, 2024: 3 @ 260.41 |
| Feb. 23, 2025 | issue | SO-250223-525 | MAIN | 4 | 260.41 | -1,041.66 | 11 | 2,864.55 | Oct. 1, 2024: 4 @ 260.41 |
| Feb. 19, 2025 | issue | SO-250219-520 | MAIN | 3 | 260.41 | -781.24 | 15 | 3,906.21 | Oct. 1, 2024: 3 @ 260.41 |
| Feb. 11, 2025 | issue | SO-250211-266 | MAIN | 9 | 260.41 | -2,343.73 | 18 | 4,687.45 | Oct. 1, 2024: 9 @ 260.41 |
| Jan. 25, 2025 | issue | SO-250125-686 | MAIN | 1 | 260.41 | -260.41 | 27 | 7,031.18 | Oct. 1, 2024: 1 @ 260.41 |
| Jan. 22, 2025 | issue | SO-250122-797 | MAIN | 8 | 260.41 | -2,083.31 | 28 | 7,291.59 | Oct. 1, 2024: 8 @ 260.41 |
| Jan. 19, 2025 | issue | SO-250119-634 | MAIN | 4 | 260.41 | -1,041.66 | 36 | 9,374.90 | Oct. 1, 2024: 4 @ 260.41 |
| Jan. 13, 2025 | issue | SO-250113-216 | MAIN | 1 | 260.41 | -260.41 | 40 | 10,416.56 | Oct. 1, 2024: 1 @ 260.41 |
| Dec. 30, 2024 | issue | SO-241230-214 | MAIN | 1 | 260.41 | -260.41 | 41 | 10,676.97 | Oct. 1, 2024: 1 @ 260.41 |
| Dec. 28, 2024 | issue | SO-241228-633 | MAIN | 3 | 260.41 | -781.24 | 42 | 10,937.39 | Oct. 1, 2024: 3 @ 260.41 |
| Dec. 21, 2024 | issue | SO-241221-765 | MAIN | 2 | 260.41 | -520.83 | 45 | 11,718.63 | Oct. 1, 2024: 2 @ 260.41 |
| Dec. 17, 2024 | issue | SO-241217-159 | MAIN | 1 | 260.41 | -260.41 | 47 | 12,239.46 | Oct. 1, 2024: 1 @ 260.41 |
| Dec. 7, 2024 | issue | SO-241207-530 | MAIN | 1 | 260.41 | -260.41 | 48 | 12,499.87 | Oct. 1, 2024: 1 @ 260.41 |
| Dec. 4, 2024 | issue | SO-241204-188 | MAIN | 1 | 260.41 | -260.41 | 49 | 12,760.29 | Oct. 1, 2024: 1 @ 260.41 |
| Dec. 1, 2024 | issue | SO-241201-683 | MAIN | 1 | 260.41 | -260.41 | 50 | 13,020.70 | Oct. 1, 2024: 1 @ 260.41 |
| Nov. 28, 2024 | issue | SO-241128-567 | MAIN | 3 | 260.41 | -781.24 | 51 | 13,281.11 | Oct. 1, 2024: 3 @ 260.41 |
| Nov. 19, 2024 | issue | SO-241119-986 | MAIN | 2 | 260.41 | -520.83 | 54 | 14,062.36 | Oct. 1, 2024: 2 @ 260.41 |
| Nov. 8, 2024 | issue | SO-241108-361 | MAIN | 2 | 260.41 | -520.83 | 56 | 14,583.18 | Oct. 1, 2024: 2 @ 260.41 |
| Nov. 5, 2024 | issue | SO-241105-564 | MAIN | 1 | 260.41 | -260.41 | 58 | 15,104.01 | Oct. 1, 2024: 1 @ 260.41 |
| Nov. 1, 2024 | issue | SO-241101-341 | MAIN | 1 | 260.41 | -260.41 | 59 | 15,364.43 | Oct. 1, 2024: 1 @ 260.41 |
| Oct. 27, 2024 | issue | SO-241027-843 | MAIN | 5 | 260.41 | -1,302.07 | 60 | 15,624.84 | Oct. 1, 2024: 5 @ 260.41 |
| Oct. 26, 2024 | issue | SO-241026-505 | MAIN | 2 | 260.41 | -520.83 | 65 | 16,926.91 | Oct. 1, 2024: 2 @ 260.41 |
| Oct. 20, 2024 | issue | SO-241020-128 | MAIN | 1 | 260.41 | -260.41 | 67 | 17,447.74 | Oct. 1, 2024: 1 @ 260.41 |
| Oct. 17, 2024 | issue | SO-241017-892 | MAIN | 2 | 260.41 | -520.83 | 68 | 17,708.15 | Oct. 1, 2024: 2 @ 260.41 |
| Oct. 15, 2024 | issue | SO-241015-708 | MAIN | 2 | 260.41 | -520.83 | 70 | 18,228.98 | Oct. 1, 2024: 2 @ 260.41 |
| Oct. 9, 2024 | issue | SO-241009-866 | MAIN | 2 | 260.41 | -520.83 | 72 | 18,749.81 | Oct. 1, 2024: 2 @ 260.41 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 74 | 260.41 | 19,270.64 | 74 | 19,270.64 | |