Invoice Tracking - Heart Disease & Stroke Prevention Program
FY '11 State Fiscal Year: 7/1/10 - 6/30/11 HDSP - 4531 HL H3221 01 Budget Period: 7/1/10 - 6/29/11
Award/Remai Cumulative Balance
Consultants/Contractors PSA# ning Amt Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May June Total Available
Blue Cross Blue Shield PF09-165A 47,445.86 14,746.50 4,780.00 11,475.50 16,431.38 47,433.38 12.48
Cameo Communications PF09-189 10,000 450.00 1,000.00 350.00 700.00 400.00 550.00 1,950.00 1,250.00 1,150.00 1,050.00 1,150.00 10,000.00 0.00
Consensus Council Inc PF09-220 18,650 2,765.84 1,470.42 1,518.75 1,504.35 7,259.36 11,390.64
KAT Communications PF09-242 5,000 5,000.00 5,000.00 0.00
Crawford Consulting PF09-263 1,800 110.00 646.25 522.50 1,278.75 521.25
Go Red Community Action Grants:
Cavalier County Health District G09-1072 4,000.00 3,146.79 3,146.79 853.21
Central Valley Health District G09-1073 3,000.00 2,958.09 2,958.09 41.91
Lake Region District Health District G09-1074 3,950.00 2,866.23 2,866.23 1,083.77
Ransom County Public Health Dept G09-1075 1,700.00 0.00 1,700.00
Sanford Mayville G09-1076 800.00 Will not be submitting an RFR --7/14/11 0.00 800.00
Sargent County District Health Unit G09-1077 3,000.00 1,151.23 982.32 2,133.55 866.45
Upper Missouri District Health Unit G09-1078 4,000.00 2,128.54 1,318.37 543.15 3,990.06 9.94
West River Health Services G09-1079 1,500.00 216.00 216.00 1,284.00
YPHHP/Mercy Hospital G09-1080 4,000.00 4,000.00 4,000.00 0.00
STEMI ID Web-based Course:
Medcenter One - Amendment G09-636A 1,500.00 1,483.65 1,483.65 16.35
G09-640A
Sandford Health/MeritCare Hosp-Fgo - Amendment 1,500.00 1,373.75 1,373.75 126.25
Work Order Request-HDSP Website Redesign:
Agency MABU 301-11-01 7,500.00 537.66 871.38 2,836.62 4,245.66 3,254.34
Total 119,346
Diabetes Grant Tracking:
Cumulative Balance
Consultants/Contractors PSA# Award Amt Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May June Total Available
Blue Cross Blue Shield PF09-165A 36,500 $9,125.00 $4,915.50 $14,340.00 $8,119.50 $36,500.00 0.00
BCBS contract for FY '12 - HDSP & Diabetes contracts will be separate - as per Susan 11/4/10
Distribution: Copy to Susan at update meetings. At end of grant year, print weekly.
12/3/2011
H:\HDSP\01Accounting\Invoice Tracking\634f6fb6-6a9e-4689-b5a7-073ada5cd5ea.xlsx
Now Complete
for FY 11 Vendor #
x 663 DIABETES
x 7339-MAIN
x 7227
x 93430
x 19440
4826
4504 - ALL
14549
1667 Public Hea
2948
15876
4937
6357
586
1358
583
Vendor #
663 DIABETES
12/3/2011
H:\HDSP\01Accounting\Invoice Tracking\634f6fb6-6a9e-4689-b5a7-073ada5cd5ea.xlsx
Invoice Tracking - Heart Disease & Stroke Prevention Program
FY '11 State Fiscal Year: 7/1/10 - 6/30/11 Special Funds - 4531 HL H12280 01 Budget Period: 7/1/09 - 6/30/11
Award Begin-ning Cumulative Balance
Consultants/Contractors PSA# Amt Balance Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May June Total Available
Altru Hospital G09-618 16,450 11,990.00 3,595.00 2,326.59 5,921.59 6,068.41
Ashley Medical Center G09-619 3,000 3,000.00 598.00 998.40 202.46 250.00 2,048.86 951.14
Carrington Health Center G09-620 3,000 3,000.00 640.00 640.00 2,360.00
Cavalier County Memorial Hospital
G09-621 3,000 3,000.00 945.00 100.00 1,045.00 1,955.00
Community Memorial Hosp-Turtle Lake
G09-623 3,000 3,000.00 745.00 185.06 930.06 2,069.94
First Care Center, Park River
G09-625 3,000 3,000.00 970.00 970.00 2,030.00
Garrison Memorial Hospital G09-626 3,000 3,000.00 869.00 125.00 217.46 1,211.46 1,788.54
Heart of America Med Ctr-Rugby
G09-627 3,000 3,000.00 2,038.36 2,038.36 961.64
Hillsboro Medical Ctr Hosp G09-628 3,000 3,000.00 100.00 720.00 820.00 2,180.00
Innovis/Essentia Health, Fargo
G09-629 15,450 13,657.00 750.00 5,795.00 7,112.00 13,657.00 0.00
Jacobson Memorial Hosp Care Ctr-Elgin
G09-630 3,000 3,000.00 1,141.00 1,141.00 1,859.00
Jamestown Hospital G09-631 3,000 3,000.00 1,536.10 1,536.10 1,463.90
McKenzie County Healthcare Systems Hosp-Watford City
G09-635 3,000 3,000.00 820.00 49.83 383.16 163.60 1,416.59 1,583.41
Medcenter One, Bismarck G09-636 16,450 7,533.00 7,533.00 7,533.00 0.00
Mercy Hospital, Valley City G09-638 3,000 1,337.00 50.00 720.00 567.00 1,337.00 0.00
Mercy Hospital, Valley City G09-638A 700 700.00 697.73 697.73 2.27
Nelson County Health System-McVille
G09-642 3,000 3,000.00 1,212.52 1,212.52 1,787.48
Northwood Deaconess Health Ctr
G09-643 3,000 3,000.00 100.00 745.00 75.00 920.00 2,080.00
Oakes Community Hospital G09-644 3,000 3,000.00 2,647.92 2,647.92 352.08
Presentation Medical Ctr-Rolla
G09-646 3,000 3,000.00 1,020.00 1,175.00 150.00 2,345.00 655.00
Sakakawea Medical Ctr-Hazen
G09-647 3,000 3,000.00 1,453.50 189.96 25.00 1,668.46 1,331.54
Sanford Health/MeritCare Hospital, Fargo 14,700
G09-640 10,212.00 750.00 3,962.00 2,271.00 2,359.75 9,342.75 869.25
Union Hospital, Mayville G09-657 3,000 2,423.00 200.00 554.00 375.00 1,129.00 1,294.00
Southwest Healthcare Services-Bowman
G09-648 3,000 3,000.00 0.00 3,000.00
St. Alexius Medical Ctr, Bis G09-649 14,700 11,712.00 10,114.11 10,114.11 1,597.89
St. Aloisius Medical Ctr-Harvey
G09-650 3,000 3,000.00 920.00 713.60 1,633.60 1,366.40
St. Andrew's Health Ctr, Bottineau
G09-651 3,000 3,000.00 1,587.84 1,587.84 1,412.16
Tioga Medical Center G09-654 3,000 3,000.00 934.26 934.26 2,065.74
Towner County Medical Ctr-Cando
G09-655 3,000 3,000.00 1,905.00 1,905.00 1,095.00
Trinity Hospitals, Minot G09-656 15,450 12,711.00 8,887.44 8,887.44 3,823.56
Hospital
Trinity Kenmare CommunityG09-632 3,000 3,000.00 1,315.92 1,315.92 1,684.08
West River Health Services-Hettinger
G09-658 3,000 3,000.00 149.00 325.00 720.00 612.44 443.56 2,250.00 750.00
Wishek Community Hospital 09-659
G 3,000 3,000.00 1,114.38 1,114.38 1,885.62
SUBTOTAL 171,900
UND G09-786 160,000 163,972.37 3,972.37 2,655.82 26,057.24 15,252.23 15,091.37 13,018.96 7,999.98 7,730.30 8,854.07 8,762.58 9,559.16 28,770.82 147,724.90 16,247.47
KAT Communications PF09-304 23,900 23,900.00 7,967.00 7,967.00 7,966.00 23,900.00 0.00
KAT Communications-Amendment
PF09-242A 36,833 36,833.00 36,833.00 36,833.00 0.00
Newmann Signs PF09-318 20,000 20,000.00 10,000 10,000 20,000.00 0.00
Total: 412,633 Total: 68,570.52
Distribution: Copy to Susan at update meetings. At end of grant year, print weekly.
C:\Docstoc\Working\pdf\634f6fb6-6a9e-4689-b5a7-073ada5cd5ea.xlsx
Vendor
#
4027
8670
8064
9497
9604
32558
4206
1147 Remit
8768
96770
29013
1207
8820
1358
586
586
32782
11244
10780
1641
email to KH
583
2948
11421
1917
9023
8880
2036
8890
6546
12396
6357
9039
383-Remit-GM
93430
93430
C:\Docstoc\Working\pdf\634f6fb6-6a9e-4689-b5a7-073ada5cd5ea.xlsx