Items / FAN-0028
Ceiling Fan 1200mm Flex FAN-0028 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)75MAIN 75
Value (FIFO)17,391.98avg 231.89
ClassCZ / NCV -
Turnover0.0xlast issue 503 days ago
Days of cover-lead time 22d
NRV 118.7034 is below cost: lower-of-cost-or-NRV write-down 8,489.23.
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 = 241.65 | 1.0 |
| Inventory position | on hand + on order | 75 + 0 | 75 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 241.65 | 1 | 24 | yes (chosen if cheapest) |
| 20 | 231.98 | 20 | 464 | yes |
| 40 | 222.32 | 40 | 889 | yes |
MOQ 10, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 1, 2025 | 75 / 75 | 231.89 | 17,391.98 |
Movement ledger 32 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| June 1, 2025 | receipt | PO-000596 | MAIN | 75 | 231.89 | 17,391.98 | 75 | 17,391.98 | |
| May 31, 2025 | issue | SO-250531-955 | MAIN | 1 | 230.33 | -230.33 | 0 | 0.00 | April 11, 2025: 1 @ 230.33 |
| May 29, 2025 | issue | SO-250529-448 | MAIN | 3 | 230.33 | -690.99 | 1 | 230.33 | April 11, 2025: 3 @ 230.33 |
| May 24, 2025 | issue | SO-250524-469 | MAIN | 2 | 230.33 | -460.66 | 4 | 921.32 | April 11, 2025: 2 @ 230.33 |
| May 21, 2025 | issue | SO-250521-622 | MAIN | 1 | 230.33 | -230.33 | 6 | 1,381.98 | April 11, 2025: 1 @ 230.33 |
| May 18, 2025 | issue | SO-250518-769 | MAIN | 11 | 230.33 | -2,533.62 | 7 | 1,612.31 | April 11, 2025: 11 @ 230.33 |
| May 16, 2025 | issue | SO-250516-718 | MAIN | 20 | 230.33 | -4,606.59 | 18 | 4,145.93 | April 11, 2025: 20 @ 230.33 |
| May 8, 2025 | issue | SO-250508-560 | MAIN | 5 | 230.33 | -1,151.65 | 38 | 8,752.52 | April 11, 2025: 5 @ 230.33 |
| April 29, 2025 | issue | SO-250429-529 | MAIN | 10 | 229.37 | -2,293.71 | 43 | 9,904.17 | Feb. 16, 2025: 2 @ 225.53; April 11, 2025: 8 @ 230.33 |
| April 11, 2025 | issue | SO-250411-808 | MAIN | 2 | 225.53 | -451.07 | 53 | 12,197.87 | Feb. 16, 2025: 2 @ 225.53 |
| April 11, 2025 | receipt | PO-000437 | MAIN | 51 | 230.33 | 11,746.80 | 55 | 12,648.94 | |
| April 8, 2025 | issue | SO-250408-293 | MAIN | 2 | 225.53 | -451.07 | 4 | 902.14 | Feb. 16, 2025: 2 @ 225.53 |
| April 2, 2025 | issue | SO-250402-131 | MAIN | 7 | 225.53 | -1,578.74 | 6 | 1,353.21 | Feb. 16, 2025: 7 @ 225.53 |
| March 31, 2025 | issue | SO-250331-259 | MAIN | 3 | 225.53 | -676.60 | 13 | 2,931.95 | Feb. 16, 2025: 3 @ 225.53 |
| March 21, 2025 | issue | SO-250321-794 | MAIN | 10 | 228.36 | -2,283.58 | 16 | 3,608.56 | Oct. 1, 2024: 7 @ 229.57; Feb. 16, 2025: 3 @ 225.53 |
| Feb. 28, 2025 | issue | SO-250228-267 | MAIN | 3 | 229.57 | -688.70 | 26 | 5,892.13 | Oct. 1, 2024: 3 @ 229.57 |
| Feb. 16, 2025 | receipt | PO-000270 | MAIN | 19 | 225.53 | 4,285.16 | 29 | 6,580.83 | |
| Feb. 1, 2025 | issue | SO-250201-993 | MAIN | 6 | 229.57 | -1,377.40 | 10 | 2,295.68 | Oct. 1, 2024: 6 @ 229.57 |
| Jan. 30, 2025 | issue | SO-250130-438 | MAIN | 1 | 229.57 | -229.57 | 16 | 3,673.08 | Oct. 1, 2024: 1 @ 229.57 |
| Jan. 29, 2025 | issue | SO-250129-423 | MAIN | 4 | 229.57 | -918.27 | 17 | 3,902.65 | Oct. 1, 2024: 4 @ 229.57 |
| Jan. 20, 2025 | issue | SO-250120-243 | MAIN | 2 | 229.57 | -459.14 | 21 | 4,820.92 | Oct. 1, 2024: 2 @ 229.57 |
| Jan. 17, 2025 | issue | SO-250117-623 | MAIN | 2 | 229.57 | -459.14 | 23 | 5,280.05 | Oct. 1, 2024: 2 @ 229.57 |
| Jan. 16, 2025 | issue | SO-250116-973 | MAIN | 1 | 229.57 | -229.57 | 25 | 5,739.19 | Oct. 1, 2024: 1 @ 229.57 |
| Dec. 29, 2024 | issue | SO-241229-173 | MAIN | 1 | 229.57 | -229.57 | 26 | 5,968.76 | Oct. 1, 2024: 1 @ 229.57 |
| Dec. 22, 2024 | issue | SO-241222-125 | MAIN | 1 | 229.57 | -229.57 | 27 | 6,198.32 | Oct. 1, 2024: 1 @ 229.57 |
| Dec. 13, 2024 | issue | SO-241213-944 | MAIN | 2 | 229.57 | -459.14 | 28 | 6,427.89 | Oct. 1, 2024: 2 @ 229.57 |
| Dec. 9, 2024 | issue | SO-241209-303 | MAIN | 1 | 229.57 | -229.57 | 30 | 6,887.02 | Oct. 1, 2024: 1 @ 229.57 |
| Nov. 17, 2024 | issue | SO-241117-327 | MAIN | 1 | 229.57 | -229.57 | 31 | 7,116.59 | Oct. 1, 2024: 1 @ 229.57 |
| Nov. 4, 2024 | issue | SO-241104-648 | MAIN | 1 | 229.57 | -229.57 | 32 | 7,346.16 | Oct. 1, 2024: 1 @ 229.57 |
| Oct. 23, 2024 | issue | SO-241023-620 | MAIN | 2 | 229.57 | -459.14 | 33 | 7,575.73 | Oct. 1, 2024: 2 @ 229.57 |
| Oct. 18, 2024 | issue | SO-241018-495 | MAIN | 3 | 229.57 | -688.70 | 35 | 8,034.86 | Oct. 1, 2024: 3 @ 229.57 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 38 | 229.57 | 8,723.56 | 38 | 8,723.56 |