| PCC--.--
|
The scope of Supply shall be defined in:
Scope of the ERP Software and Biomatric Attendance Device and Scope of Reporting Advantages in installed software:
01. Accounts Management
1. Consolidated Balance Sheet of Plant-1 & Plant-2.
2. Comparative Income Statement of Plant-1 & Plant-2.
3. Comparative Cost of Goods Sold Statement of Plant-1 & Plant-2.
4. Statement of Changes in equity.
5. Statement of Cash Flows.
6. Statement of Fund Flows.
7. Comparative Notes in all items of balance sheet, income statement & cost of goods sold statement.
8. Schedule of Govt. equity of Plant-1 & Plant-2.
9. Schedule of Foreign Loan of Plant-1 & Plant-2.
10. Schedule of ADP Loan of Plant-1.
11. Schedule of advance of Plant-1 & Plant-2 with aging.
12. Schedule of advance tax of Plant-1 & Plant-2.
13. Schedule of Subsidy receivable from Govt. of Plant-1 & Plant-2.
14. Schedule of deduction & withholding from salary & bills of Plant-1 & Plant 2.
15. Schedule of Store-in-transit of Plant-1 & Plant-2.
16. Consolidated Budget variance report (Operational).
17. Consolidated Budget variance report (Income statement).
18. Consolidated Management ratio statement.
19. Consolidated cost breakup of Plant-1 & Plant-2.
20. Individual cost breakup of Plant-1 & Plant-2.
21. Individual Details General Ledger of Plant-1 & Plant-2.
22. Individual Trial Balance of Plant-1 & Plant-2.
23. Necessary subsidiary ledger of Plant-1 & Plant-2.
24. Annual Budget Related All reports.
25. Others necessary reports & notes.
02. Payroll Management:
1. Salary (Officer, Staff, Worker Wise Salary sheet).
2. Summary Top sheet.
3. Individual Pay Slip.
4. Bank Advice (Officer – Sonali Bank, Staff & Worker-Janata Bank).
5. Supplementary Salary Bill & Bank Advice.
6. BCIC P.F own contribution Deduction Statement.
7. BCIC Pension contribution Deduction Statement & Company contribution).
8. DAPFCL P.F contribution, Deduction statement. (Both Own & Company contribution).
9. Others Company P.F cont. Deduction. Statement. (Example. CUFL, JFCL, AFCCL, UFFL, PUFFL, KPML, SFCL, CCC etc.)
10. Welfare Loan Deduction Statement Local (DAPFCL).
11. Welfare Loan Deduction statement Other Project.
12. House building & Motor Cycle Loan Deduction Statement for BCIC.
13. House building & Motor Cycle loan Deduction Statement for DAPFCL.
14. House building & Motor Cycle loan Deduction Statement for other Project.
15. Overtime Statement & Bank Advice.
16. Board Meeting Information from Overtime (04 Report).
17. Food & Conveyance Bill and Bank Advice.
18. Gratuity statement for BCIC officers (Yearly).
19. Gratuity statement for BCIC officers. Staff & Workers.
20. Festival Bonus Bill & Bank Advice.
21. Incentive Bonus Bill & Bank Advice.
22. Uniform & Leverage Bill & Bank Advice.
23. Income Tax Deduction from Salary Statement (Monthly, Quarterly, Yearly).
24. Individual Income Tex Assessment.
25. Individual Officer, Staff, Worker total payment & Deduction,
(Quarterly, Half Yearly, Yearly).
26. Pay commission/Wages Commission Arrear Bill. And Bank Advice.
27. Others necessary reports.
03. HR Management:
01. Employees Details profile.
02. Retirement date with warning before 01 month.
03. Salary Increment date with warning before 01 month.
04. Promotion due date and PRL date.
05. Biometric Attendance system (14 No’s Biometric attendance Device provided by Software Developer).
06. Total Leave auto calculation System.
07. Leave approval automation.
08. Man Power All information.
09. Others necessary reports.
04. Store Accounts and Ware House Management:
01. Material wise receiving.
02. Material wise issue.
03. MRR wise receiving.
04. Material receiving register.
05. Material issue register.
06. Between two dates MRR report.
07. Between Two date SR report.
08. Material closing Balance etc.
09. Material Location.
10. Material User Department.
11. Slow Moving Item.
12. Absolute Item.
13. Financial Year wise all report.
14. Others necessary reports.
05. Sales and Dealers Management:
01. Sales Register.
02. Dealer wise report.
03. District Wise delivery report.
04. Bank wise report.
05. Monthly report.
06. Allotment Month wise report.
07. Dealer wise undelivered report.
08. District wise undelivered report.
09. Total Undelivered report.
10. Delivery Challan report.
11. Bank wise summary.
12. Month wise summary.
13. Allotment month wise summary.
14. Upazila Wise Report.
15. Others necessary reports.
06. PF Management:
a) PF Member Ledger (Individual).
b) PF Loan ledger.
c) Total Employees Summary Sheet (Officer, Staff, Workers Wise Total).
d) Bank Account.
e) Annual PF Statement (Individual).
f) Profit Distribution Sheet.
g) Res. Statement from Other project.
h) Member fund Transfer Statement To other Project.
i) P.F Member List (Officer, Staff, Worker Wise & Total).
j) Others Report (IF Required)
07. Gratuity Management:
a) Gratuity Member ledger.
b) Bank Account.
c) Rec. Statement from Other project.
d) Member Fund Transfer List To Other project.
e) Payment List.
f) Others Report.
08 Welfare Management:
a) Welfare Fund Member Ledger.
b) Welfare Loan & Grant Ledger.
c) Bank Account.
d) Others Report.
09. Loan Management (House Building & Motor Cycle):
01. Loan Schedule.
02. Individual Ledger.
03. Remaining Deduction and Installment.
04. Others Report.
10. Cash and Bank Management:
01. Bank reconciliation.
02. Cash flow statement.
03. Cash Book.
04. LC Related All report.
04. Others Statement.
11. Bill Management:
1. Suppliers Wise Vat & Tax fixation and their certificate presentation.
2. Contractor Wise Vat & Tax fixation and their certificate presentation.
3. To know bill summery and total bill of Suppliers & Contractor.
4. To know quantity & payment of Suppliers & Contractor wise security.
5. To know quantity of by name wise Unadjusted.
6. To know quantity of by name Company wise Unadjusted.
7. To know A & F Schedule.
8. Related Report.
Product: ERP Software.
SL Product Description Qty Unit Price(Vat Tax Included) Total Price
1. Accounts Management
Multi Project and all accounting related activities 1
2. Payroll and HR Management All activities for payroll and HR Management 1
3. Store Accounts and Warehouse Management Raw materials and Spare parts 1
4. Sales & Dealers Management Sales related all activities 1
5. PF, Gratuity, Welfare Fund Management All fund management activities 1
6. Loan Management(House Building, Motor cycle) All activities for manage loan and advanced 1
7. Cash & Bank Management Cash and Bank related all activities 1
8. Bill Management All bill related activities 1
9. Medical Management (Madeline In and Out Ledger and Other report) 1
10 Co-Operative Management Product purchase and Sales related all report 1
11 Related Others Module Related Report 1
Product Hardware and Accessories
12 Finger + face+ Card detection device (with Protective Casing) 14
13 Related Accessories 1 lot
14 Power backup for device:
Finger + face+ Card detection device 06
Process Costing:
1. Cost of Demin water ( Per unit/total)
2.Cost of electricity ( Per unit/total)
3. Cost of Stem ( Per unit/total)
4. Cost of bulk urea ( Per unit/total)
5.Cost of bagged urea ( Per unit/total)
6. Other cost head to be mentioned in P.o
15 Installation, testing and commission of the total System Job
Others charges(If require)
Total ( Taka)
Service validity: 5 years (After warranty Period of Software)
Software interface language: English, Some Report requires In Bangla.
Data Base: Oracle / MS SQL.
Server: Cloud Server with Storage.
Device Specification:
Attendance Device Specification – Face + Finger + Card
User Capacity: 30,000
Finger Capacity: 4,000
Face Capacity: 2000
Card Capacity:2000
Transection/log: 1,00,000
Proximity Card Capacity: 10,000
Display: 2.8 inch TFT LCD Color Screen or higher
Indicator light: Red and green
Operating Temperature: 0 - 45 degree Celsius
Operating Humidity: 20% to 80%
Power: 12V
Comm. Port Ethernet , USB-Client
Pen Drive USB host
Fingerprint Identification: <= 2 seconds
Face Identification: <= 2 seconds
Verification: <= 1 seconds
FRR <1%
FAR <= 0.0001%
Language English
Voice confirmation Yes
Keypad Yes
Direct Database connectivity: Must have MS SQL or Oracle supported
Access Control function: Yes,
3rd Party Electric Lock, Door Sensor, Exit Button, Alarm, Wiegand In/Out
Proximity Card support: Mifare or HID card
Power Supply with Power Backup
12V DC Metal Power Supply with Battery Backup 3A
• Output voltage: 12 VDC 3 Amp
• Input voltage: 190-265VAC – 50-60Hz
• Lockable metal enclosure, grey epoxy coated finish
• Output short-circuit protection
• With SA plug top and 300mm lead
• Metal housing included
• With battery back-up 7AH (Battery included)
Server Specification:
Description Quantity
1 Compute
Utilization
Number of Instances 4
Average Days Usage per Month/31 day(s) 31
Average Hours Usage per Dar/24 hour(s) 24
Configuration
Compute - Virtual Machine Standard(4 Core) OCPU: 32 GB Memory: 120GBx4 = 480 GB Additional Storage: Up to 1 PB of remote Block Volumes(Per Core)
Windows OS 4 OCPU Windows Server Standard license
2 Load Balancer
Utilization
Number of Instance 1
Average Days Usage per Month/31 day(s) 31
Average Hours Usage per Dar/24 hour(s) 24
Configuration
100 Mbps Load Balancer 1
3 Network
Utilization
Number of Instance 1
Average Days Usage per Month/31 day(s) 31
Average Hours Usage per Dar/24 hour(s) 24
Configuration
Outbound Data Transfer Unlimited
4 Storage
Configuration
Block Volume 300 GB
Object Storage 500 GB
Archive Storage 200 GB
Note:
1. Maintained and Follow International Compliance rules.
2. Built in Security
3. High Ability
|
The scope of Supply shall be defined in:
Scope of the ERP Software and Biomatric Attendance Device and Scope of Reporting Advantages in installed software:
The scope of Supply shall be defined in:
Scope of the ERP Software and Biomatric Attendance Device and Scope of Reporting Advantages in installed software:
01. Accounts Management
1. Consolidated Balance Sheet
2. Comparative Income Statement
3. Comparative Cost of Goods Sold Statement
4. Statement of Changes in equity.
5. Statement of Cash Flows.
6. Consolidated Management ratio statement.
7. Consolidated cost breakup
8. Individual cost breakup
9. Cash Book
10. Individual Details General Ledger
11. Individual Trial Balance
12. Subsidiary ledger
13. Journal voucher with Tagging.
14. Cumulative Income Statement [Monthly, quarterly, half-yearly, yearly]
15. Cumulative Cost of goods sold [Monthly, quarterly, half-yearly, yearly]
16. Cumulative Cost Break Up [Monthly, quarterly, half-yearly, yearly]
17. Cumulative Notes Report [Monthly, quarterly, half-yearly, yearly]
18. Compare Income Statement [Monthly, quarterly, half-yearly, yearly]
19. Compare Cost of goods sold [Monthly, quarterly, half-yearly, yearly]
20. Compare Cost Break Up [Monthly, quarterly, half-yearly, yearly]
21. Compare Notes Report [Monthly, quarterly, half-yearly, yearly]
22. Auto Voucher No. Monthly.
23. Voucher Approval option.
24. Notes Report.
25. Notes Report - Fixed Asset for Account Head
27. Schedule of Govt. equity
28. Schedule of Foreign Loan
29. Schedule of ADP Loan
30. Schedule of advance with aging
31. Schedule of advance tax
32. Schedule of Subsidy receivable from Govt.
33. Schedule of deduction & withholding from salary & bills
34. Schedule of Store-in-transit
02. Payroll Management:
1. Salary (Officer, Staff, Worker Wise Salary sheet).
2. Summary Top sheet.
3. Individual Pay Slip.
4. Bank Advice (Officer – Sonali Bank, Staff & Worker-Janata Bank).
5. Supplementary Salary Bill & Bank Advice.
6. BCIC P.F own contribution Deduction Statement.
7. BCIC Pension contribution Deduction Statement & Company contribution).
8. CUFL P.F contribution, Deduction statement. (Both Own & Company contribution).
9. Others Company P.F cont. Deduction. Statement. (Example. DAPFCL, JFCL, AFCCL, UFFL, PUFFL, KPML,
SFCL, CCC etc.)
10. Welfare Loan Deduction Statement Local (CUFL).
11. Welfare Loan Deduction statement Other Project.
12. House building & Motor Cycle Loan Deduction Statement for BCIC.
13. House building & Motor Cycle loan Deduction Statement for CUFL.
14. House building & Motor Cycle loan Deduction Statement for other Project.
15. Overtime Statement & Bank Advice.
16. Board Meeting Information from Overtime (04 Report).
17. Food & Conveyance Bill and Bank Advice.
18. Gratuity statement for BCIC officers (Yearly).
19. Gratuity statement for BCIC officers. Staff & Workers.
20. Festival Bonus Bill & Bank Advice.
21. Incentive Bonus Bill & Bank Advice.
22. Uniform & Leverage Bill & Bank Advice.
23. Income Tax Deduction from Salary Statement (Monthly, Quarterly, Yearly).
24. Individual Income tax Assessment.
25. Individual Officer, Staff, Worker total payment & Deduction,
(Quarterly, Half Yearly, Yearly).
26. Pay commission/Wages Commission Arrear Bill. And Bank Advice.
27. Others necessary reports. (Need to Delete)
03. HR Management:
1. Employees Details information.
2. Retirement date with warning before 01 month.
3. Salary Increment date with warning before 01 month.
4. Promotion information and PRL
5. Biometric Attendance system
6. (As per demand Biometric attendance Device provided by Software Developer)
7. Leave calculation System.
8. Leave approval System.
9. Active Employee List
10. Inactive Employee List
11. New Joining Employee List
12. Released Employee List
13. Monthly manpower
14. Manpower Officer
15. Manpower Staff
16. Manpower worker
17. Daily Present Report
18. Daily Absent Report
19. Daily Leave Report
20. Daily OT Report
21. Daily Attendance Summary Report
22. Daily Missing Out Report
23. Daily Movement Report
24. Daily Attendance Report
25. Monthly Attendance Report
26. Monthly Late Report
27. Monthly Absent Report
28. Individual Job Card Report
29. All employee list excel file information
04. Store Accounts and Ware House Management:
1. Purchase requisition system with report
2. Purchase Order system with report
3. MRR wise receiving
4. SR Option
5. Between two date MRR report
6. Between Two date SR report
7. Material closing Balance information
8. Material Location
9. Material User Department
10. Slow Moving Item
11. Absolute Item
12. KARDEX CARD
13. Master Item List
14. Missing Number.
15. Material wise receiving
16. Material wise issue
17. Between two date MRR report with value
18. Between Two date SR report with value
19. Product value with rate
20. Inventory Report
21. Master Item List with inventory and consumption code
22. Issue Voucher
23. MRR Voucher
24. Auto issue Voucher
25. Auto MRR Voucher
26. Approval option
27. MRR by Inter Transfer from other BCIC organization.
28. MRR Provision information
29. Full System Calculation with Avg. Method System. [Material Rate auto calculation based on MR and Issue]
05. Sales and Dealers Management:
1) District Wise Allotment Entry with report
2) Dealer wise Booking Allotment Entry with report
3) Delivery Challan wise Entry with report
4) Gate Pass system
5) DO No. Wise Challan Report
6) Allotment Wise Summary
7) District Wise Allotment Summary
8) Challan Details
9) Boraddho Vittik Mullo Joma
10) Dealer Vittik Mullo Joma
11) Dealer Vittik Mullo Baki
12) Yearly Booking lotment Summary
13) Tali Sheet
14) Gate Pass Report
15) Delivery Challan Report
16) Receiver Wise Challan
17) Certification of daily supply
18) Representative wise Report
19) Unit wise Delivery Challan Option
20) Date Wise Dealer Wise report
21) Delivery Order wise Entry with report
22) Delivery Challan wise Entry with report
23) DO Wise District Summary
24) DO Date Wise Report.
25) Pay slip Date Wise Bank Summary
26) Date Wise DO Summary
27) DO Date Wise Bank Summary
28) DO No. Wise Challan Report
29) Representative Wise Report
30) Sales reconciliation (Yearly Bank Wise)
31) Sales reconciliation (Month Wise)
32) Representative Wise Summary Report
33) Sales Voucher
34) Daily Sales Summary
35) DO Challan Order
36) Receiver Wise Challan
37) Delivery challan wise bank summary
38) Page index
06. PF Management:
a) PF Member Ledger (Individual). b) PF Loan ledger.
c) Total Employees Summary Sheet (Officer, Staff, Workers Wise Total). d) Bank Account.
e) Annual PF Statement (Individual). f) Profit Distribution Sheet.
g) Res. Statement from Other project.
h) Member fund Transfer Statement To other Project.
i) P.F Member List (Officer, Staff, Worker Wise & Total).
j) Others Report (IF Required) (Need to delete it)
07. Gratuity Management:
a) Gratuity Member ledger.
b) Bank Account.
c) Rec. Statement from Other project.
d) Member Fund Transfer List To Other project.
e) Payment List.
f) Others Report. (Need to delete it)
08 Welfare Management:
a) Welfare Fund Member Ledger.
b) Welfare Loan & Grant Ledger.
c) Bank Account.
d) Others Report. (Need to delete it)
09. Loan Management (House Building & Motor Cycle):
1. HB Loan (Local) Sheet
2. HB Loan (Local) Summary
3. House Building Loan Letter
4. HB Loan Ledger
5. HB Loan Individual Ledger
6. HB Loan input
7. HB Loan Letter
8. HB Loan Schedule.
9. Motor Cycle Loan (Local) Sheet
10. Motor Cycle Loan (Local) Summary
11. Motor Cycle Loan Letter
12. Motor Cycle Loan Ledger
13. Motor Cycle Loan Individual Ledger
14. Motor Cycle Loan input
15. Motor Cycle Loan Letter
16. Motor Cycle Loan Schedule.
17. PF Loan (Local) Sheet
18. PF Loan (Local) Summary
19. PF Loan Letter
20. PF Loan Ledger
21. PF Loan Individual Ledger
22. PF Loan input
23. PF Loan Letter
24. PF Loan Schedule.
25. Welfare Loan (Local) Sheet
26. Welfare Loan (Local) Summary
27. Welfare Loan Letter
28. Welfare Loan Ledger
29. Welfare Loan Individual Ledger
30. Welfare Loan input
31. Welfare Loan Letter
32. Welfare Loan Schedule.
10. Cash and Bank Management:
1) Bank reconciliation
2) Cash Book
3) FDR List
4) One bank Check Book Format
5) Bank Clearing Option
11. Bill Management:
1. Suppliers Wise Vat & Tax fixation and their certificate presentation.
2. Contractor Wise Vat & Tax fixation and their certificate presentation.
3. To know bill summery and total bill of Suppliers & Contractor.
4. To know quantity & payment of Suppliers & Contractor wise security.
5. To know quantity of by name wise Unadjusted.
6. To know quantity of by name Company wise Unadjusted.
7. To know A & F Schedule. Need to delete
8. Related Report. Need to delete
12. Medical Management
1) Item Requisition system with report
2) Item Issue system with report
3) Item Transfer internal store
4) Document Post/Unpost
5) Reorder Level settings with notification
6) Internal Store Report of all medicine
7) Pharmacy Stock Resister Report of all medicine
8) Log Resister Report of all medicine
9) Doctor Prescription Report
10) Chikitsa Bebosta Patra Report
11) Monthly Treatment Report
12. Co-Operative Management
1. Product Entry
2. Purchase
3. Sales
4. Purchase Return
5. Sales Return
6. Member List
7. Stock
8. Member Ledger
9. Cash/ Due Sales Report
10. Sales wise Profit
13. Related Others Module (ERP Integration)
1) Payroll Salary Auto voucher integration.
2) Inventory MRR Auto voucher
3) Inventory Issue – Category wise auto voucher.
4) Production & Inventory information link with cost break up.
Product: ERP Software.
SL Product Description Qty Unit Price (Vat Tax Included) Total Price
1. Accounts Management
Multi Project and all accounting related activities
2. Payroll and HR Management All activities for payroll and HR Management
3. Store Accounts and Warehouse Management Raw materials and Spare parts
4. Sales & Dealers Management Sales related all activities
5. PF, Gratuity, Welfare Fund Management All fund management activities
6. Loan Management (House Building, Motor cycle) All activities for manage loan and advanced
7. Cash & Bank Management Cash and Bank related all activities
8. Bill Management All bill related activities
9. Medical Management (Madeline In and Out Ledger and Other report)
10 Co-Operative Management Product purchase and Sales related all report
11 Related Others Module (ERP Integration)
Product Hardware and Accessories
12 Finger + face+ Card detection device (with Protective Casing) 06pcs
13 Related Accessories 1 lot
14 Power backup for device:
Finger + face+ Card detection device 06
Process Costing:
1. Cost of Demin water ( Per unit/total)
2. Cost of electricity ( Per unit/total)
3. Cost of Steam ( Per unit/total)
4. Cost of bulk urea ( Per unit/total)
5. Cost of bagged urea ( Per unit/total)
6. Other cost head to be mentioned in P.o
15 Installation, testing and commission of the total System Job
Others charges(If require)
Total ( Taka)
Service validity: 5 years (After warranty Period of Software)
Software interface language: English, Some Report requires In Bangla.
Data Base: Oracle / MS SQL.
Server: Cloud Server with Storage.
Device Specification:
Brand: Hikivison/ Dahua/ Virdi
Attendance Device Specification – Face + Finger + Card
7-inch LCD touch screen
2 MP wide-angle dual-lens
Adjusts supplement light brightness manually
Face recognition in dark environment
Face recognition distance: 0.3 to 3 m
Suggested height for face recognition: between 1.4 m and 1.9 m
Deep learning algorithm
5,000 face capacity, 5,000�ngerprintcapacity, 10000 card and 50,000 Log capacity
Multiple authentication modes
Facerecognitonduratonï¼?0.2 s/User; face recognition accuracy rate ≥ 99%
Imports card and user data to the device via TCP/IP communication
Stand-alone operation
Transmits data to the client software via TCP/IP communication and saves the data on the client software
Capture linkage and captured pictures saving
Imports data to the device from the client software
Manage, search and set device data after logging in the device locally
Mountable Power Supply with 7.0a Battery and Housing included.
Server Specification: Description Quantity
Cloud Server Specification
Cloud Server: Database hosting should be on Oracle/Microsoft Cloud server.
1.Compute
Utilization
Number of Core: 4
Intel(R) Xeon(R) Platinum 8167M CPU@ 2.00GHz or equivalent
RAM : 32 GB or higher
Windows OS : 2 OCPU Windows Server2016 or higher Standard license
2.Load Balancer
Utilization
Number of Instance: 2
Configuration: 100 Mbps Load Balancer: 1
3.Network
Number of Instance:2
Configuration: Outbound Data Transfer Unlimited
4.Storage
Configuration
Block Volume :250 GB
Object Storage: 250 GB
Archive Storage: 250 GB
5. MS SQL / Oracle Licensed Database.
Maintained and Follow International Compliance rules.
Built in Security
High Ability
Total User support: up to 100 user
|