Cassidy Turley Real Estate Solutions_Belden 9-3

Operational & Financial Reporting

Sample Reports

September Services Summary

WHAT IS INVOLVED IN REPORTING?

RealEstatePortfolio

Value toFee

FinancialPerformance

Value toFee TTM-$2.55:1

Expenses

H/Lvs.

PortfolioBreakdown SquareFootage

0 20 40 60 80

Actual YTD $1,636,253 ($42,884) ($109,801) ($687,545) 2012OPC 2011Actual

September

9,424,422

10,000,000

7,704,712

IdleFacilities

5,000,000

Thousands

1,148,987

Facility

ExpectedExit SeptemberExpenses

0

Retail

Non-Retail

Owned

IdleW-S

3/31/2013 $62,657

Jul-12

Jan-12

Jun-12

Oct-11

Apr-12

Feb-12

Sep-12

Dec-11

Aug-12

Nov-11

Mar-12

May-12

Value

Fee

Retail

Non-Retail

Owned

*Calculatedas cost savingsdividedbymanagement fee

Cost Savings Initiatives

Occupancy&SpacePlanning

Maintenance

Projects

MaintenanceHours %byLocation

TotalOccupancy

Provided setupand support forUnitedWayproduct sale

HQ

90% 77% 89% 65%

Vendor

Location

Description

Savings/Avoidance Amount

23%

HQ,CC,R&D

AssistedwithcoordinationofEmployeeAppreciationCelebration

Satellite 11%

Value to Fee

RealEstateTaxAppeals

$21,789 $21,789 $8,110

Measuring Performance

NY

County

Multiple RETaxappeal

Avoidance

B,M& LA

ProvideA/VsupportandassistedwithBoardMeeting inKansas

Maintenance

R&D Eliminated1mtnceTech@Weeks

PlannedReduction $3,500

$- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000

R&D 18%

77%

Mounted transformer,wiredpumps fordryerexhaustvs.vendor Replacedbrokencableongolf cart for securityvs.vendor Cost savings from installingprojector vs.vendor Replaced sinkdrain in4Abreakroom vs.plumber Rewired receptacle forWellness Centervs.electrician Setupanduseof inhouseA/V equipment forHungerGamesevent Randatacable forsecurity camerasvs. securityvendor

Maintenance

HQ

Avoidance

$155

Assistedwith setupand support forUnitedWayevent

HQ 62%

Occupied Unoccupied

Maintenance

HQ

Avoidance

$30

CallCenter&R&Doffice renovationprojectunderway

CallCenter 5%

OfficePopulation2,079 Therewere9movesduringthemonth

Maintenance

CC

Avoidance

$1,450

BTHVAC installednewpumps /pans for thedryerexhaustduct

Maintenance

HQ

Avoidance

$175

YTDchurn rateof6.96%

Maintenance completed821workorders inSeptember 67%ofworkorders completedwere forHQ Theworkorderclosingratio forSeptember is100%

89%ofSeptembermoveswere internal toHQ

Completed transitionofNYoffices tonewHVACcompany

Maintenance

HQ

Avoidance

$180

Tracking Goals

Avoidance

$1,920

Maintenance

HQ

Security&Safety

Imaging

Mail

Maintenance

R&D

Avoidance

$700

157badges issued thismonth,monthly2012average is129 505badgesmodified thismonth,monthly2012average is886 0 IXO Incidents reported,monthly2012average is54 Fleet Thereare currently363vehicles,1 forkliftand1pieceof

Scanned37,925pages forCustomerService,HumanResources,

Totalpostageusage forHQ&R&Dwas$9,395

InvoiceDisputes

$470

andAccountsPayableduringthemonth

Achieved$494ofsavingsbysendingall firstclassmailpresort Oct-11 Dec-11 Feb-12 Apr-12 Jun-12 Aug-12

Disposal

CC

Disputedcharges

Savings

$70

Caughtbillingerror forcopierpaper order

PaperCo

R&D

Savings

$400

FitnessCenter

Amenities

Value

MgtFee

VendorManagement

$21,338

TheFitnessCenterhad1,285participants for themonth;YTD

InSeptember13%ofemployees atebreakfastand17%ate

Savings forpurchasingand replacing exit signbatteries insteadof landlord Disputed6%price increaseoncontract work

LLD

NY

Savings

$2,600

heavymachinery in theFleet

Avg is1,679

lunchonsiteat the café

Key Performance Indicators Service Level Agreements

SummitFitnessoffered19group fitness classes

OnsiteClothingCarehad110 customers and$2,740 in sales

Fire Safety

HQ

Avoidance

$847

Elevator Janitorial

HQ

Savingsachievedby switchingvendors Savings

