Implementation of ERP System at 08 Dairy Plants for Pradeshik Cooperative Dairy Federation Limited (PCDF), Uttar Pradesh

Ref: Submission of Proposal against your RFP Reference No. UPL/SW/2025-26/26

Our details financial proposal is as follows:

Tender Inviting Authority : Managing Director, UPTRON POWERTRONICS LIMITED

Name of Work: Implementation of ERP System at 08 Dairy Plants for Pradeshik Cooperative Dairy Federation Limited (PCDF), Uttar Pradesh.

Rate for First year

Sl.No Work/Discription Qty cost (Rs.) Total Amount (Rs.)

1 ERP Module (Website)

1.1 Manufacturing • Work schedule management • Master Production Scheduling (MPS) • Master Requirement Planning (MRP) • Link to weighing scales • Quality Assurance • Capacity Planning • Process, discrete, and mixed-mode manufacturing • Parts lists, composition, formula management 1

1.2 Inventory • Movements and transactions • RF data acquisition • Quality control • Costing • Physical counting • Replenishment • Multilevel warehousing and location management 1

1.3 Purchasing • Purchase requests • Encumbrance accounting • Requests for proposals • Purchase orders • Multilevel approval processing • Contracts • Invoice tracking 1

1.4 Quality & Compliance Management • Quality Analysis and Control • Pre-process, In-process, Post-Process and Inventory QC • Labels with Ingredient Statements, Allergens, Halal, Kosher, etc. • Reports • Meet HACCP, FSSAI, Lot Recalls plus Audits 1

1.5 R&D/Formulation • New Recipe Development • Recipe Management • Opportunity Management • Sample Management • Recipe Costing 1

1.6 HR automation • Employee Information Management • Recruitment and Hiring • Performance Management • Benefits Management • Financial Management • Time and Attendance Management • Learning and Professional Development • Accounting 1

1.7 Accounting: • Fund Management • Balance Sheet Management • Tax Management • Fixed Asset Management • Reporting 1

1.8 Payroll Module; Payroll Module • Enables complete end-to-end payroll automation for all employees across plants and the Head Office. • Integrates attendance, leave, overtime, shift allowances, and other deductions seamlessly. • Supports flexible salary structure setup, pay heads, arrears, increments, and full statutory compliance. • Automatically generates payslips, payroll registers, bank transfer files, PF/ESI reports, and audit-ready logs. • Offers role-based access for HR, finance, and management with summary views and analytical insights. • Ensures accurate, timely monthly payroll processing through automated checks and approval workflows. 1

1.9 Sales and Marketing: Sales & Marketing Module • Manages the complete product catalog, pricing structures, distribution channels, and customer-wise order processing. • Monitors plant-wise and route-wise sales, dispatch, billing, and invoicing activities. • Seamlessly integrates with inventory and production modules to enable real-time stock visibility and demand planning. • Supports dealer and distributor management, rate contracts, and configuration of schemes and discounts. • Provides interactive dashboards for tracking sales performance, revenue trends, product movement, and forecasts. • Automatically generates sales MIS, tax reports, and reconciliation data for finance and compliance. 1

2.1 Admin Level Mobile APP for Reporting & Dashboard (Android APP including Hosting charges and Play Store Charges): • Native Android application developed for admin-level users to access real-time reports, dashboards, and operational analytics on the go. • Provides secure, role-based login to monitor production, procurement, inventory, HR, finance, sales, and overall workflow status. • Features interactive dashboards with charts, KPIs, alerts, approval actions, and plant-wise performance insights. • Seamlessly integrated with the ERP backend through secure APIs to ensure live data synchronization. • Includes development and configuration of API endpoints with secure connectivity and data protection mechanisms. • Covers Google Play Store publishing, app signing, compliance and security checks, and applicable annual Play Store charges. 1

2.2 Admin Level Mobile APP for Reporting & Dashboard (Iphone APP including hosting and playstore charges): • Native iOS application developed for admin users to access real-time dashboards, reports, KPIs, and workflow status. • Provides secure, role-based authentication to monitor production, procurement, inventory, HR, finance, sales, and plant operations. • Offers interactive visual analytics with charts, alerts, notifications, and approval workflows. • Seamlessly integrates with the ERP backend through secure API connectivity for live data synchronization. • Includes Apple App Store publishing, provisioning profiles, app review compliance, and applicable annual App Store charges. 1

