ERP Proposal for Cable Manufacturing Industry

Current Situation

The client is one of the leading cable manufacturer in coimbatore and he was looking for ERP for his Cable Manufacturing unit. His end customers are the top leading suppliers of wires with their own brand names in and outside India. The client had their own in-house developed Desktop application software, which partially met the management expectation. But it needed more customisation to make the process simpler, easier and more user friendly.

Existing System

The existing version of software was  developed using traditional Visual Basic version 6 (VB6) and Microsoft SQL (MSSQL) as backend.

Limitation

While doing the case study in the existing system, it has been discovered that tracking the inventory levels of copper is not straight forward. Every time the resources should calculate the list of copper utilised during a course of time, calculate and analyse the requirements for the future, and place the next order to the vendors that is not accurate and precise. It takes lot of time to track production, sales, past orders, wastage and future orders manually. Not only the above, improper planning results to wasting useful labor in trivial works, and is also prone to human error

Major Drawback

Another major drawback on using the existing system is the employees in the production area have to leave the production area, go to a computer, log in to the computers, open the software, provide the required inputs, get information about the input product, and provide the required updates. And the process to do that takes about thirty minutes to an hour

To overcome this situation, we recommend to build an android mobile app where the employees can bring an android phone or tablet into the production area and enter the inputs and get all the information that they need in about one second. That is really the beauty of mobile software. It simplifies some complex tasks that do not need to be complex. Our business model is very simple but the Desktop Software that is being used is complex.

What we proposed

The best way to simplify complex business processes and make employees’ jobs easier is to migrate the existing version of desktop software into webbased version using PHP as the development language, MYSQL as backend and develop mobile application using Android. Since android version devices are cheap we plan to develop android application that will get the input from the user and synchronise that information into the main server similarly, the same approach will be used for the output.

The Opportunity  after the initial discussion with the client’s IT organization with their IT heads, the goals / key were derived as below Some of them are the key criteria’s

  1. a) Current version  of  application  platform  should  be  customized  according  to  the  needs  of  each    So  the  existing  application  source  code  should  be  altered  / modified  to  meet  the  requirement. No clear roadmap is laid to follow the requirements.
  2. b) Develop an android version of the software that will help the users to use the system in the areas where desktops cannot be used.

The proposal for Cable Industry for our client can be viewed here

You should be logged in to download the PDF Version of the proposal

Proposal for Help desk

Introduction

inexpensivecoders is a Custom software development and Mobile application development company focused on empowering organisations by deploying the best of breed, cost-effective software solutions that would add immense value to their business processes . From Desktop to mobile including Android, iPhone applications, iPad applications, PHP, HTML5, .Net, PERL, CFML, Python applications) inexpensivecoders delivers apps and websites on every platform.

inexpensivecoders also offers full white label solutions, mobile applications, mobile websites, complete brand customization, applications for small businesses and more.Our wide-range of services include Custom Applications Development, Applications Maintenance Outsourcing, Web Services, Architectural Strategy & Design, Enterprise Application Integration (EAI), Enterprise Application Implementation (ERP/CRM), BI/Data Warehousing, Legacy Systems Support. inexxpensivecoders service portfolio encompasses the entire range of solutions required by the IT industry.

inexpensivecoders has grown to become a global service provider of IT Services focused on the telecom, media, technology, manufacturing, power and healthcare industries. Our services span from Application Management Outsourcing, Packaged Application Services, Independent Validation, Verification and Testing, Product Development, and Support, to higher value-added offerings including Managed Platform and Product Engineering Services.

Scope of Work

Client want us to develop Helpdesk ticketing system which can be used for multiple locations (Botswana, India, Mauritius and Zambia)

Features
  • Ticketing management
  •  Escalation.
  • Knowledge access
  •  Public and private actions on tickets
  • Customizable ticket submission form
  • Job Card with time spent on ticket with cost.
  • Email With Superpowers – Use as email management software, keeping your existing email account and receiving all the functionality of our tool.
  • Responsive – application will be fully responsive and will scale to the size of any device.
  • Open Source – You will receive full non-encrypted and non-obfuscated source code, so you can modify it (or hire a freelancer to do it for you) in any way you want.
  • Lifetime License – Pay once and receive a lifetime license. There are no recurring fees.
  • Professional Design – Pixel-perfect design based on Google’s material design guidelines.
  • Search – Powerful search with multiple integrated providers, including elastic search, algolia, MySQL and more.
  • Rich Text Editor – Ticket body uses a rich text editor that allows file uploads, code formatting, inline images, canned replies, links, undo/redo, drafts and more.
  • Knowledgebase Management – Organize your knowledge base using categories and tags, create articles with a powerful html editor.
  • User Settings – Let users change common settings like their time zone, language, country and more.
  • Groups – Flexible groups system to assign users to or agents to teams, organizations, companies and more.

 

Compatible Browsers IE11, Firefox, Safari, Opera, Chrome, Edge
Software Framework Laravel
Software Version PHP 7.x, PHP 5.6

 

Client has to provide the following to aid the development:-
• Privacy Policy and terms of Condition (only if they deviate from normal industrial standards)

Resources that needs to be deployed from inexpensivecoders:-

Designation Number of resources
PHP Developer 2
Business Relation Manager 1
QA and Testing 1
Ui/Ux 1

 

  • These resources will be deployed by inexpensivecoders at their desired location.
  • The client can enquire, question or even suggest his ideas at any time to the Business Relation Manager as per his own convenience.
  • The Client is not responsible for the resources in any which way.

 

NOTE: Any Features, Design, or other development changes made after the freezing of requirement gathering (SOW) will be treated as a Change Request and will be treated as out of project boundaries and will be charged accordingly.

Costing Involved For Application Development:-

