cassidyturley.com | 9
Operational & Financial Reporting
RealEstatePortfolio
Value toFee
FinancialPerformance
Expenses
H/Lvs.
September
Actual
2012OPC
2011Actual
YTD
$1,636,253 ($42,884) ($109,801) ($687,545)
IdleFacilities
Facility
ExpectedExit SeptemberExpenses
IdleW-S
3/31/2013 $62,657
*Calculatedas cost savingsdividedbymanagement fee
Occupancy&SpacePlanning
Maintenance
Projects
Provided setupand support forUnitedWayproduct sale
HQ
90%
HQ,CC,R&D
77%
AssistedwithcoordinationofEmployeeAppreciationCelebration
NY
89%
B,M& LA
65%
ProvideA/VsupportandassistedwithBoardMeeting inKansas
Assistedwith setupand support forUnitedWayevent
CallCenter&R&Doffice renovationprojectunderway
OfficePopulation2,079
Therewere9movesduringthemonth
BTHVAC installednewpumps /pans for thedryerexhaustduct
YTDchurn rateof6.96%
Maintenance completed821workorders inSeptember
89%ofSeptembermoveswere internal toHQ
67%ofworkorders completedwere forHQ
Completed transitionofNYoffices tonewHVACcompany
Theworkorderclosingratio forSeptember is100%
Security&Safety
Imaging
Mail
157badges issued thismonth,monthly2012average is129
Scanned37,925pages forCustomerService,HumanResources,
Totalpostageusage forHQ&R&Dwas$9,395
505badgesmodified thismonth,monthly2012average is886
andAccountsPayableduringthemonth
Achieved$494ofsavingsbysendingall firstclassmailpresort
0 IXO Incidents reported,monthly2012average is54
Fleet
FitnessCenter
Amenities
Thereare currently363vehicles,1 forkliftand1pieceof
TheFitnessCenterhad1,285participants for themonth;YTD
InSeptember13%ofemployees atebreakfastand17%ate
heavymachinery in theFleet
Avg is1,679
lunchonsiteat the café
SummitFitnessoffered19group fitness classes
OnsiteClothingCarehad110 customers and$2,740 in sales
HQ
62%
CallCenter
5%
R&D
18%
Satellite
11%
MaintenanceHours
%byLocation
77%
23%
TotalOccupancy
Occupied Unoccupied
1,148,987
9,424,422
7,704,712
0
5,000,000
10,000,000
Retail
Non-Retail
Owned
PortfolioBreakdown
SquareFootage
Retail
Non-Retail
Owned
0
20
40
60
80
Oct-11
Nov-11
Dec-11
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Thousands
Value toFee
TTM-$2.55:1
Value
Fee
September Services Summary
5
Financials
2012 September
Facilities
Actual
OPC
2011
QTD
Actual
OPC
2011
YTD
Actual
OPC
2011
NY -34Showroom
90 $
(4)
$
(5)
$
264 $
(23)
$
(37)
$
803 $
(52)
$
(71)
$
NY-MadisonShowroom
91 $
(5)
(0)
286
(0)
12
825
(22)
23
Bentonville&Minneapolis
57 $
(0)
(1)
171
(2)
(1)
511
(8)
(9)
L.A.Office
8 $
0
(1)
25
(0)
(7)
76
4
14
SellingFacilities
247 $
(9)
$
(7)
$
746 $
(25)
$
(33)
$
2,215
$
(78)
$
(42)
$
HQ
801 $
126
74
2,478
300
62
6,841
4
(125)
DC
-
$
-
(14)
-
-
(90)
-
-
(641)
R&D
167 $
3
1
517
13
12
1,470
(27)
(10)
DTCSupport
14 $
14
14
45
45
45
45
45
45
Worldwide Support
40 $
(160)
(156)
187
(440)
(415)
1,441
(455)
(376)
HBIHQFacilities
1,023 $
(17)
$
(81)
$
3,227 $
(83)
$
(387)
$
9,797
$
(433)
$
(1,108)
$
ExitedFacilities
63 $
(18)
$
(23)
$
214 $
(47)
$
(42)
$
631
$
(160)
$
(148)
$
NY -34Design
104 $
4
(2)
300
(6)
(13)
914
(4)
(6)
NY -MadisonDesign
200 $
(3)
3
626
4
22
1,845
(11)
63
NYDesignFacilities
304 $
1
$
1
$
927 $
(3)
$
9
$
2,759
$
(15)
$
56
$
Sub-totalFacilitiesbeforeallocation
1,636 $
(43)
$
(110)
$
5,113 $
(158)
$
(453)
$
15,402
$
(687)
$
(1,242)
$
H / (L) vs.
H / (L) vs.
000's
H / (L) vs.
0
200
400
600
800
1,000
1,200
1,400
1,600
Work Order Comparison
2010
2011
2012
HQ1
38%
HQ2
29%
CC
4%
R&D
9%
NY
19%
Work Orders by Location
September -821
12
Location
•67%ofworkorderswerecompletedatHQ
•19%were completed inNY
Type
•21%ofworkordersweremoveor furniture related
•114preventativemaintenanceworkorderswerecompleted thismonth;PM
closing ratio100%
•41%ofNYworkorderswere formovesor furniture
Reported
•65%ofworkorderswere reportedby facility services
•The closing ratio forSeptemberwas100%
Productivity
•Maintenancecompleted821workordersduring September
•Themaintenance teamcompletedanaverageof
41
workordersperday
which isapproximately8per techeachday
Maintenance
Top10WorkOrderTypes
ThisMonth's
WorkOrders
ThisMonth YTD2012 2011
Electrical
33
46
40
36
Events
97
118
24
NA
Furniture
78
37
22
47
InteriorRepairs&Maint.
71
33
35
48
Lighting
99
23
24
31
MoveManagement
38
88
59
54
Office Services
42
33
42
48
PM
113
43
44
42
StorageMoves
54
39
37
Setup
37
85
80
86
Avg.CompletionTime (Minutes)
Benchmarking
Measuring Performance
Key Performance Indicators
Service Level Agreements
$-
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
$70,000
Oct-11 Dec-11 Feb-12 Apr-12 Jun-12 Aug-12
Value to Fee
Value
MgtFee
•September–$2.83:1
•YTD–$2.69:1
Value to
Fee
•SeptemberCostSavings: $52,201
•VendorManagement:$21,338
September
Initiatives
•September
Savings
-$14,342
•September
Avoidance
-$27,266
•September
PlannedReductions
-$10,593
Distribution
6
22%
60%
18%
Year toDate
Cost Savings Initiatives
Vendor
Location
Description
Savings/Avoidance Amount
RealEstateTaxAppeals
$21,789
County
Multiple RETaxappeal
Avoidance
$21,789
Maintenance
$8,110
R&D Eliminated1mtnceTech@Weeks
PlannedReduction $3,500
Maintenance
HQ
Mounted transformer,wiredpumps
fordryerexhaustvs.vendor
Avoidance
$155
Maintenance
HQ
Replacedbrokencableongolf cart for
securityvs.vendor
Avoidance
$30
Maintenance
CC
Cost savings from installingprojector
vs.vendor
Avoidance
$1,450
Maintenance
HQ
Replaced sinkdrain in4Abreakroom
vs.plumber
Avoidance
$175
Maintenance
HQ
Rewired receptacle forWellness
Centervs.electrician
Avoidance
$180
Maintenance
HQ
Setupanduseof inhouseA/V
equipment forHungerGamesevent
Avoidance
$1,920
Maintenance
R&D
Randatacable forsecurity camerasvs.
securityvendor
Avoidance
$700
InvoiceDisputes
$470
Disposal
CC
Disputedcharges
Savings
$70
PaperCo
R&D
Caughtbillingerror forcopierpaper
order
Savings
$400
VendorManagement
$21,338
LLD
NY
Savings forpurchasingand replacing
exit signbatteries insteadof landlord
Savings
$2,600
Fire Safety
HQ
Disputed6%price increaseoncontract
work
Avoidance
$847
Elevator
HQ
Savingsachievedby switchingvendors Savings
$415
Janitorial
R&D Savingsachievedbyaligning service Savings
$1,698
Janitorial
HQ
Savingsachievedby reducingcarpet
cleaning scope
PlannedReduction $539
Janitorial
R&D
Savingsachievedbyeliminating Idle
side sweeping
PlannedReduction $472
Janitorial
R&D
Cancelledbi-monthly rug service in
favorofutilizingownedmats
Savings
$183
Janitorial
HQ
Monthly savings from switchingcarpet
cleaningvendors
Savings
$2,268
Landscaping
R&D
Monthly savings from switching
landscapingvendors
Savings
$1,990
Janitorial
R&D
Monthly savings from switching
janitorial vendors
Savings
$2,495
Janitorial
Multiple Cancelled Interiorplants
PlannedReduction $602
Landscaping
HQ
Reduced landscaping scope
PlannedReduction $3,118
Uniform
R&D
ClosedWeeksaccountandaddedML
toOS toavoid$5service feeweekly
Avoidance
$20
FoodService
Multiple Reducedcoffee service scope
PlannedReduction $2,362
FoodService
Multiple Eliminatednapkins
Savings
$394
Security
HQ
Negotiatedcontract rate
Savings
$6
Postage
NY -11 Removedunusedpostagemachine
Savings
$162
Postage
NY-7 Utilized smallerpostagemachine
Savings
$95
Furniture
Bentonville Negotiatedpricingwithvendor
Savings
$15
Rental
HQ
Cost savings from selectinga less
expensive vendor forservice
Savings
$1,014
Fire Safety
NY
Disputed invoice charges
Savings
$43
MailServices
Savings
$494
Tracking Goals
WHAT IS INVOLVED
IN REPORTING?
Sample Reports