BILL OF MATERIALS AUTOMATION FINAL PRESENTATION

1. BILL OF MATERIALS AUTOMATIONFINAL PRESENTATION Adi Y. Nugroho SYSM 6309: Advanced Requirements Engineering Summer 2013 Aug 3rd, 2013

2. Table of Content • Scenario • Problems • Solution • Class Diagram • Functional Requirement • Non-functional Requirement • SIG Diagram • Automation Demo • Summary

3. Scenario

4. The Cast Telco Vendor Company Telco Operator Company Bruce Account Manager Mark Engineering Manager Daniela HR Manager Swati Solution Manager Robert Customer Adi Engineering Lead Alex Project Manager Tatiana Design Engineer Natasha Programmer (Intern)

5. On a Customer Meeting Our team has already completed the microwave design for 13 markets and we are ready to order the equipment. We don’t have so much time.. Our leased line partner will be no longer exist next year due to bankruptcy. We have to move all sites from leased line to microwave network. The quotation for the equipment must be in my desk 2 months for now... Then we must start the roll out for those 6000 links next 4 months. Bruce Account Manager Well that is tough... But let me discuss with my team… And I will get back to you soon… Robert Customer

6. On an Internal Sales Meeting I will make the shopping list for all imported parts including the price based on our solution… The customer asked about the price quotation for those 6k link on 2 months for now... Swati Solution Manager Bruce Account Manager I will ask the engineering team to provide the Bill of Materials based on the design and solution… Please don’t try to make any mistakes on the calculation, every single error will have effect on this "multi millions dollar" project. Our company policy can only tolerate 0.1% errors maximum. Alex Project Manager

7. On an Internal Project Meeting Well… That would be challenging for us. Currently I have no more resources for engineer other than Adi and Tatiana. Others engineers are already booked for VN Project. I doubt we can complete it within the time frame. Great job for completing the design on time… Anyway we have to provide the BOM as soon as we can. The deadline will be 2 months from now. Alex Project Manager Mark Engineering Manager Gentlemen, this is the solution that we offer to our customer so please use this product based on our agreement with them. I can compile the whole design from the market engineer and I will match it with the product that you proposed. However this is will take 4 months to finish it with 2 engineers only. Swati Solution Manager Adi Engineering Lead

8. On an Internal Engineering Meeting Based on my experience each site will take 15 minutes. If only me and Tatiana we can complete it within 4 months the fastest. We need 2 more engineers to meet the deadline. I can’t believe it. We have to complete the BOM within 2 months for 6000 links with 0.1% error maximum. Adi, help me to understand how we calculate the resources for this…? Moreover.. If we bring more people for this project , it will create more human errors, inconsistencies and need good coordination between us. I think that would be inefficient way and I believe the error will be more than 5%. Based on direction from our top management team we cannot add more engineers until the end of the year. We can bring some contractors however they will cost $70 per hour! Adi Engineering Lead Mark Engineering Manager Tatiana Design Engineer

9. On an Internal Engineering Meeting Alright I hear you.. So what is our plan..? Do you have any idea for this? Currently I am very busy with VN project so I appreciate any ideas to solve this. I have idea to automate this work, however we need a programmer.. I don’t think we have resource for programmer at the moment. Adi Engineering Lead Mark Engineering Manager You may try to ask HR department maybe they have an intern with programming skills… That’s a great idea… Thank you Tatiana.. Tatiana Design Engineer

10. On an Internal Meeting with HR Our project currently demand a programmer to help us building the automation. You come on the perfect time… We just hire a intern who has specialty in programming… However please don’t expect her so much on telecom technology, she need someone who can guide her to do the job… My engineer can help her. That wouldn’t be a problem. I appreciate for your cooperation. Mark Engineering Manager Daniela HR Manager I have experience with SQL, .NET, and C#. That’s would be great… Welcome to our team.. And good luck. Natasha Programmer (Intern)

11. Problems • Speed and accuracy requirement to build the BOM. • Speed: 2x faster than normal. • Accuracy: 0.1% maximum error tolerance. • Lack of resources. • Hiring new engineer will take 2-3 months. • Hiring contractor will be costly for engineering department.

12. Project Structural Diagram Sales Domain Competence Domain

13. Project Behavioral Diagram

14. Solution • Automation will be the best solution in order to: • Speed up the work, 100 times faster minimum. • Minimize the errors up to 0.1%. • Utilize minimum resources for optimum result. • Achieve department’s cost saving target.

15. Automation Class Diagram Automation System Input/output Files External Process

16. Functional Requirement • System shall accept input files in Excel format. • System shall copy all information from input files to a dedicated server’s database. • System shall generate output files in Excel format. • System shall provide one page for “file uploads” as interface to upload input files. • System shall requires standard template for the input files. • System shall provide input files per customer on “file uploads” page. • System shall provide input files per market on “file uploads” page. • System shall provide option to select certain input files on “file uploads” page. • System shall provide version for every upload process on “file uploads” page. • System shall provide 2 different options, major and minor version on “file uploads” page. • System shall provide comment area for every upload process on “file uploads” page. • System shall provide “browse button” to select input files from user’s local drive on “file uploads” page. • System shall have validation process to minimize the error up to 0.1% maximum on “file uploads” page. • System shall provide “validate and upload” button to start data validation and uploading process on “file uploads” page. • System shall have a feedback or warning announcer to tell user that the input files has some errors. • System shall display all version number, date, user email, and upload comment that already submitted to “file upload” page for history tracking purposes.