Development cost XX,XXX INR
Hosting and domain per year (Optional) X,XXX INR
TOTAL XX,XXX INR

This amount is exclusive of tax (which will be according to Indian Govt.).
Note : Domain and hosting cost included in first year.

3.  Terms and Conditions

1. Contract: The client’s approval for work to commence shall be deemed a contractual agreement between the client and inexpensivecoders. The approval for the work can be through either an email confirming back the quote (with the quote document attached) or the quote document signed by the client.

Important: Payment of the advance fee indicates that the client accepts these terms and conditions, and approves to commence the work.

2. Free Technical Support: inexpensivecoders provides 1 Months free technical support for following kind of issues:

  1. Programming errors/bugs
  2. Logical Bugs/Calculation related errors/bugs
  3. Connection errors/API Integration Errors
    Above support is not available if the errors/bugs arise due to any external entity. Example:
  4. Server or software or application or extension downgrades or upgrades
  5. Edits done by any external entity/person/professional in the code/scripts delivered by us.
  6. Operating System or Browser Version Downgrades/Upgrades
  7. Any other factor which is not directly related to any deficiency at the end of inexpensivecoders

Note: If anything occurred in software which is beyond the project agreement, inexpensivecoders shall not be liable for any kind of support. inexpensivecoders can deny for any kind of support during this period.

3. Browser compatibility: inexpensivecoders makes every effort to design pages that work flawlessly on most popular current browsers i.e. IE11 and latest versions of Firefox/Chrome released on the date of project agreement. We however cannot be held responsible for pages that do not display acceptably in new versions of browsers released after pages have been designed. IE10 and older IE versions are outdated browsers and hence we don’t design with them in mind. We recommend using latest version of Chrome or Firefox instead of older versions of Microsoft Internet Explorer.

4. Photography and graphics: inexpensivecoders may use stock photographs and images while creating the website. Images and graphics purchased from stock libraries are not generally included in the quote and will be invoiced separately. inexpensivecoders will keep the client updated about the stock images being used and the cost involved before raising the invoice.

5. Search Engine Submission: Following services are not part of the project unless agreed otherwise in writing:

a. Submission of websites on different search engines.
b. Securing good ranking of your website on different search engines.
c. Search Engine Optimization – On Page/Off Page.

6. Site maintenance: Unless otherwise agreed in writing, following services will be separately billed after the website has been made live:
a. Content updates
b. Refinements and logical tweaks to the website, which were not planned/approved by client earlier.
c. Content presentation and design updates which were not planned/approved by client earlier.

7. Content: After inexpensivecoders has delivered the website to client, client is solely responsible for the content/information/images posted on his website. If there is any error or omission by inexpensivecoders team while uploading/posting the content/information/images on client’s website, inexpensivecoders will correct it if reported to inexpensivecoders representatives.

8. Material: All material supplied by the client shall remain client’s property. inexpensivecoders rightfully believes that this material belongs to the client and that it does not breach any copyright laws. Under no circumstances shall inexpensivecoders be held responsible for any claims, damages, and loss of profit or reputation caused to client due to the use of material provided by the client.

9. Domain names booked by inexpensivecoders on behalf of client: inexpensivecoders provides domain name consultancy if required. Domain names registered by inexpensivecoders on the client’s behalf are property of inexpensivecoders until client has paid for the domain booked and any fee involved.
inexpensivecoders agrees to transfer such domains to the client or his/her agent when asked to do so provided that all accounts have been settled.

Note: Domains booked and owned by client are not subject to this term. This term applies only to those domains that are booked by inexpensivecoders upon the request of client.

10. Travel Time and Expenses: Travelling time to and from the client premises is not generally included in our estimate. If a visit/travel is required for meeting, the client will bear all the expenses or as agreed by both the parties.

11. 3rd Party Add-ons/services/applications: All third-party costs arising from the registration of a domain name/purchase of third party utilities/services shall be met by the Client and are payable to inexpensivecoders before a formal application for registration is made. Examples of 3rd party fees are as under:
• Domain Names
• Server Space Hosting Fees
• SSL Certificates
• Backup Services
• 3rd Party APIs, if any, required by ‘Client’ to be integrated with the work ordered.
• 3rd Party Plugins/Scripts/Applications/Software/Widgets/Services, if any, required by ‘Client’ to be integrated with the work ordered.
• Payment Gateways Signup and Recurring Fees

12. Examples of work: Unless negotiated otherwise, inexpensivecoders retains the right to list/display the client name and logo with or without work performed (Design/Development/Online Promotion) for the Client in its respective portfolio and promotion materials. This over-ride all previous agreements and NDAs signed.

13. Quotations: The price quoted to the client is for the work agreed in the proposal document only. Should the client decide that changes are required after the project work has been initiated, then inexpensivecoders will provide a separate quote for the additional work and may need to review the timescale for completing the project. Cost estimates and prices quoted are valid for maximum one month unless otherwise agreed.

14. Mode of Payment

a. Clients Based Outside India: International Wire Transfers, Credit Card/PayPal.
b. Clients Based in India: NEFT, RTGS or Physical Cheques.

15. Payment Terms:

a. Payment plan is agreed between the ‘Client’ and inexpensivecoders based on the milestones.
b. Payment shall be due within 7 days of the invoice date unless specifically mentioned in the Invoice.
c. Full publication of the website/technical work will only take place after full payment has been received in our account unless otherwise agreed in writing.
d. Any material previously published may be removed if payment is not received. When this occurs, a minimum charge of $150 USD will be charged to have the site restored.
e. Accounts that have not been settled within 7 days of the date shown on the invoice will incur a late payment charge of $50 USD or 5% of the Invoiced Amount (whichever is higher), for each week delayed.
f. In case of delay in payments beyond the due date, inexpensivecoders reserves the right to stop the work being commenced and ‘Client’ agrees to exempt inexpensivecoders from meeting the timelines agreed.

