how to solve cost efficciency by data envelopment analysis in excel

High rise in the number of private vehicles is the major cause of traffic problems. From 1989/90 to 2017/2018, vehicles registration in Bagmati zone has elevated from 34,606 to 1,172,413 out of which 12,617 are buses and 921,917 are motorcycles (74% in overall vehicle composition in the valley). To meet the mobility demand, people prefer private vehicles like motorcycle over public vehicles. Kathmandu valley, in central Nepal suffers high population density because of the centralization, causing major traffic problems like congestion, delay, accidents, high demands of fuel, air pollution, noise pollution etc. Transit companies to explore the strategies to facilitate operational performance Scenarios development and evaluation can help lead Suggests that the longest route’s performance can be enhanced significantly upon The result of second set of scenarios for long route problem Routes except the longest route under the first set of scenarios, emerge to beīetter performing efficiently without considerable negative deviation inĮffectiveness.

DEA was conducted to access the performance Least Squares (PLS) regression was used to determine the most influential input Variables accordingly with regression model where it was relevant. Long route problem by changing the most important input variable and output Performance, scenarios were created for relatively underperforming routes and To explore the possibility of enhancing the To access the relative performance of transit system in absence of historicalĭata and research to compare with. (DEA) in terms of efficiency and effectiveness score. This study evaluates the operational performance of all routes of Sajhaīus Yatayat operating inside Kathmandu valley using Data Envelopment Analysis

How to solve cost efficciency by data envelopment analysis in excel