3 API & Integration Service

3.1 API Development • Architect and build secure, standards-based RESTful APIs to enable seamless integration between ERP modules and external systems. • Develop robust endpoints to fetch, update, validate, and synchronize data across web portals and mobile applications. • Perform data mapping, transformation, and formatting to ensure smooth interoperability with third-party platforms. • Implement strong authentication, authorization, and token-based security controls. • Create webhook services, callbacks, and event-driven triggers for real-time data exchange. • Establish reliable error-handling, logging, and retry mechanisms to ensure uninterrupted communication. • Conduct comprehensive API testing, including integration, performance/load, and security testing. • Deliver detailed technical documentation covering API endpoints, data structures, workflows, and usage guidelines. 1

3.2 Integration with E-Commerce • Seamless integration of the ERP system with the PCDF E-Commerce platform for real-time synchronization of products, pricing, inventory levels, and dispatch information. • Automated exchange of order data, delivery status, payment confirmations, and customer details between both systems. • API-driven connectivity to enable smooth and reliable flow of procurement, inventory, and sales-related information. • Comprehensive mapping of product codes, units of measure, tax structures, and financial entries to ensure data consistency. • Real-time updates for order fulfillment, cancellations, returns, and inventory adjustments. • Secure communication framework incorporating authentication, encryption, and validation mechanisms. • End-to-end integration testing to ensure data accuracy, system stability, and seamless operational flow. • Management dashboards providing visibility into online sales performance, demand patterns, and key metrics. 1

4 Analytic and Dashboard 1

4.1 Reports (for All Officers and Workflow) • Role-based reporting for officers, managers, and plant heads covering production, inventory, procurement, finance, HR, quality control, and dispatch. • Workflow-driven reports highlighting pending actions, approvals, escalations, and process status across departments. • Automated MIS generation for daily, weekly, and monthly operational and management summaries. • Consolidated as well as plant-wise performance reports to support effective monitoring and decision-making. • Real-time data visibility with drill-down capabilities to analyze transactions, exceptions, and operational bottlenecks. • Configurable export options in Excel and PDF formats for audits, analysis, and compliance requirements. 1

4.2 Admin/User Dashboard with Key Analytics • Centralized dashboards for administrators and users providing real-time operational, financial, and departmental insights. • Visual representation of critical KPIs, including production output, procurement activities, inventory status, sales performance, HR indicators, and quality metrics. • Role-based views tailored to user responsibilities, highlighting tasks, approvals, alerts, and workflow progress. • Interactive analytics featuring charts, trend analysis, heat maps, and drill-down options for detailed evaluation. • Consolidated analytics at plant-wise and Head Office levels to track performance and identify gaps. • Automated data synchronization across all ERP modules to ensure accurate and up-to-date information. 1

5.1 User Training (Online Mode) • Delivery of structured online training programs for users across all eight plants and the Head Office, with up to 20 users per location. • Module-wise training covering Manufacturing, Inventory, Procurement, HR, Accounting, Payroll, Sales, and Quality. • Role-specific sessions tailored for operators, plant managers, accounts, HR, QC, and admin-level users. • Live demonstrations of end-to-end workflows, approval processes, dashboards, and reporting features. • Hands-on practice sessions with guided exercises to enable real-time ERP usage. • Training schedules aligned with plant shift timings to ensure maximum participation. • Interactive query-resolution sessions and scenario-based learning focused on day-to-day operations. • Development and delivery of comprehensive training materials, including presentations, checklists, and reference guides. • Post-training evaluations and feedback sessions to assess user readiness for Go-Live. • User support during UAT to facilitate familiarization and validation of configured workflows. 1

