BILL OF MATERIALS AUTOMATION FINAL PRESENTATION Adi Y

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

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

Scenario

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

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

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 6 k link on 2 months for now. . . Bruce Account Manager Swati Solution Manager 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. I will ask the engineering team to provide the Bill of Materials based on the design and solution… Alex Project Manager

On an Internal Project Meeting 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. 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. 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. Swati Solution Manager 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. Adi Engineering Lead

On an Internal Engineering Meeting 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…? Mark Engineering Manager 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! 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. 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%. Adi Engineering Lead Tatiana Design Engineer

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. Mark Engineering Manager You may try to ask HR department maybe they have an intern with programming skills… Adi Engineering Lead That’s a great idea… Thank you Tatiana. . Tatiana Design Engineer

On an Internal Meeting with HR Our project currently demand a programmer to help us building the automation. Mark Engineering Manager 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. 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)

Problems • Speed and accuracy requirement to build the BOM. – Speed: 2 x 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.

Project Structural Diagram Sales Domain Competence Domain

Project Behavioral Diagram

Solution • Automation will be the best solution in order to: 1. 2. 3. 4. 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.

Automation Class Diagram Automation System Input/output Files External Process

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.

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.

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 50 m, 100 m, or 300 m 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.

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.

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

Automation Demo

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

Input Files • Antenna model ANT 2 0. 3 28 HP (TR) ANT 2 0. 3 28 HPX (TR) ANT 2 0. 6 11 HPX (TR) ANT 2 0. 6 18 HPX (TR) ANT 2 0. 6 28 HPX (TR) ANT 2 0. 9 11 HPX (TR) • Radio model --> 2010 18 064 T/16 -20 2010 28 064 T/16 -20 MLTN 28/2 X 064 T/16 X-20 MLTN 28/2 X 093 T/64 X-25 MLTN 28/2 X 093 T/64 X-30 TN 11/2 X 225 T/128 X HP-160 TN 11/2 X 225 T/128 X HP-80 TN 11/2 X 225 T/128 X St-165 TN 11/2 X 248 T/256 X HP-185 TN 11/2 X 248 T/256 X HP-195 TN 11/2 X 279 T/512 X HP-100 TN 11/2 X 279 T/512 X HP-210 TN 18/2 X 143 T/64 X HP-25 TN 18/2 X 165 T/16 X HP-50 TN 18/2 X 165 T/16 X HP-60 TN 18/2 X 194 T/64 X HP-150 TN 18/2 X 194 T/64 X HP-65 TN 18/2 X 194 T/64 X HP-70 TN 18/2 X 194 T/64 X St-145 TN 18/2 X 225 T/128 X HP-85 TN 18/2 X 225 T/128 X St-155

Input Files • Frequencies and sub-band 18700 11200 27922 • Configuration 1+0 1+1 2+0 • Cable Length Site. ID DFW 282 Units feet FH DFW 599 Coax 1 Coax 2 Coax 3 Coax 4 Coax 5 Coax 6 Coax 7 Coax 8 Fiber 1 Fiber 2 Fiber 3 145

BOM Generation Manual Approach • Sample case DFW 282 1 st link 2 nd link

BOM Generation Manual Approach • Input for DFW 282: – 1 st link: ANT 2 0. 6 18 HP (TR) TN 18/2 X 107 T/128 X HP-40 18700 19530 1+1 Coax 2 Coax 3 Coax 4 Coax 5 Coax 6 Coax 7 Coax 8 Fiber 1 145 145 – 2 nd link: ANT 2 0. 3 28 HP (TR) 2010 28 064 T/16 -20 27922 Coax 1 Coax 2 Coax 3 Coax 4 Coax 5 Coax 6 Coax 7 Coax 8 Fiber 1 145 145 28340 1+0

Using Manual Work

BOM Generation Manual Approach Antenna and Radio Cabling Indoor unit

Using Automation

BOM Generation Automation • File Upload Process

BOM Generation Automation • BOM Generation

BOM Generation Automation • BOM File was Generated

BOM Generation Automation • BOM Tracker Generation

BOM Generation Automation • BOM Tracker was generated

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.

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 ~ $ 44 k more for this project.

Question. . ?

Thank You!