A Study on Material Planning and Procurement Management at Sidel Pvt. Ltd.

Week 1

Work Done (From: 03/03/2026 To: 09/03/2026)

During the first week of the internship, the primary focus was on understanding the organization,
its operational structure, and gaining initial exposure to the material planning and procurement
activities carried out within the company.

 Introduction to Company Profile

The internship began with an overview of Sidel Pvt. Ltd., including its history, business
operations, and role in the manufacturing industry. Information was provided about the
company’s mission, vision, and major product lines. This helped in understanding the
company's contribution to packaging and manufacturing solutions and its global
presence.

 Organizational Structure and Departments

An introduction to the organizational structure was provided to understand the hierarchy

and coordination between various departments. Key departments observed included:

 Procurement Department:

Responsible for sourcing raw materials, selecting vendors, negotiating prices, and
issuing purchase orders to ensure timely availability of materials.

 Production Department:

Handles the manufacturing operations and provides material requirements based

on production planning and scheduling.

 Quality Control Department:

Ensures that all incoming raw materials and finished products meet the required
quality standards and specifications.

 Stores and Inventory Management:

Manages the receipt, storage, and issuance of materials while maintaining

accurate inventory records and stock levels.

General
  Logistics and Supply Chain:

Coordinates the transportation, delivery, and distribution of materials and

products to maintain smooth supply chain operations.

Understanding the roles of these departments helped in identifying how material planning
and procurement activities are integrated across different functions.

 Orientation on Material Planning and Procurement Workflow

A brief orientation session was conducted by the procurement team explaining the
material planning and procurement process followed in the organization. The process
includes:

 Demand identification by the production department:

The production department forecasts the required materials based on production

schedules, customer orders, and demand forecasts.

 Preparation of material requirements:

Based on the production plan, the required quantity and specifications of materials
are determined. This step ensures accurate planning of raw materials and
components.

 Raising purchase requisitions:

Once the material requirements are finalized, a purchase requisition (PR) is raised
and forwarded to the procurement department for further processing.

 Vendor selection and purchase order generation:

The procurement team evaluates potential suppliers, compares quotations, and

selects suitable vendors. After finalizing the vendor, a purchase order (PO) is
generated and sent to the supplier.

 Material receipt and inspection:

When the materials arrive at the company, they are received by the stores
department and inspected by the quality control team to ensure that they meet the
required specifications and standards.

General
  Inventory storage and distribution to production:

After successful inspection, the materials are stored in the warehouse or inventory
system. These materials are then issued to the production department as per the
production requirements.

This orientation provided a clear understanding of how material planning and

procurement processes are structured to support efficient production and maintain smooth
supply chain operations within the organization.

 Observation of Material Handling and Storage

During the first week of the internship, a visit was conducted to the
stores and inventory management area of Sidel Pvt. Ltd. to observe
the procedures involved in material handling and storage. This
observation helped in understanding how materials are efficiently
managed from the time they are received until they are issued for
production.

The following key activities were observed during the visit:

 Incoming material verification:

When materials arrive from suppliers, they are first verified by the stores
department. This includes checking the delivery documents, purchase orders, and
quantity of materials received to ensure accuracy.

 Proper labeling and storage of materials:

After verification, materials are labelled with relevant details such as item code,
description, and storage location. They are then stored in designated areas within
the warehouse to ensure easy identification and accessibility.

 Inventory tracking:

The inventory levels of materials are monitored and recorded to maintain accurate
stock information. This helps the organization track available materials and plan
future procurement activities effectively.

 Material issuing procedures for production:

General
 Materials are issued to the production department based on approved material
requests. The stores department ensures that the correct quantity and type of
material are supplied according to production requirements. Used SAP System.

These observations provided practical insight into how material flow is managed within
the organization. It also highlighted the importance of systematic storage practices and
accurate inventory management to support smooth production operations.

Learning Outcome

During the first week of the internship at Sidel Pvt. Ltd., a foundational understanding of
the company’s organizational structure and operational workflow was developed.
Exposure to different departments, including procurement, production, quality control,
and inventory management, helped in understanding how these functions are
interconnected.
The observations highlighted several key insights:
 Importance of Coordination: Effective communication and coordination
between procurement, stores, and production departments are essential to ensure
timely availability of materials and smooth operational flow.
 Understanding Workflow: The orientation on material planning and
procurement provided clarity on how demand is identified, purchase requisitions
are raised, vendors are selected, and materials are received and issued to
production.
 Practical Exposure: Observing material handling, storage practices, and
inventory management offered practical knowledge about how materials are
systematically managed to support uninterrupted production.
Overall, Week 1 provided a clear understanding of the structural and functional aspects of
material planning and procurement, laying the foundation for more detailed analysis in the
subsequent weeks.

General
Work Scheduled for Next Week (10/03/2026 To: 16/03/2026)

The following activities are planned for the upcoming week to gain a deeper understanding of
the material planning and procurement system at Sidel Pvt. Ltd.:

 Collection of Initial Data on Material Requirement Planning (MRP):

Gather relevant data related to the Material Requirement Planning (MRP) system used in
the organization. This includes understanding how material demand is forecasted, how
production requirements are translated into material requirements, and how procurement
cycles are planned.
 Study of Procurement Cycles:
Observe and document the stages involved in the procurement cycle, including purchase
requisition, supplier evaluation, purchase order creation, delivery, and payment
processes.
 Understanding Documentation and Standard Operating Procedures (SOPs):
Review the official documentation and Standard Operating Procedures followed by the
procurement and stores departments for material planning, purchasing, and inventory
management.

These activities will help in developing a comprehensive understanding of

the planning and procurement workflow within the organization.

Queries (If any)

 Request access to historical purchase orders and inventory records.

General
A Study on Material Planning and Procurement Management at Sidel Pvt. Ltd.

Week 2

Work Done (From: 10/03/2026 To: 16/03/2026)

