Project Summary
A solution that is aimed to solve multiple Business to operate independently but will share common contacts and Goods / services as per need In each of the business units. Traditional solutions usually may have to leave separate entries in different databases but we provide single solutions to solve this problem and let the management look at data from a single source, analyses and take an informed decision on specific scenarios. Management and Decision Support System as an Enterprise Resource Planning Suite. We have an aim and that is to have a Single Database and a single Application to access the same from any where as far as possible to manage all our activities. For a more detailed explanation please refer to the Product Features List.
Key Words
ERP, Multi Business,Factory Management, Management Information Systems, Descision Support Systems, Software
Introduction
Setup a centralised Database that is robust enough to encompass the different activities of a Business Organisation of any Size in different Verticals. Have a simple and a robust Application that shall allow us to access this Database from any part of the World with Security measures incorporated and Access to the Specified Persons with functions specific to their activities. Related reports and information will be shared between Different Departments that are customised and are of a practical utility.
Origin Of Proposal
By Our Experience and Observation we have found that not many Applications are available that try to provide an End to End Solution for an Organisation at least in India and even if they are available at present they are not a common feature in all Private Institutions that have a Businesses in Different Fields.
Problem Definition
To have a Common Standard for Database Architecture so that it can be Shared across many different Levels in the Organisation and the External Environment like Government, Funding Agencies, Tax Authorities etc for Decision making and a General Harmonious and Higher Progress.
Work plan
We will be starting with MS SQL Server as a Database, C# as Code Behind language and MVC.net with HTML as the Front End to start with and Development on other Databases and other Languages at a later stage depending on the Demand and need of the Technology.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
Accounts
- Account Group
- Account Section
- Bank Account
- Expense
- Expense Type
- Income Head
- Income Head Type
- Tax Duty
- Tax Type
- Payment Issu Parent
- Payment Mode
- Payment Rcpt Parent
- Payment Rcpt Det
- Payment Rcpt Parent
- Asset Block
- Asset
- Asset Type Tax Config
Calendar
- Calendar Events Det
- Holiday
- Holiday Type
- Yearly List Of Holidays
Security
- User Type
- User Type Report Privilages
- User Type Privilages
Contacts Management
- Caste
- Contact Addr
- Contact Category
- Contact Group
- Contact Hobbies
- Contact Languages
- Contact
- Contact Multiple Roles Det
- Contact Qualifications
- Contact Skills
- Contact Type
- Hobby
- Quota Caste Allocation
- Quota
- Skill
- Skill Type
Location
- City
- Country
- District
- State
Language
- Language
- Language Type
Inventory Management
- Asset Block Alloc Det
- Asset Block Type
- Asset Class
- Asset Type
- Issu Parent
- Item Designation
- Item Designation Property Sub Type Std Val
- Item Designation Property Val
- Item Form
- Item Form Property Sub Type Config
- Item Grade
- Item Info
- Item Process Config
- Item Property
- Item Property Fixed Sub Type
- Item Property Sub Type
- Item Property Sub Type Values
- Item Property Type
- Item Property Val
- Item Pur Track
- Item Service
- Item Service Category
- Item Service Group
- Item Service Sub Type
- Item Service Type
- Item Store Shelf StockShelf
- U O M
- Product Feature
- Product Set Det
- Product Set Parent
- Product Sub Feature
- Mtl Reqt Det
- Mtl Reqt Parent (BOM)
Human Resource Dept
- Employee Benefit
- Employee Benefit Type
- Employee Cur Sal Comp
- Employee Cur Sal Deduct
- Employee Deduct
- Employee Deduct Type
- Employee Group Benefit
- Employee Group Deduct
- Employee Group Leave Type
- Employee Group Sal Comp
- Employee Leave
- Employee Leave Open Bal
- Employee Leave Register
- Employee Leave Type
- Employee Loan Apply
- Employee Loan Disburs
- Employee Loan Purpose
- Employee Log Details
- Employee Config
- Employee Contribute
- Employee Sal Advance
- Employee Sal Comp
- Employee Sal Comp Type
- Employee Sal
- Employee Sal Parent
Purchase
- P O Det
- P O Parent
- P O Schedule
- P O Shdl
- P O Terms
Planning
- Plan
- Plan Type
- Production Plan
Production
- Processes
- Machine Item Process Config
- Machines Avail
System Admin
- Data Entry Mode
- Menu
- Menu Type
- Module
- Module Table Details
- Org Education Vertical Config
- Owner Addr
- Trans Type
- Table Rec Year Serial No
- Table
- Team
Sales
- Quote Det
- Quote Det Rev
- Quote Parent
- Quote Parent Rev
- Quote Terms
- S O Det
- S O Parent
- S O Terms
- Pack List Det
- Pack List Parent
- Bill Det
- Bill G S T Det
- Bill Other Charges Det
- Bill Parent
- Bill Terms
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | Developing a Core Team who can type in all Languages that are used in India, These people will be developing the Resources Files that will be necessary so that users are comfortable in using the Multi Business Solution ERP. | 2 |
| 2 | Developing a Simple call Center that can explain the process that is to be employed for running and using the ERP, the same team will train other Startups to make sure that they will lend support for Manufacturers and or Traders and other users who will be given adquate support as and when necessary. | 3 |
| 3 | We will be further Developing and Implementing an application that is nearly ready along with Design Rights to modify the Database and Front End so that new Versions can be developed for different Verticals of Manufacturing and Or Traders in the near future. | 2 |
| 4 | We will need Data Entry Operators who can completely segregate the Data initially for Different Industries specific to Products and Services mapped to HSN Codes and our Ta Structures so that we can ensure that all Data will be mapped to the different Departments and Users, this is a massive work and may need more resources. | 3 |
| 5 | The next step will be to ensure that we build a Flexible Process Design Team that can manage the ever growing need of the different Methods and Technologies that are emerging at every hour to replace the existing Products and Services that are being offered to Humanity at large in different parts of the World. | 2 |
| 6 | In short the Application software must support all the Core Funcationalities that are necessary to Run a Manufacturing and Or a Trading Organisation irrespective of its size with different Modules at its core Integrated on a single platform. | 1 |
| 7 | Prime Importance will be to Develop an Implementation Methodology for Each Category of Industry , for eg. One possiblity will be first to have a common Software with All Data Support for say Idlers so that we can make sure that all Data is readily available at finger tips in case any Spares are required so that it can be procured in the shortest time possible in an efficient way irrespective of their location, here the Emphais will be more on using minimum resources in terms of Material Wealth that is being unearthed. The idea is to keep one thing in mind that is "It Costs A Lot More to Produce Bad Quality" and Better to avoid that by a more Systematic Approach. | 2 |
| 8 | Next Step once the First version is built sucessfully Implemented at least in One Manufacturing Cum Trading Unit in each one of the States in the whole of our Country. | 1 |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Programmers | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
We are planning to Tie Up with Ramakrishna Mission Vivekananda Educational and Research Institute http://rkmvu.ac.in/ so that they can maintain the Entire Design, Source Code and Related Documentation necessary for it to Survive and Grow or Tie up with Microsoft Corporation / Microsoft Foundation so that A Team can be formed to Ensure that these Services and Upgrades are available to All Organisations in India freely to Develop and Enhance but not to Voilate the Set Statuatory and Predefined Standards.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Programmers | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