$415

•September–$2.83:1 •YTD–$2.69:1

R&D Savingsachievedbyaligning service Savings

$1,698

Value to Fee

Savingsachievedby reducingcarpet cleaning scope Savingsachievedbyeliminating Idle side sweeping Cancelledbi-monthly rug service in favorofutilizingownedmats Monthly savings from switchingcarpet cleaningvendors

Janitorial

HQ

PlannedReduction $539

Janitorial

R&D

PlannedReduction $472

Janitorial

R&D

Savings

$183

Janitorial

HQ

Savings

$2,268

Monthly savings from switching landscapingvendors Monthly savings from switching janitorial vendors

Landscaping

R&D

Savings

$1,990

•SeptemberCostSavings: $52,201 •VendorManagement:$21,338

September Initiatives

Janitorial

R&D

Savings

$2,495

Janitorial

Multiple Cancelled Interiorplants

PlannedReduction $602 PlannedReduction $3,118

Landscaping

HQ

Reduced landscaping scope

ClosedWeeksaccountandaddedML toOS toavoid$5service feeweekly

Uniform

R&D

Avoidance

$20

FoodService FoodService

Multiple Reducedcoffee service scope

PlannedReduction $2,362

18% Year toDate

Multiple Eliminatednapkins

Savings Savings Savings Savings Savings

$394

22%

Security Postage Postage Furniture

HQ

Negotiatedcontract rate

$6

•September Savings -$14,342 •September Avoidance -$27,266 •September PlannedReductions -$10,593 60%

NY -11 Removedunusedpostagemachine NY-7 Utilized smallerpostagemachine Bentonville Negotiatedpricingwithvendor

$162

Benchmarking

$95 $15

Distribution

Cost savings from selectinga less expensive vendor forservice

Rental

HQ

Savings

$1,014

6

Fire Safety

NY

Disputed invoice charges

Savings Savings

$43

MailServices

$494

Financials

2012 September Facilities

000's

H / (L) vs.

H / (L) vs.

H / (L) vs.

YTD Actual

QTD Actual

OPC

2011

Actual

OPC

2011

OPC

2011

NY -34Showroom

90 $ $ 91 $ 57 $

(4) (5) (0)

$

(5) (0) (1) (1) (7)

264 $

$

(23)

$

(37)

803 $

$

(52) (22)

$

(71)

Maintenance

NY-MadisonShowroom Bentonville&Minneapolis

286 171

(0) (2) (0)

12

825 511

23

(1) (7)

(8)

(9)

L.A.Office

8 $

0

25

76

4

14

247 $

$

(9)

$

746 $

$

(25)

$

(33)

2,215 $

$

(78)

$

(42)

SellingFacilities

Work Order Comparison

Top10WorkOrderTypes ThisMonth's

Avg.CompletionTime (Minutes)

HQ DC

801 $

126

74

2,478

300

62

6,841

4

(125) (641)

WorkOrders ThisMonth YTD2012 2011

1,000 1,200 1,400 1,600

$

-

-

(14)

-

-

(90)

-

-

Electrical

33 97 78 71 99 38 42

46

40 24 22 35 24 59 42 44 37 80

36

R&D

167 $

3

1

517

13

12

1,470

(27)

(10)

Events

118

NA

Furniture

37 33 23 88 33 43 39 85

47 48 31 54 48 42

DTCSupport

14 $

14

14

45

45

45

45

45

45

InteriorRepairs&Maint.

0 200 400 600 800

2010 2011 2012

Lighting

MoveManagement

Worldwide Support

40 $

(160)

(156)

187

(440)

(415) (387)

1,441

(455) (433)

(376)

Office Services

1,023 $

$

(17)

$

(81)

3,227 $

$

(83)

$

9,797 $

$

(1,108) $

HBIHQFacilities

PM

113

StorageMoves

54 37

63 $ $

(18)

$

(23)

214 $

$

(47)

$

(42)

$

631

$

(160)

$

(148)

ExitedFacilities

Setup

86

NY -34Design

104 $ 200 $ 304 $

4

(2)

300 626

(6)

(13)

914

(4)

(6)

5 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 4 22 1,845 (11) (15) 63 56 (3) $ 9 $ 2,759 $ $ $ (158) $ (453) $ 15,402 $ (687) $ (1,242) $

NY -MadisonDesign NYDesignFacilities

(3)

3 1

$

1

$

927 $

Work Orders by Location September -821

1,636 $

$

(43)

$

(110)

5,113 $

Sub-totalFacilitiesbeforeallocation

HQ1 38%

NY 19%

R&D 9%

CC 4%

HQ2 29%

12

cassidyturley.com | 9