During the second week of the internship, the focus was on gaining a deeper understanding of
the procurement procedures and material planning practices followed at Sidel Pvt. Ltd.. Various
operational activities related to vendor management, material planning, and inventory control
were studied.

 Study of Procurement Procedures

The procurement procedures followed at Sidel Pvt. Ltd. were studied in detail to gain an
in-depth understanding of how the organization acquires materials efficiently and
effectively. Procurement is a critical function that ensures the timely availability of
materials required for production while optimizing costs and maintaining quality
standards.
The procurement process at the company is structured and systematic, involving the
following key steps:
 Identification of Material Requirements:
The procurement team works closely with the production and planning
departments to determine the exact materials and quantities needed based on
production schedules and forecasts.

 Raising Purchase Requisitions (PR):

Once material requirements are identified, a purchase requisition is created and
submitted for approval. This ensures that all procurement activities are authorized
and justified.
 Supplier Evaluation and Selection:
Potential suppliers are evaluated based on criteria such as product quality, cost,
delivery reliability, lead time, and past performance. This ensures that the selected
vendors are reliable and capable of meeting organizational requirements.
 Issuing Purchase Orders (PO):
After selecting the appropriate vendor, a purchase order is generated specifying
material specifications, quantity, price, and delivery terms. This formalizes the
procurement agreement between the company and the supplier.
 Monitoring Delivery and Payment:
The procurement team monitors supplier deliveries to ensure timelines are met.
After successful delivery and quality verification, payments are processed
according to contractual terms.

Following this structured procurement process helps Sidel Pvt. Ltd. maintain smooth material
flow, minimize stockouts, control procurement costs, and support uninterrupted production.

General
Observing these procedures provided practical insight into the operational workflow and the
critical role of the procurement department.

 Vendor Selection and Evaluation Criteria

The vendor selection process at Sidel Pvt. Ltd. was closely observed to understand how
the organization identifies and maintains reliable suppliers. Effective vendor management
is a critical aspect of procurement, as it directly impacts material quality, delivery
timelines, and overall production efficiency.
Vendors are evaluated using a structured set of criteria, which includes:
 Product Quality: Ensuring that the materials supplied meet the required
specifications and quality standards to avoid production disruptions.
 Pricing: Comparing costs among different suppliers to achieve cost-effective
procurement while maintaining quality.
 Delivery Reliability: Assessing the supplier’s ability to deliver materials on time
and in the required quantity.
 Lead Time: Evaluating the time taken from placing a purchase order to receiving
the materials, which affects inventory planning and production schedules.
 Past Performance: Reviewing historical records of supplier performance,
including consistency in quality, timeliness, and responsiveness to issues.

This systematic evaluation process helps the organization maintain a dependable supplier
base, minimizes procurement risks, and ensures smooth operational workflow. Observing
this process provided valuable insight into how procurement decisions are made to
balance cost, quality, and efficiency.

 Observation of Material Requirement Planning for Production

Material Requirement Planning (MRP) activities were observed to understand how

material demand is generated based on production schedules at Sidel Pvt. Ltd.. The MRP
process plays an important role in ensuring that the required raw materials and
components are available at the right time to support uninterrupted production.
The production department prepares production schedules based on customer orders,
demand forecasts, and delivery commitments. These schedules serve as the basis for
determining the quantity and timing of materials required for manufacturing operations.
Based on the production plan, the material planning team calculates the required
quantities of raw materials and components by referring to the product specifications and
bill of materials. This helps in identifying the exact material requirements for each
production cycle.
The MRP system then evaluates the current inventory levels available in the stores and
compares them with the planned material requirements. If the available stock is

General
 insufficient, the procurement department is notified to initiate the purchasing process in
advance.
This observation provided a clear understanding of how production planning, inventory
management, and procurement activities are integrated to ensure smooth manufacturing
operations and efficient utilization of resources within the organization.

 Data Collection on Inventory Management

During the second week of the internship, relevant data related to inventory management
was collected from the stores and procurement departments of Sidel Pvt. Ltd.. The
purpose of collecting this data was to understand how the organization maintains optimal
inventory levels to support uninterrupted production while minimizing excess stock.

The collected information focused on the following key aspects:

 Current inventory levels:

Data regarding the available quantity of raw materials, components, and spare
parts stored in the warehouse was reviewed. Monitoring current inventory levels
helps the organization ensure that sufficient materials are available for production
activities while avoiding overstocking.

 Reorder points for critical materials:

Information on reorder points was gathered for essential materials used in

production. The reorder point indicates the minimum stock level at which a new
purchase order must be initiated to replenish inventory and prevent stock
shortages.

 Supplier lead times for material delivery:

Data related to supplier lead times was also collected to understand the average
time taken by suppliers to deliver materials after a purchase order is issued. This
information plays a crucial role in planning procurement schedules and
maintaining appropriate safety levels.
The collected data will be used for further analysis to evaluate the effectiveness of
the inventory management system and to identify opportunities for improving
material planning and procurement efficiency within the organization.

General
The collected data will be used for further analysis to evaluate the effectiveness of the inventory
management system and to identify opportunities for improving material planning and
procurement efficiency within the organization.

Learning Outcome (Week 2)

During the second week of the internship at Sidel Pvt. Ltd., a deeper understanding of
procurement operations and material planning processes was developed. The study of
procurement procedures helped in understanding how organizations ensure the timely
procurement of materials while maintaining quality and cost efficiency.
Observing the vendor selection and evaluation process provided insight into how suppliers are
assessed based on criteria such as reliability, pricing, delivery performance, and product quality.
This helped in understanding the importance of maintaining strong supplier relationships for
effective supply chain management.
Additionally, exposure to Material Requirement Planning (MRP) activities improved
understanding of how production schedules influence material demand. The collection of data
related to inventory levels, reorder points, and supplier lead times also provided practical
knowledge about inventory management and its role in maintaining uninterrupted production.
Overall, this week enhanced practical knowledge of procurement workflows, vendor
management, and inventory control systems within the organization.

