Team Member - Inventory Control Finance

Division

Finance

Department

Operations Finance

Sub Department

SCM Finance

Job Purpose

Provide Finance partnership and support to Integrated Planning Business function in the area of slow-moving inventory, Purchase requisition evaluations, disposals, identifying high risk inventory and driving governance to minimize inventory write off and optimise overall inventory.

Key Accountabilities (1/6)

Monitor Slow moving / Near Expiry RMPM Inventory in India and ensure liquidation plans are in place to minimize inventory write off.

• Coordinate with planning cluster and align slow moving inventory target for the year.
• Prepare and circulate slow moving MIS covering cluster wise actual slow moving vs target / LE comparison.
• Participate in periodic inventory performance review with respective cluster and ensure reason for slow-moving liquidation plan and timeline are available and updated in SAP.
• Prepare monthly slow-moving projections for 6 months and ensure liquidations plan are available and updated in SAP. Inventory without liquidation plan is highlighted as risk inventory and discussed in respective forum to minimize inventory write off risk.

Key Accountabilities (2/6)

Monitor Slow moving / Near Expiry FG Inventory in India for export market and ensure liquidation plans are in place to minimize inventory write off.

• Prepare and circulate monthly MIS on slow-moving / Near expiry inventory
• Discuss risk inventory with Business to ensure liquidation plan are available to minimize inventory write off risk.
• Evaluate inventory provisions where liquidation plans are not available, align with business and communicate to costing team on monthly basis for inventory provision

Prepare and circulate various MIS, support MOR review and adhoc analysis as required

• Prepare and circulate Monthly slow-moving MIS, Export FG near expiry, Consumption v/s Receipts.
• Prepare presentations on slow-moving RMPM inventory, Export FG inventory, Covid Portfolio, High value inventory coverage analysis for monthly operational review (MOR) with Global Supply chain head.
• Drive Governance through Dashboards as far as possible to reduce man hours.

Key Accountabilities (3/6)

Validate disposal proposals, monitor disposal progress and outstanding receivables.

• Evaluate all disposal proposal and liaison with procurement to get better rate and generate revenue and minimize CoPE.
• Prepare and circulate weekly MIS on pending disposal status and driving governance meeting with planning and procurement for early disposal action.
• Review outstanding receivables due to disposal sale and follow up with stake holders for timely collection / accounts clearing.

Evaluate high value purchase requisitions and assist team lead in releasing PR in SAP

• Evaluate purchase requisitions basis business demand, stock in hand and open purchase orders.
• Validate data source of purchase requisitions raised for strategic buy / supply disruption etc

Key Accountabilities (4/6)

Continuously evaluate existing process, propose process simplification and automation, and drive its implementation

• Evaluate existing process, propose simplification / automation initiatives and align with respective stakeholders for implementation.
• Coordinate with IT team on automation design and ensure proper financial controls are in place.
• Act as Finance partner for various IT and SCM automation projects (Slow Moving, FG etc).

Key Accountabilities (5/6)

Monitor India RMPM COPE and discussions across CFT for reduction of same

• Participate and have regular discussion with CFT for reduction of India RMPM COPE
• Preparation and analysis of COPE so as to ensure reduction in cost control.

Key Accountabilities (6/6)

Monitor Export Freight and preparation of MIS

• Discussions with CFT to check Air Sea Mix and have regular discussions with Planners to track Export Freight and thereby ensuring reduction in overall Air freight cost
• Prepare necessary MIS to track and monitor Export Freight.

Major Challenges

• Dealing with multiple stakeholders of Supply Chain function across Cipla.

Overcome by: Conducting regular meetings, regular monitoring of the action plan and follow ups providing timely reports/regular follow ups/in-person meeting.

• High volume disposal transactions and ensuring physical dispatch before quotation / inventory expiry.

      Overcome by – Prioritising high value items, sending regular update and continuous follow up.

Key Interactions (1/2)

• Cluster heads, Unit planners, Unit Stores.
• Business Unit, Procurement & planning team for Inventory optimization
• SAP, IT teams (need-based) for IT development of SCM and simplification projects.
• SCC Team Members

Key Interactions (2/2)

• External Consultants (Addressing need-based Data-related, SAP-related queries)
• Statutory Auditor.

Dimensions

• Monitor Slow moving RMPM inventory worth INR 300 Cr across India
• FG inventory for export BU worth 250- 300 Cr
• Processing  ~150-200 Disposal transaction amounting to ~43-50 Cr.
• Approval of PR > 1 Cr - ~ 450 PR.
• Controlling RMPM inventory lying at 150 locations.
• Controlling India RMPM COPE(Cost of Poor Execution/Inventory wastage)
• Monitor Air Sea Mix and keep a close check on Export Freight Cost

Key Decisions (1/2)

• Disposal evaluation
• PR approval < 1Cr
• Process Simplification and automations

Key Decisions (2/2)

• Recommendations for approval on disposal/destruction of inventory based on loss and provision value
• PR evaluation based on MRP requirement, Open PO, and stock in hand
• Decide on the MIS / Process to be automated, and finalizing design along with IT

Education Qualification

Qualified CA / ICWA / MBA

Relevant Work Experience

0-3 years of work experience in the field of finance preferably. Operations/SCM/Business Finance and Computer Proficiency in Excel, Statistical Analysis software’s and PowerPoint