Home

ROI Calculator

Fri, 04/16/2010 - 16:26 — moderas
Pager item text: 
ROI
url: 
http://www.old.moderas.org/roi.htm
Slide text: 
<p> This online calculator clearly demonstrates the value of technology in Research Administration by helping you determine the possible return on investment of implementing eRA as well as the value of business intelligence to your institution.</p>
Image: 

 

/* Styles needed by */
*.ee134 { background-color : #FFFFFF; font-size : 11.00pt;font-family : "Arial", Sans-serif; border-bottom : 2px solid #000000; border-right : 2px solid #000000 }
*.ee133 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-bottom : 2px solid #000000; border-left : 2px solid #000000 }
*.ee132 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : right; border-bottom : 2px solid #000000; border-right : 2px solid #000000 }
*.ee131 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : right }
*.ee130 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : right; border-right : 2px solid #000000 }
*.ee129 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Times New Roman", Sans-serif }
*.ee128 { background-color : #FFFFFF; font-size : 12.00pt; font-weight : bold; font-family : "Times New Roman", Sans-serif; border-right : 2px solid #000000 }
*.ee127 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Arial", Sans-serif }
*.ee126 { background-color : #FFFFFF; font-size : 11.00pt; font-weight : bold; font-family : "Arial", Sans-serif; border-right : 2px solid #000000 }
*.ee125 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-right : 2px solid #000000; text-align : left }
*.ee225 { background-color : #FFFF32; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-right : 2px solid #000000; text-align : left }
*.ee145 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; text-align : left }
*.ee124 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; text-align : right; border-right : 2px solid #000000 }
*.ee123 { background-color : #001AE0; font-size : 11.00pt; font-weight : bold; font-family : "Verdana", Sans-serif }
*.ee122 { background-color : #001AE0; font-size : 11.00pt; color : #FFFFFF; font-weight : bold; font-family : "Verdana", Sans-serif; border-bottom : 2px solid #000000; border-right : 2px solid #000000 }
*.ee121 { background-color : #001AE0; font-size : 11.00pt; font-family : "Verdana", Sans-serif }
*.ee120 { background-color : #001AE0; font-size : 11.00pt; color : #FFFFFF; font-family : "Verdana", Sans-serif; border-bottom : 2px solid #000000; border-right : 2px solid #000000 }
*.ee119 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Times New Roman", Sans-serif; border-right : 2px solid #000000}
*.ee118 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-bottom : 2px solid #000000 }
*.ee117 { background-color : #FFFFFF; font-size : 11.00pt; color : #ff0000; font-family : "Arial", Sans-serif }
*.ee116 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; text-align : right }
*.ee115 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Times New Roman", Sans-serif }
*.ee114 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-right : 2px solid #000000 }
*.ee113 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif }
*.ee112 { background-color : #FFFFFF; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-left : 2px solid #000000 }
*.ee111 { background-color : #001AE0; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-bottom : 2px solid #000000; border-right : 2px solid #000000 }
*.ee105 { background-color : #001AE0; font-size : 16.00pt; color : #FFFFFF; font-weight : bold; font-family : "Verdana", Sans-serif; text-align : center}
*.ee104 { background-color : #001AE0; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-left : 2px solid #000000 }
*.ee103 { background-color : #001AE0; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-right : 2px solid #000000; border-bottom : 2px solid #000000; border-top : 2px solid #000000 }
*.ee102 { background-color : #001AE0; font-size : 16.00pt; color : #FFFFFF; font-weight : bold; font-family : "verdana", Sans-serif; text-align : center; border-bottom : 2px solid #000000; border-top : 2px solid #000000 }
*.ee101 { background-color : #001AE0; font-size : 11.00pt; border-bottom : 2px solid #000000; font-family : "Arial", Sans-serif }
*.ee100 { background-color : #001AE0; font-size : 11.00pt; font-family : "Arial", Sans-serif; border-top : 2px solid #000000; border-bottom : 2px solid #000000; border-left : 2px solid #000000 }

var co = new Object;

function recalc_onclick(ctl) {
if (document.formc.automatic_recalc.checked || ctl=='') {
co.ResearchRevenue=eeparseFloat(document.formc.ResearchRevenue.value);
//alert ("RR " + document.formc.ResearchRevenue.value)
co.HasSoftwareSolution=eeparseFloatV(document.formc.HasSoftwareSolution[document.formc.HasSoftwareSolution.selectedIndex].value);
//alert ("HSS " + document.formc.HasSoftwareSolution[document.formc.HasSoftwareSolution.selectedIndex].value)
co.ProposalsPerYear=eeparseFloat(document.formc.ProposalsPerYear.value);
//alert ("PPY " + document.formc.ProposalsPerYear.value)
co.ProposalsWonPerYear=eeparseFloat(document.formc.ProposalsWonPerYear.value);
//alert ("PWPY " + document.formc.ProposalsWonPerYear.value)
co.HoursToPrepare=eeparseFloat(document.formc.HoursToPrepare.value);
//alert ("HTP " + document.formc.HoursToPrepare.value)
co.HourlyRate=eeparseFloat(document.formc.HourlyRate.value);
//alert ("HRATE " + document.formc.HourlyRate.value)
calc(co);
document.formc.CaptureRate.value=eedisplayPercentND(co.CaptureRate,0);
document.formc.AvgProposalValue.value='$' +eedisplayFloatNDTh(co.AvgProposalValue,0);
document.formc.ProposalHours.value=eedisplayFloatNDTh(co.ProposalHours,0);
document.formc.ProposalStaff.value=eedisplayFloatNDTh(co.ProposalStaff,1);
document.formc.CostPerProposal.value='$' +eedisplayFloatNDTh(co.CostPerProposal,0);
document.formc.TotalProposalCost.value='$' +eedisplayFloatNDTh(co.TotalProposalCost,0);
document.formc.InSight.value='$' + eedisplayFloatNDTh(co.InSight,0);
document.formc.AdditionalProposals.value=eedisplayFloatNDTh(co.AdditionalProposals,0);
document.formc.AdditionalProposalsPossible.value=eedisplayFloatNDTh(co.AdditionalProposalsPossible,0);
document.formc.AdditionalProposalRevenue.value='$' + eedisplayFloatNDTh(co.AdditionalProposalRevenue,0);

};

};

var eeisus=1;
var eetrue="TRUE";
var eefalse="FALSE";
var eedec=".";
var eeth=",";
var eedecreg=new RegExp("[.]","g");
var eethreg=new RegExp(",","g");

function calc(data){

var fltResearchRevenue=data.ResearchRevenue*1000000;
var fltHasSolftwareSolution=data.HasSoftwareSolution;
var fltProposalsPerYear=data.ProposalsPerYear;
var fltProposalsWonPerYear=data.ProposalsWonPerYear;
var fltHoursToPrepare=data.HoursToPrepare;
var fltHourlyRate=data.HourlyRate;
var fltAvgProposalValue = fltResearchRevenue/fltProposalsWonPerYear;
var fltCaptureRate = (fltResearchRevenue*1000000)/fltProposalsWonPerYear;
var fltProposalHours = fltProposalsPerYear * fltHoursToPrepare;
var fltProposalStaff = (fltProposalHours / 2080) * 1.2;
var fltCostPerProposal=fltHoursToPrepare * fltHourlyRate;
var fltTotalProposalCost=fltHoursToPrepare * fltHourlyRate * fltProposalsPerYear ;
var fltInSight = ((fltResearchRevenue)/(fltProposalsWonPerYear/fltProposalsPerYear))*((fltProposalsWonPerYear/fltProposalsPerYear)*1.01)-fltResearchRevenue;
var fltAdditionalProposals = (fltProposalsPerYear*1.2-fltProposalsPerYear) * fltHasSolftwareSolution;
var fltAdditionalProposalsPossible= (fltAdditionalProposals * (fltProposalsWonPerYear/fltProposalsPerYear));
var fltAdditionalProposalRevenue = fltAdditionalProposalsPossible * fltAvgProposalValue;

//alert( fltProposalsPerYear*1.2-fltProposalsPerYear);

data.CaptureRate=fltProposalsWonPerYear/fltProposalsPerYear;
data.AvgProposalValue= fltAvgProposalValue;
data.ProposalHours = fltProposalHours;
data.ProposalStaff = fltProposalStaff;
data.CostPerProposal = fltCostPerProposal;
data.TotalProposalCost = fltTotalProposalCost;
data.InSight = fltInSight;
data.AdditionalProposals = fltAdditionalProposals;
data.AdditionalProposalsPossible = fltAdditionalProposalsPossible;
data.AdditionalProposalRevenue = fltAdditionalProposalRevenue;

};

function myIsNaN(x){return(isNaN(x)||(typeof x=='number'&&!isFinite(x)));};

function round(n,nd){
if(isFinite(n)&&isFinite(nd)){
var sign_n=(n<0)?-1:1;
var abs_n=Math.abs(n);
var factor=Math.pow(10,nd);
return sign_n*Math.round(abs_n*factor)/factor;
}
else{return NaN;}
};

function s2n(str){
str=String(str).replace(eedecreg,".");
return parseFloat(str);
}

function v2n(v){
switch(typeof v){case "number":return v;
case "string":return s2n(v);
case "boolean":return v?1:0;
case "object":if(v.constructor==Number){return v;};

if(v.constructor==String){return s2n(v);};
if(v.constructor==Boolean){return v?1:0;};
return Number.NaN;
default:return Number.NaN;
}
};

function eeparseFloat(str){
str=String(str).replace(eedecreg,".");
var res=parseFloat(str);
if(isNaN(res)){return 0;}else{return res;}
};

function eeparsePercent(str){
var parts=String(str).split('%');
var tmp=String(parts[0]).replace(eedecreg,".");
var res=parseFloat(tmp)/100;if(isNaN(res)){return 0;}else{return res;}};

function eedisplayFloatND(x,nd){
if(myIsNaN(x)){
return Number.NaN;
}
else{
var res=round(x,nd);
if(nd>0){
var str=String(res);
if(str.indexOf('e')!=-1)return str;
if(str.indexOf('E')!=-1)return str;
var parts=str.split('.');
if(parts.length<2){
var decimals=('00000000000000').substring(0,nd);
return(parts[0]).toString()+eedec+decimals;
}
else{
var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);
return(parts[0]).toString()+eedec+decimals;
}
}
else{
return res;
}
}
};

function eedisplayPercentND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{return eedisplayFloatND(x*100,nd)+'%';}}

function eedisplayDollarND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{return '$' + eedisplayatND(x,nd);}}

function eedisplayFloatNDTh(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var res=round(x,nd);if(nd>0){var str=String(res);if(str.indexOf('e')!=-1)return str;if(str.indexOf('E')!=-1)return str;var parts=str.split('.');var res2=eeinsertThousand(parts[0].toString());if(parts.length<2){var decimals=('00000000000000').substring(0,nd);return(res2+eedec+decimals);}else{var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);return(res2+eedec+decimals);}}else{return(eeinsertThousand(res.toString()));}}};var eeparseFloatVreg=new RegExp("^ *-?[0-9.]+ *$");

function eeparseFloatV(str){if(str=="")return str;str=String(str).replace(eedecreg,".");if(!eeparseFloatVreg.test(str)){return str;};var res=parseFloat(str);if(isNaN(res)){return str;}else{return res;}};

function eeinsertThousand(whole){if(whole==""||whole.indexOf("e")>=0){return whole;}else{var minus_sign="";if(whole.charAt(0)=="-"){minus_sign="-";whole=whole.substring(1);};var res="";var str_length=whole.length-1;for(var ii=0;ii<=str_length;ii++){if(ii>0&&ii%3==0){res=eeth+res;};res=whole.charAt(str_length-ii)+res;};return minus_sign+res;}};

 

ROI-Calculator for Research Solutions

 

 

 

 

 

 

 

Current Research Funding Per Year (in Millions)

 

 

 

 

 

 

 

 

Does Your Institution Own an Integrated Proposal System?

YesNo

 

 

 

How Many Proposals Does Your Institution Submit Per Year?

 

 

 

How Many Grants Does Your Institution Convert Per Year?

 

 

 

Estimated Hours to Prepare a Budget and Proposal For Submission

 

 

 

Approximate Hourly Staff Expense for Proposal Staff

 

 

 

  

 

 

 

 

 

RESULTS

 

 

 

Percentage of Grants Awarded to Proposals Submitted

 

 

 

Average Proposal Value

 

 

 

Total Hours Spent Generating and Submitting Proposals

 

 

 

Minimum Staff Required to Support Proposal Efforts

 

 

 

Average Insitutional Cost Per Proposal Submitted

 

 

 

Total Annual Proposal Cost to Institution

 

 

 

InSight<\/a> Business Intelligence Tool you can focus your proposal efforts in the areas were you are most successful or improve the area that may not be. We feel a 1% improvement is higly conservative')">1% Improvement by using InSight™ (Business Intelligence)  

 

 

 

Number of Additional Proposals Possible to Generate  

 

 

 

Number of Additional Proposals Possible to Convert  

 

 

 

Possible Increases in Proposal Revenue  

 

 

 

 

 

 

 

 

Please send comments and thoughts to info@moderas.org

 

 

 

 

Automatic recalculation 
recalc_onclick('');
The browser does not support JavaScript. The calculations
will not work. Please access the web page using another browser.

var lpMTagConfig = {'lpServer' : "server.iad.liveperson.net",'lpNumber' : "65798960",'lpProtocol' : "http"}; function lpAddMonitorTag(src){if(typeof(src)=='undefined'||typeof(src)=='object'){src=lpMTagConfig.lpMTagSrc?lpMTagConfig.lpMTagSrc:'/hcp/html/mTag.js';}if(src.indexOf('http')!=0){src=lpMTagConfig.lpProtocol+"://"+lpMTagConfig.lpServer+src+'?site='+lpMTagConfig.lpNumber;}else{if(src.indexOf('site=')<0){if(src.indexOf('?')<0)src=src+'?';else src=src+'&';src=src+'site='+lpMTagConfig.lpNumber;}};var s=document.createElement('script');s.setAttribute('type','text/javascript');s.setAttribute('charset','iso-8859-1');s.setAttribute('src',src);document.getElementsByTagName('head').item(0).appendChild(s);} if (window.attachEvent) window.attachEvent('onload',lpAddMonitorTag); else window.addEventListener("load",lpAddMonitorTag,false);
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));

var pageTracker = _gat._getTracker("UA-7604421-1");
pageTracker._setAllowLinker(true)
pageTracker._setDomainName("none")
pageTracker._initData();
pageTracker._trackPageview();