General
Work Scheduled for Next Week (17/03/2026 To: 23/03/2026)

 Analyse inventory turnover, procurement efficiency, and supplier performance.

 Study coordination between procurement and production departments.

 Analyse collected data related to inventory levels, reorder points, and supplier lead times.
 Study the purchase order process and approval hierarchy followed within the
procurement department.
 Understand the documentation and record-keeping procedures for procurement
transactions.
 Observe the coordination between procurement, stores, and production departments in
managing material flow.

Queries (If any)

 Clarification on safety stock levels and buffer stock policies.

 Request additional access to vendor evaluation records and supplier performance reports
for analysis.
 Seek clarification on the procurement approval workflow and authorization levels within
the department.

General
A Study on Material Planning and Procurement Management at Sidel Pvt. Ltd.

Week 3

Work Done (From: 17/03/2026 To: 23/03/2026)

Analysis of Inventory and Procurement Performance

The analysis of inventory and procurement performance was carried out to evaluate the overall
effectiveness of the existing system at Sidel Pvt. Ltd.. This analysis focused on key performance
indicators that reflect how efficiently materials are managed and procured within the organization.
The following parameters were considered:
Inventory Turnover
Inventory turnover was analyzed to assess how frequently inventory is utilized and replenished over a
specific period at Sidel Pvt. Ltd.. It is an important performance indicator that reflects the efficiency of
inventory management practices within the organization.
Inventory turnover is generally calculated using the following formula:
Inventory Turnover = Cost of Goods Sold (COGS) / Average Inventory
Where:
 Cost of Goods Sold (COGS):
The total cost of materials or products that have been used or sold during a specific period.

 Average Inventory:
The average value of inventory held during that period, calculated as:
Average Inventory = (Opening Inventory + Closing Inventory) / 2

This formula helps measure how efficiently inventory is managed at Sidel Pvt. Ltd., indicating how often
inventory is turned over or utilized within a given timeframe.
A higher inventory turnover ratio indicates that materials are being used efficiently, with minimal
holding time in storage. This suggests effective demand planning and reduced risk of excess inventory or
obsolescence.
On the other hand, a lower inventory turnover ratio may indicate overstocking, slow-moving materials,
or inefficiencies in material planning. This can lead to increased carrying costs, storage issues, and
potential wastage.
Analyzing inventory turnover helps the organization maintain an optimal balance between supply and
demand, ensuring that materials are available when needed while minimizing unnecessary inventory
costs.
Procurement Efficiency

General
Procurement efficiency was evaluated to understand how effectively the purchasing activities are carried
out at Sidel Pvt. Ltd.. It focuses on ensuring that materials are procured in a timely, cost-effective, and
reliable manner without affecting production schedules.
The evaluation was based on the following key factors:
 Procurement Cycle Time:
This refers to the total time taken from raising a purchase requisition to the final delivery of
materials. A shorter cycle time indicates a more responsive and efficient procurement process.

 Cost-Effectiveness:
Procurement efficiency also depends on the ability to obtain materials at competitive
prices while maintaining required quality standards. Effective negotiation and supplier
selection contribute to cost savings.

 Adherence to Delivery Schedules:

Timely delivery of materials is critical for uninterrupted production. Monitoring whether
suppliers deliver materials as per agreed timelines helps in assessing procurement
reliability.

Efficient procurement ensures that the right materials are available at the right time and cost,
minimizing delays and avoiding excess inventory. This ultimately supports smooth
production operations and enhances overall supply chain performance within the
organization.

Supplier Performance

Supplier performance was assessed to evaluate the reliability and effectiveness of vendors
associated with Sidel Pvt. Ltd.. This assessment is essential to ensure that procurement activities
support uninterrupted production and maintain quality standards.

The evaluation was based on the following key criteria:

 Quality of Materials Supplied:

Suppliers were assessed on their ability to consistently provide materials that meet the
required specifications and quality standards, minimizing rejections and rework.

 On-Time Delivery:
The ability of suppliers to deliver materials as per the agreed schedule was evaluated, as
delays can directly impact production timelines.
 Lead Time Consistency:
Consistency in delivery lead times was analyzed to ensure accurate planning and
scheduling of procurement activities.
 Responsiveness:
The responsiveness of suppliers in handling queries, resolving issues, and adapting to
urgent requirements was also considered.

General
Reliable supplier performance plays a crucial role in maintaining efficient procurement
operations. It helps in reducing uncertainties, avoiding production delays, and building strong
long-term relationships with vendors, thereby contributing to overall supply chain effectiveness.

Study of Interdepartmental Coordination

The coordination between procurement and production departments was examined to understand
how material requirements are effectively aligned with production schedules at Sidel Pvt. Ltd..
Effective interdepartmental coordination is essential to ensure the smooth flow of materials and
uninterrupted manufacturing operations.

The production department prepares detailed production schedules based on customer orders and
demand forecasts. These schedules specify the quantity and timing of products to be
manufactured, which directly determine the material requirements.

The procurement department works closely with the production team to ensure that the required
materials are available as per the schedule. Based on the production plan, procurement initiates
the purchasing process by raising purchase requisitions, selecting vendors, and ensuring timely
delivery of materials.

Regular communication and coordination between these departments help in:

 Avoiding Material Shortages and Production Delays:

Effective coordination between procurement and production ensures that all required raw
materials and components are available on time. This prevents interruptions in the
production process, reduces idle time for machinery and labor, and helps maintain
scheduled production targets.
 Preventing Excess Inventory and Overstocking:
Close coordination between procurement and production helps in ordering materials
based on actual production needs rather than estimates alone. This avoids holding
unnecessary stock, reduces storage costs, minimizes the risk of material obsolescence,
and ensures optimal utilization of warehouse space.
 Ensuring Timely Procurement Aligned with Production Needs:
Coordination between procurement and production ensures that purchase orders are
raised and materials are delivered just in time to meet production schedules. This
alignment reduces delays, supports uninterrupted manufacturing, and maintains a smooth
workflow across departments.

 Improving Overall Operational Efficiency:

