Inventory client
Sunhaven Hardware
Vision
To be the first choice of builders and homeowners for hardware and construction supply, recognized for excellence and honest service.
Mission
We make hardware and construction supply simpler and more reliable for builders and homeowners, combining local knowledge with modern practices and responsible growth.
Last 6 months · May – Oct 2026
Stock value
₱7.04M
Down 15.8% vs Sep
Items in stock
183
19,674 units on hand
Low stock
6
Down 14.3% vs Sep
Listed below
Open orders
9
Purchase orders not yet received
Stock in and stock out
Per month, in units
- Stock in
- Stock out
View as table
| Month | Stock in | Stock out |
|---|---|---|
| May 2026 | 14,778 | 14,918 |
| June 2026 | 12,788 | 13,706 |
| July 2026 | 13,471 | 11,984 |
| August 2026 | 8,193 | 12,049 |
| September 2026 | 9,140 | 13,441 |
| October 2026 | 7,857 | 11,554 |
Order fill rate
Customer orders shipped complete in October
Recent activity
- Delivery of 267 units received from supplierToday, 8:52 AM
- Kristine Villanueva created a purchase order for Portland cement 40kgYesterday
- Cycle count completed for Building materialsNov 16
- Carlo Bautista adjusted stock after a damaged-goods reportNov 14
Stock value by category
Today
- Building materials₱2.88M41%
- Tools₱1.49M21%
- Electrical₱1.35M19%
- Plumbing₱1.01M14%
- Other₱311K4%
Items running low
| Item | On hand | Reorder at | Status |
|---|---|---|---|
| Deformed bar 10mm | 29 | 190 | Critical |
| PVC pipe 1/2" | 45 | 300 | Critical |
| GI sheet gauge 26 | 17 | 110 | Critical |
| Portland cement 40kg | 171 | 290 | Low |
| Circuit breaker 20A | 155 | 190 | Low |
| Electrical wire 3.5mm | 129 | 290 | Low |
Business health · October figures
At risk
4 areas to watch. Stock levels (6 low · 3 critical) and stock flow (0.68 in for every 1 out) need the most attention.
Health checks
-
Problem
Stock levels6 low · 3 critical
Items below their reorder level. Critical means under 40% of it.
-
Problem
Stock flow0.68 in for every 1 out
Units received compared with units sold, last 3 months.
-
Problem
Order fill rate87.6%
Customer orders shipped complete in October. Target: 97%.
-
Problem
Stock valuedown 15.8% vs Sep
Total value of stock on hand compared with last month.
Suggested actions
- High Reorder the critical items now: Deformed bar 10mm, PVC pipe 1/2", GI sheet gauge 26.
- High Stock is running down (0.68 in for every 1 out): raise purchase orders before items run out.
- High Lift the order fill rate (87.6%) to 97%: check which items caused short shipments.
- High Stock value fell 15.8%: confirm it is planned (clearance) and not missing stock.
- Low Keep the monthly cycle count and review reorder levels each quarter.
Suggested actions for the account manager, based on the figures in the Dashboard tab. Each check compares one figure with a set limit.