1. Project Background and Description The company is currently using an excel sheet for BoM(Bill of Material) generation. They need a web interface where a user can enter only required information and BoM is generated/downloaded in the same excel format. 2. Project Scope The application will provide screens to enter information through user friends’ interfaces. It will also allow to display as well as download the generated BoM. The data in generate BoM can be shown/hidden as per pre-decided criteria. The cells in the excel which needs to be set from the web application will always remain in the same position i.e. currently from Row#3 to Row#5. Any change in these cell position will cause issue in BoM generation. Although this can also be made dynamic by providing a field mapping screen but that will become too complex to handle 3. High-Level Requirements The new system must include the following: • Ability to allow both internal and external users to access the application without downloading any software • Ability to integrate the new software into existing WordPress site wither by calling web service or an Iframe. • Downloading of BoM
4. Deliverables 1. A web application that will either be used independently or will be used inside an Iframe in WordPress site. 2. A web service that will receive the required data as input and will return the filled BoM in provided excel format. 3. Complete source code of the application
5. Implementation Plan 1. Application will be developed on local computer 2. WordPress integration will be done first on any demo WordPress site 3. A demo will be given via a Zoom or Google Meet sessions 4. Once completed and approved application will be hosted on hosting server if the company already have otherwise will have to get hosting services first. 5. WordPress Integration will be done live site.
