Business Intelligence Reports
Comprehensive analytics and data exports for inventory, procurement, and
maintenance operations
📊 Report Generation System
Select a report type below to configure filters and generate detailed analytics.
All reports can be exported to Excel or PDF format.
Item-wise Purchase History
⭐
Complete purchase history for each inventory item with supplier and
pricing details
Popular
Batch-wise Movement
Track batch movements from receipt to consumption with full traceability
Machine-wise Spare Cost
⭐
Analyze spare parts costs per machine with trend analysis and
forecasting
Price Fluctuation Report
Monitor price changes over time for critical items and identify
cost-saving opportunities
Trending
Stock Valuation Report
📌
Saved
Current inventory value with FIFO/LIFO costing and aging analysis
📦
Item-wise Purchase History Report
Use this report to identify high-spend items, supplier dependency, and abnormal price movements.
247
Total Items
1,842
Purchase Orders
৳18.4M
Total Purchase Value
8
Active Suppliers
| Item Code | Item Name | Category | Total Qty Purchased | Total Value | Vs Last Qtr | Avg Unit Price | Last Purchase Date | Primary Supplier | Action |
|---|---|---|---|---|---|---|---|---|---|
| SP-TTS-JK | Thread Tension Spring ⚠ Usage Spike | Spare Parts | 145 pcs | ৳123,250 | +15% vs Avg | ৳850 | Jan 15, 2026 | Juki Bangladesh | View Details (12 batches) |
| SP-NBA-MO | Needle Bar Assembly | Spare Parts | 28 pcs | ৳406,000 | -2% vs Avg | ৳14,500 | Dec 22, 2025 | Singer Bangladesh | View Details (4 suppliers) |
| RM-THR-40 | Polyester Thread 40/2 (5000m) | Raw Materials | 2,450 cones | ৳1,225,000 | Same | ৳500 | Jan 20, 2026 | Bengal Thread Mills | View Details (Active PO) |
| SP-ULP-MO | Upper Looper | Spare Parts | 42 pcs | ৳134,400 | -8% vs Avg | ৳3,200 | Nov 28, 2025 | Juki Bangladesh | View Details (3 batches) |
| TR-BTN-15 | Plastic Button 15mm (White) | Trims & Accessories | 125,000 pcs | ৳62,500 | Same | ৳0.50 | Jan 10, 2026 | YKK Bangladesh | View Details (High vol) |
| SP-OIL-5L | Machine Oil (5L) | Consumables | 380 ltrs | ৳171,000 | +5% vs Avg | ৳450 | Jan 18, 2026 | Singer Bangladesh | View Details (Recurriung) |
| SP-RHA-MO | Rotary Hook Assembly | Spare Parts | 18 pcs | ৳288,000 | +12% vs Avg | ৳16,000 | Oct 15, 2025 | Juki Bangladesh | View Details (Critical) |
| SP-NDL-14 | Needle Set (Size 14) | Consumables | 8,450 pcs | ৳101,400 | -1% vs Avg | ৳12 | Jan 22, 2026 | Groz-Beckert | View Details (Bulk) |
💡 Consider reviewing suppliers with frequent price changes or high dependency ratios to diversify
procurement risk.
Data Notes: Figures based on recorded purchase
transactions. Manual adjustments and pending postings may affect totals. Supplier pricing reflects
last confirmed purchase order.
🔄
Batch-wise Movement Report
Use this to trace specific lot numbers for quality control audits and defect investigation.
1,247
Active Batches
8,942
Total Movements
৳12.4M
Current Batch Value
156
Depleted Batches
| Batch Number | Item Name | Movement Type | Date | Quantity | Remaining | Issued To | Reference | Action |
|---|---|---|---|---|---|---|---|---|
| BTH-2026-0034 | Thread Tension Spring | Issued | Jan 26, 2026 | 1 pc | 3 pcs | Machine SM-034 | WO-2026-0157 | View |
| BTH-2026-0034 | Thread Tension Spring | Received | Jan 15, 2026 | 25 pcs | 4 pcs | - | PO-2026-0198 | View |
| BTH-2025-1287 | Machine Oil (5L) | Issued | Dec 28, 2025 | 2 ltrs | 18 ltrs | Machine SM-034 | WO-2025-1243 | View |
| BTH-2025-1089 | Upper Looper | Issued | Nov 14, 2025 | 1 pc | 0 pcs | Machine SM-034 | WO-2025-1156 | View |
| BTH-2025-0956 | Cleaning Solution (500ml) | Adjusted | Nov 05, 2025 | -2 btl | 12 btl | - | ADJ-2025-089 | View |
💡 Monitor batches with rapid depletion rates to identify potential quality issues or process
inefficiencies.
Data Notes: Movement data reflects system-recorded
transactions. Batch traceability is subject to proper GRN and issue documentation. Historical
movements may include system migrations.
⚙️
Machine-wise Spare Cost Analysis
Analyze this to spot "lemon" machines with abnormally high maintenance costs vs. production
value.
Top 10 Machines by Spare Cost (Last 12 Months)
95
Total Machines
৳8.4M
Total Spare Cost (YTD)
৳88,421
Avg Cost per Machine
+12.4%
YoY Change
| Machine No | Type | Line / Floor | Total Spare Cost (YTD) | Avg Monthly Cost | Trend vs Last Year | Cost Efficiency | Top Spare Item | Action |
|---|---|---|---|---|---|---|---|---|
| SM-034 | Sewing - Overlock 4T | Line C / Floor 2 | ৳84,600 | ৳7,050 | +18.2% | 1.4x Avg | Needle Bar Assembly | View (18 mths data) |
| CM-012 | Cutting - Auto | Cutting / Floor 1 | ৳156,800 | ৳13,067 | +24.5% ⚠ Cost Spike | 2.1x Avg | Cutting Blade Set | View (Recall history) |
| EM-003 | Embroidery - 6 Head | Special / Floor 1 | ৳124,200 | ৳10,350 | -5.2% | 0.9x Avg | Rotary Hook Assembly | View (Under warranty) |
| SM-018 | Sewing - Buttonhole | Line B / Floor 2 | ৳92,400 | ৳7,700 | +8.9% | 1.0x Avg | Buttonhole Knife | View (Standard) |
| PM-007 | Pressing - Steam | Finishing / Floor 3 | ৳68,500 | ৳5,708 | +1.2% | 0.8x Avg | Steam Valve Gasket | View (Low maint) |
💡 Investigate machines with abnormally high spare costs to determine if replacement or
refurbishment is more cost-effective.
Data Notes: Cost analysis based on work order spare
consumption and maintenance records. Trend calculations use year-over-year comparison. Machine
downtime costs not included.
📈
Price Fluctuation Analysis
Monitor this to catch unauthorized supplier price hikes and negotiate better quarterly
contracts.
Price Trend Analysis - Top 5 Items by Fluctuation
42
Items Tracked
18
Price Increases
8
Price Decreases
+8.4%
Avg Price Change
| Item Code | Item Name | Current Price | Previous Price | Change | % Change | Vs Market | Last Updated | Supplier | Action |
|---|---|---|---|---|---|---|---|---|---|
| SP-NBA-MO | Needle Bar Assembly | ৳15,200 | ৳14,500 | +৳700 | +4.8% | +2% High | Dec 22, 2025 | Singer Bangladesh | Details (via PO-205) |
| RM-THR-40 | Polyester Thread 40/2 | ৳520 | ৳500 | +৳20 | +4.0% | On Par | Jan 20, 2026 | Bengal Thread Mills | Details (contract) |
| SP-TTS-JK | Thread Tension Spring | ৳850 | ৳820 | +৳30 | +3.7% | -5% Low | Jan 15, 2026 | Juki Bangladesh | Details (spot buy) |
| SP-OIL-5L | Machine Oil (5L) | ৳430 | ৳450 | -৳20 | -4.4% | -8% Low | Jan 18, 2026 | Singer Bangladesh | Details (bulk) |
| SP-RHA-MO | Rotary Hook Assembly | ৳16,800 | ৳16,000 | +৳800 | +5.0% ⚠ Markup | +6% High | Oct 15, 2025 | Juki Bangladesh | Details (disputed) |
💡 Review suppliers with high price volatility and consider negotiating fixed-price contracts for
critical items.
Data Notes: Price fluctuation analysis based on purchase
order history. Market comparison estimates derived from supplier quotations. Currency fluctuations
may affect international purchases.
💰
Stock Valuation Report
Use this report to understand tied-up capital, slow-moving inventory, and financial audit
valuation.
Stock Value Distribution by Category
Risk Indicators
Slow-moving stock (>90 days)
৳1.1M
Dead stock (>180 days)
৳0.6M
High-value low-turnover items
7 Items
৳12.4M
Total Stock Value
৳8.2M
Spare Parts Value
৳3.1M
Raw Materials Value
৳1.1M
Slow Moving Stock
| Item Code | Item Name | Category | Current Stock | Unit Cost (FIFO) | Total Value | Age (Days) | Turnover Rate | Action |
|---|---|---|---|---|---|---|---|---|
| SP-TTS-JK | Thread Tension Spring | Spare Parts | 4 pcs | ৳850 | ৳3,400 | 12 days | High | View |
| RM-THR-40 | Polyester Thread 40/2 | Raw Materials | 1,250 cones | ৳520 | ৳650,000 | 7 days | Very High | View |
| SP-NBA-MO | Needle Bar Assembly | Spare Parts | 4 pcs | ৳15,200 | ৳60,800 | 35 days | Medium | View |
| SP-RHA-MO | Rotary Hook Assembly | Spare Parts | 1 pc | ৳16,800 | ৳16,800 | 104 days ⚠ Aging | Low | View |
| TR-BTN-15 | Plastic Button 15mm | Trims | 45,000 pcs | ৳0.50 | ৳22,500 | 17 days | High | View |
| SP-OIL-5L | Machine Oil (5L) | Consumables | 68 ltrs | ৳430 | ৳29,240 | 9 days | Very High | View |
💡 Plan purchase orders for low-stock critical items and consider liquidating slow-moving inventory
to free up working capital.
Data Notes: Stock valuation uses FIFO costing method.
Physical stock verification conducted quarterly. Aging analysis based on last movement date.
Consignment stock excluded from totals.