Okay sorry for the miscommunication. For the projection, I need to know the total expense for the entire year. (See the first account below: $12,808 spent to date + $4,652 remaining
contract = projection $17,460.)
If I take your yellow amounts as additional expenses before 9/30/11, that’s a total of $5,550,632 for Vitruvian and $1,221,458 for Spring Valley to be spent from Fund 49. We only have
$3.8 million remaining for Vitruvian and $206k remaining for Spring Valley.
I am assuming that the overage is to be covered by grant funds. For the Fund 49 accounts, this should only be the expense that will be paid from bond funds. Fund 85 should only be
the expense that will be paid by DISD, and Fund 86 should only be the expenses that will be paid by Dallas County and COG.
Since this is all for the budget, I need the email backup to refer to later, which is why I haven’t called.
Thanks,
Marisa
From: Clay Barnett
Sent: Tuesday, June 07, 2011 10:27 AM
To: Marisa Perry
Cc: Nancy Cline; Alison Ream
Subject: RE: Fund 49 - FY11 Projection and FY12 Budget
Marisa,
I assumed that you would add what had already been spent to the amount that I gave. Call me if I am making absolutely no sense.
Thanks,
Clay Barnett, P.E.
Town Engineer
Town of Addison
16801 Westgrove Drive
Addison, TX 75001-2818
Office: (972) 450-2857
From: Marisa Perry
Sent: Tuesday, June 07, 2011 10:25 AM
To: Clay Barnett
Cc: Nancy Cline; Alison Ream
Subject: RE: Fund 49 - FY11 Projection and FY12 Budget
Clay,
Some of your projections are less than what has already been spent this year. Does that mean that some of the expenses already recorded will be moved from Fund 49?
Thanks,
Marisa
From: Clay Barnett
Sent: Tuesday, June 07, 2011 9:55 AM
To: Marisa Perry
Cc: Nancy Cline; Alison Ream
Subject: RE: Fund 49 - FY11 Projection and FY12 Budget
Marisa,
I filled out as many blanks below as I could. I do not have a copy of the Shackelford contract, so I have no knowledge of how the payments will be structured for FY12. Alison or Nancy
can provide you with the DISD reimbursement information.
If you need any additional information, please let me know.
Thanks,
Clay Barnett, P.E.
Town Engineer
Town of Addison
16801 Westgrove Drive
Addison, TX 75001-2818
Office: (972) 450-2857
From: Marisa Perry
Sent: Wednesday, June 01, 2011 12:45 PM
To: Nancy Cline; Clay Barnett; Alison Ream
Subject: Fund 49 - FY11 Projection and FY12 Budget
Nancy, Clay, and Alison,
The current balance of Fund 49 as of last week’s check run was $7,299,999.25 consisting of:
Cash 7,946,452.35
Retainage Payable – Spring Valley (59,240.33)
Retainage Payable – Vitruvian (587,212.77)
Fund 49 Balance 7,299,999.25
Below are the expenditures to date. Please provide your projected total expense for the year as well as the budget for next year. I also need to know the amount of expenses that will
be moved from this fund to the grant funds to be covered by grant monies. For instance, if $1 million of expenses in 49-000-58210-83100 will be covered by Dallas County and we expect
to spend $500,000 of our own money before 9/30, the total projection should be $3,363,939.
Thanks!
Marisa Perry, CPA
Financial Services Manager
Town of Addison
(972) 450-7064
FY11 Budget
YTD 5/27/11
FY11 Projection
Comments
FY12 Budget
49-000-56040-03300
SPECIAL SERVICES - SPRING VALLEY
0
12,808.21
17,460
$4,652 Shackelford contract
?
49-000-56040-83100
SPECIAL SERVICES - VITRUVIAN
0
317,265.79
326,361
UDR & Dallas Morning News
47,886
49-000-56510-03300
AUDIT AND LEGAL - SPRING VALLEY
0
4,313.26
7,310
Avg $600/month May-Sept
0
49-000-56510-83100
AUDIT AND LEGAL - VITRUVIAN
0
4,186.00
7,190
Avg $600/month May-Sept
0
49-000-56570-03300
ENGINEERING/ARCHITECTURAL SVCS
0
37,985.45
48,540
$1,870 Halff, $8,680 Terracon
0
49-000-56570-83100
ENGINEERING/ARCHITECTURAL SVCS
0
464,342.31
410,300
Icon, Halff, HNTB, UDR, TBG, Kleinfelder
59,925
49-000-58110-03300
LAND PURCHASE - SPRING VALLEY
0
448,976.00
448,976
Projecting at YTD
0
49-000-58150-03300
LAND BETTERMENTS – SPRING VALLEY
0
1,250.00
1,250
Projecting at YTD
0
49-000-58150-83100
LAND BETTERMENTS - VITRUVIAN
9,000,000
2,780,048.32
3,097,973
NTC, UDR, Oncor
458,000
49-000-58210-03300
STREETS AND ALLEYS – SPRING VALLEY
600,000
1,185,131.58
1,221,458
NTC
0
49-000-58210-83100
STREETS AND ALLEYS - VITRUVIAN
2,500,000
3,863,939.28
1,715,998
NTC, AB&R, CPS
140,573
85-000-58210-03300
STREETS AND ALLEYS – SPRING VALLEY
?
Amt paid by DISD
?
86-000-58150-83100
LAND BETTERMENTS - VITRUVIAN
1,370,000
Amt paid by Dallas County & COG
0
86-000-58210-03300
STREETS AND ALLEYS – SPRING VALLEY
700,000
Amt paid by Dallas County & COG
0