16. Cancellation: Both the parties reserve the right to cancel the project at any stage.

i. In case the project is cancelled by Client, the payments made for the project can be refunded to the client after deducting the upfront payment amount received for Initiation of the project and the other payments received against the milestones completed.
ii. In case the project is cancelled by inexpensivecoders, the payments made for the project can be refunded after deducting USD 10 per hour for the hours spent on the work performed for the client including but not limited to the time spent on project discussion, requirements gathering, project planning & documentation, project initiation and execution. After the payments are settled between the two parties – inexpensivecoders shall transfer to ‘Client’ – all the documents, designs and scripts produced for the project.
iii. In case of interruption/problem from any third- party service like hosting, API’s or any services, inexpensivecoders shall not be held responsible for any data/files lost or any issue or will not be liable for any refund of amount.

iv. After project/order cancellation/refund issued, inexpensivecoders reserves all rights to take down the website published. Client is responsible to keep a backup of the data published on the website/server, inexpensivecoders shall not be held responsible for any data/files lost.

17. Delayed Response from Client Side: Unreasonable delays from client side in providing the required feedback/information/data to finish the project shall exempt inexpensivecoders from meeting the timelines mentioned in the quote. In case, client does not provide required details/data/information for more than 15 working days, client authorizes inexpensivecoders to forfeit the payments made towards this project.

18. Time Estimates: Client agrees that stipulated timelines cannot be met if the project scope is changed by client once the project scope document is finalized. Client agrees not to change the requirements without extending the original agreed timelines by minimum 1 week against each change request.

19. Share in profits from business or sale of business: After client makes the agreed payment for the project, inexpensivecoders will not claim share in client’s profits from business or from sale of business to some other company.

20. Copyright/Ownership Rights: inexpensivecoders will retain the copyright of any material, including design, artwork and the source code, created for the client by inexpensivecoders. inexpensivecoders reserves the right to retain the copyright on all material created by inexpensivecoders unless otherwise agreed between the two parties in writing. As per the agreed terms client owns rights on following items:

i. Logo/Graphics/Pictures/Images supplied by client – Yes
ii. Website Interface/PSD/Creatives/Designs – Yes, if client has ordered custom design with Exclusive Rights.
iii. Programming Files/Source Code – Yes, if the Client has ordered the project with Exclusive Rights. Client does not own the copyright/Intellectual property rights for projects being done on Single Domain License basis.
iv. If the project is being done on Single Domain License basis, Client owns the rights to use the system only on designated domains and Client should take reasonable care of the system files to restrict un-authorized access of the system scripts/source code delivered.

21. Ownership of Code and Intellectual Property Rights: Unless otherwise agreed, inexpensivecoders is the owner of the source code and the intellectual property rights and reserves the right to reuse the code for other projects.

(Terms 22nd to 25th are only applicable in case of Single Domain Non Exclusive License)

22. Single Domain License: Unless otherwise agreed, client agrees to setup the scripts delivered only on one domain, one sub-domain (subdomain.yourdomain.com) and local host. However if client wish to run same website on different domain/sub-domain, then client has to purchase separate license for each domain/sub-domain.

No license would be required for Add-on Domains that will point to the main domain where this system will be implemented. All add-on domains will be forwarded to the main domain from the hosting server and no additional license would be required for these domains. For every new domain or sub-domain, client has to buy a separate license.

23. License Validity Period: Limited period license is issued initially. After 6 months from the date of full payment, life time license is issued. Feel Free to contact inexpensivecoders Support Team, in case your license has expired and payment has been made in full, such issues will be resolved on highest priority.

24. No recurring costs of license: There is no renewal/recurring license fee. However, if client wishes to run same website on different domain or sub domain, then client has to purchase separate license for each domain or sub domain.

25. Use of encrypted files: Unless otherwise agreed, inexpensivecoders can use own framework (code library in encrypted format) for web applications development for making source code of our intellectual property/scripts secure from other programmers; faster turnaround time; and bug free application development. Client will be provided with detailed documentation for using framework (code library functions). With the help of documentation provided, other programmers can modify the website functionality. inexpensivecoders framework is collection of functions related to Database Manipulation, Images/Files Management, Paging, and Form Builder etc. which looks like PHP Functions but have different syntax than default PHP functions. Other willing and efficient PHP programmers can learn and practice this functions/framework within 2-4 days.

Note: In no event, inexpensivecoders shall be liable to the client or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate these Web pages or website, even if inexpensivecoders has been advised of the possibility of such damages. Despite the best efforts of inexpensivecoders, errors in web page information may occur. At no time, will inexpensivecoders be held responsible for accidentally including erroneous information, extending beyond correcting the error.
Should inexpensivecoders waive any of these terms on an individual basis, this shall not affect the validity of remaining clauses or commit inexpensivecoders to waive the same clause on any other occasion.

By agreeing to these terms and conditions, your statutory rights are not affected.
inexpensivecoders reserves the right to change or modify any of these terms or conditions at any time, but agreements signed prior to the updates in this agreement remains unaffected. Please feel free to contact us for more info/clarification about any of the terms and conditions mentioned above.

E commerce website along with Inventory, Account & Sales Management Proposal

Scope of Work:-

The client wants us to develop E commerce website along with Inventory, Account & Sales Management.

Compatible Browsers

IE10, IE11, Firefox, Safari, Opera, Chrome, Edge Software Framework

Development Platform

PHP 7.x, PHP 5.6, MySQL 4.x, MySQL 5.x,Laravel

Main Features

