7-Worksheet M2 - Developing Your Budget.pdf

PDF 73 KB Posted

Attached to
BB26-5 CAHPS Survey
Solicitation number
BB26-5
Issued by
Utah

About this file

The document is a comprehensive budget worksheet template titled "Worksheet M2. Developing Your Budget" designed to help organizations develop detailed project budgets across multiple cost categories. The worksheet provides a structured approach to estimating project expenses, including project management costs, vendor costs, and reports development costs. It allows for line-item breakdown of expenses such as staff hours, travel, consultant fees, sample preparation, questionnaire development, translation, mailing, data processing, interviews, printing, and report creation.

The worksheet includes sections for tracking both direct monetary costs and in-kind contributions, with spaces to calculate gross project budget, total monetary value of in-kind contributions, and net project budget. A key feature is the detailed granularity, which enables precise cost estimation by breaking down expenses into specific components like staff hourly rates, number of trips, translation costs per page, printing specifications, and other granular project elements. The template is flexible, allowing users to add rows for multiple staff members, consultants, and customize the budget to their specific project needs while providing a comprehensive view of potential project expenditures.

View the file

Other files

File Type Posted
6-Scoresheet .xls XLS spreadsheet
1-Claim of Business Confidentiality Updated.pdf.pdf PDF
3-Attachment A - General Provisions.docx DOCX document
4-Attachment B - Scope of Work.docx DOCX document
5-Attachment C - RFP Specifications.docx DOCX document
2-Vendor Prerequisites - RFP Agency.pdf PDF

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

Worksheet M2. Developing Your Budget

Cost category or basis for cost estimate Cost estimate

In-kind contributions (explain where relevant)

A. Project management

1. Hours spent by your team to plan, coordinate, and manage the project

For each staff member assigned to the project, indicate the hourly cost and the estimated number of hours on the project.

Refer to the tasks you have assigned each staff member in Worksheet A.

Use that to estimate the number of hours needed to complete the task(s).

Name of staff member:

(1) Hourly rate: .......................$

(2) Est. number of hours :

1x2= Cost to project ................$

Name of staff member:

(1) Hourly rate: .......................$

(2) Est. number of hours:

1x2= Cost to project ................$

(Add staff members as appropriate.)

2. Staff travel

For each staff member estimate number of trips and average cost per trip.

(1) Number of trips

(2) Average cost per trip: ........$ 1x2=Total travel cost: .............$

(1) Number of trips

(2) Average cost per trip: ........$ 1x2=Total travel cost: .............$

(Add staff members as appropriate.)

3. Consultant hours on the project

For each consultant assigned to the project, indicate the hourly cost and the estimated number of hours on the project.

Consultant 1:

(1) Hourly rate: .......................$

(2) Est. number of hours:

1x2= Cost to project ................$

(Add consultants as appropriate.)

4. Project management cost subtotal not accounting for in-kind contributions

(Add rows 1 to 3.)

B. Vendor costs1

5. Clean and prepare sample

(If vendor is drawing the sample, that should be reflected here.)

6. Assemble and print questionnaires

7. Cost of translation into relevant languages

Translation costs vary and can range from $20 to $75 per page. The higher end costs generally include formatting the questionnaire, while the lower end costs do not.

8. Develop CATI/telephone script $

9. Mailing of survey

1. Mailing Advance Letter: ....$

2. Mailing Wave 1: ................$

3. Mailing Thank You card ....$

4. Mailing Wave 2: ................$ Total (1+2+3) ..................= $

10. Conduct telephone interviews $

11. Process all returned questionnaires and completed telephone interviews

12. Enter data

13. Clean and prepare data file $

14. Analyze data $

15. Submit final data file and ALL supporting documentation

16. Vendor cost subtotal

(Add rows 5 to 15 not accounting for in-kind contributions.)

1 You can obtain these costs from the final budget that was included in the contract signed with the vendor.

Reports development costs

17. Development cost

Include cost of developing mockups, testing, and creating the final draft for review.

18. Cost of creating the final camera-ready copy

Include cost of inserting final output from analysis program into the report, proofing, reviewing, and creating the final camera-ready copy.

19. Printing costs

Include number of pages, number of colors, and type of paper.

Number of pages:

Number of colors:

Type of paper:

Cost of printing: ......................$

20. Reports development cost subtotal

(Add rows 17 to 19 not accounting for in-kind contributions.)

21. Gross project budget not accounting for in-kind contributions

(Add rows 4, 16 and 20.)

22. Total monetary value of all in-kind contributions

23. Net project budget after accounting for in-kind contributions

(Gross budget – total monetary value of all in-kind contributions; row 21-22.)

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