| ATTACHMENT A | ||||||||||||||||||||||
| Cost Summary | ||||||||||||||||||||||
| Winter Control account - 700 504 | ||||||||||||||||||||||
| BUDGET | PURCHASE ORDER | |||||||||||||||||||||
| A | B | C | D=B+C | E=A-D | F | G | H | I=F-G-H | ||||||||||||||
| Account | Description | Budget | Expenditures to date | Accruals/OS invoices to be posted as of Feb 15-08 | Total Expenditures and Accruals | Subtotal Budget Remaining | PO Number | Vendor | PO Amount | Spent to date-Dec. 31/07 | Invoices outstanding on PO | Total PO increase required | ||||||||||
| 700-504-4501 | Construction Tools | 1,964 | 1,927 | 1,927 | 37 | |||||||||||||||||
| 700-504-4520 | Sand | 39,458 | 58,827 | 58,827 | -19,369 | |||||||||||||||||
| 700-504-4543 | Calcium Products | 2,330 | 1,792 | 1,792 | 538 | |||||||||||||||||
| 700-504-5426 | Transit Bus Shelters | 451,275 | 324,559 | 324,559 | 126,716 | |||||||||||||||||
| 700-504-5427 | Regional Road Winter Mtce. | 0 | 23,446 | 23,446 | -23,446 | |||||||||||||||||
| OVER EXPENDITURE REQUESTS FOR PO INCREASES DUE TO WINTER STORMS | ||||||||||||||||||||||
| 700-504-4525 | Townwide S/D of Sodium Chloride | 933,943 | 862,550 | 448,717 | 1,311,267 | -377,324 | B6-48-line 2 | Sifto Canada Inc | 865,800 | 862,550 | 448,717 | -445,466 | ||||||||||
| 700-504-5301 | Roads Winter Maintenance - Rental Grades | 892,043 | 1,031,114 | 106,833 | 1,137,946 | -245,903 | B4-130- line 6 | Curtis Enterprizes 2004 Inc | 95,000 | 91,812 | 27,739 | -24,551 | ||||||||||
| B3-149-line 7 | JAG Construction | 53,000 | 52,242 | 12,307 | -11,549 | |||||||||||||||||
| B3-122-line 7 | D Crupi & Sons Ltd | 58,000 | 56,718 | 18,002 | -16,720 | |||||||||||||||||
| B3-126-line 7 | Vidome Construction Ltd | 135,000 | 130,515 | 36,790 | -32,305 | |||||||||||||||||
| B3-125-line 7 | Pit Haulage Limited | 47,000 | 46,742 | 11,996 | -11,738 | |||||||||||||||||
| Total 700-504-5301 | 892,043 | 1,031,114 | 106,833 | 1,137,946 | -245,903 | 388,000 | 378,029 | 106,834 | -96,863 | |||||||||||||
| 700-504-5302 | Sidewalk Winter Maintenance | 988,280 | 1,199,723 | 200,222 | 1,399,945 | -411,665 | B3-121-line 7 | Nu Con Contracting | 442,700 | 274,179 | 190,623 | -22,102 | ||||||||||
| 700-504-5316 | Winter Mtnce Tandem Axle | 845,920 | 728,115 | 252,855 | 980,970 | -135,050 | B3-120 | D, Crupi | 845,920 | 728,115 | 252,855 | -135,050 | ||||||||||
| 700-504-5407 | Winter Maintenance-Hired loaders as required | 272,952 | 232,498 | 206,421 | 438,919 | -165,967 | B7-45-line 1 | Wilson Contracting | 5,000 | 4,863 | 2,040 | -1,903 | ||||||||||
| B7-40-line1 | Larkin Contruction | 40,000 | 10,966 | 96,238 | -67,204 | |||||||||||||||||
| B7-43-line 1 | Griffith Property Services Ltd | 25,000 | 6,580 | 62,206 | -43,786 | |||||||||||||||||
| B7-41-line 1 | G. Dunlop Construction Ltd | 10,000 | 9,686 | 6,149 | -5,835 | |||||||||||||||||
| B7-42-line 1 | Markham Property Services Ltd | 11,000 | 4,387 | 15,525 | -8,912 | |||||||||||||||||
| B7-44 | JAG Construction | 4,500 | 2,193 | 6,616 | -4,309 | |||||||||||||||||
| Total 700-504-5407 | 272,952 | 232,498 | 206,421 | 438,919 | -165,967 | 95,500 | 38,675 | 188,774 | -131,949 | |||||||||||||
| 700-504-5416 | Snow removal-Markham Main Street and Yonge Street Thornhill | 65,690 | 52,050 | 25,950 | 78,000 | -12,310 | B5-2-line 6 | Nu-Con Construction | 17,500 | 17,400 | 17,400 | -17,300 | ||||||||||
| B7-36-line1 | Wilson Contracting | 10,000 | 8,550 | 8,550 | -7,100 | |||||||||||||||||
| Total 700-504-5416 | 65,690 | 52,050 | 25,950 | 78,000 | -12,310 | 27,500 | 25,950 | 25,950 | -24,400 | |||||||||||||
| TOTAL BALANCE IN WINTER CONTROL ACCOUNT | 4,493,855 | 4,516,601 | 1,240,998 | 5,757,598 | -1,263,743 | 2,665,420 | 2,307,498 | 1,213,752 | -855,830 | |||||||||||||