COVID-19 RESPONSE EXPENDITURE SUMMARY
AS OF WEDNESDAY APRIL 22ND PM

TOTAL EXPENDITURES

28%

PERSONNEL
OTHER OPERATING
72%

EMERGENCY PURCHASES BY CATEGORY
CLEANING SUPPLIES
FOOD
ITI
MEDICAL SUPPLIES
OPERATIONS
PPE
PUBLIC SANITATION
SOAP/SANITIZER
STAFFING
TRANSLATION

TOTAL EXPENDITURES
PERSONNEL $926,792.32
OTHER OPERATING $2,413,503.09
TOTAL SPEND $3,340,295.41

PERSONNEL SPEND 3.1.2020 - 4.11.2020
Department Regular Time
OT
Total Hours
CAO
$5,269.14
$0.00
126
Council
$106,579.06
$0.00
2396.72
ED
$4,136.52
$0.00
112
Fire
$26,477.27
$13,176.11
2842
Health
$208,904.03 $10,727.57
8700
HUD
$8,766.72
$0.00
154
Law
$3,815.01
$0.00
88.5
Mayor
$277,096.99
$0.00
6860
MSY
$36,674.90
$31.17
840.15
PDU
$10,538.34
$0.00
276
Police
$102,070.22 $12,552.67
4640.52
Property Mgmt
$345.10
$172.55
29.5
Workforce Dev
$6,018.31
$0.00
114
TOTAL $888,758.80 $38,033.52
31664.5

EMERGENCY PURCHASES SPEND BY CATEGORY
Category
CLEANING SUPPLIES

Total Spend
$54,371.77

FOOD
ITI

$83,850.15
$842,828.00

MEDICAL SUPPLIES

$32,036.57

OPERATIONS
PPE
PUBLIC SANITATION

$254,857.47
$723,512.81
$63,726.00

SOAP/SANITIZER

$108,320.32

STAFFING
TRANSLATION
TOTAL

$200,000.00
$50,000.00
$2,413,503.09
0

 DETAILED OTHER OPERATING SPENDING
AS OF WEDNESDAY APRIL 22ND PM
DATE
03/13/2020
03/14/2020
03/15/2020
03/16/2020
03/17/2020
03/18/2020
03/19/2020
03/20/2020
03/21/2020
03/22/2020
03/23/2020
03/24/2020
03/25/2020
03/26/2020
03/27/2020
03/28/2020
03/30/2020

SPEND
$44,602.55
$284,112.28
$111,411.40
$44,850.50
$5,328.12
$67,294.54
$3,903.14
$11,294.04
$10,118.00
$18,372.98
$102,246.23
$2,354.51
$25,088.00
$310.00
$7,915.61
$8,302.15
$16,731.39

EMERGENCY SPEND PER DAY

03/13/2020
03/14/2020
03/15/2020
03/16/2020
03/17/2020
03/18/2020
03/19/2020
03/20/2020
03/21/2020
03/22/2020
03/23/2020
03/24/2020
03/25/2020
03/26/2020
03/27/2020
03/28/2020
03/30/2020
03/31/2020
04/01/2020
04/02/2020
04/03/2020
04/06/2020
04/07/2020
04/08/2020
04/09/2020
04/10/2020
04/14/2020
04/15/2020
04/16/2020
04/18/2020
04/19/2020
04/20/2020
04/21/2020
04/22/2020

$900,000
$800,000
$700,000
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
$-

EMERGENCY PURCHASES
SPEND
DATE
$1,696.64
03/31/2020
$10,848.18
04/01/2020
$71,307.79
04/02/2020
$140,157.14
04/03/2020
$780,835.97
04/06/2020
$155,083.32
04/07/2020
$28,508.78
04/08/2020
$49,082.40
04/09/2020
$9,552.36
04/10/2020
$1,000.00
04/14/2020
$29,125.47
04/15/2020
$14,401.09
04/16/2020
$209,634.45
04/18/2020
$32,324.76
04/19/2020
$22,671.38
04/20/2020
$69,399.00
04/21/2020
$23,638.92
04/22/2020
TOTAL: $2,413,503.09

