2019.01.03 Pathology.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 2019.01.03 Pathology.xlsx as PDF for free.
More details
- Words: 1,233
- Pages: 22
Pathology Detail Paid Sr. No. Service Provider
1 2
IDC NSML
Total
No. of Hospital
Total Invoice
No. of Invoices
3 6
29 20
29 20
9
49
49
Amount ### ###
267,270,098
Finance No. of Invoices
Amount withheld
Amount
0 0
-
0
-
NSML Due
30,349,037
30,349,037
Pending Liability IDC NSML IDC NSML
Pending till November Pending till November December till May December till May
Total Pending Liability
30,349,037 109,122,000 262,287,053
401,758,090
18,187,000 34,085,000
48,529,263
Hospital No. of Invoices
Operations No. of Invoices
Amount
Outsourcing No. of Invoices
Amount
Amount
0 0
-
0 0
-
0 0
-
0
-
0
-
0
-
0 0
Pathology Financial Forecasting Sr. No. Hospital Name SP Amount Held 1 Chakwal IDC 2 Attock IDC 3 Jehlum IDC IDC Sub Total 1 Layyah NSML 22,977,233 2 Vehari NSML 7,371,804 3 Mianwali NSML 4 Bahawalnagar NSML 5 Khushab NSML 6 Bhakkar NSML NSML Sub Total 30,349,037
Total
30,349,037
December 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 34,085,000
January 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 34,085,000
February 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
March 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
April 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
52,272,000
52,272,000
66,716,263
66,716,263
66,716,263
May 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
Total
30,600,000 34,338,000 44,184,000 109,122,000 66,000,000 40,458,000 56,052,000 42,000,000 17,044,124 40,732,929 262,287,053
66,716,263
371,409,053
Pathology Lab Sr. No
Sr. Mon
Name of Hospital
Service Provider
8
1
Chakwal
IDC
9
1
Chakwal
IDC
10
1
Chakwal
IDC
11 12
1 2
Chakwal Attock
IDC IDC
13 14 15 16
1 2 3 4
Chakwal Attock Jehlum Layyah
IDC IDC IDC NSML
17 18 19 20 21
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
22 23 24 25 26
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
27 28 29
1 2 3
Chakwal Attock Jehlum
IDC IDC IDC
Deployment Date
December, 2017 Dec-17 Total December, 2017 Jan-18 Total December, 2017 Feb-18 Total December, 2017 28 March, 2018 Mar-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 Apr-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 May-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 Jun-18 Total December, 2017 28 March, 2018 25 April, 2018
Month
Finance
Status
Dec-17
Paid
Jan-18
Paid
Feb-18
Paid
Mar-18 Mar-18
Finance 18.05.18
Paid Paid
Apr-18 Apr-18 Apr-18 Apr-18
Finance 25.05.18 Finance 25.05.18 Finance 21.06.18 Finance 20.05.18
Paid Paid Paid Paid
May-18 May-18 May-18 May-18 May-18
Finance25.06.18 Finance25.06.18 Finance 19.07.18 Finance25.06.18 Finance25.06.18 Sent bac
Paid Paid Paid Paid Paid
Jun-18 Jun-18 Jun-18 Jun-18 Jun-18
20.08.18 17.8.18 3.8.18 1.08.18 3.8.18, finance 10.12.18, f
Paid Paid paid Paid Paid
Jul-18 Jul-18 Jul-18
Finance 20.08.18 Finance 20.08.18 Finance 14.09.18, sent ba
Paid Paid Paid
30 31
4 5
Layyah Vehari
NSML NSML
32 33 34 35 36
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
37 38 39 40 41 42
1 2 3 4 5 6
Chakwal Attock Jehlum Layyah Vehari Mianwali
IDC IDC IDC NSML NSML NSML
43 44 45 46 47 48 49
1 2 3 4 5 6 7
Chakwal Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC IDC NSML NSML NSML NSML
50 51 52 53 54 55 56
1 2 3 4 5 6 7
Chakwal Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC IDC NSML NSML NSML NSML
57
1
Chakwal
IDC
09 April, 2018 23 May, 2018 Jul-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 Aug-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 Sep-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Oct-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Nov-18 Total December, 2017
Jul-18 Jul-18
Finance 28.09.18 Finance 28.09.18
Paid Paid
Aug-18 Aug-18 Aug-18 Aug-18 Aug-18
Finance 14.09.18 sent to us Finance 14.09.18 sent to us Sent to ops wing, finance 2 Finance 28.09.18 Finance 28.09.18
Paid Paid Paid Paid Paid
Sep-18 Sep-18 Sep-18 Sep-18 Sep-18 Sep-18
Finance 30.10.18, 05.12.18 Finance 23.10.18, send aga Finance 07.12.18 Finance 26.10.18 Finance 14.11.18, SENT TO Finance 07.12.18
Paid Paid Paid paid Paid Paid
Oct-18 Oct-18 Oct-18 Oct-18 Oct-18 Oct-18 Oct-18
Finance 07.12.18 Finance 11.12.18 Finance 17.12.18 Finance 07.12.18 Finance 11.12.18 Finance 18.12.18 Finance 07.12.18
Paid Paid Paid Paid Paid Paid Paid
Nov-18 Nov-18 Nov-18 Nov-18 Nov-18 Nov-18 Nov-18
Finance 24.12.18 Finance 21.12.18 Finance 21.12.18 Finance 24.12.18 Finance 21.12.18 Finance 24.12.18 Finance 17.12.18
Paid Paid Paid Paid Paid Paid Paid
Dec-18
58 59 60 61 62 63
2 3 4 5 6 7
Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC NSML NSML NSML NSML
28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Dec-18 Total
Dec-18 Dec-18 Dec-18 Dec-18 Dec-18 Dec-18
Grand Total Paid Finance Hospital Ops OS Total
49 49
Ch ### Ch Ch
86,400,000 Ch Ch Ch Ch
Ch
Annual actual 56,771,520 66,000,000 86,400,000 ### 83,482,752 ### 93,828,996
657 73
0 0 0
0
0
0
0
0
0
0
0
0
0
0
Pathology Lab Sr. No
Sr. Mon
1 2 3 4 5 6 7
1 2 3 4 5 6 7
Name of Hospital
Service Provider
Chakwal IDC Attock IDC Jehlum IDC Layyah NSML Vehari NSML Mianwali NSML BahawalnagarNSML
Deployment Date December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018
Month Infra Invoice - Paid Infra Invoice - hospital 5.11.18 Infra Invoice - hospital 5.11.18 Infra Invoice - At OS Infra Invoice - At Hospital With Vendor With Vendor
CONTRACT AMOUNTS OF 24x7 PATHOLOGY SERVICES Sr. No 1 2 3 4
Hospitals Amount per Anum Firms 184,665,481 Vehari & Bahawalnagar North Shore 189,292,596 Layyah & Bhakkar 167,777,271 Khusab & Mianwali IDC 140,562,520 Jhelum, Attock & Chakwal TOTAL AVERAGE REMAINING HOSPITALS
Date of Contract 18th December, 2017 18th December, 2017 18th December, 2017 15th September, 2017 682,297,868 48,735,562 536,091,182 1,218,389,050.00
Month
Paid 2,094,327 2,094,327 1,800,000 4,956,414 2,997,807 4,097,041 3,819,085 3,869,690 4,350,068
Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Total
30,078,758
IDC Paid IDC Pending at Finance
70,995,767 0
NSML Paid NSML Invoice Generated NSML Withheld + Penalty for NSML Pending at hospital
57,778,167 88,127,204 30,349,037 7,901,133
Chakwal Finance
Jehlum OS
Hospital
Paid
142,963 4,565,509 3,032,946 6,293,996 6,221,882
-
-
-
20,257,296
Jehlum Finance OS
Hospital
Paid
Attock Finance OS
Layyah Hospital
52,725 3,220,024 4,317,454 3,856,198 4,824,567 4,388,745
-
-
-
20,659,713
Paid
6,955,390 6,467,089 7,942,177 7,797,193 7,395,819 8,565,095
-
-
-
45,122,763
Invoice Generated
Layyah Withheld
7,560,207 15,846,087 10,653,512 11,176,799 10,568,328 12,295,063
604,817 9,378,998 2,711,335 3,379,606 3,172,509 3,729,968
68,099,996
22,977,233
Vehari Finance
-
OS
Hospital
-
30,349,037 22977233 7371804
-
Paid
Invoice Generated
2,185,920 2,155,386 4,237,128 4,076,970
2,432,794 5,759,508 5,762,531 6,072,375
12,655,404
20,027,208
Vehari Withheld
Finance
OS
Hospital
Mianwali Withhold Finance
Paid
Bahaw OS
Hospital
Paid
246,874 3,604,122 1,525,403 1,995,405 7,901,133 7,371,804
-
-
7,901,133
-
-
-
-
-
-
Bahawalnagar Withhold Finance OS
-
-
Hospital
-
-
1 2
IDC NSML
Total
No. of Hospital
Total Invoice
No. of Invoices
3 6
29 20
29 20
9
49
49
Amount ### ###
267,270,098
Finance No. of Invoices
Amount withheld
Amount
0 0
-
0
-
NSML Due
30,349,037
30,349,037
Pending Liability IDC NSML IDC NSML
Pending till November Pending till November December till May December till May
Total Pending Liability
30,349,037 109,122,000 262,287,053
401,758,090
18,187,000 34,085,000
48,529,263
Hospital No. of Invoices
Operations No. of Invoices
Amount
Outsourcing No. of Invoices
Amount
Amount
0 0
-
0 0
-
0 0
-
0
-
0
-
0
-
0 0
Pathology Financial Forecasting Sr. No. Hospital Name SP Amount Held 1 Chakwal IDC 2 Attock IDC 3 Jehlum IDC IDC Sub Total 1 Layyah NSML 22,977,233 2 Vehari NSML 7,371,804 3 Mianwali NSML 4 Bahawalnagar NSML 5 Khushab NSML 6 Bhakkar NSML NSML Sub Total 30,349,037
Total
30,349,037
December 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 34,085,000
January 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 34,085,000
February 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
March 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
April 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
52,272,000
52,272,000
66,716,263
66,716,263
66,716,263
May 5,100,000 5,723,000 7,364,000 18,187,000 11,000,000 6,743,000 9,342,000 7,000,000 4,261,031 10,183,232 48,529,263
Total
30,600,000 34,338,000 44,184,000 109,122,000 66,000,000 40,458,000 56,052,000 42,000,000 17,044,124 40,732,929 262,287,053
66,716,263
371,409,053
Pathology Lab Sr. No
Sr. Mon
Name of Hospital
Service Provider
8
1
Chakwal
IDC
9
1
Chakwal
IDC
10
1
Chakwal
IDC
11 12
1 2
Chakwal Attock
IDC IDC
13 14 15 16
1 2 3 4
Chakwal Attock Jehlum Layyah
IDC IDC IDC NSML
17 18 19 20 21
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
22 23 24 25 26
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
27 28 29
1 2 3
Chakwal Attock Jehlum
IDC IDC IDC
Deployment Date
December, 2017 Dec-17 Total December, 2017 Jan-18 Total December, 2017 Feb-18 Total December, 2017 28 March, 2018 Mar-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 Apr-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 May-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 Jun-18 Total December, 2017 28 March, 2018 25 April, 2018
Month
Finance
Status
Dec-17
Paid
Jan-18
Paid
Feb-18
Paid
Mar-18 Mar-18
Finance 18.05.18
Paid Paid
Apr-18 Apr-18 Apr-18 Apr-18
Finance 25.05.18 Finance 25.05.18 Finance 21.06.18 Finance 20.05.18
Paid Paid Paid Paid
May-18 May-18 May-18 May-18 May-18
Finance25.06.18 Finance25.06.18 Finance 19.07.18 Finance25.06.18 Finance25.06.18 Sent bac
Paid Paid Paid Paid Paid
Jun-18 Jun-18 Jun-18 Jun-18 Jun-18
20.08.18 17.8.18 3.8.18 1.08.18 3.8.18, finance 10.12.18, f
Paid Paid paid Paid Paid
Jul-18 Jul-18 Jul-18
Finance 20.08.18 Finance 20.08.18 Finance 14.09.18, sent ba
Paid Paid Paid
30 31
4 5
Layyah Vehari
NSML NSML
32 33 34 35 36
1 2 3 4 5
Chakwal Attock Jehlum Layyah Vehari
IDC IDC IDC NSML NSML
37 38 39 40 41 42
1 2 3 4 5 6
Chakwal Attock Jehlum Layyah Vehari Mianwali
IDC IDC IDC NSML NSML NSML
43 44 45 46 47 48 49
1 2 3 4 5 6 7
Chakwal Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC IDC NSML NSML NSML NSML
50 51 52 53 54 55 56
1 2 3 4 5 6 7
Chakwal Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC IDC NSML NSML NSML NSML
57
1
Chakwal
IDC
09 April, 2018 23 May, 2018 Jul-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 Aug-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 Sep-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Oct-18 Total December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Nov-18 Total December, 2017
Jul-18 Jul-18
Finance 28.09.18 Finance 28.09.18
Paid Paid
Aug-18 Aug-18 Aug-18 Aug-18 Aug-18
Finance 14.09.18 sent to us Finance 14.09.18 sent to us Sent to ops wing, finance 2 Finance 28.09.18 Finance 28.09.18
Paid Paid Paid Paid Paid
Sep-18 Sep-18 Sep-18 Sep-18 Sep-18 Sep-18
Finance 30.10.18, 05.12.18 Finance 23.10.18, send aga Finance 07.12.18 Finance 26.10.18 Finance 14.11.18, SENT TO Finance 07.12.18
Paid Paid Paid paid Paid Paid
Oct-18 Oct-18 Oct-18 Oct-18 Oct-18 Oct-18 Oct-18
Finance 07.12.18 Finance 11.12.18 Finance 17.12.18 Finance 07.12.18 Finance 11.12.18 Finance 18.12.18 Finance 07.12.18
Paid Paid Paid Paid Paid Paid Paid
Nov-18 Nov-18 Nov-18 Nov-18 Nov-18 Nov-18 Nov-18
Finance 24.12.18 Finance 21.12.18 Finance 21.12.18 Finance 24.12.18 Finance 21.12.18 Finance 24.12.18 Finance 17.12.18
Paid Paid Paid Paid Paid Paid Paid
Dec-18
58 59 60 61 62 63
2 3 4 5 6 7
Attock Jehlum Layyah Vehari Mianwali Bahawalnagar
IDC IDC NSML NSML NSML NSML
28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018 Dec-18 Total
Dec-18 Dec-18 Dec-18 Dec-18 Dec-18 Dec-18
Grand Total Paid Finance Hospital Ops OS Total
49 49
Ch ### Ch Ch
86,400,000 Ch Ch Ch Ch
Ch
Annual actual 56,771,520 66,000,000 86,400,000 ### 83,482,752 ### 93,828,996
657 73
0 0 0
0
0
0
0
0
0
0
0
0
0
0
Pathology Lab Sr. No
Sr. Mon
1 2 3 4 5 6 7
1 2 3 4 5 6 7
Name of Hospital
Service Provider
Chakwal IDC Attock IDC Jehlum IDC Layyah NSML Vehari NSML Mianwali NSML BahawalnagarNSML
Deployment Date December, 2017 28 March, 2018 25 April, 2018 09 April, 2018 23 May, 2018 12-Sep-18 30 October, 2018
Month Infra Invoice - Paid Infra Invoice - hospital 5.11.18 Infra Invoice - hospital 5.11.18 Infra Invoice - At OS Infra Invoice - At Hospital With Vendor With Vendor
CONTRACT AMOUNTS OF 24x7 PATHOLOGY SERVICES Sr. No 1 2 3 4
Hospitals Amount per Anum Firms 184,665,481 Vehari & Bahawalnagar North Shore 189,292,596 Layyah & Bhakkar 167,777,271 Khusab & Mianwali IDC 140,562,520 Jhelum, Attock & Chakwal TOTAL AVERAGE REMAINING HOSPITALS
Date of Contract 18th December, 2017 18th December, 2017 18th December, 2017 15th September, 2017 682,297,868 48,735,562 536,091,182 1,218,389,050.00
Month
Paid 2,094,327 2,094,327 1,800,000 4,956,414 2,997,807 4,097,041 3,819,085 3,869,690 4,350,068
Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Total
30,078,758
IDC Paid IDC Pending at Finance
70,995,767 0
NSML Paid NSML Invoice Generated NSML Withheld + Penalty for NSML Pending at hospital
57,778,167 88,127,204 30,349,037 7,901,133
Chakwal Finance
Jehlum OS
Hospital
Paid
142,963 4,565,509 3,032,946 6,293,996 6,221,882
-
-
-
20,257,296
Jehlum Finance OS
Hospital
Paid
Attock Finance OS
Layyah Hospital
52,725 3,220,024 4,317,454 3,856,198 4,824,567 4,388,745
-
-
-
20,659,713
Paid
6,955,390 6,467,089 7,942,177 7,797,193 7,395,819 8,565,095
-
-
-
45,122,763
Invoice Generated
Layyah Withheld
7,560,207 15,846,087 10,653,512 11,176,799 10,568,328 12,295,063
604,817 9,378,998 2,711,335 3,379,606 3,172,509 3,729,968
68,099,996
22,977,233
Vehari Finance
-
OS
Hospital
-
30,349,037 22977233 7371804
-
Paid
Invoice Generated
2,185,920 2,155,386 4,237,128 4,076,970
2,432,794 5,759,508 5,762,531 6,072,375
12,655,404
20,027,208
Vehari Withheld
Finance
OS
Hospital
Mianwali Withhold Finance
Paid
Bahaw OS
Hospital
Paid
246,874 3,604,122 1,525,403 1,995,405 7,901,133 7,371,804
-
-
7,901,133
-
-
-
-
-
-
Bahawalnagar Withhold Finance OS
-
-
Hospital
-
-
Related Documents
Doc-20190103-wa0001.docx
July 2020 2
Doc-20190103-wa0030.ppt
November 2019 7More Documents from ""
Mom Status Tracker
August 2019 34
2019.01.03 Pathology.xlsx
October 2019 12
2018-12-27 Mep Payment.xlsx
October 2019 13
Procurement Committee Notifications.pdf
October 2019 14
Sample Evaluation Mom.docx
October 2019 21