Effective coordination between procurement and production streamlines the flow of
materials, minimizes waiting times, reduces stock discrepancies, and ensures that
resources are optimally utilized. This leads to smoother operations, lower costs, and
higher productivity across the organization.

General
This study highlighted the importance of synchronized planning and continuous information
sharing between procurement and production departments to maintain an efficient and
responsive supply chain system.

Data Analysis of Inventory Parameters

The collected data on inventory levels, reorder points, and supplier lead times was analyzed
to evaluate the effectiveness of the material planning and procurement system at Sidel Pvt.
Ltd.. This analysis helps identify trends, inefficiencies, and potential areas for improvement
in inventory management.

Key aspects analyzed include:

Inventory Levels

The current stock levels at Sidel Pvt. Ltd. were examined to evaluate whether inventory is
maintained at optimal levels. This analysis ensures that there is enough stock to meet
production requirements without creating excess inventory or tying up unnecessary capital.

Key observations include:

 Sufficiency for Production:

Inventory was reviewed to confirm that all critical materials and components are
available to support uninterrupted production schedules.
 Avoiding Overstocking:
Excessive stock can lead to higher holding costs, storage issues, and potential
obsolescence. Monitoring inventory levels helps prevent overstocking.
 Identifying Material Movement Patterns:
Patterns of high or low inventory were analyzed to distinguish between fast-moving and
slow-moving items. This helps in prioritizing procurement, managing storage space
efficiently, and improving overall inventory management.

Analyzing inventory levels provides actionable insights to optimize material availability,

reduce costs, and maintain a smooth production workflow.

Reorder Points

The reorder points for critical materials at Sidel Pvt. Ltd. were analyzed to assess whether
they are set accurately to balance inventory availability and cost efficiency.

Key points of the analysis include:

General
  Preventing Stockouts:
Correctly defined reorder points ensure that materials are replenished before inventory
reaches a critically low level, thereby avoiding interruptions in production.
 Minimizing Excess Inventory:
Setting reorder points too high can lead to overstocking, tying up capital and increasing
storage costs. Properly calibrated points help maintain optimal inventory levels.
 Alignment with Lead Times and Demand:
Reorder points were evaluated in relation to supplier lead times and production demand
patterns to ensure timely replenishment without delays or shortages.

By analyzing and adjusting reorder points, the organization can maintain smooth production
operations while optimizing inventory levels and reducing unnecessary holding costs.

Supplier Lead Times

The lead times reported by suppliers at Sidel Pvt. Ltd. were reviewed to evaluate their
reliability and consistency in delivering materials.

Key observations include:

 Assessing Reliability:
Consistent lead times indicate dependable suppliers, allowing the procurement team to
plan orders accurately and ensure timely material availability for production.
 Impact of Variations:
Variations or delays in supplier lead times can disrupt production schedules, requiring
adjustments in material planning or safety stock levels to prevent stockouts.
 Planning Safety Stocks:
Understanding supplier lead times helps in determining appropriate safety stock levels,
ensuring that unexpected delays do not halt production while minimizing excess
inventory.

Monitoring and analyzing supplier lead times is critical for effective procurement planning,
maintaining uninterrupted production, and improving overall supply chain efficiency.

By analyzing these parameters, the organization can optimize inventory levels, improve
procurement planning, and reduce operational delays. The insights gained also support decision-
making for better resource allocation and more efficient supply chain management.

Study of Purchase Order Process and Approval Hierarchy

The purchase order (PO) process and approval hierarchy at Sidel Pvt. Ltd. were studied to
understand the complete workflow followed within the procurement department. This study
helped in identifying how materials are formally requisitioned, approved, and procured in a
structured manner.

General
Key aspects of the study include:

 Purchase Order Cycle:

The Purchase Order (PO) cycle at Sidel Pvt. Ltd. begins with a purchase requisition
raised by the production or stores department. This requisition specifies the type,
quantity, and specifications of the required materials.

Key steps in the PO cycle include:

 Requisition Review:
The procurement team reviews the purchase requisition to verify the material
requirements, check existing inventory, and confirm budget availability.
 Supplier Selection:
Suitable suppliers are identified and evaluated based on quality, cost, lead time,
and reliability. This ensures that the materials are procured from dependable
sources.
 Purchase Order Generation:
Once the supplier is finalized, a purchase order is created detailing the material
specifications, quantities, agreed prices, delivery schedules, and payment terms.
 PO Dispatch and Tracking:
The purchase order is sent to the supplier, and the procurement team monitors the
delivery to ensure that materials are received on time and as per the specifications.

Following this structured PO cycle ensures that materials are procured efficiently, reduces
errors, and maintains a smooth flow of materials to support uninterrupted production.

 Approval Levels:
Each purchase order (PO) at Sidel Pvt. Ltd. passes through a defined approval
hierarchy to ensure accountability and proper control over procurement expenditures.

Key points regarding approval levels:

 Supervisor Approval:
For routine or low-value materials, the immediate supervisor verifies the purchase
requisition and approves the PO based on production or operational requirements.
 Managerial Approval:
For higher-value or critical materials, department managers review the PO to ensure
alignment with budget allocations, operational priorities, and procurement policies.
 Finance Department Approval:
Final approval from the finance team may be required for high-cost or bulk orders to
confirm budget availability and authorize payment.
 Accountability and Control:
This multi-level approval process ensures that all purchases are properly authorized,
reduces the risk of unauthorized procurement, and maintains financial and operational
control within the organization.

General
 Implementing structured approval levels ensures transparency, minimizes errors, and
strengthens the overall procurement governance.

 Authorization Procedures:

The procurement team at Sidel Pvt. Ltd. follows strict authorization procedures to ensure
that all purchases are legitimate and compliant with company policies. This process
includes:

 Verification of Material Requirements: Confirming that the requested materials are