o Privileged Admin Dashboard
o Staff Dashboard
o Suppliers Ledger
o Customers Ledger
o Purchase Management
o Sales Management
o Invoice Generating
o Inventory Management
o Expense Management
o Damage Management
o To Be Stocked Out Product Alert
o Graphical Reports
o Print & PDF Download
o Multi User Creation
o Multiple Currencies
o General Settings

Admin Dashboard:
Admin are being able to see some system status on their dashboard page and can see how many suppliers, customers, users are registered to the system.

  • Graphical Reports:
    Last 7 days sales, Customers Report, Expenses Report, Sales Report.
  • Add Suppliers
  • Add Categories
  • Add Products
  • Add Customers
  • Add Expense
  • Add Damage
  • Add User
  • Purchase
  • Sales
  • Invoice:
    Invoice creation is much easier
  • Ledgers
  • Individual Supplier History
  • Individual Supplier Payment
  • Customers Ledgers
  • Individual Customer Payment
  • Reports
  • Purchase Report
  • Sales Report
  • Sales Details

Client has to provide the following to aid the development:-
 Logo and taglines for each web
 Images (copyright to client)
 Name of pages that are to be present on the web-application
 Topics that need to be included along with the name of page on which they appear in advance (for the purpose of content generation)
 Contact details to be placed on the web-application
 Privacy Policy and terms of Condition (only if they deviate from normal industrial standards)

Resources that needs to be deployed from inexpensivecoders:-

Designation                  Number of resources
Web Developer             2
Business Relation Manager   1
QA and Testing       1
Ui/Ux         1

 These resources will be deployed by inexpensivecoders at their desired location.
 The client can enquire, question or even suggest his ideas at any time to the Business Relation Manager as per his own convenience.
 The Client is not responsible for the resources in any which way.

NOTE: Any Features, Design, or other development changes made after the freezing of requirement gathering (SOW) will be treated as a Change Request and will be treated as out of project boundaries and will be charged accordingly.

Costing Involved For Web-Application Development:-
Development cost                     XX,XXX INR
Support and Maintenance (domain and hosting included)    XX,XXX INR
TOTAL                             X,XX,XXX INR

This amount is exclusive of tax (which will be according to Indian Govt.).

Crypto Examiner (Crypto Compare) Application Requirement

The customer is looking to develop a crypto examiner (crypto comparer) web application. The technology decided is to use Reactjs.  The crypto examiner website can be used to prepare some comparison grids and charts. For the pricing data it was advised to use https://www.cryptocompare.com/api/  The Client will be providing formula to calculate the values like Sharpe Ratios.  The Design should be emulated from the mockup, however the color themes will be finalized once the website is up and running.

Snow software Requirement

The requirement for Snow software is to develop a Mobile Application, which is for Users who does the work of Cleaning the Snow. The Basic scope of this application is that the Users will visit a site and complete the work assigned to them. On completion of the work, they will use the Mobile Application to enter the Work Details. A Web application will also be provided for creation and maintenance of Master Records and for Entry of Work Details.

Mobile Application Features
The Mobile Application will be used by Users to enter the Work Details and Update them once they have completed the Work. When the Users Launch the Application, they will see a list of In-progress Works performed by them. They can search by Site Number, Work Status, Start Date. They can also edit the Work Details by clicking any of the Work Detail. They will be displayed the Work Details screen with an option to modify the data. There will also be a New Work button, which will take them to Work Details Screen afresh. For the Current Scope of the Project there will not be any login page for the Application.

Work List Screen
When the Users launch this application, the Work List Screen will be displayed. This screen will display the list of last 10 Work Details by the User in the In Progress Status. This screen will also have a search option, where the users can search by Site Number, Work Status, Start Date. They can also edit the Work Details by clicking on any of the Work Detail. This will display the Work Details screen with an option to modify the data. There will also be a New Work button, which will take them to a new Work Details Screen.

Work Entry Screen
When the Users launch this application, the Work List Screen will be displayed. By clicking the New Work Button, they can enter a New Work Details. The Users will enter the following details:

# Field Name Type Required Business Logic

(if any)

1 Phone Number Auto Populated N/A Phone Number of the device from which the application is launched.
2 Work Status Option – Completed or

In Progress

Yes
3 Work Start Date Free Text Yes Allow only Valid Date in the Format mm/dd/yyyy. Default to today’s Date.

This should happen when the application is opened and can be a simple start button or text that is clicked. If they need to enter another date and time that is what the free text is for.

4 Work Start Time Free Text Yes Allow only Valid Time in the Format hh:mm:ss. Default to Current Time.

This can function the same way as the Start date and start date and time should be on the same screen.

5 Work End Date Free Text Yes Allow only Valid Date in the Format mm/dd/yyyy. Default to today’s Date.

Same as Start Date.

6 Work End Time Free Text Yes Allow only Valid Time in the Format hh:mm:ss. Default to Current Time. Same as End Time.
7 Duration Auto Populated N/A Difference between the Start Date Time and End Date Time.
8 Location Free Text Yes Free Text
9 Work Type Drop Down – Prepopulated Yes Populate with the List of WorkTypeName from WorkTypeMaster.
10 Condition Drop Down – Prepopulated Yes Populate with the List of ConditionName from ConditionMaster.
11 Material Used Drop Down – Prepopulated Yes Populate with MaterialName from MaterialMaster based on the Work Type Selected.
12 Qty of Material Used Free Text No If it is Empty or N/A send 0 for updation.
13 GPS Cordinates Auto Update Yes Users will not see this field or enter this field. It will be sent to the Web service automatically.

