info@end2end.lk
No. 11, Crest Wood Terrace, Hokandara Road, Thalawatugoda, Sri Lanka.
end2end Company Profile

How We Digitized Manpower Planning for Garment Finishing Operations

Home Blog
mc
End2End Solutions

How We Digitized Manpower Planning for Garment Finishing Operations — A Custom Tool Built for the Apparel Industry

In the apparel manufacturing world, the finishing department is where every garment reaches its final form before it leaves the factory floor. It is also one of the most labour-intensive, operationally complex, and time-sensitive departments in the entire production chain. Despite its critical role, manpower planning in finishing operations has traditionally relied on spreadsheets, gut feel, and experience — a combination that often results in overstaffing, understaffing, production bottlenecks, and missed delivery targets.

At End2End Solutions, we believe that sustainable operational excellence in the apparel industry comes from one thing above all: the right data, in the right hands, at the right time. This is the story of how we identified a genuine operational challenge in a garment finishing department and built a purpose-built digital tool to solve it.

The Problem: Manual Manpower Planning in a High-Speed Environment

    A garment finishing department typically handles dozens of different styles simultaneously-each with its own set of operations, standard minute values (SMVs), wash types, and delivery timelines. The operations themselves are split across two major phases:

  • Pre Wash operations — actions performed on the garment before it goes through the wash process (tacking, stitching, quality checks)
  • Post Wash operations-actions performed after washing (thread trimming, inspection, finishing, folding, packing)

    • Each style demands a different combination of these operations. The quantity received daily varies. The number of available working hours changes. And on top of all this, the department must simultaneously manage a Receive Plan (incoming garments from production) and a Dispatch Plan (outgoing finished garments to the warehouse or shipping).

    Planning manpower for this environment manually — using spreadsheets, calculators, and printed loading plans — creates several well-known pain points:

  • Supervisors spend significant time every morning calculating how many workers are needed per operation
  • Numbers are inconsistent between shifts and supervisors
  • There is no easy way to visualize manpower needs across a date range
  • Adjusting for last-minute quantity changes requires recalculating everything from scratch
  • There is no clear audit trail or reference document for planning decisions

These are not small inefficiencies. In a department processing thousands of garments daily, a miscalculation of even a few workers per operation can result in production delays, overtime costs, or quality escapes.

The Solution: A Purpose-Built Manpower Forecasting Tool

    End2End Solutions designed and implemented a custom digital manpower forecasting system specifically for garment finishing operations. The tool was built as a lightweight, browser-based application — meaning it requires no installation, no server infrastructure, and no IT department to maintain. It runs directly in any modern web browser from a single HTML file.

    The system is built on a core manpower calculation formula used across the apparel industry: Manpower Required = (Quantity × SMV) / (Available Hours × 60 × Efficiency %)

    This formula is applied per operation, per style, per day — automatically — the moment the planning data is loaded.

Key Features and Capabilities
1. Intelligent Data Import

    The tool reads directly from the existing Excel-based production loading plan used by the department. No data re-entry required. The system automatically identifies the relevant planning sheet, extracts style names, quantities, factory allocations, and dates — and maps them to the style master database.

2. Style Master Database

    Every style in the department is stored with its complete set of operations, SMV values, and efficiency settings. Both Pre Wash and Post Wash operations are maintained separately. The database can be updated through a dedicated Style Master Editor — a companion tool that allows adding new styles, editing existing ones, and exporting the updated file — all without touching any code.

3. Five Calculation Modes

    The system offers five distinct operational modes, each designed for a specific planning scenario:

    • Daily Planned Forecast — calculates manpower from the planned daily quantities in the loading plan
    • Weekly Planned Forecast — generates a manpower pivot table across a selected date range, with factory filtering and a line chart view
    • Style Master Editor — full CRUD management for the style and operation database with configurable default efficiency settings
    • Receive & Dispatch Forecast — independently calculates Pre Wash manpower from the Receive Plan and Post Wash manpower from the Dispatch Plan, with separate quantity inputs and available hours per row
4. Configurable Efficiency Settings

    Default efficiency values for Pre Wash and Post Wash operations are configurable directly within the tool. Individual operations can carry their own efficiency override, and where no override is set, the department-level default applies automatically. This gives managers the ability to reflect realistic productivity standards without modifying any formula.

5. Comprehensive Summary Views

    After calculating manpower, the tool generates structured summary views including:

    • Factory-wise Quantity Summary — total garments received and dispatched per factory per date
    • Factory-wise Manpower Summary — total manpower requirement per factory per date
    • Operation-wise Manpower Breakdown — manpower required per individual operation across the date range, with daily totals and range totals
6. Detailed Style-by-Style Breakdown

    Every confirmed style shows a detailed card displaying each operation with its SMV, efficiency percentage, actual manpower value, and rounded manpower requirement. Filters allow users to narrow the view by style name, factory, or wash type instantly.

7. Export to PDF and Excel

    All summary views can be exported to a formatted PDF report (landscape A4, branded header, page numbers) or to an Excel file with separate sheets for Receive Plan and Dispatch Plan data — ready for sharing with department managers or uploading to reporting systems.

8. Multi-Factory Support

    The tool handles multi-factory environments natively. Factory filter pills allow users to select one or multiple factories simultaneously, with the manpower calculation and summary views updating instantly to reflect the selected scope.

The Style Master Editor — A Companion Tool

    One of the most operationally important components of this system is the Style Master Editor — a standalone tool designed for the Industrial Engineering or Planning team.

    Built as a separate browser-based application, it allows authorised users to:

  • Upload the existing style database (Excel format)
  • View all existing styles with their current Pre Wash and Post Wash operations and SMV values
  • Add new styles with operation-level SMV and quantity reference values
  • Edit existing styles — updating SMVs or adding/removing operations
  • Queue multiple style additions and edits in a single session
  • Download the updated Excel file with all changes applied — new styles appended and edited styles updated in-place, with automatic SL numbering and total calculations

      • A duplicate style detection system alerts the user if a style name already exists in the database, and a similar-name warning suggests the correct colour-variant format when relevant (e.g. Style (COLOUR NAME).

      SMV KPI cards update in real time as values are entered — showing the total Pre Wash SMV, total Post Wash SMV, and combined grand total — giving IE engineers an immediate visual check before saving.


The Technology Approach

    A deliberate decision was made to keep the tool as operationally simple as possible. There is no database server, no cloud infrastructure, and no login system to manage. The entire application runs in a browser from a single HTML file.

    This approach was chosen for very specific reasons:

  • Zero installation — any computer with a modern browser can run it immediately
  • Zero maintenance overhead — no server updates, no database backups, no IT dependency
  • Offline capable — works without internet connectivity, critical in factory floor environments
  • File-based data — all data flows through the existing Excel files the department already uses
  • Rapid deployment — the tool can be updated and redistributed in minutes

    The result is a system that sits at the intersection of industrial engineering discipline and practical digital deployment — sophisticated in its calculation logic, but simple enough that any supervisor can use it without training.

Business Impact

    The implementation of this tool directly addresses the following measurable outcomes for garment finishing departments:

  • Reduced planning time — manpower calculations that previously took 30–60 minutes per shift are completed in seconds
  • Improved accuracy — consistent formula application eliminates human calculation errors
  • Better visibility — supervisors and managers see the same numbers from the same data source
  • Faster response to change — when quantities change, recalculation is instant
  • Improved accountability — PDF and Excel exports create a dated record of every planning decision