17. Functional Requirement • System shall provide one page for “BOM generation” as interface to generate BOM. • System shall generate standard template for the BOM. • System shall provide BOM generation per customer on “BOM generation” page. • System shall provide BOM generation per market on “BOM generation” page. • System shall provide option to select certain 2 BOM type: preliminary and final on “BOM generation” page. • System shall provide version for every BOM generation process on “BOM generation” page. • System shall provide 2 different options, major and minor version on “BOM generation” page. • System shall provide comment area for every upload process on “BOM generation” page. • System shall provide “generate BOM in Excel” button to proceed generating BOM in Excel. • System shall provide BOM in Excel file and this file must be downloadable to user’s local drive. • System shall display all version number, date, user email, BOM generation comment and also all BOM versions that already submitted on “BOM generation” page for history tracking purposes. • System shall give option for user to save, save as, open or cancel the BOM generation file on “BOM Generation” page.

18. Functional Requirement • System shall generate BOM based on requirement as below: • Use 1 antenna for 1+0, 1+1, and 2+0 link configuration. • Use 1 radio for 1+0 and use 2 radio for 1+1 and 2+0 link configuration. • 1+1 radio configuration need additional asymmetric power splitter with quantity 1. • 2+0 radio configuration need integrator with quantity 1. • All antenna’s and radio’s frequency, diameter, polarization, capacity, modulation, strength level, must match with the link configuration. • All cables should follow “cable length” input file and must be chosen based on 50m, 100m, or 300m granularity. • All connector quantity should be calculated based on cable’s calculation result. • Every 1 radio need 1 modem unit. • Site with up to 2 radio will need 1 small indoor unit. • Site with 3-5 radio will need 1 medium indoor unit. • Site with 6-10 radio will need 2 medium indoor unit. • Basic software shall be added for each indoor unit. • Capacity software shall follow the capacity stated on link configuration. • Protection software shall be added for 1+1 link configuration.

19. Non-Functional Requirement • System shall generate the BOM with processing time less then 15 seconds per market. • System shall has error less than 0.1%. • System’s shall meet availability target 99.9%. • System’s website shall be inside company network for security purposes. • System shall block all access from external network. • System shall provide feature for password recovery. • System shall provide admin page to accept user registration, add new user, and remove user. • System shall provide welcome page for user to register, enter system using user name and password, and request for password recovery. • System shall provide registration process to create account for user. • System shall reject registration from email that already exist in database. • System shall provide registration verification process to add user. • System shall create account and password for registered user. • System shall allow registered user to enter system, upload, download and generate the BOM base on privilege as below: • Common user: enter and download. • Special user: enter, upload, generate, and download. • System shall allow user to download the latest information on the database through tracker feature. • System shall provide user friendly GUI. • System shall have re-use process for different customers or projects or markets. • System shall provide custom process for different customers or projects or markets.

20. NFR SIG Diagram Performance Efficiency Security Speed Reliability User Friendly Reusability Customizability Availability Integrity Confidentiality

21. Automation Demo

22. Input Files • Link list contains information about: • Antenna model • Radio model • Frequency and sub-band • Configuration • Cable length contains information about: • Number of link • Coaxial cable length • Fiber cable length

23. Input Files • Antenna model • Radio model -->

24. Input Files • Frequencies and sub-band • Configuration • Cable Length

25. BOM Generation Manual Approach • Sample case DFW282 1st link 2nd link

26. BOM Generation Manual Approach • Input for DFW282: • 1st link: • 2nd link:

27. Using Manual Work

28. BOM Generation Manual Approach Antenna and Radio Cabling Indoor unit

29. Using Automation

30. BOM Generation Automation • File Upload Process

31. BOM Generation Automation • BOM Generation

32. BOM Generation Automation • BOM File was Generated

33. BOM Generation Automation • BOM Tracker Generation

34. BOM Generation Automation • BOM Tracker was generated

35. Feedback for Future Project • The algorithm to generate the BOM cannot be re-used for different projects or customer however the system provide customization for the programmer. • GUI for the user is still not user-friendly, better design and flow on the GUI are required for future project. • We almost achieved the maximum error required by sales manager (0.5% instead of 0.1%). This is due to some incorrect data inside the input files. We need better system to validate the input files more precisely and put more effort to socialized the standard template to the market engineer.

36. Summary • Automation successfully solve the engineering team problems by generating BOM thousands time faster than manual work. • Automation can minimize the error during BOM generation up to 0.5%. • Automation reduce the demand for contractor that will cost ~ $ 44k more for this project.

37. Question..?

38. Thank You!