necessary and aligned with production or operational needs.
 Budget Check: Ensuring that sufficient funds are available and the purchase aligns with
approved budget allocations.
 Compliance with Policies: Verifying that the purchase adheres to organizational
procurement guidelines, approval hierarchies, and quality standards.

These authorization procedures help prevent unauthorized or unnecessary purchases,

maintain accountability, and support efficient and controlled procurement operations.

 Tracking and Monitoring:

Once a purchase order is approved and sent to the supplier, the procurement team actively
tracks the order to ensure timely delivery and compliance with agreed specifications. This
includes:

 Monitoring the supplier’s delivery schedule to anticipate any potential delays.

 Coordinating with the stores and production departments to prepare for material
receipt.
 Verifying that the delivered materials match the purchase order in terms of quantity,
quality, and specifications.
 Updating records to maintain accurate inventory and procure documentation.

Effective tracking and monitoring help prevent production delays, reduce procurement risks, and
maintain smooth operational workflow.

Review of Documentation and Record-Keeping Procedures

The documentation practices and record-keeping procedures for procurement transactions at

Sidel Pvt. Ltd. were studied to ensure compliance, traceability, and transparency in the
procurement process. Proper documentation is critical for tracking material flow, verifying
purchases, and supporting audits.

General
Key aspects of the review include:

 Purchase Requisition Records:

Detailed records of all purchase requisitions raised by the production or stores
departments are maintained at Sidel Pvt. Ltd.. These records include:

 Material Specifications: Clear details of the required materials, including type, grade,
and other technical specifications.
 Quantities: The exact number or volume of materials needed to meet production
requirements.
 Approval Status: Documentation of the approvals obtained at various levels in the
authorization hierarchy.

Maintaining these records ensures traceability, accountability, and transparency in the

procurement process and serves as a reference for future planning and audits.

 Purchase Orders and Supplier Documents:

Copies of all purchase orders, supplier quotations, agreements, and confirmations are
maintained at Sidel Pvt. Ltd.. These documents provide clear information regarding:

 Pricing: Agreed costs for materials to ensure budget compliance and prevent
discrepancies.
 Delivery Timelines: Expected delivery dates to coordinate with production schedules.
 Terms and Conditions: Supplier obligations, payment terms, and other contractual
details.

Proper maintenance of these documents ensures transparency, accountability, and easy

reference in case of disputes, audits, or process improvements.

 Material Receipt and Inspection Records:

At Sidel Pvt. Ltd., all received materials are properly documented to ensure accuracy
and quality compliance. This includes:

 Material Receipt Documentation: Recording the arrival of materials in the inventory

system with details such as quantity, supplier, and delivery date.
 Quality Inspection Reports: Conducting inspections to verify that materials meet the
required specifications and quality standards.
 Acknowledgment of Deliveries: Confirming receipt of materials from suppliers and
updating records to reflect inventory availability.

Maintaining these records ensures traceability, supports inventory accuracy, and prevents
production delays due to substandard or missing materials.

 Inventory Updates:

General
 At Sidel Pvt. Ltd., inventory records are continuously updated to maintain real-time
visibility of stock levels. Key practices include:

 Stock Levels: Recording the current quantity of all materials in the inventory system.
 Material Issuance: Updating records when materials are issued to production or other
departments.
 Returns and Adjustments: Documenting any returns, damaged items, or adjustments to
ensure accuracy.

These practices help in preventing stock discrepancies, supporting timely procurement

decisions, and ensuring smooth production operations.

 Compliance and Audit Trail:

All procurement records at Sidel Pvt. Ltd. are maintained in strict accordance with
organizational policies to ensure accountability and transparency. Key aspects include:

 Traceability: Each transaction, from purchase requisition to material receipt, is properly

documented for easy tracking.
 Audit Readiness: Organized records allow internal and external audits to verify
procurement activities, approvals, and financial compliance.
 Process Improvement: Maintaining detailed records helps identify gaps, inefficiencies,
or recurring issues in procurement and inventory management, enabling continuous
process improvement.

This ensures that procurement operations are controlled, compliant, and efficient, supporting
both financial and operational accountability.

Studying these procedures provided practical insight into how systematic documentation
supports accountability, operational efficiency, and regulatory compliance in procurement
and inventory management.

Observation of Material Flow Coordination

The coordination between the procurement, stores, and production departments at Sidel Pvt.
Ltd. was observed to understand how materials move efficiently through the organization.
Smooth material flow is essential to avoid production delays, reduce excess inventory, and
optimize resource utilization.

Key observations include:

General
  Procurement to Stores:
Materials ordered by the procurement department are received in the stores, where they
undergo verification and quality inspection to ensure they meet the required
specifications. Once confirmed, the materials are recorded in the inventory system for
accurate stock tracking and future usage. This step ensures that only approved and
quality-checked materials enter the production supply chain.
 Stores to Production:
Materials are issued from the stores to the production department according to the
production schedules. The stores ensure that the right quantities of materials are
delivered at the appropriate time, supporting uninterrupted manufacturing and
preventing delays due to material shortages.
 Interdepartmental Communication:
Continuous communication between procurement, stores, and production departments
ensures that material requirements, shortages, or delivery delays are promptly
identified and addressed. This collaboration helps in quick decision-making, prevents
production disruptions, and maintains a smooth flow of materials across all stages of
operations.
 Efficiency and Accuracy:
Coordinated workflows between procurement, stores, and production help maintain
accurate inventory records, reduce idle time in production, and ensure that materials
are available precisely when needed. This integration improves operational efficiency,
minimizes wastage, and supports timely completion of production schedules.

Observing material flow coordination provided insight into the importance of integrated
planning, timely communication, and process synchronization to support uninterrupted
manufacturing operations.

Work Scheduled for Next Week (24/03/2026 To: 30/03/2026)

 Prepare process flow diagrams for material planning and procurement workflow.
 Study stock reconciliation and periodic inventory audit methods.

Queries (If any)

 Request historical data on procurement delays and stockouts.

