Attachment_5_-_Cost_Estimate_Format.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Tobacco Retailer Inspections
Solicitation number
75F40119R00065
Issued by

About this file

This document contains a sample cost estimate format and example for conducting tobacco retailer inspections over five years. The Food and Drug Administration intends to award multiple IDIQ contracts to conduct inspections in five regions across the United States. The cost estimate example outlines direct labor costs, subcontractor costs, other direct costs including travel and materials, indirect costs including overhead and fringe benefits, and total estimated costs for each of the five years. Direct labor includes positions for a program coordinator, backup coordinator, and administrative assistant. Subcontractor costs include inspectors and student minors. Other direct costs include items like insurance, supplies, equipment, and office space rental. Indirect costs are calculated as percentages of direct costs and direct labor. The total estimated costs increase each year to account for inflation.

Attachment 5

View the file

Other files

Show all 21

On GovTribe

Work with this file

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

Text version

Sample Layout Attachment 5 - Cost Estimate Format and Example

This document has multiple sheets, including a completed example cost estimate.
Direct Labor:QuantityTime or %RateTotal Est. Cost
Program Coordinator
Backup Program Coordinator
Commissioned Officers
Minors
Total Direct Labor Costs
Subcontract:
Inspectors
Minors
Other subcontractor costs
Total Sobcontract Costs
Other Direct Costs:
Travel
Materials and Supplies (itemize)
Equipment (itemize)
Other
Total Other Direct Costs
Indirect Costs:
Overhead Rate
Fringe Benefit Rate
Total Indirect Costs
Total Estimated Costs
Some of the above costs will not apply to how your agency has proposed to conduct inspections.

Example Cost Estimate

STATE X Cost Estimate (Year 1)
Direct Labor:QuantityTime or %RateTotal Est. CostTotal Cost over 5 years
Program Coordinator1100% FTE$40.00$83,200.00$441,729.60
Backup Program Coordinator150%FTE$28.00$29,120.00$154,616.80
Admin Assistant125% FTE$13.50$7,020.00$37,273.60
Total Direct Labor Costs$119,340.00$633,620.00
Subcontract:1
Inspectors850% FTE$20.00$166,400.00$832,000.00
Student Minors24$100 stipends$2,400.00$12,000.00
Total for Subcontractor, Inc.$168,800.00$844,000.00
Other Direct Costs:
Travel$16,587.00$86,251.00
Insurance for Minors$1,233.00$1,233.00$6,165.00
Materials and Supplies
Paper6 boxes$40.00$240.00$1,200.00
Office supplies12 months$200.00$2,400.00$12,000.00
Equipment
Laptops2$1,200.00$2,400.00$2,400.00
File cabinets4$780.00$3,120.00$3,120.00
Buy money for minors300 buys$7.00$2,100.00$11,900.00
Office Space rental12 months$965.00$11,580.00$60,363.12
Total Other Direct Costs$39,660.00$183,399.12
Indirect Costs:
Overhead Rate10% of direct costs$32,780.00$166,101.91
Fringe Benefit Rate34% of direct labor$40,575.60$215,430.80
Total Indirect Costs$73,355.60$381,532.71

Total Estimated Costs Year 1 $401,155.60 $2,042,551.83

STATE X Cost Estimate (Year 2)
Direct Labor:QuantityTime or %RateTotal Est. Cost
Program Coordinator1100% FTE$41.20$85,696.00
Backup Program Coordinator150%FTE$28.84$29,993.60
Admin Assistant125% FTE$13.91$7,233.20
Total Direct Labor Costs$122,922.80
Subcontract:1
Inspectors850% FTE$20.00$166,400.00
Student Minors24$100 stipends$2,400.00
Total for Subcontractor, Inc.$168,800.00
Other Direct Costs:
Travel$17,416.00
Insurance for Minors$1,233.00$1,233.00
Materials and Supplies
Paper6 boxes$40.00$240.00
Office supplies12 months$200.00$2,400.00
Buy money for minors350$7.00$2,450.00
Office Space rental12 months$993.95$11,927.40
Total Other Direct Costs$35,666.40
Indirect Costs:
Overhead Rate10% of direct costs$32,738.92
Fringe Benefit Rate34% of direct labor$41,793.75
Total Indirect Costs$74,532.67
Total Estimated Costs Year 2$401,921.87
STATE X Cost Estimate (Year 3)
Direct Labor:QuantityTime or %RateTotal Est. Cost
Program Coordinator1100% FTE$42.44$88,275.20
Backup Program Coordinator150%FTE$29.71$30,898.40
Admin Assistant125% FTE$14.33$7,451.60
Total Direct Labor Costs$126,625.20
Subcontract:1
Inspectors850% FTE$20.00$166,400.00
Student Minors24$100 stipends$2,400.00
Total for Subcontractor, Inc.$168,800.00
Other Direct Costs:
Travel$17,416.00
Insurance for Minors$1,233.00$1,233.00
Materials and Supplies
Paper6 boxes$40.00$240.00
Office supplies12 months$200.00$2,400.00
Buy money for minors350$7.00$2,450.00
Office Space rental12 months$1,023.77$12,285.24
Total Other Direct Costs$36,024.24
Indirect Costs:
Overhead Rate10% of direct costs$33,144.94
Fringe Benefit Rate34% of direct labor$43,052.57
Total Indirect Costs$76,197.51
Total Estimated Costs Year 3$407,646.95
STATE X Cost Estimate (Year 4)
Direct Labor:QuantityTime or %RateTotal Est. Cost
Program Coordinator1100% FTE$43.71$90,916.80
Backup Program Coordinator150%FTE$30.60$31,824.00
Admin Assistant125% FTE$14.75$7,670.00
Total Direct Labor Costs$130,410.80
Subcontract:1
Inspectors850% FTE$20.00$166,400.00
Student Minors24$100 stipends$2,400.00
Total for Subcontractor, Inc.$168,800.00
Other Direct Costs:
Travel$17,416.00
Insurance for Minors$1,233.00$1,233.00
Materials and Supplies
Paper6 boxes$40.00$240.00
Office supplies12 months$200.00$2,400.00
Buy money for minors350$7.00$2,450.00
Office Space rental12 months$1,023.77$12,285.24
Total Other Direct Costs$36,024.24
Indirect Costs:
Overhead Rate10% of direct costs$33,523.50
Fringe Benefit Rate34% of direct labor$44,339.67
Total Indirect Costs$77,863.18
Total Estimated Costs Year 4$413,098.22
STATE X Cost Estimate (Year 5)
Direct Labor:QuantityTime or %RateTotal Est. Cost
Program Coordinator1100% FTE$45.02$93,641.60
Backup Program Coordinator150%FTE$31.52$32,780.80
Admin Assistant125% FTE$15.19$7,898.80
Total Direct Labor Costs$134,321.20
Subcontract:1
Inspectors850% FTE$20.00$166,400.00
Student Minors24$100 stipends$2,400.00
Total for Subcontractor, Inc.$168,800.00
Other Direct Costs:
Travel$17,416.00
Insurance for Minors$1,233.00$1,233.00
Materials and Supplies
Paper6 boxes$40.00$240.00
Office supplies12 months$200.00$2,400.00
Buy money for minors350$7.00$2,450.00
Office Space rental12 months$1,023.77$12,285.24
Total Other Direct Costs$36,024.24
Indirect Costs:
Overhead Rate10% of direct costs$33,914.54
Fringe Benefit Rate34% of direct labor$45,669.21
Total Indirect Costs$79,583.75

Total Estimated Costs Year 5 $418,729.19

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