After entering the above details, the User will click the Submit button, which will check if all the data is entered and are valid and send the data to the Web Service, which will update the database and return a confirmation of Submitted Information and then return to the same screen for accepting new entry. Based on the Phone Number, the First Name and Last Name will be stored in the database. If the Phone Number does not match with that of the Phone number available in the database, the data will not be stored and an Error Message will be displayed to the User.

The Application will also have a logout button, which will close the application.

Web Application Features
Administrator will have access to the Web Application. Administrator will use this Application to Manage the Masters and View the Dashboard. For the Current Scope of the Project there will not be any login page for the Application. Administrator can access the Application by typing in the URL and the Dashboard page will be the default page.

Users can access the web application by entering their phone number. They can only see data they have entered or enter new data but data entered via the web application will have “Web Entry” instead of GPS map of location where work was completed.

Dashboard
When the application is launched, the Dashboard Page will be displayed. This Page will display the latest 25 Work Details in the table format with the following details:
 Phone No
 First Name & Last Name
 Site Number – Alpha and Numeric Field
 Work Start Date Time
 Work End Date Time
 Duration
 Work Status
 Work Type
 Material Used
 Conditions
 Quantity of Material Used
 GPS Location (can click and see location on Map in google)

Administrator will also have search panel on the top of the list, where the data can be filtered based on the following criteria:
 Date Range
 Name
 Work Start Date
 Work End Date
 Site Number
 Work Status
 GPS Location
 Work Type
 Material Used
 Conditions

Map View
This Section will be used to Display the location of Users in a Google Map.

In this page, there will be a list of Users with a Checkbox. Administrator can select one or multiple users, based on which the Map View will represent the Location of selected users by pins.

Manage Users
This Section will be used to Create and Manager Users. The Administrator has to enter the following details to create a User:

# Field Name Type Required Business Logic (if any)
1 First Name Free Text – 50 Chars Yes N/A
2 Last Name Free Text – 50 Chars No
3 Email Id Free Text – 50 Chars Yes
4 Phone Number Free Text – 20 Chars Yes
5 Is Web User Option – Yes/No Yes Default to No
6 Password Free Text – 12 Chars No If the User is a Web User Passward will be mandatory. Minimum 8 Characters.
7 Confirm Password Free Text – 12 Chars No Should be same as Password.
8 Active Option – Yes/No Not Displayed in Creation Mode. Active will be default value while creation. Displayed only in Edit Mode.

Administrator can also Activate/Deactivate a User. If a User is marked as Web User, then the Password will be mandatory. This option is provided, so that in future if the admin section needs an Authentication, this option can be used.

Manage Work Type
This Section will be used to Create and Manage Work Type. The Administrator has to enter the following details to create a Work Type:

# Field Name Type Required Business Logic (if any)
1 Work Type Name Free Text – 50 Chars Yes N/A
2 Work Type Description Free Text – 500 Chars No
3 Active Option – Yes/No Not Displayed in Creation Mode. Active will be default value while creation. Displayed only in Edit Mode.

Administrator can also Activate/Deactivate a Work Type. If a Work Type is marked as Inactive, that Work Type will not be available during Entry for the Mobile App Users but will be available for Reporting/Dashboard purposes.

Manage Material Type
This Section will be used to Create and Manage Material Type. The Administrator has to enter the following details to create a Material Type:

# Field Name Type Required Business Logic (if any)
1 Material Type Name Free Text – 50 Chars Yes N/A
2 Material Type Description Free Text – 500 Chars No
3 Active Option – Yes/No Not Displayed in Creation Mode. Active will be default value while creation. Displayed only in Edit Mode.

Administrator can also Activate/Deactivate a Material Type. If a Material Type is marked as Inactive, that Material Type will not be available during Entry for the Mobile App Users but will be available for Reporting/Dashboard purposes.

Associate Work Material Type
This Section will be used to Associate Material Types with Work Types.

Administrator will select the Work Type and a Grid below will display the Material Types, the Grid will also have a Checkbox in each row. Administrator will select the Material Type that needs to be associated with the Work Type Selected and save. When the Administrator selects a Work Type all Material Types which are associated with it will be checked by default. There will also be Select All/De-Select All Option, which will be used to select all the Material Types to associate to the Work Type rather selecting them one by one.

The following data will be captured during this process:

# Field Name Type Required Business Logic (if any)
1 Work Type Drop Down Yes N/A
2 Material Type Grid Display No  All Material Types which are associated with the Work type selected will be checked by default.

Condition Master
This Section will be used to Create and Manage how Work Condition was. The Administrator has to enter the following details to create a Condition Category:

# Field Name Type Required Business Logic (if any)
1 Condition Name Free Text – 50 Chars Yes N/A
2 Condition Description Free Text – 500 Chars No
3 Active Option – Yes/No Not Displayed in Creation Mode. Active will be default value while creation. Displayed only in Edit Mode.

Administrator can also Activate/Deactivate a Condition. If a Condition is marked as Inactive, that condition will not be available during Entry for the Mobile App Users but will be available for Reporting/Dashboard purposes.

Work List Screen
Users will have to enter the Phone number and if the Phone number is available in the database, then the page will display the list of last 10 Work Details for the User in the In Progress Status. This screen will also have a search option, where the users can search by Site Number, Work Status, Start Date. They can also edit the Work Details by clicking any of the Work Detail. They will be displayed the Work Details screen with an option to modify the data. There will also be a New Work button, which will take them to Work Details Screen afresh.

Work Entry Screen
From the Work List Screen will be displayed. By clicking the New Work Button, they can enter a New Work Details. The Users will enter the following details:

# Field Name Type Required Business Logic

(if any)

1 Phone Number Auto Populated N/A Phone Number entered by the user will be prepopulated.
2 Work Status Option – Completed or

In Progress

