CFB_TEFAP_CCC_CTR052617_ISB_v15_4.25.23__KG_.pdf

129 KB Posted

Attached to
Master Agreement AZ|CTR052617
Contract number
CTR052617
Issued by
Arizona

About this file

Written by GovTribe AI ·

This document is an Itemized Service Budget for the Community Food Bank, specifically for the TEFAP (The Emergency Food Assistance Program) service, with Contract #CTR052617 covering the state fiscal year period from 07/01/2022 to 6/30/2023. The budget is a detailed financial breakdown for a food bank operation in Arizona, involving multiple funding sources including TEFAP Admin, CARES BBB, Farm to Food Bank One-Time, TEFAP ARPA, and TEFAP CCC.

The total funding allocation is $1,446,705.71, distributed across different contract periods and funding categories. The budget comprehensively details personnel costs, with numerous positions including drivers, warehouse staff, coordinators, and managers, each allocated a specific percentage of effort and funding source. Key budget categories include salaries ($670,573.26), employee-related expenses ($137,544.43), travel expenses ($36,510.72), occupancy costs ($17,981.89), equipment ($221,700.00), materials and supplies ($20,738.00), and operating services ($146,880.73). The contract includes a special instruction to spend $235,223.65 by 9/30/22, and the budget is strategically structured to allocate costs across different funding streams, with indirect costs bringing the total service costs to $1,445,705.71.

View the file

Other files

File Type Posted
CTR052617_-_Additional_Endorsements.pdf PDF
CTR052617_Contract_Amendment_10.pdf PDF
CTR052617_Contract_Amendment_15.pdf PDF
CTR052617_Contract_Amendment_19.pdf PDF
CTR052617_Contract_Amendment_20.pdf PDF
CTR052617_-_COI_and_WOS_WC.pdf PDF
CTR052617_Contract_Amendment_13.pdf PDF
CTR052617_Contract_Amendment_16.pdf PDF
CTR052617_Contract_Amendment_17.pdf PDF
CTR052617_Contract_Amendment_18.pdf PDF
CTR052617_Certificate_of_Insurance_Exp_2024.7.1.pdf PDF
CTR052617_Contract_Amendment_11.pdf PDF
CTR052617_Contract_Amendment_12.pdf PDF
CTR052617_Contract_Amendment_14.pdf PDF
CTR052617_Debarment_Checks.pdf PDF
Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

$1,404,455.71 $974,979.71 $116,496.00 $111,280.00 $201,700.00 $41,250.00 $1,445,705.71

7/1/22 to 6/30/23 *Must spend

$235,223.65 by 9/30/22 7/1/22 to 9/30/22 12/1/22 to 6/30/23 7/1/22 to 6/30/23 2/1/23 to 6/30/23

1. Personnel SFY23 SFY23 SFY23 SFY23 SFY23

# Pos FTE Position Total Service Cost (Salary * DES %)

DES

% TEFAP Admin CARES BBB Farm to Food Bank

One-Time TEFAP ARPA TEFAP CCC Total DES Costs

