Job Work & Subcontracting Analysis Report
Job Work & Subcontracting Analysis - User Guide
1. Introduction ๐ญ๐ ๏ธ
In modern manufacturing, outsourcing specialized processes (e.g., Heat Treatment, Electroplating, Anodizing, Specialized Turning) to third-party vendors is standard practice. The Job Work Analysis Report provides complete visibility over “Inventory Lying with Vendors.” It ensures that every kilogram or unit of raw material sent out on a Delivery Challan is reconciledโeither returned as passed finished components or accounted for as allowable process scrap.
โน๏ธ
Core Objectives:
- Vendor Stock Reconciliation: Monitor exact quantities and weights of inventory currently held at vendor premises.
- Yield & Loss Auditing: Contrast sent input weights against returned output weights to identify unauthorized losses.
- Pending Challan Aging: Track open subcontracting dispatches exceeding expected turnaround times.
- GST Statutory Verification: Reconcile outward vs inward delivery challans for quarterly and annual tax compliance.
Typically, this report is used by PPC Managers, Store Keepers, Subcontracting In-Charges, and Cost Accountants.
2. Accessing the Report ๐
Navigate to Manufacturing > Reports > Job Analysis.
3. Analysis Options & Generated Workbooks โจ
The generation interface allows selection of three primary report modes:
A. Job Out Analysis (JobOut_Report.xlsx)
- Outward Dispatches: Tracks materials issued from company stores to external subcontractors.
- Balancing Logic: Reconciles outward delivery challans against inward receipts, displaying issued quantity, returned quantity, and outstanding balance.
- Aging Analysis: Calculates elapsed turnaround days since outward dispatch to highlight overdue vendor jobs.
B. Job In Analysis (JobIn_Report.xlsx)
- Inward Receipts: Tracks returned processed materials received back at company gates.
- Quality Stratification: Classifies returned items by state (Good vs. Rejected vs. Rework) and reconciles scrap returned.
C. Plan Vs Actual Analysis (PlanVsActual_Report.xlsx)
- Yield & Conversion Audit: Contrasts original planned target quantities/weights against actual received quantities.
- Tolerance Enforcement: Evaluates process loss percentages against engineering standards, detecting abnormal melting, machining, or scale loss.
4. Key Filters & Analytical Controls ๐ ๏ธ
- Vendor (Party) & Process Filtering: Restrict analysis to a specific subcontractor or manufacturing operation.
- Pending Jobs Only: Filters out balanced/closed challans, displaying only active outward materials currently lying at vendor premises.
- “Omit Challan received after the To Date”: A vital historical audit control. When reconciling vendor inventory as of a past date (e.g. financial year-end or month-end audit), checking this option ignores any inward receipts that took place after the selected “To Date,” recreating the exact point-in-time stock balance.
- Report Queue Alert: To maintain server responsiveness, large multi-vendor queries are processed asynchronously. If 15 or more background requests are currently pending, the system displays a status alert.
5. Key Column Definitions ๐
- Challan / Annexure No & Date: Official delivery document number and issue date.
- Target Qty / Weight: Planned output expected to be returned.
- Actual Received Qty / Weight: Net good physical material received back.
- Balance Qty / Weight: Outstanding balance still accountable to the job worker.
- Aging (Days): Turnaround duration since material dispatch.
6. Best Practices / Tips ๐ก
- Weekly Overdue Challan Review: Filter by “Pending Jobs Only” every week to follow up on open challans with aging exceeding standard turnaround thresholds (e.g., > 10 days).
- Use Historical Cutoff for Audits: Always check “Omit Challan received after the To Date” when running stock reconciliation for past statutory tax periods or physical stock verification dates.
- Track Rejected Material Segregation: Ensure materials returned under “Rejected” status are promptly routed for vendor rework or charged back via commercial debit notes.