Yes
3 Work Start Date Free Text Yes Allow only Valid Date in the Format mm/dd/yyyy. Default to today’s Date.

This should happen when the application is opened and can be a simple start button or text that is clicked. If they need to enter another date and time that is what the free text is for.

4 Work Start Time Free Text Yes Allow only Valid Time in the Format hh:mm:ss. Default to Current Time.

This can function the same way as the Start date and start date and time should be on the same screen.

5 Work End Date Free Text Yes Allow only Valid Date in the Format mm/dd/yyyy. Default to today’s Date.

Same as Start Date.

6 Work End Time Free Text Yes Allow only Valid Time in the Format hh:mm:ss. Default to Current Time. Same as End Time.
7 Duration Auto Populated N/A Difference between the Start Date Time and End Date Time.
8 Location Free Text Yes Free Text
9 Work Type Drop Down – Prepopulated Yes Populate with the List of WorkTypeName from WorkTypeMaster.
10 Condition Drop Down – Prepopulated Yes Populate with the List of ConditionName from ConditionMaster.
11 Material Used Drop Down – Prepopulated Yes Populate with MaterialName from MaterialMaster based on the Work Type Selected.
12 Qty of Material Used Free Text No If it is Empty or N/A send 0 for updation.

After entering the above details, the User will click the Submit button, which will check if all the data is entered and are valid and send the data to the Web Service, which will update the database and return a confirmation of Submitted Information and then return to the same screen for accepting new entry. Based on the Phone Number, the First Name and Last Name will be stored in the database

Fun Shopy Ecommerce Requirement

We received a requirement to develop an Ecommerce website with the following modules

Admin Module (Web):
1. Add/Modify/Delete/View/Export products
2. Add(Upload)/Modify/Delete/View/Export multiple users (Modify implies delete and add)
3. Add/Modify/Delete/View/Export New web Pages
4. Add/Modify/Delete/View/Export Customers
5. Option to View Shipping Requests from Customers
6. Monitor Retailer and Customer Activities
7. Configure Allowed Pin codes (This is how it is called in India. For other countries it is called as Zip codes) for postal
8. View google Analytics
9. Generate Reports
10. Manage banner and Web Pages
11. search banner in home page
12. Showing cart details in home page top
13. cookies to enable best performance
14 . Enable Feature for Facebook Re targeting and Marketing
15. copy meta tag paste in head of theme code
16 sitemap submission in google check
17 fastest drop shipping conversion theme
18 Pingdom speed test less than 1 second
19 mailchimp configuration
20 Whastup option to share image and do whats up marketing
21, Fraud Analysis
22 Number of products unlimited
23 Manual order creation
24 Discount codes
25 Website and blog
26 Abandoned cart recovery
27 Free SSL certificate
28 Gift cards
29 Advanced report builder
30 Third-party calculated shipping rates
31 Sell on Facebook
33 Bank level security with free 256-bit SSL certificate
34 display offer button on product for ex(common panda)
35 operlo dropshipping
36 Product Recommendation
37 Display striked options ex panda
38 quick links
39 Dashboard including all possible analysis like shopify
40 Display social media connection front of page
41 Display google reviews
42 HOT DEALS TODAY!
43 HOME FAQ CONTACT
45 deal timer
46 recommendation
47 Shipping Policy
48 Refund Policy
49 Privacy Policy
50 Terms Of Service
51 setup your facebook tracking pixel
52 signup analyt,adword install tracking code
53 Create press page

Customer Module(Web + iOS + Android) :
1. Website with Home page, About Us, Contact Us and other CMS pages
2. Enter the postal code and land to customised home page
3. Display various deals like deal of the day ,season sale,Hot deals
4. mirroring ..to sell product in amazon ebay
5. Receives sms or mail notifications when there is a sale of their favorite product or from the stores.
6. Instant chat server for phone reply

Yearbook Application Development in Flex

Scope of Proposal

This proposal covers the quote for performing Study, Design, Development and Testing of Yearbook Website using FLEX, C# DotNet and MSSQL . The Application will be accessed by Client Admin and their Users.

This document covers the proposed technology architecture for developing Yearbook website using Flex. It also includes the team responsibilities, requirement change procedures and the effort required to complete this project.

Scope of Project

The scope of the project is to develop Yearbook Website which will allow the users to login, design and build the yearbook using the templates / image library available in the yearbook application online, move around the pages and finally publish the yearbook. The administrator’s responsibility include approving the registered users, emailing the credentials to the registered users and printing the yearbook. The reason for developing the Yearbook Website using Flex and the features of both Flex and the proposed Yearbook website is given below.

Rich Internet Applications (RIA’s) are becoming an important differentiator in the area of web today. This makes the application to reach the users fast and provide greater level of success and high level satisfaction in users based interactions. To build RIAs there are different technologies that can be used today, But “Adobe Flex” is the right tool for many web developers. The major features of Adobe Flex are

• Adobe Flex is a collection of technologies released by Adobe Systems for the development and deployment of cross platform rich Internet applications
• Flex is Open source software.
• The Adobe Flash Player, upon which Flex applications run, is already installed on about a billion computers worldwide
• Applications developed using Flex assures Rich User Experience through insightful interaction with the application and presenting information in a visually rich interface
• The highly evolved client environment of Flex permits the applications to process huge number of information at client-end without any noticeable change in performance of the applications
• improved reliability, availability, scalability and security

The developed yearbook application will have the functionalities listed below