1 0.01 Director Of Logistics 1,133.55 1% 1,133.55 1,133.55 1 0.31 Fleet Coordinator 16,606.90 31% 16,606.90 16,606.90 1 0.31 Inv Control Manager 21,981.39 31% 14,907.86 7,073.53 21,981.39 1 0.18 Transportation Coordinator 10,975.78 18% 10,975.78 10,975.78 1 0.20 Clients Food Coordinator 9,962.60 20% 9,962.60 9,962.60 1 0.27 Class A CDL TD Driver Trainer 14,343.20 27% 14,343.20 14,343.20 1 0.31 Driver Agency Market 13,765.91 31% 13,765.91 13,765.91 1 0.31 Tefap Pima Driver 12,340.49 31% 12,340.49 12,340.49 1 0.45 Community Programs Coordinator 21,164.96 45% 21,164.96 21,164.96 1 0.09 Warehouse Supervisor Gv Amado 5,303.64 9% 5,303.64 5,303.64 1 0.31 Warehouse Operations & Logistics Manager 19,255.03 31% 19,255.03 19,255.03 1 0.31 Volunteer Services Manager 16,417.89 31% 16,417.89 16,417.89 1 0.40 Client Vol Svc Spvsr 19,471.93 40% 19,471.93 19,471.93 1 0.31 CDL Driver Class A 14,358.05 31% 14,358.05 14,358.05 1 0.37 Willcox Cdl Driver Warehouse 17,813.97 37% 17,813.97 17,813.97 1 0.20 Client Vol Svc Spvsr 9,700.43 20% 9,700.43 9,700.43 1 0.20 Client Services & Volunteer Services Manager 12,914.26 20% 12,914.26 12,914.26 1 0.33 Inventory Control Specialist 15,515.07 33% 15,515.07 15,515.07 1 0.12 Warehouse Assistant 4,625.84 12% 4,625.84 4,625.84 1 0.25 Partner Program Manager 15,180.24 25% 15,180.24 15,180.24 1 0.31 Transportation Sup 17,407.77 31% 17,407.77 17,407.77 1 0.31 CDL Class A Driver 13,781.42 31% 13,781.42 13,781.42 1 0.46 Transportation Manager 23,341.96 46% 15,830.61 7,511.35 23,341.96 1 0.34 Director of Warehouse Operations 39,453.24 34% 27,621.57 11,831.67 39,453.24 1 0.22 Nogales Warehouse Assistant Border Pilot Funded 8,489.89 22% 8,489.89 8,489.89 1 0.18 Allociations Supervisor 10,575.36 18% 10,575.36 10,575.36 1 0.31 Warehouse Supervisor 16,164.82 31% 16,164.82 16,164.82 1 0.62 Partner Program Coordinator I 32,577.06 62% 22,503.24 10,073.82 32,577.06 1 0.31 Production Assistant 11,949.02 31% 11,949.02 11,949.02 1 0.31 Inventory Control Specialist 13,807.65 31% 9,403.85 4,403.80 13,807.65 1 0.31 CFB Truck Driver 12,211.71 31% 12,211.71 12,211.71 1 0.22 Nogales Warehouse & Client Services Assistant 8,548.20 22% 8,548.20 8,548.20 1 0.25 Client Services Specialist 9,244.15 25% 9,244.15 9,244.15 1 0.37 Warehouse Assistant 14,554.10 37% 14,554.10 14,554.10 1 0.22 Warehouse Asst Nog 8,198.37 22% 8,198.37 8,198.37 1 0.37 Distribution Center Clerk 6,831.12 37% 6,831.12 6,831.12 1 0.31 Volunteer Services Supervisor 14,409.30 31% 14,409.30 14,409.30 1 0.01 Client Advocacy Coordinator 520.28 1% 520.28 520.28 1 0.03 Data Analyst 1,894.37 3% 1,894.37 1,894.37 1 0.12 Allocations Coordinator 5,202.47 12% 5,202.47 5,202.47 1 0.30 Warehouse Manager 19,871.12 30% 13,803.07 6,068.05 19,871.12 1 0.03 Client Svs Vol Coor Gv S 1,121.86 3% 1,121.86 1,121.86 1 0.31 CDL A Driver AAFB Funded 13,614.84 31% 13,614.84 13,614.84 1 0.37 Warehouse Assistant 14,454.15 37% 14,454.15 14,454.15 1 0.37 Warehouse Assistant 14,454.15 37% 14,454.15 14,454.15 1 0.15 Amado-Green Valley Resource Center Manager 9,471.89 15% 9,471.89 9,471.89 1 0.31 Warehouse Assistant 11,148.15 31% 11,148.15 11,148.15 1 0.37 CDL Driver Class A 15,822.68 37% 15,822.68 15,822.68 1 0.31 Warehouse Assistant 12,045.13 31% 12,045.13 12,045.13 1 0.01 Client Advocacy Specialist 475.14 1% 475.14 475.14 1 0.31 Client Services Specialist 5,692.60 31% 5,692.60 5,692.60 1 0.28 Warehouse Assistant 10,408.14 28% 10,408.14 10,408.14

Contract Period *Special Instructions

State Fiscal Year

Total Funding Allocation

Total

Community Food Bank

Itemized Service Budget - Revised 03/03/2023 Service: TEFAP

Contract # CTR052617 Contract Period: 07/01/2022 to 6/30/2023

# Pos FTE Position Total Service Cost (Salary * DES %)

DES

% TEFAP Admin CARES BBB Farm to Food Bank

One-Time TEFAP ARPA TEFAP CCC Total DES Costs

