Project Summary
To Develop a Fresh Milk Distribution 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,Fresh Milk, Milk Distribution, Enterprise Resource Planning, Process Design
Introduction
Setup a centralised Database that is robust enough to encompass the different activities of a Milk Production Center. 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
Usually Milk that is Stripped from Cows and Buffalos is sent to a Milk Diary which then Gets Pasturised and Either Canned or Packed in Sachets. We can do this only for Extra Milk that cannot be consumed Immediately.
Problem Definition
To Connect the Milk Strippers and Consumers so that Fresh Milk is Delivered by Delivery Boys in Cans Directly to their Door Steps with their Records Maintained Electronically.
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 Milk Delivery 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 other users who will be given adequate 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 in the near future. | 2 |
| 4 | We will need Data Entry Operators who can completely Collect and segregate the Data initially so that we can ensure that all will be mapped to the Locations, this is a massive work and may need more resources. | 3 |
| 5 | In short the Application software must support all the Core Functionalities that are necessary to Run a Milk Collection and Delivery System. | 2 |
| 6 | For a more detailed Explanation please refer to the Product Features. | 1 |
| 7 | Prime Importance will be to Develop an Implementation Methodology for at least 5 Locations Using Different Languages. | 1 |
| 8 | Next Step once the First version is built successfully Implement Horizontally in Other Locations. | Need to Workout Details |
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 | Data Entry and Delivery Resources | 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
Connect the Milk Producers and the Buyers in a given locality. Employ and train people to deliver the milk to the respective Buyers place. Employ and train people to manage the server along with a few Accountants who will work full time in the Community Setup. In the long run we will intend to Design and Manufacture Milk cans of 0.5ltrs to 2 ltrs with level Indicators and Fat Content Analysers inbuilt. This will help to update the milk bought and sold between the two parties. Payments will be made to Milk Producers once a week through a Dedicated Bank maintained by Aurom India if we get Funds to Implement Aurom CBS. Only minimum of a weeks advance is expected to be deposited in the Bank account of the Buyer which has to be replenished from time to time. The Basic system that will be developed in the shortest possible time will be scaled up to take care of the larger interest of the Human Eco System and help to reduce Unemployment and create jobs.
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 |
| Data Entry and Delivery Resources | 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 |