General
A Study on Material Planning and Procurement Management at Sidel Pvt. Ltd.

Week 4

Work Done (From: 24/03/2026 To: 30/03/2026)

During this period, the following activities were undertaken as part of the MBA project:

 Conducted a detailed observation of inventory audit procedures and stock verification processes
to understand existing control mechanisms.

 Analyzed vendor performance metrics and evaluated procurement cost structures to assess
efficiency and cost-effectiveness.

 I identified key bottlenecks in material planning and procurement scheduling, with a focus on
their impact on operational efficiency and supply chain performance.

1. Inventory Audit Procedure:

The inventory audit procedure is a systematic process used to verify the accuracy, existence, and
condition of inventory records maintained by an organization. The key steps involved in the
procedure are as follows:
 Planning the Audit
The audit process begins with defining the scope, objectives, and schedule of the audit. Relevant
inventory records and documentation are reviewed prior to the audit.
 Physical Stock Verification
A physical count of inventory is conducted to verify the actual stock available in warehouses or
storage locations. This may be carried out through periodic or cycle counting methods.
 Reconciliation of Records
The physical stock count is compared with the recorded inventory levels in the system. Any
discrepancies such as shortages, excess stock, or damages are identified.
 Investigation of Variances
Differences between physical and recorded inventory are analyzed to determine the root causes,
such as recording errors, pilferage, or process inefficiencies.
 Documentation and Reporting
All findings, discrepancies, and observations are documented in an audit report. This includes
details of variances and possible reasons.
 Corrective Actions
Necessary corrective measures are implemented, such as updating inventory records, improving
control mechanisms, or addressing operational gaps.
 Follow-up and Review
post-audit reviews are conducted to ensure that corrective actions have been effectively
implemented and to prevent recurrence of discrepancies.

This procedure helps ensure accuracy in inventory records, strengthens internal controls, and supports
efficient inventory management.

General
 2. Stock Verification Procedure:

The stock verification procedure is a systematic process undertaken to ensure that the physical
inventory matches the recorded inventory levels and to maintain accuracy in stock records. The
key steps involved are as follows:
 Preparation and Planning
The verification process begins with defining the scope, selecting the verification method (full
count or cycle count), and preparing necessary documents such as stock records and inventory
lists.
 Segregation of Inventory
Inventory is organized and categorized based on type, location, or identification codes to facilitate
an efficient and accurate counting process.
 Physical Counting of Stock
A physical count of all items is conducted using appropriate methods such as manual counting,
barcode scanning, or RFID systems to ensure accuracy.
 Recording of Observations
The counted quantities are recorded systematically and compared with the book records or system
data.
 Identification of Discrepancies
Any differences between physical stock and recorded stock, including shortages, excess
quantities, or damaged goods, are identified.
 Analysis of Variances
Discrepancies are analyzed to determine their root causes, such as errors in data entry, theft,
misplacement, or process inefficiencies.
 Reporting
A detailed report is prepared highlighting the discrepancies, observations, and possible reasons
for variances.
 Corrective Measures
Necessary actions are taken to rectify discrepancies, update records, and improve inventory
control processes.
 Final Review and Approval
The verification results are reviewed and approved by authorized personnel to ensure
accountability and accuracy.

This procedure helps in maintaining reliable inventory records, minimizing losses, and improving overall
inventory management efficiency.
3. Vendor Performance Metrics:
Vendor performance metrics are quantitative and qualitative indicators used to assess the
effectiveness, reliability, and efficiency of suppliers. These metrics help organizations optimize
procurement decisions, reduce costs, and improve overall supply chain performance. Key metrics
include:
 Delivery Timeliness
o Measures of whether suppliers deliver goods or services on or before the agreed schedule.

General
 o Late deliveries can disrupt production and inventory planning, making this a critical
performance indicator.
 Order Accuracy
o Evaluates the percentage of orders delivered correctly in terms of quantity, specifications,
and documentation.
o High accuracy reduces rework, returns, and administrative overhead.
 Quality Compliance
o Assesses whether supplied materials meet the required quality standards and
specifications.
o Low-quality deliveries can lead to production delays, increased waste, and customer
dissatisfaction.
 Cost Competitiveness
o Examines whether suppliers provide goods at competitive and reasonable costs, including
potential discounts or bulk pricing advantages.
o Helps in optimizing procurement budgets and overall cost efficiency.
 Flexibility and Responsiveness
o Measures how quickly a supplier can adapt to changes in order quantity, delivery
schedules, or special requests.
o High responsiveness supports dynamic business requirements and reduces operational
risks.
 Communication and Support
o Evaluates the effectiveness of communication, problem resolution, and overall supplier
collaboration.
o Strong supplier relationships contribute to smoother operations and quicker issue
resolution.
 Reliability and Consistency
o Tracks a supplier’s consistency in meeting all performance expectations over time.
o Reliable suppliers reduce operational uncertainties and improve supply chain stability.
4. Procurement Cost Analysis:
Procurement cost analysis is the process of evaluating all costs associated with acquiring goods
and services from suppliers. It aims to understand cost structures, identify inefficiencies, and
recommend strategies for cost optimization without compromising quality or operational
efficiency.

Collected procurement data including purchase orders, invoices, supplier quotations, and payment
records.
Categorized costs into:
 Direct costs: Cost of materials, shipping, taxes, and duties.
 Indirect costs: Inventory carrying costs, handling, administrative overheads, and stock-out costs.
Benchmarked procurement costs against industry standards and organizational targets.
Evaluated supplier pricing structures, discount policies, and payment terms.
Visual Report To Show procurement cost components:

General
 Cost