CLEANING SUPPLIES
EMS
$4,622.51
MTRC
$22,207.79
NOFD
$675.60
NOHSEP
$5,675.14
OCD
$2,576.31
PROPERTY MGT
$14,403.40
PUBLIC WORKS
$4,211.02
FOOD
NOHSEP
$83,850.15
TECHNOLOGY
CAO-CREDIT CARD
$98.26
ITI
$800,411.23
MAYOR'S OFFICE
$29,520.00
NOHSEP
$218.11
OCJC
$12,580.40
MEDICAL SUPPLIES
EMS
$9,755.22
NOHSEP
$246.46
HEALTH DEPT
$5,303.50
NOFD
$16,731.39
TRANSLATION
HEALTH DEPT
$50,000.00

OPERATIONS
HEALTH DEPT
$5,158.54

NOHSEP
NOFD
PROPERTY MGT
CORONER
MAYOR’S OFFICE

$83,208.43
$1,010.10
$13,005.00
$52,075.40
$100,400.00
PPE

EMS
$187,237.63
EMS/NOPD
$4,812.00
NOFD
$4,284.25
HEALTH DEPT
$24.40
NOHSEP
$526,233.34
PROPERTY MGT
$921.19
PUBLIC SANITATION
HEALTH DEPT
$49,290.00
PROPERTY MGT
$14,436.00
SOAP/SANITIZER
MTRC
$62,326.00
NOHSEP
$42,025.88
PROPERTY MGT
$2,218.44
NOFD
$1,750.00
STAFFING
1
NOHSEP
$200,000.00

 DETAILED PERSONNEL SPENDING
PERSONNEL SPEND – POLICE AND FIRE
Row Labels
Regular Time
Mar 1 - Mar 14
Police
$63,514.69
Mar 15 - Mar 28
Fire
$26,477.27
Police
$38,555.53
Mar 29 - Apr 11
Fire
$0.00
Police
$1,373.45
Row Labels
Mar 8 - Mar 21
CAO
Council
ED
Health & EMS
HUD
Law
Mayor
MSY
PDU
Property Mgmt
Workforce Dev
Mar 22 - Apr 4
CAO
Council
ED
Health & EMS
HUD
Law
Mayor
MSY
PDU
Property Mgmt
Workforce Dev

AS OF THURSDAY APRIL 16TH PM

OT

Total Hours

$7,445.64

2,872.80

$500,000.00

$13,176.11
$5,107.03

2,842.00
1,767.72

$450,000.00

PERSONNEL SPEND PER PAY PERIOD
14000
12000

$400,000.00
10000

$350,000.00

$59,156.42
$32,910.77

PERSONNEL SPEND –ADMIN
Regular Time
OT

3,235.00
1,250.12

$300,000.00

8000

$250,000.00

Total Hours

$200,000.00
$150,000.00

$2,341.84
$28,873.31
$1,625.06
$66,717.99
$2,901.52
$688.32
$114,555.21
$455.17
$3,309.03
$263.21
$2,279.89

$0.00
$0.00
$0.00
$4,557.77
$0.00
$0.00
$0.00
$0.00
$0.00
$131.61
$0.00

56
590
44
2,831.25
49
15.5
2,896.75
8
88
22.5
42

$2,927.30
$77,705.75
$2,511.46
$142,186.04
$5,865.20
$3,126.69
$162,541.78
$36,219.73
$7,229.31
$81.89
$3,738.42

$0.00
$0.00
$0.00
$6,169.80
$0.00
$0.00
$0.00
$31.17
$0.00
$40.94
$0.00

70
1,806.72
68
5,868.75
105
73
3,963.25
832.15
188
7
72

6000
4000

$100,000.00
2000

$50,000.00
$0.00

0
Mar 1 - Mar 14

Mar 15 - Mar 28

Mar 22 - Apr 4

Regular Time

TOTAL PERSONNEL SPEND
BY DEPARTMENT

Overtime

Mar 8 - Mar 21

Mar 29 - Apr 11

Hours

TOTAL HOURS WORKED
BY DEPARTMENT
CAO
Council
ED
Fire
Health
HUD
Law
Mayor
MSY
PDU
Police
Property Mgmt
Workforce Development

CAO
Council
ED
Fire
Health
HUD
Law
Mayor
MSY
PDU
Police
Property Mgmt
2
Workforce Development