Job Work & Subcontracting Analysis Report

Job Work & Subcontracting Analysis - User Guide

1. Introduction 🏭🛠️

In modern manufacturing, it is common to send raw materials to external vendors for specialized processes like hardening, plating, coating, or specialized machining. The Job Work Analysis Report is your primary tool for tracking this “Inventory on Loan.” It ensures that every kilogram of material sent out is accounted for, either returned as finished parts or justified as process scrap.

This report is essential for Production Managers, Store Keepers, and Cost Accountants.

2. Key Analysis Modules 🚀

A. Job Out Analysis (Out-Sourced)

• The Loan Cycle: Tracks materials sent by your organization to a third party. The system marks a job as “Matched” (Closed) only when the returned quantity/weight cancels out the issued quantity.
• Aging Alert: Automatically calculates how many days a material has been with a vendor. Use this to follow up on delayed shipments.

B. Job In Analysis (Service Providing)

• Customer Stock Tracking: If your factory performs job work for others, this module tracks the materials received from customers and ensures they are returned after processing.

C. Plan Vs Actual (Efficiency Audit)

• Yield Recovery: Specifically designed to highlight the “Gap” between your production plan and the actual quantity received. This is critical for processes where weight loss (e.g., evaporation or scale loss) is expected but must be kept within tolerance.

3. Advanced Features & Controls 🛠️

• “Matched” Logic: The report uses sophisticated background matching. If you send 1000kg and receive 995kg with a 5kg acceptable loss, the system helps you “Close” the job to clear your pending registers.
• Omit Future Returns: A strategic audit filter that allows you to see the “Pending Stock” as of a specific historical date, ignoring any returns that happened after that date.
• State-Wise Tracking: Categorizes returned goods as “Good” or “Rejected,” allowing for immediate quality-based financial adjustments or re-processing.

4. Understanding Data Columns 📊

• Annexure No & Date: The unique Challan/Document reference for the material movement.
• Target Weight / Plan: The expected quantity to be received back.
• Actual Weight: The physical quantity actually returned by the vendor.
• Balance Weight: The “Shortage” or “Pending” amount still with the worker.
• Aging (Days): Total days elapsed since the material was sent out.
• Job Item Notes: Specific instructions given to the worker (e.g., “Heat treat to 45 HRC”).

5. Source Transactions 🔄

The reporting engine synthesizes data from:

1. Job Work Master: Defines the Vendor, Process, and Unit.
2. Job Work Details (JobWork1): Chronological log of “IN” and “OUT” movements.
3. Inventory Master: Item specifications and unit of measurements.

6. Best Practices / Tips 💡