Analytics Workplace Swati Godbole Payal Seth Chittaranjaneshwar Jha

Analytics @ Workplace Swati Godbole Payal Seth Chittaranjaneshwar Jha 30 th Oct. 2003

Welcome to Oman – the Land of Sindbad

…and the Sharqiya Transmission System Project http: //www. jyotistructures. com/web. nsf/about? Open. Frame. Set

Analytics in the Project A Project of this magnitude could have several possible application of optimization models viz. • Optimum location of central stockyard • Optimization of fleet of trucks/trailers • Output optimization of activities like foundation, pylon installation etc. • Selection of Vendors • Allocation of contractual works

Our Chosen Application • • Use optimization model to further economize work allotment of contractors for stringing activities. Finally Selected Contractors – One for each line:

Parameters Revisited Objective: Work Execution at Minimum Cost by Optimizing Order Quantity Constraints: • Per km Output • Stringing km • TSE Machines Variables: Order Level Contractor’s Selection

Using Optimization Model (1)

Using Optimization Model (2)

Savings of …. • ~$ 68, 000 on stringing activities alone • $ 250, 000 total estimated savings on project • Potential savings of 1 million dollars p. a. for the company How? By applying optimization models on other preceding activities also, a conservative estimate of 2. 5% savings could be projected on $10 m project portion which amounts to $250, 000. If JSL does 4 such projects p. a. , which is quite likely, a potential savings of $1 m is in the offering.

So What? ? This Sharqiya project worth US$ 62 m was won with a margin of $58, 000 only, among 22 global bidders. Generally such T&D projects are won over with the difference of 1% - 2%.

End of Desert Safari Shukraan!! (Thank You!!)