Type Description
Component
Purchase Price of
Direct The basic cost of acquiring goods from the supplier.
Materials
Freight and
Costs incurred to transport goods from the supplier to the
Shipping Direct
organization.
Charges
Taxes and
Direct Government-imposed charges on purchased materials.
Duties
Handling Costs for loading, unloading, and internal movement of
Indirect
Charges inventory.
Storage /
Expenses related to storing inventory, including rent,
Warehousing Indirect
utilities, and security.
Costs
Administrative Costs related to procurement operations, such as staff
Indirect
Overheads salaries and office expenses.
Stock-out / Additional costs are incurred due to inventory shortages
Indirect
Expediting Costs or emergency orders.
Discounts / Direct / Reductions in costs offered by suppliers can offset direct
Rebates Indirect costs or reduce overall expenditure.

Notes:

 Direct Costs: Costs that are directly tied to the purchase of goods.

 Indirect Costs: Costs associated with handling, storing, or managing inventory, not directly part
of the purchase price.

Table provides a clear distinction between direct and indirect costs:

General
Key Points:

 Direct Costs: Core costs of purchasing materials, shipping, and taxes.

 Indirect Costs: Support-related expenses like handling, storage, and

administration.

 Discounts/Rebates: Reduce total expenditure and improve cost efficiency.

 Total Procurement Cost: Represents the sum of all direct and indirect
costs after adjustments.

5. Material Planning and Procurement Bottlenecks:

Efficient material planning and procurement scheduling are critical to

maintaining smooth operations and supply chain performance. Bottlenecks in
these processes can cause delays, increased costs, and stock imbalances,
negatively impacting overall organizational efficiency. This section analyzes
key bottlenecks and their effects.

Flow Diagram for more clarity:

General
 Material Requirement Forecast

 This is the initial stage where demand is forecasted based on production

plans, historical data, market trends, or customer orders.

 The forecast determines what materials are needed, in what quantity, and by
when, forming the foundation for procurement planning.

 Accurate forecasting is critical to avoid both overstocking and shortages.

 Procurement Scheduling

 Based on the forecast, procurement schedules are created to time the

ordering and delivery of materials.

 Scheduling involves deciding when to place orders, quantities to order, and

coordinating delivery timelines to meet production needs.

 Efficient scheduling aligns supply with demand while minimizing inventory

carrying costs.

 Supplier Delivery

 Suppliers fulfill the scheduled procurement orders by delivering materials.

 The reliability and timeliness of supplier deliveries significantly impact the

production schedule and inventory levels.

 This stage depends on vendor performance, transportation, and logistics

management.

 Bottleneck Detected? (Decision Point)

 This diamond-shaped node represents a crucial decision point where the

process checks if any bottleneck or disruption has occurred.

 Bottlenecks can arise due to delayed supplier deliveries, inaccurate forecasts,

procurement scheduling errors, or logistical issues.

 The process flow diverges here based on whether a bottleneck is detected or

not.

 If Delay/ Stock-Out

 If a bottleneck is detected, it leads to delays in receiving materials or stock-

outs (inventory shortages).

 Such situations disrupt production schedules, increase operational costs, and

may cause missed customer deadlines.

 This is a critical operational risk requiring immediate attention.

General
 Analyze Cause & Implement Corrective Action

 Following a detected bottleneck, the underlying causes are thoroughly

analyzed. This may involve investigating supplier performance, forecast
accuracy, scheduling errors, or logistics inefficiencies.

 Corrective actions could include adjusting procurement schedules,

renegotiating supplier terms, improving forecast methods, or enhancing
communication between teams.

 Implementing these solutions aims to remove the bottleneck and prevent

recurrence.

 If No Bottleneck — Smooth Operations

 If no bottleneck is detected, materials are delivered as scheduled, and

operations proceed without disruption.

 This outcome represents an optimized procurement and planning process

aligned with production needs.

 Return to Smooth Operations After Correction

 After corrective actions are implemented for bottlenecks, the system returns
to smooth operations, ensuring continuity and efficiency in the supply chain.

Conclusion

The comprehensive analysis of inventory management, vendor performance, procurement costs,

and material planning processes has revealed critical insights into operational efficiencies and
challenges. Effective inventory audits and stock verification ensure accurate control over
materials, while rigorous evaluation of vendor performance helps optimize supplier relationships.
Procurement cost analysis highlights opportunities to reduce expenditures through strategic
scheduling and cost tracking. Identifying bottlenecks in material planning and procurement
scheduling underscores the need for integrated systems and proactive coordination to prevent
delays and stock-outs.

Implementing the recommended improvements—such as enhanced forecasting, process

automation, standardized procedures, and stronger supplier collaboration—will significantly
improve supply chain performance. Ultimately, these measures contribute to reducing costs,
minimizing risks, and maintaining smooth operational flow, aligning with the organization’s
strategic objectives.

General
A Study on Material Planning and Procurement Management at Sidel Pvt. Ltd.

Week 5

Work Done (From: 31/03/2026 To: 06/04/2026)

 Completed analysis of material planning and procurement performance metrics.

 Identified areas for improvement in inventory management, procurement scheduling, and
vendor coordination.
 Prepared charts and tables summarizing procurement lead times, stock levels, and order
fulfillment rates.

1. Performance Analysis of Material Planning and Procurement:

During this week, the focus was on evaluating material planning and procurement performance
metrics to identify inefficiencies and opportunities for improvement in inventory management,
procurement scheduling, and vendor coordination. Data-driven analysis was performed to provide
actionable insights for operational optimization.

Data Sources for Analysis:

The performance analysis of material planning and procurement was based on the following
primary data sources:

Procurement Records:
Detailed purchase orders, supplier quotations, and invoice histories were examined to assess
procurement costs, lead times, and ordering patterns.

General
 Inventory Logs:
Stock records, including current balances, past movements, and inventory adjustments, were
analyzed to evaluate stock levels, turnover rates, and discrepancies.

Vendor Performance Reports:

Supplier performance metrics, including delivery timeliness, order accuracy, quality compliance,
and responsiveness, were reviewed to assess reliability and efficiency.

Order Fulfillment Statistics:

Data on order completion rates, on-time delivery, and fulfillment delays were collected to
determine operational effectiveness and identify bottlenecks in supply chain execution.

