Attachment_5_-_Cost_Estimate_Format(1).xlsx

XLSX spreadsheet 20 KB Posted

Attached to
3rd Party Tobacco Retailer Inspections
Solicitation number
17-223-SOL-00040
Issued by

About this file

Attachment 5 - Cost Estimate Format Template

View the file

Other files

Show all 18

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 (Base Year)
Direct Labor:QuantityTime or %RateTotal Est. CostTotal Cost over 3 years
Program Coordinator1100% FTE$40.00$83,200.00$257,171.20
Backup Program Coordinator150%FTE$28.00$29,120.00$90,012.00
Admin Assistant125% FTE$13.50$7,020.00$21,704.80
Total Direct Labor Costs$119,340.00$368,888.00
Subcontract:1
Inspectors850% FTE$20.00$166,400.00$499,200.00
Student Minors24$100 stipends$2,400.00$7,200.00
Total for Subcontractor, Inc.$168,800.00$506,400.00
Other Direct Costs:
Travel$16,587.00$51,419.00
Insurance for Minors$1,233.00$1,233.00$3,699.00
Materials and Supplies
Paper6 boxes$40.00$240.00$720.00
Office supplies12 months$200.00$2,400.00$7,200.00
Equipment
Laptops2$1,200.00$2,400.00$2,400.00
File cabinets4$780.00$3,120.00$3,120.00
Cameras8$97.00$776.00$776.00
Buy money for minors300 buys$7.00$2,100.00$2,100.00
Office Space rental12 months$965.00$11,580.00$11,580.00
Total Other Direct Costs$40,436.00$112,126.64
Indirect Costs:
Overhead Rate10% of direct costs$32,857.60$98,741.46
Fringe Benefit Rate34% of direct labor$40,575.60$125,421.92
Total Indirect Costs$73,433.20$224,163.38

Total Estimated Costs Base Period $402,009.20 $1,211,578.02

STATE X Cost Estimate (Option Year 1)
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 Option Year 1$401,921.87
STATE X Cost Estimate (Option Year 2)
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 Option Year 2 $407,646.95

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