SCE&G uses third-party contractors to pick up, transport and install lights and poles for commercial customers across South Carolina. With their existing manual system, SCE&G lacked visibility into which contractor was picking up inventory items for which job, nor could they quickly track when and where each job would be installed or have timely notification when the jobs were completed. Contractors completed all field paperwork manually and could take up to 120 + days to transcribe hand-written field notes and submit the job completion paperwork to SCE&G for billing.
Because SCE&G could not bill its customers until after receipt of completed job documentation from contractors, billings were delayed, account receivables were behind and customers were unhappy. SCE&G needed greater visibility of each job status and precise reporting of where jobs were in the installation process. They were developing a new Light Management System (LMS) to track the light as the asset and the pole and wiring as attachments to create a kit. They wanted to know where each pole was installed via GPS coordinates and what kit was used. They needed to associate jobs with contractors and identify when each contractor took delivery of poles and kits for each job. Because contractors might take poles and kits for several jobs, it could take them days or weeks to complete all jobs. SCE&G wanted to know when each job was installed and completed in order to forecast for billing, and remove and automate manual paperwork for each job.
Inovity had previously provided unique value to SCE&G with a mobile meter-reading application that was designed and installed at SCE&G over three years ago. The key decision-maker for the project at SCE&G considered the team at Inovity to be subject matter experts and believed they had the expertise to develop an application to fit this new need. As a trusted advisor and proven provider, Inovity proposed a mobile application for the light and pole tracking project based on their meter-reading app. The decision-making team at SCE&G awarded Inovity the project.
Using their existing framework from SCE&G’s meter-reading application, Inovity created a new application to track the high-dollar lights and poles used by contractors for SCE&G installations, and integrated the movement of the inventory with SCE&G’s Peoplesoft backend system. Inovity’ developers and engineers worked closely with SCE&G project managers to thoroughly test, troubleshoot and tweak the system before installation and deployment, ensuring a smooth transition to the new application. The application ensured that contractors who checked in to SCE&G’s yard to pick up kits for each job would have poles and kits scanned and associated with them. SCE&G would then issue a loaner Motorola Solutions (now Zebra Technologies) MC75 mobile computer for the contractor to use during installation. When ready to begin a job, contractors would scan weather-resistant barcode labels on the light poles/kits at the installation location and their work order number. The application would capture the GPS coordinates of the location and time/date stamp the transaction. When contractors would return to one of SCE&G’s 26 satellite networks, the data would be uploaded to SCE&G’s Peoplesoft system, either automatically or by prompting an operator to upload the data. SCE&G would then be notified about the installation, including the pole and kit identification numbers, location, time, date and contractor who performed the installation. SCE&G’s elected to have only WLAN connectivity with the field devices to meet their current business needs, rather than real-time WWAN or cellular connectivity.
With the Inovity’ light tracking application in place, SCE&G saw dramatic increases in the quality and frequency of data generated by its installation contractors. With a total of 40 units in place over two implementation phases, SCE&G was able to reduce billing time from 120+ days after job completion down to 7-10 days, and dramatically improve its receivables. Because all manual forms were automated through the mobile application and removed from field installations, fewer errors occurred in customer billing. SCE&G now had complete visibility of its valuable inventory and could locate the status of a job quickly and accurately.
As a trusted advisor to SCE&G, Inovity took its proven application that had been in place and working well for over three years, modified it for the current business challenge and developed a successful application that solved the customer’s needs. With the solution working well, SCE&G is considering future modifications to include RFID tracking and expansion of the application to other SCE&G business units.