2. Identification of Improvement Areas in Inventory, Procurement, and Vendor Coordination:

Efficient supply chain management relies heavily on accurate inventory management, timely
procurement scheduling, and effective vendor coordination. This phase of the project focused on
analyzing these processes to identify gaps and opportunities for operational improvement.

Explanation of the Diagram

 Main Node: “Identified Areas for Improvement” – highlights the three focus
areas:

o Inventory Management

General
 o Procurement Scheduling

o Vendor Coordination

 Causes: Each area is analyzed for root causes that hinder efficiency.

 Recommendations: Clear solutions are provided for each cause to improve

operations.

 Color Coding & Icons:

o Yellow for areas (analysis focus)

o Blue for causes (problems)

o Green for recommendations (solutions)

o Icons add visual clarity for report readers

Areas For Improvement:

 Inventory Management 🏬
Efficient inventory management ensures that materials are available in the
right quantity at the right time while minimizing excess stock. Key challenges
include overstocking, stock-outs, and inaccurate manual tracking.
Improvements in this area—such as automated tracking systems, just-in-time
(JIT) principles, and regular audits—enhance operational efficiency, reduce
carrying costs, and maintain production continuity.
 Procurement Scheduling 🛒
Procurement scheduling involves planning orders to align with production
needs and demand forecasts. Misaligned orders, lead time variability, and
reliance on manual scheduling can create delays or excess inventory.
Implementing integrated planning tools, standardized procedures, and
predictive analytics ensures timely procurement, optimized inventory levels,
and smooth production flow.
 Vendor Coordination 🤝
Vendor coordination focuses on managing supplier relationships to ensure
timely, accurate, and high-quality deliveries. Common issues include late
deliveries, communication gaps, and limited performance monitoring.
Solutions such as establishing vendor KPIs, improving communication
channels, and maintaining contingency plans strengthen supplier reliability,
improve order fulfillment rates, and reduce supply chain risks.

3. Visualization of Procurement and Inventory Metrics:

 Procurement Lead Times

General
 Analyzed the time taken from placing an order to receiving materials
from suppliers.
Lead time variations across suppliers were identified and represented
using bar charts or line graphs to highlight bottlenecks.
 Stock Levels
Current stock levels were compared against required inventory for
production needs.
Tables and charts were prepared to show overstock, optimal stock, and
stock-out situations for each material.
 Order Fulfillment Rates
Evaluated the percentage of orders delivered on time and in full.
Visualizations such as pie charts or bar graphs were used to clearly
indicate supplier performance and internal fulfillment efficiency.

Purpose and Benefit

These visualizations allow stakeholders to quickly identify gaps, inefficiencies,

and trends in procurement and inventory management.
They form a foundation for data-driven recommendations to optimize
procurement scheduling, inventory control, and supplier management.

General
Explanation for Report Inclusion

 Main Node:
“Procurement & Inventory Dashboard” – acts as the central reporting
figure.
 Lead Times:
Shows average procurement durations and variability, helping identify
suppliers or scheduling bottlenecks.
 Stock Levels:
Highlights material imbalances, including overstock and stock-outs,
with visual cues for quick comprehension.
 Order Fulfillment Rates:
Represents supplier reliability and internal execution efficiency, with
percentages of on-time vs delayed orders.
 Benefit:
Combines multiple performance metrics into a single, professional
dashboard, providing a clear, data-driven view for analysis and
decision-making.

Example Metrics for Procurement & Inventory

Example Target
Metric Description
Value Value

Procurement Lead Average time from order placement to

7 days 5 days
Time material receipt

Inventory Accuracy Percentage of stock levels matching

90% 95%
🏬 required inventory

General
Order Fulfillment Percentage of orders delivered on time
88% 95%
Rate ✅ and complete

How These Metrics Work in Analysis

Procurement Lead Time

o If the target is 5 days but the actual average is 7 days, there’s a 2-day
delay that can affect production scheduling.

Inventory Accuracy

o 90% accuracy means 10% of items are miscounted or mismatched,

which could cause stock-outs or excess inventory.

Order Fulfillment Rate

o 88% of fulfilment indicates that 12% of orders are delayed or

incomplete, showing areas for vendor or internal process
improvement.

General
How to Interpret the Dashboard

 Radar Chart

Shows relative performance across the three main KPIs.

Lead Time Efficiency is 71%, indicating procurement delays.

Inventory Accuracy is 90%, slightly below the 95% target.

Order Fulfillment Rate is 88%, showing room for improvement in

reliability.

 Funnel Diagram

Visualizes the flow of procurement: Orders Placed → Materials Received

→ Stock Available → Orders Fulfilled.

Highlights potential bottlenecks at each stage.

 Infographic Metrics

Provides a concise, executive-ready summary of actual vs target

values.

Helps quickly identify areas needing action.

Conclusion

The analysis of procurement, inventory, and vendor performance highlights several

key insights critical to improving supply chain efficiency.

 Procurement Efficiency: Lead time analysis revealed delays

compared to target timelines, indicating opportunities for process
optimization and better supplier coordination.
 Inventory Management: Stock levels and inventory accuracy
metrics identified instances of overstocking and minor discrepancies,
emphasizing the need for automated tracking systems, regular audits,
and just-in-time practices.

General
  Order Fulfillment & Vendor Coordination: Evaluation of order
fulfillment rates and vendor performance highlighted gaps in on-time
delivery and reliability, suggesting the implementation of clear KPIs,
improved communication, and contingency planning for high-risk
suppliers.
 Visual Insights: Dashboards, radar charts, and funnel diagrams
provided a clear, data-driven view of performance, linking
operational problems directly to actionable solutions. This visualization
approach allows decision-makers to quickly identify bottlenecks,
monitor KPIs, and implement targeted improvements.

Overall, addressing the identified gaps through automation, better planning tools,
and structured vendor management will enhance operational efficiency, reduce
costs, and strengthen the overall supply chain performance.

General
General