XLS ROI example

One time suppliesCostQuantityTotalTags=B5*C5Cover labels=B6*C6AV tags=B7*C7AV boxes (some systems only)=B8*C8Other Other Other Total=SUM(D5:D11)One time labor costs for taggingCost/hrHoursTotalRegular staff (if included)=B17*C17Additional, paid personnel =B18*C18Training staff or patrons=B19*C19OtherTotal=SUM(D17:D20)One time equipment installationEquipment costsCostQuantityTotalSecurity gates=$B27*$C27Staff check stations=$B28*$C28Self-check stations=$B29*$C29Portable scanners=$B30*$C30Programming stations=$B31*$C31Sorting equipment=$B32*$C32Other=$B33*$C33Other=$B34*$C34Total0Costs - Ongoing CostsMaintenance CostsYear 1Year 2Year 3Year 4Year 5TotalMaint contract by year (when known)=SUM(B41:F41)Maintenance contract Year 1=B42Previous Maintenance Contract (recent year)=B43Supply costs (1 year)CostQuantityTotalTags=SUM($B47*$C47)Cover labels=SUM($B48*$C48)AV tags=SUM($B49*$C49)AV boxes=SUM($B50*$C50)Other=SUM($B51*$C51)Other=SUM($B52*$C52)Total=SUM(D47:D52)Percentage increase in acquisitions per year3(Default is 3%)Previous system supply costsCostsQuantityTotalUse same quantities as current system costsTattle tape=SUM($B61*$C61)Barcodes=SUM($B62*$C62)AV tattle tape=SUM($B63*$C63)Lock boxes, etc (some systems only)=SUM($B64*$C64)Other=SUM($B65*$C65)Other=SUM($B66*$C66)Total=SUM(D61:D66)Labor CostsCost/item# ItemsTotalNew system=SUM($B71*$C71)Previous System=C71=SUM($B72*$C72) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download