• The Site will be very fast
• The Site will be user friendly with Rich look. The tools provided in the GUI will be really simple and straightforward. The user will be able to work within a single window.
• The user will be able to drag and drop images, use bottom controls and live preview for configuring yearbook.
• Users can login to the site and Register for using the yearbook application.
• Administrator will approve the registered users and send an email with login credentials to the user.
• Using the provided username and password the user can login and access the yearbook application
• The yearbook application will have unlimited number of pages.
• User can use the templates available in the yearbook application
• The yearbook will have an online image library. These images can be used by the users while designing the year book.
• The users can customize the borders/frames in the yearbook pages.
• The users can Move around the pages and rearrange the page numbers.
• The users can publish the yearbook
• The published yearbook can be printed by the administrator in 300 dpi. If required, it can also be exported as pdf and emailed to the users.
• The users will be able to Save, modify and republish their yearbooks
• Portrait and Landscape Layout (Will be available only if requested)
• Animate during Flip (Will be available only if requested)
• Inserting Videos in the year book (Will be available only if requested.)

The website would be designed and developed using Flex, C# Asp.Net and Microsoft SQL Server 2008 as back end.

Features
The features and functionalities of the developed yearbook website are listed below.

Homepage
The Homepage lists the features of the Yearbook Application and will have a link to register for using the yearbook application.

Registration
 The link to load the Registration page will be present in the home page
 When the user clicks on the Register Link this page will be loaded and displayed to the user
 This page will be used to capture required information from the user and update in the database.
 After successful registration, it will be notified to the administrator.
 The user will receive an email from the administrator (should this be automated) with username and password

Login Process
This section lists the features of the Login process.

 Login Page
This is the first page in the application.
Users can log into the application using the username and password provided by the admin.

 Forgot Password
This is a link in the login page
When the user clicks on forgot password link, a forgot password page will be displayed to accept the users email address.
The email address will be verified in the systems database and if it is correct then the password will be emailed to the user.

 Change Password
This is a link in the login page
When the user clicks on the change password link, a change password page will be displayed to the user.
In this page, the user name, current password and new password will be obtained as input and verified in the system database.
If the provided username and password is correct then the password will be changed in the system database.

Dashboard
 After the successful login, this page will be displayed to the user
 The Toolbar will be displayed in this page.
 Using this page the users can perform any required operations.

User Management Process
 The Yearbook application, by default, will have two types of roles. They are
 Administrator – These users will have all the rights. The major role of the admin is to approve the registered users, send credentials in email and print the published yearbook.
 General Users – These users are approved by the administrators. These users are regular site users.

Admin Module
 In this module the administrator can
 Review the list of registered users and email the credentials to the users
 Activate / deactivate users
 Manage Database
 Manage the site content (if required)
 Print the Published yearbook

Tool Bar
 The tool bar will have icons for options that the user uses frequently.

YearBook Creation Process
 The Yearbook Creation process involves
 Preparing book pages with Templates
 Defining Borders / Frames
 Define the Contents Alignment
 Inserting Images (Either from online image gallery or from local machine)
 Moving around Pages
 Publishing and
 Printing

Architecture

System Architecture

The architecture is divided into 2 layers basically, like Client layer and Server layer.

Client Layer:
This layer would be used by the website end users. It will basically be a thin client layer built using Flex and HTML, and its primary aim would be to present the data to the user and get the input..

Server/Database Layer:
This layer will be a typical Web server layer running IIS server that can run pages. It will have the application pages hosted in it. The POS pages will be run by the web server engine and the HTML results would be rendered to the client. This layer can hold the database (Microsoft SQL Server) as well. If required, the database can be hosted in a separate server machine.

Tools and Technologies
The following are the tools and technologies that will be used in the development of this application.

Operating System 32 Bit Windows  Server 2003
Languages C#.Net, HTML, CSS, AJAX
Database Microsoft SQL Server 2008
Source Repository Visual Source Safe
Tools Visual Studio 2008
Framework Dot Net 3.5
RIA Adobe Flex with SDK 2.5

Development Methodology
The Yearbook Website would be designed and developed using the following methodology which includes 4 phases.

Phase 1 – System Study
• During this phase, a detailed study would be done on the requirement and database design will be finalized.

Phase 2 – Layout Design, HTML and CSS Creation
• During this phase, the web designer will prepare 3 Sample layouts for the website, which would consist of home page and inner page options.

Deliverable : 3 UI Layout options in JPG Format

Phase 3 – Development and Unit testing
• The development phase will commence on approval of the Design Phase. Unit testing of the system will be carried out in this phase after development.
• On agreed intervals the team would conduct online review sessions with the client to demonstrate to progress of tasks.
• A temporary staging server would be setup for the client to review the progress. This server will be updated on regular intervals.

Phase 4 – System and functional testing
• On completion of the unit testing for the individual modules, Functional, System and Integration testing will be done to verify the proper flow of required data from one module to the other

Deliverable : Tested Website and source code

Assumptions
We assume that Client will,

1. Provide us technical guidance wherever applicable to understand the current system.
2. Approve the DB Design, UI Layouts and Design on time, so that the website can be completed on time.
3. Coordinate between the end client and inexpensivecoders to ensure that the client requirements are met (in case an End Client is involved).
4. Provide Test data (if required) for testing of the application on completion of the development.

Intellectual Property
All personnel engaged in this client sensitive project are to execute the non-disclosure and intellectual property agreement, which will prevent misuse of company proprietary information as well as client proprietary information. A general vigil on the activities of the employee is also maintained to ensure that there is no threat to the agreements.

Project Responsibilities
inexpensivecoders’s Responsibilities
The roles and responsibilities of all resources involved and shown in the above diagram in the proposed team are mentioned below. This clarity will lead to better understanding and communication between the two organizations and enable better relationship management. The following are roles and responsibilities of different resources that will be working as part of this project.