1 0.02 Transportation Coordinator 1,000.00 0.02 1,000.00 1,000.00 1 0.06 Fleet Coordinator 3,000.00 0.06 3,000.00 3,000.00 1 0.11 CDL Driver 5,000.00 0.11 5,000.00 5,000.00 1 0.11 CDL Class A Driver 5,000.00 0.11 5,000.00 5,000.00 1 0.05 CDL Driver 2,500.00 0.05 2,500.00 2,500.00 1 0.11 CDL A Driver AAFB Funded 5,000.00 0.11 5,000.00 5,000.00 1 0.02 Class A CDL TD Driver Trainer 1,000.00 0.02 1,000.00 1,000.00 1 0.08 Tefap Pima Driver 3,008.36 0.08 2,500.00 2,500.00 1 0.11 Driver Agency Market 5,000.00 0.11 5,000.00 5,000.00 1 0.11 CDL Driver Class A 5,000.00 0.11 5,000.00 5,000.00 1 0.03 Warehouse Assistant 1,000.00 0.03 1,000.00 1,000.00 1 0.03 Warehouse Assistant ‐ Cardboard Disposal 1,000.00 0.03 1,000.00 1,000.00 1 0.03 Warehouse Assistant 1,000.00 0.03 1,000.00 1,000.00 1 0.03 Operations Coordinator 1,000.00 0.03 1,000.00 1,000.00 1 0.02 Allocations Coordinator 1,000.00 0.02 1,000.00 1,000.00 1 0.02 Allociations Supervisor 1,000.00 0.02 1,000.00 1,000.00 1 0.02 Warehouse Associate 1,000.00 0.02 1,000.00 1,000.00 1 0.02 Warehouse Supervisor 1,000.00 0.02 1,000.00 1,000.00 1 0.03 Production Warehouse Assistant 1,000.00 0.03 1,000.00 1,000.00 1 0.03 Warehouse Assistant 1,000.00 0.03 1,000.00 1,000.00 1 0.02 Warehouse Supervisor 1,000.00 0.02 1,000.00 1,000.00 1 0.04 Warehouse Assistant 1,500.00 0.04 1,500.00 1,500.00 1 0.04 Warehouse Assistant 1,500.00 0.04 1,500.00 1,500.00 1 0.03 Inventory Control Specialist 1,500.00 0.03 1,500.00 1,500.00 1 0.02 CDL Driver Class A 1,000.00 0.02 1,000.00 1,000.00 1 0.03 Distribution Center Clerk 1,000.00 0.03 1,000.00 1,000.00 1 0.02 Willcox Cdl Driver Warehouse 1,000.00 0.02 1,000.00 1,000.00 1 0.20 Warehouse Assistant 7,500.00 0.20 7,500.00 7,500.00 1 0.20 Warehouse Assistant 7,500.00 0.20 7,500.00 7,500.00 1 0.20 Warehouse Assistant 7,500.00 0.20 7,500.00 7,500.00 1 0.21 Operations Coordinator 7,500.00 0.21 7,500.00 7,500.00

Salaries 670,573.26 623,611.04 46,962.22 53,500.00 - 30,000.00 754,073.26

2. Employee Related Expense (E.R.E.) - payroll taxes and benefits 120,703.19 112,249.99 3,349.44 14,445.00 - 7,500.00 137,544.43

3. Professional & Outside Service

Annual Audit - - - - Contractors & Service Volunteers - - - - Temp Labor - 1.00 - Other Professional & Outside Services - - - -

- 1.00 - - - - -

4. Travel -

Conferences, meetings, mileage - 1.00 - - - Vehicle Maintenance & Repair - 1.00 - Fuel Expense 24,510.72 1.00 10,000.00 14,510.72 12,000.00 36,510.72 Leased Vehicles - 1.00 - Annual Vehicle Insurance - -

24,510.72 1.00 10,000.00 14,510.72 12,000.00 - 36,510.72

5. Occupancy - -

Utilities 17,981.89 1.00 10,000.00 7,981.89 17,981.89 Building Maintenance & Repair - 1.00 - - -

17,981.89 10,000.00 7,981.89 - - - 17,981.89

6. Equipment

Warehouse/Vehicle Equipment Maint & Repair - 1.00 - - Capital Equipment - 1.00 - - 20,000.00 201,700.00 221,700.00 Office/Warehouse Equipment - 1.00 - - Technology - 1.00 - - Facility Renovations - - -

- - - 20,000.00 201,700.00 - 221,700.00

7. Materials & Supplies -

Warehouse & Program Supplies 20,738.00 1.00 20,000.00 738.00 20,738.00

# Pos FTE Position Total Service Cost (Salary * DES %)

DES

% TEFAP Admin CARES BBB Farm to Food Bank

One-Time TEFAP ARPA TEFAP CCC Total DES Costs

Office & Technology Supplies - 1.00 - Food Purchases - - -

20,738.00 20,000.00 738.00 - - 20,738.00

8. Operating Services

Telephone - 1.00 - Printing & Postage - - Dues & Fees (includes AAFB, A2H, program, etc) - - Insurance (general, vehicle, volunteer, liability, cyber) - 1.00 - - Rent - - Other Operating Services 143,843.91 111,480.73 32,363.18 3,036.82 146,880.73

143,843.91 1.00 111,480.73 32,363.18 3,036.82 - - 146,880.73

Direct Costs 998,350.97 1.00 887,341.76 105,905.45 102,981.82 201,700.00 37,500.00 1,335,429.03

9. Indirect Cost 99,835.10 87,637.95 10,590.55 8,298.18 - 3,750.00 110,276.68

Total Service Costs/CSA Total Cost: 1,098,186.07 974,979.71 116,496.00 111,280.00 201,700.00 41,250.00 1,445,705.71

File details come from the government source that posted it. Updated .