Complete all questions in assignment section of Module. Assignments can be completed in Word documents and/or Excel spreadsheets. Module 14: pages 146-147 1. Refer to the case and your cost estimate in Module 13, assignment 1. Prepare a budget justification using the format of Box 14.1. 2. Continuing the project from Module 13, assignment 2, prepare a budget justification for the project for which you have made a cost estimate.

FluQ Vaccination Campaign - Cost Estimate

Prepared in the format of Appendix A (Chen, Weikart, & Williams, 2015) Source: Chen, G., Weikart, L., & Williams, D. (2015). Budget tools: Financial methods in the public sector. SAGE Publications.

I. Assumptions and Parameters

• Number of schools: 30
• Children per school: 1,200
• Eligible for vaccination per school: 1,000
• Refusal rate: 8%
• Vaccinated children per school: 1,000 92% = 920
• Total children vaccinated: 920 30 = 27,600
• Non-vaccinated children (eligible but not vaccinated): 80 per school 30 = 2,400
• Staff wages:
  • Doctor: $95/hr
  • Nurse: $64/hr
  • Admin staff: $32/hr
• Fringe benefits: 2% of payroll
• Coloring book cost: $1.75/child
• Vaccine + supplies: $2.00/dose
• Database setup (annual): $10,000
• Years of program: 3 (costs calculated annually unless otherwise noted)

II. Program Components

1. Education Campaign

Staffing per school session (5 sessions/school):

• 1 Doctor 2 hrs 5 sessions = 10 hrs
• 2 Nurses 2 hrs 5 sessions = 20 hrs
• 2 Admins 2 hrs 5 sessions = 20 hrs

Per school total:

• Doctor: 10 hrs $95 = $950
• Nurses: 20 hrs $64 = $1,280
• Admins: 20 hrs $32 = $640
• Coloring books: 1,200 children $1.75 = $2,100

Total for 30 schools:

• Doctor: $950 30 = $28,500
• Nurses: $1,280 30 = $38,400
• Admins: $640 30 = $19,200
• Coloring books: $2,100 30 = $63,000

Subtotal (Education component) = $149,100

2. Vaccination Clinics

Number of vaccinations: 27,600 Time per vaccination: 6 minutes = 0.1 hour Total nurse hours: 27,600 0.1 = 2,760 hours Total nurse cost: 2,760 hrs $64 = $176,640

Doctors on site (1 per school per day) Assume 1 day/school = 30 days Doctor hours: 30 8 hrs = 240 hrs Doctor cost: 240 hrs $95 = $22,800

Vaccine and supplies: 27,600 $2 = $55,200

Subtotal (Vaccination Clinics) = $176,640 + $22,800 + $55,200 = $254,640

3. Data Recording and Reporting

• Vaccinated children: 27,600 10 min = 4,600 hrs
• Non-vaccinated children: 2,400 5 min = 200 hrs
• Total admin hours: 4,600 + 200 = 4,800 hrs
• Admin labor: 4,800 hrs $32 = $153,600

Reporting analysis (2 admin staff 3 weeks @ 40 hrs/week): = 2 3 40 = 240 hrs = 240 hrs $32 = $7,680

Subtotal (Data/Reporting) = $153,600 + $7,680 = $161,280

4. Technical Setup

• Database setup and IT costs (annual): $10,000

5. Fringe Benefits

• 2% of total staff payroll
• Total labor:
  • Education: $950 + $1,280 + $640 = $2,870/school 30 = $86,100
  • Vaccination: $176,640 (nurses) + $22,800 (doctors) = $199,440
  • Admin/Data: $153,600 + $7,680 = $161,280
  • Total payroll: $86,100 + $199,440 + $161,280 = $446,820
• Fringe benefits: 2% $446,820 = $8,936

III. Total Annual Program Cost

Component	Amount ($)
Education Campaign	$149,100
Vaccination Clinics	$254,640
Data Reporting	$161,280
Technical Setup	$10,000
Fringe Benefits (2%)	$8,936
Total (Annual)	$583,956

3-Year Total (assuming stable cost): $583,956 3 = $1,751,868

Question 2: Your Own Local Project (Example)

Project: Community Mental Health Support Hotline

Goal: Establish and operate a 24/7 mental health hotline for residents in the locality.

Assumptions:

• 3 shifts per day (8 hrs each), 1 licensed counselor per shift.
• Supervisor available during business hours (8 hrs/day 5 days/week).
• Two administrative assistants (40 hrs/week each).
• Staff wages:
  • Counselors: $40/hr
  • Supervisor: $50/hr
  • Admins: $30/hr
• Rent and utilities: $2,500/month
• Technology (phone system, CRM, etc.): $15,000 setup + $500/month
• Fringe benefits: 25% of payroll (includes health, retirement)

Cost Estimate

Category	Calculation	Annual Cost ($)
Counselors	3 shifts 8 hrs 365 $40	$350,400
Supervisor	8 hrs 5 days 52 weeks $50	$104,000
Admin Assistants	80 hrs/week 52 $30	$124,800
Payroll Total	-	$579,200
Fringe (25%)	25% $579,200	$144,800
Rent/Utilities	$2,500 12	$30,000
Tech Setup	One-time	$15,000
Tech Maintenance	$500 12	$6,000
Total (Year 1)	-	$775,000
Annual Cost (Yr 2+)	Excludes tech setup	$760,000