5.2 Development of User Manuals, Admin Guides, SOPs, and Training Videos (Soft Copy Only) • Preparation of comprehensive user manuals for all ERP modules with clear, step-by-step operating instructions. • Development of detailed admin guides covering system configuration, user management, and administrative controls. • Creation of Standard Operating Procedures (SOPs aligned with plant-level workflows and approval mechanisms. • Design of module-wise process flow diagrams and quick-reference sheets for ease of understanding. • Compilation of FAQ documents to address common operational and usage-related queries. • Formatting and delivery of all documentation in soft-copy formats (PDF/Word) for easy distribution across plants. • Provision of bilingual documentation (English/Hindi), if required, to support broader user adoption. • Revision and updating of documents post-UAT and Go-Live to reflect finalized processes and workflows. • Establishment of a centralized digital repository for storing manuals, SOPs, guides, and videos to support long-term capacity building. 1

6 Technical Support

6.1 Onsite Technical Support Service (1 year) Onsite Technical Support Service (1 Year) – Annual Cost: ₹10,00,000 • Continuous onsite ERP technical support for one year, covering issue resolution, workflow support, report generation, UAT and Go-Live assistance, coordination with the central team, and smooth day-to-day plant operations. • The annual cost of ₹10,00,000 is inclusive of a dedicated technical resource deployed onsite. 1

6.2 Website Management Executive Onsite ( 2 Per Plant @ 8 Plants = 16 Executives): Two dedicated senior executives deployed at each plant to handle daily ERP operations, data validation, workflow monitoring, module support (Production, Inventory, Purchase, HR, and Accounts), MIS reporting, user assistance, and ensuring SOP compliance. Each executive is paid ₹40,000 per month, 16

7.1 Cloud-Based Hosting Environment (1-Year) via MeitY-Empanelled CSP • Enterprise-grade compute infrastructure with 8–16 vCPUs and 64–128 GB RAM deployed across multiple nodes with auto-scaling capabilities. • High-availability SQL database cluster (8 vCPU, 64 GB RAM, 1 TB SSD – primary plus replica) for critical transactional workloads. • 3–5 TB of encrypted SSD storage to ensure fast and secure data access. • Automated daily backups with 90-day retention and offsite disaster recovery snapshots. • Premium network bandwidth of at least 1 Gbps for seamless connectivity across all plants. • Private VPC setup with static IPs and secure VPN tunnels to maintain isolated and protected network access. • Multi-zone deployment with disaster recovery failover (RPO < 15 minutes, RTO < 60 minutes). • Enterprise-grade Layer-7 load balancers supporting full SSL termination for secure and reliable traffic distribution. • Advanced cloud security features, including DDoS protection, WAF, IAM controls, encryption, and network isolation. • 24×7 monitoring, log analytics, automated alerts, and continuous performance tracking. • Regular OS and database patching, environment hardening, and SLA-based uptime management. • Dedicated hosting for API services and third-party integrations. • Comprehensive coverage of cloud platform, OS, database, storage, networking, security, and monitoring licenses. • Complete DevOps and cloud management services included for the entire year. 1

8.1 Wapp Solution for Security 1

8.2 Cert in Security Audit through Cert-in Empanelled Partner every 6 month 2

8.3 Quality Assurance and Performance Testing 1

8.4 Wildcard SSL 1

9 SMS, Email & What’s app

9.1 Transactional SMS 100000

9.2 Transactional Email 100000

9.3 What’s app Service Msg. 100000

11 UPL Centage @ 10%

14 Overall cost including taxes

Annual Maintenance Contract (AMC) Cost for 2nd Year and Subsequent Years (Per Annum).

Sl.No Work/Discription Qty cost (Rs.) Total Amount (Rs.)

1 Annual Maintenance & Support for ERP Website Module

1.1 Manufacturing • Work schedule management • Master Production Scheduling (MPS) • Master Requirement Planning (MRP) • Link to weighing scales • Quality Assurance • Capacity Planning • Process, discrete, and mixed-mode manufacturing • Parts lists, composition, formula management 1

1.2 Inventory • Movements and transactions • RF data acquisition • Quality control • Costing • Physical counting • Replenishment • Multilevel warehousing and location management 1

1.3 Purchasing • Purchase requests • Encumbrance accounting • Requests for proposals • Purchase orders • Multilevel approval processing • Contracts • Invoice tracking 1

1.4 Quality & Compliance Management • Quality Analysis and Control • Pre-process, In-process, Post-Process and Inventory QC • Labels with Ingredient Statements, Allergens, Halal, Kosher, etc. • Reports • Meet HACCP, FSSAI, Lot Recalls plus Audits 1

1.5 R&D/Formulation • New Recipe Development • Recipe Management • Opportunity Management • Sample Management • Recipe Costing 1

1.6 HR automation • Employee Information Management • Recruitment and Hiring • Performance Management • Benefits Management • Financial Management • Time and Attendance Management • Learning and Professional Development • Accounting 1

1.7 Accounting: • Fund Management • Balance Sheet Management • Tax Management • Fixed Asset Management • Reporting 1

1.8 Payroll Module; Payroll Module • Enables complete end-to-end payroll automation for all employees across plants and the Head Office. • Integrates attendance, leave, overtime, shift allowances, and other deductions seamlessly. • Supports flexible salary structure setup, pay heads, arrears, increments, and full statutory compliance. • Automatically generates payslips, payroll registers, bank transfer files, PF/ESI reports, and audit-ready logs. • Offers role-based access for HR, finance, and management with summary views and analytical insights. • Ensures accurate, timely monthly payroll processing through automated checks and approval workflows. 1

1.9 Sales and Marketing: Sales & Marketing Module • Manages the complete product catalog, pricing structures, distribution channels, and customer-wise order processing. • Monitors plant-wise and route-wise sales, dispatch, billing, and invoicing activities. • Seamlessly integrates with inventory and production modules to enable real-time stock visibility and demand planning. • Supports dealer and distributor management, rate contracts, and configuration of schemes and discounts. • Provides interactive dashboards for tracking sales performance, revenue trends, product movement, and forecasts. • Automatically generates sales MIS, tax reports, and reconciliation data for finance and compliance. 1

2 Annual Maintenance & Support for ERP Mobile APP

2.1 Admin Level Mobile APP for Reporting & Dashboard (Android APP including Hosting charges and Play Store Charges): • Native Android application developed for admin-level users to access real-time reports, dashboards, and operational analytics on the go. • Provides secure, role-based login to monitor production, procurement, inventory, HR, finance, sales, and overall workflow status. • Features interactive dashboards with charts, KPIs, alerts, approval actions, and plant-wise performance insights. • Seamlessly integrated with the ERP backend through secure APIs to ensure live data synchronization. • Includes development and configuration of API endpoints with secure connectivity and data protection mechanisms. • Covers Google Play Store publishing, app signing, compliance and security checks, and applicable annual Play Store charges. 1

2.2 Admin Level Mobile APP for Reporting & Dashboard (Iphone APP including hosting and playstore charges): • Native iOS application developed for admin users to access real-time dashboards, reports, KPIs, and workflow status. • Provides secure, role-based authentication to monitor production, procurement, inventory, HR, finance, sales, and plant operations. • Offers interactive visual analytics with charts, alerts, notifications, and approval workflows. • Seamlessly integrates with the ERP backend through secure API connectivity for live data synchronization. • Includes Apple App Store publishing, provisioning profiles, app review compliance, and applicable annual App Store charges. 1

3 Annual Maintenance & Support for API & Integration Service

3.1 API Development • Architect and build secure, standards-based RESTful APIs to enable seamless integration between ERP modules and external systems. • Develop robust endpoints to fetch, update, validate, and synchronize data across web portals and mobile applications. • Perform data mapping, transformation, and formatting to ensure smooth interoperability with third-party platforms. • Implement strong authentication, authorization, and token-based security controls. • Create webhook services, callbacks, and event-driven triggers for real-time data exchange. • Establish reliable error-handling, logging, and retry mechanisms to ensure uninterrupted communication. • Conduct comprehensive API testing, including integration, performance/load, and security testing. • Deliver detailed technical documentation covering API endpoints, data structures, workflows, and usage guidelines. 1

3.2 Integration with E-Commerce • Seamless integration of the ERP system with the PCDF E-Commerce platform for real-time synchronization of products, pricing, inventory levels, and dispatch information. • Automated exchange of order data, delivery status, payment confirmations, and customer details between both systems. • API-driven connectivity to enable smooth and reliable flow of procurement, inventory, and sales-related information. • Comprehensive mapping of product codes, units of measure, tax structures, and financial entries to ensure data consistency. • Real-time updates for order fulfillment, cancellations, returns, and inventory adjustments. • Secure communication framework incorporating authentication, encryption, and validation mechanisms. • End-to-end integration testing to ensure data accuracy, system stability, and seamless operational flow. • Management dashboards providing visibility into online sales performance, demand patterns, and key metrics. 1

4 Analytic and Dashboard 1

4.1 Reports (for All Officers and Workflow) • Role-based reporting for officers, managers, and plant heads covering production, inventory, procurement, finance, HR, quality control, and dispatch. • Workflow-driven reports highlighting pending actions, approvals, escalations, and process status across departments. • Automated MIS generation for daily, weekly, and monthly operational and management summaries. • Consolidated as well as plant-wise performance reports to support effective monitoring and decision-making. • Real-time data visibility with drill-down capabilities to analyze transactions, exceptions, and operational bottlenecks. • Configurable export options in Excel and PDF formats for audits, analysis, and compliance requirements. 1

4.2 Admin/User Dashboard with Key Analytics • Centralized dashboards for administrators and users providing real-time operational, financial, and departmental insights. • Visual representation of critical KPIs, including production output, procurement activities, inventory status, sales performance, HR indicators, and quality metrics. • Role-based views tailored to user responsibilities, highlighting tasks, approvals, alerts, and workflow progress. • Interactive analytics featuring charts, trend analysis, heat maps, and drill-down options for detailed evaluation. • Consolidated analytics at plant-wise and Head Office levels to track performance and identify gaps. • Automated data synchronization across all ERP modules to ensure accurate and up-to-date information. 1

5.1 User Training for All Plants (online) 1

6 Technical Support

6.1 Onsite Technical Support Service (1 year): Year-round onsite ERP support, issue resolution, workflow assistance, report generation, UAT/go-live support, coordination with central team, and ensuring smooth day-to-day plant operations. 1

6.2 Website Management Executive Onsite (2 Per Plant) Two dedicated executives per plant for daily ERP operations, data validation, workflow monitoring, module support (Production, Inventory, Purchase, HR, and Accounts), MIS reporting, user assistance, and ensuring SOP compliance. 16

7.1 Cloud-Based Hosting Environment (1-Year) via MeitY-Empanelled CSP • Enterprise-grade compute infrastructure with 8–16 vCPUs and 64–128 GB RAM deployed across multiple nodes with auto-scaling capabilities. • High-availability SQL database cluster (8 vCPU, 64 GB RAM, 1 TB SSD – primary plus replica) for critical transactional workloads. • 3–5 TB of encrypted SSD storage to ensure fast and secure data access. • Automated daily backups with 90-day retention and offsite disaster recovery snapshots. • Premium network bandwidth of at least 1 Gbps for seamless connectivity across all plants. • Private VPC setup with static IPs and secure VPN tunnels to maintain isolated and protected network access. • Multi-zone deployment with disaster recovery failover (RPO < 15 minutes, RTO < 60 minutes). • Enterprise-grade Layer-7 load balancers supporting full SSL termination for secure and reliable traffic distribution. • Advanced cloud security features, including DDoS protection, WAF, IAM controls, encryption, and network isolation. • 24×7 monitoring, log analytics, automated alerts, and continuous performance tracking. • Regular OS and database patching, environment hardening, and SLA-based uptime management. • Dedicated hosting for API services and third-party integrations. • Comprehensive coverage of cloud platform, OS, database, storage, networking, security, and monitoring licenses. • Complete DevOps and cloud management services included for the entire year. 1

8.1 Wapp Solution for Security 1

8.2 Cert in Security Audit through Cert-in Empanelled Partner every 6 month 2

8.3 Quality Assurance and Performance Testing 1

8.4 Wildcard SSL 1

9 SMS, Email & What’s app

9.1 Transactional SMS 100000

9.2 Transactional Email 100000

9.3 What’s app Service Msg. 100000

11 UPL Centage @ 10%

14 Overall cost including taxes

C Grand Total (Table A + Table B)