Role Responsibilities
Project Leader
 Providing primary contact for the engagement at offshore.
 Managing and directing the development team including setting priorities, coordinating, and the reporting of the off-shore activities
 Ensuring that the members of project team, understand the Project requirements
 Planning and co-ordination of tasks.
 Assigning work to team.
 Attends development and design walk through
 Monitoring progress of work
 Ensuring the project delivery schedule and quality standards are met
 Providing daily, weekly and monthly reports on project status
 Discussing the project status on regular basis to the Client representative.

Web Designer
 Provide 3 Sample layouts for the website, which would consist of home page and inner page options.
 Co-ordinate with the Development team to ensure that XHTML and CSS Standards are met.

Development Team
 Coding
 Code Review
 Unit Testing
 Delivering the software to the onsite team.

Test Team
(Testing Engineers)
 Test and ensure that the Website is as per the Functional Specification document provided by the Client.

Client Responsibilities
Client has to identify and appoint a resource at their end that would be the Project Coordinator and a single point of contact during the engagement. Following are the responsibilities expected from Client:

• Provide acceptance test criteria.
• Provide Test Data (if required).

Change Control Procedure
Any change in the functionalities or requirements or any change in the scope of the Systems Requirements Specification made after the approval and freezing of the Client requirements, will have to be done through the Change Control Procedure of inexpensivecoders, which is detailed below:

• The client will submit a Customer Complaint Form in writing for any change that is required.
• The change will be evaluated for Technical, Commercial and Schedule implications by inexpensivecoders and submitted to the client.
• The client will approve the same in writing, in a token of acceptance of all implications.

The Approval shall be done within a reasonable time frame (not later than 5 working days) so that the idle time of the resources is minimized.

Joint Reviews / Technical Reviews
Client and inexpensivecoders shall review the progress of work in any of the following ways:

• Joint discussions.
• Submission of progress reports periodically to the client by inexpensivecoders as per Client request.
• The reviews shall be conducted
 For verification of acceptance results;
 For technical clarification / deliverables;
 To ensure client’s requirements (as agreed to) are met.
• The results of the reviews shall be documented.

Review Mechanism
• Online Meetings:
Online meetings will be conducted using online meeting tools like
 GoToMeeting
 WebEx
 Skype

• Staging Server:
 inexpensivecoders will host the application under development in a Stage Server.
 This Server will be an External IP Host.
 This Server will be available 24 X 7, for Client Representative to monitor the progress.

Communication Mechanism
inexpensivecoders will keep updating the project status to its clients through weekly reports and statuses. This report will have the activities performed by the project team, milestones achieved, and activities planned for next week. Apart from these, teleconferences and IM with project team can be arranged for updating project status and discuss any other issue that might come up, if  Client  desires so.

inexpensivecoders recommends the following communication methods during this engagement.

Information Type Mode Monitoring Frequency Participants in communication Supporting Tool (if any)
Progress/Status Mail / IM Once per week  Client  Rep

inexpensivecoders PL

Progress Report
Timesheets Email Once per Month inexpensivecoders PL Timesheet
Issue management Tele Conference / IM On Need basis  Client  Rep

inexpensivecoders PL

Requests for clarification Email / IM On Need basis  Client  Rep

inexpensivecoders PL

Deliverables Appropriate method to be agreed at time.  Client  Rep

inexpensivecoders PL

Appropriate tools to be agreed at time (CD, FTP, etc)

Project Effort, Pricing and Commercial Terms

Project Effort

S. No. Phase Man Hours
1     Study, Requirement Analysis and Database Design
2     Layout Design, HTML and CSS Creation
3     Design Development (HTML Files)
4     Development and Unit Testing
5     System and Functional Testing
6     Project Management & Communication
Total (in Man Hours)

The estimated effort for analysis, design, development, testing and implementation of the Yearbook Website works out to                                             . The billing would be done on the actual time spent on the project.

We can assure you that our time estimates will not vary more than 10% unless there is a vast change in the requirement.

Timeline

Phase Man Hours No. Of Resources Working days
1     Study, Requirement Analysis and Database Design
2     Layout Design, HTML and CSS Creation
3     Design Development (HTML Files)
4    Development and Unit Testing
5    System and Functional Testing
6    Project Management & Communication – (TL)
Total (in Man Hours)

Pricing
We propose a Time and Material Model (T & M) for the development of this project. We can assure you that our time estimates will not vary more than 10% unless there is a vast change in the requirement.

The following are the hourly rates

# Resource Phases Allocation Rate
1 Project Leader Requirement Review and

Project Management

Need Basis
2 Programmer Development & Unit Testing Fulltime (40Hrs/week)
3 Tester System and Functional Testing Need Basis
4 Web Designer UI and HTML/CSS design Need Basis

Based on the rate chart and the estimated project effort, the pricing would work out to USD  .

Note:

  1. We will allocate 2 Developers on a fulltime basis 40 hrs per week on your project.
  2. Monthly Timesheets will be sent to you giving details of time logged by all resources and the work done.
  3. Invoice will be raised on approved time sheets.

Kindly note that billing will be done based on the actual number of hours spent and only on the Approved time sheets.

Deliverables

The following are the list of deliverables that will be provided inexpensivecoders:

# Phase Deliverable Days / Weeks
1  Study, Requirement Analysis and Database Design Database Design Document  

5 Days from start of project

2  Layout Design, HTML and CSS Creation 3 UI Layout options in JPG Format  

15 Days from start of project

3  Design HTML Design 15 Days from approval of Layout Design.
4 System and functional testing Tested Website and source code After the Fixes on the UAT Approval.

Note:
a) During the course of development, based on the agreed time intervals, the inexpensivecoders and Client representatives will conduct periodic reviews and could have interim deliveries as and when needed.
b) The Time Frame for the development is arrived by assuming we deploy 1 resources for development, 1 resource for testing, 1 for web designing and 1 for project management.