Attachment A - OCFS -WIC Services Budget Template.xlsx
XLSX spreadsheet 33 KB Posted
- Solicitation number
- 24RFP24-0904004-010
- Issued by
- Harding County, South Dakota
About this file
The document is a budget template related to a state and local contract opportunity from the South Dakota Department of Health to provide personnel support for the Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) within the Office of Child and Family Services. The contract requires the selected entity to carry out federal and state requirements by providing indirect and direct services to or for WIC participants. The number, type, and location of the positions will be determined by the Department of Health based on needs within the WIC program. Several positions have been identified as needs, including receptionists, senior secretaries, vendor liaisons, and WIC public health assistants.
The budget template provides details on the estimated costs for personnel, including salary ranges for the various positions, standard benefits, travel costs, mobile connectivity, supplies and materials, and capital assets. The travel costs are broken down into in-state and out-of-state travel. The template also includes information on the calculation of salary and benefits, as well as the travel reimbursement guidelines.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP Document.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
FTE Justification New Attachment A
Personal Services
Salary 2,088
| Standard Benefits |
| Social Security |
Opp, Carol: Opp, Carol:
Update this information every April using BFM's YE & Operating Budget Procedures & Mary Keeler (W/C rate)
| 0.0765 | |
| Retirement | 0.0600 |
| Unemployment Insurance | 0.0010 |
| Workmen's Compensation | 0.0016 |
| Total % of Salary | 13.91% |
Health Insurance per FTE $ 11,782
| Travel | |
| In State Travel | |
| Occasional (6 day trips a year) | $ 1,363 |
Opp, Carol: Richardson, Carol:
Linked to Travel tab
Moderate (approx. 12 weeks a year) $ 8,179 Opp, Carol: Richardson, Carol:
Linked to Travel tab Extensive (more the 12 weeks a year) $ 16,358 Opp, Carol: Richardson, Carol:
Linked to Travel tab
| Out of State Travel | $ 1,500 |
| Must be justified by each anticipated trip |
**All travel includes per diem/lodging/vehicle costs
| Other Services & Costs | |
| Internal Service Charges for Business Function | 3,452 |
| (accounting, payroll, telephone & IT, records management, purchasing, etc.) |
| Central Services | 900 |
| Telehone & BIT Computer Access and Fees | 2,357 |
| PEPL Liability Coverage & Fidelity Bond Coverage | 195 |
| Rent | 1,716 |
| $ 5,168 |
| Mobile Connectivity (optional with Director approval) |
| Standard Phone - Talk and Text |
Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 230 Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills.
iPhone (smart phone) Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 480 Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills.
Mi-Fi or Hotspot, Elite Pad, or Tablet with unlimted data Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 442 Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills.
Iphone with Hot Spot Feature Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 540 Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills.
| Supplies and Materials | |
| Total Cost | $ 1,903 |
Opp, Carol: Richardson, Carol:
Linked to Totals (acct's) tab Office Supplies $ 916 Opp, Carol: Richardson, Carol:
Linked to Totals (acct's) tab Printing $ 438 Opp, Carol: Richardson, Carol:
Linked to Totals (acct's) tab Postage & Freight $ 549 Opp, Carol: Richardson, Carol:
Linked to Totals (acct's) tab
Linked to Travel tab
Opp, Carol: Richardson, Carol:
Linked to Travel tab Opp, Carol: Richardson, Carol:
| Linked to Travel tab | Capital Assets | |
| 34" Monitor | $ 497 | |
| Laptop & Accessories* | $ 1,720 | |
| (*Docking Station, Keyboard, Mouse) |
Positions & Pay range
| Position | Pay Range |
| Receptionist (GD) | $15.61 - $18.37 |
| Senior Secretary (GF) | $19.16 - $22.54 |
| Vendor Liaison (GF) | $19.16 - $22.54 |
| WIC Public Health Assistant (GG) | $21.29 - $25.05 |
| Nutrition Educator (GH) | $23.43 - $27.56 |
| Registered Dietitian (GI) - Special Pay Plan | $27.19 - $31.50 |
FTE Justification
| Department of Health | |||
| FY24 Budget Request - FTE Justification | FY24 | FY23 | Difference |
Personal Services
FTE Hours for Fiscal Year 2,088 2,088
| Standard Benefits |
| Social Security |
Opp, Carol: Opp, Carol:
Update this information every April using BFM's YE & Operating Budget Procedures & Mary Keeler (W/C rate)
| 0.0765 | 0.0765 | 0.0000 | |
| Retirement | 0.0600 | 0.0600 | 0.0000 |
| Unemployment Insurance | 0.0010 | 0.0010 | 0.0000 |
| Workmen's Compensation | 0.0016 | 0.0016 | 0.0000 |
| Total % of Salary | 13.91% | 13.91% |
Health Insurance per FTE $ 11,782 $ 9,872
Per Kari Williams 03.22.17 email, FY18 Health/Life is $8,470.00 vs. FY17's $8,387 per employee ~ $83.00 increase. $ 1,910
| Travel | |
| In State Travel | |
| Occasional (6 day trips a year) | $ 1,363 |
Opp, Carol: Richardson, Carol:
Linked to Travel tab
| $ 1,244 | $ 119 |
| Moderate (approx. 12 weeks a year) | $ 8,179 |
Opp, Carol: Richardson, Carol:
| Linked to Travel tab | $ 7,466 | $ 713 |
| Extensive (more the 12 weeks a year) | $ 16,358 |
Opp, Carol: Richardson, Carol:
Linked to Travel tab $ 14,933 $ 1,426
| Out of State Travel | $ 1,500 | $ 1,500 | $ - 0 |
| Must be justified by each anticipated trip |
**All travel includes per diem/lodging/vehicle costs
| Contractual Services | ||
| Central Services | 900 | 748.00 |
Linked to Totals (acct's) tab
| $ 152 | ||
| Telehone & BIT Computer Access and Fees | 2,357 | 2,357.04 |
Opp, Carol: Richardson, Carol:
| Linked to 1.) BIT Rates FY## Operating Budget Load worksheet (have to open that worksheet & this one at the same time). | $ - 0 | ||
| PEPL Liability Coverage & Fidelity Bond Coverage | 195 | 210.00 |
Opp, Carol: Richardson, Carol:
| Get this rate from J. Schaefer's Year End Procedures & Operating Budget Procedures memo (from Spring of current year). Add $195 PEPL rate to Gen. Liab. $3.65 rate. | $ (15) | ||
| Rent | 1,716 | 1,156.62 |
Opp, Carol: Richardson, Carol:
| Linked to Totals (acct's) tab | $ 559 | |||
| $ 5,168 | $ 3,753 | $ 1,415 |
| Mobile Connectivity (optional with Director approval) |
| Standard Phone - Talk and Text |
Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 230 Opp, Carol: Richardson, Carol:
| Get these rates from the most current AT&T monthly bills. | 230 | $ - 0 |
| iPhone (smart phone) |
Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 480 Opp, Carol: Richardson, Carol:
| Get these rates from the most current AT&T monthly bills. | 480 | $ - 0 |
| Mi-Fi or Hotspot, Elite Pad, or Tablet with unlimted data |
Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills.
Opp, Carol: Opp, Carol:
Update this information every April using BFM's YE & Operating Budget Procedures & Mary Keeler (W/C rate)
Opp, Carol: Richardson, Carol:
| Get these rates from the most current AT&T monthly bills. | 442 | $ - 0 |
| Iphone with Hot Spot Feature |
Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 540 Opp, Carol: Richardson, Carol:
Get these rates from the most current AT&T monthly bills. 540 $ - 0
| Supplies and Materials | |
| Total Cost | $ 1,903 |
Opp, Carol: Richardson, Carol:
| Linked to Totals (acct's) tab | $ 1,930 | $ (27) |
| Office Supplies | $ 916 |
Opp, Carol: Richardson, Carol:
| Linked to Totals (acct's) tab | $ 898 | $ 18 |
| Printing | $ 438 |
Opp, Carol: Richardson, Carol:
| Linked to Totals (acct's) tab | $ 485 | $ (47) |
| Postage & Freight | $ 549 |
Opp, Carol: Richardson, Carol:
Linked to Totals (acct's) tab Opp, Carol: Richardson, Carol:
Per Kari Williams 03.22.17 email, FY18 Health/Life is $8,470.00 vs. FY17's $8,387 per employee ~ $83.00 increase.
Opp, Carol: Richardson, Carol:
Linked to Travel tab
Opp, Carol: Richardson, Carol:
Linked to Travel tab
Linked to Travel tab $ 548 $ 1
| Capital Assets | |||
| 34" Monitor | $ 497 | $ 365 | $ 132 |
| Laptop & Accessories* | $ 1,720 | $ 1,266 | $ 454 |
| (*Docking Station, Keyboard, Mouse) |
Salary & Benefit CalC
| Salary & Benefit Calculation | ||
| Full Time Employees | ||
| **Update the yellow box for calculation | ||
| Hourly Rate | ||
| Number of Hours | 2088 | |
| Salary | $0.00 | |
| Benefits (FY24 Rates): | ||
| Social Security | 0.0765 | $0.0000 |
| Retirement | 0.0600 | $0.0000 |
| Unemployment Insurance | 0.0010 | $0.0000 |
| Workmen's Compensation | 0.0016 | $0.0000 |
| 0.1391 | ||
| Health Insurance (per hour) | $4.73 | $11,782.00 |
Total Salary & Benefit $11,782.00
Travel Rates
| Travel and Lodging | |||||||
| Day Rate | Travel Reimbursement Guidelines | ||||||
| Meals | 40.00 | ||||||
| Lodging | 75.00 | ||||||
| Total | 115.00 | Schedule for calculation of travel meal allowances: | |||||
| *Assume all trips include lodging | |||||||
| Leave | Return | ||||||
| Miles | 220 | Breakfast | before 5:31 AM | after 7:59 AM | |||
| Rate (eff. 7/15) | 0.51 | Lunch | before 11:31 AM | after 12:59 PM | |||
| 112 | Dinner | before 5:31 PM | after 7:59 PM |
Total 227 In-state per diem rates:
| Occasional Travel | Breakfast | $6.00 | Lodging | $75.00+ tax (effective (7/1/2019) | |||||
| # of Trips | 1,363.20 | Lunch | $14.00 | ||||||
| 6 | Dinner | $20.00 | |||||||
| Total | $40.00 | ||||||||
| Moderate Travel | |||||||||
| # of Weeks | 8,179.20 | Out-of-state per diem rates: | |||||||
| 12 | |||||||||
| # of Days overnight | |||||||||
| (assume 3 a week) | Breakfast | $10.00 | Lodging | $175.00 plus tax | |||||
| 36 | Lunch | $18.00 | (Finance Officer may approve an | ||||||
| Dinner | $28.00 | additional allowance of up to $100 a | |||||||
| Extensive Travel | Total | day for lodging. Please clear approval before you travel. Amounts over this need to be approved by Auditor’s Office before trip.) | $56.00 | ||||||
| 16,358.40 | |||||||||
| Allowance for use of privately owned vehicle: | |||||||||
| Out of State Travel & Lodging | |||||||||
| An employee shall be paid $0.51 cents a mile for use of a privately owned vehicle on official business outside the city limits of the employee's designated post of duty. When no state vehicle is available or approval is obtained before trip by BOA Feet & Travel. | |||||||||
| Meals* | 224.00 | ||||||||
| Lodging* | 525.00 | If Fleet vehicles are available in a designated city; but the employee desires to drive a personal vehicle, the employee shall be paid at the rate of $0.28 cents a mile. | |||||||
| Airfare | 800.00 | ||||||||
| Public Transportation | 200.00 | ||||||||
| Total | 1,749.00 | ||||||||
| *Numbers based on 4 day/3 night trip. | |||||||||
| Other things to look for: |
| 1. Please be sure Leave and Return times are on the voucher. |
| 2. Please ensure the license plate # is on the voucher for both private vehicles and fleet vehicles or list POV for private vehicle in lieu of license plate. |
| 3. Please ensure mileage is correct. |
| 4. Attach original receipts for all claims. |
| 5. Cannot be reimbursed for tips. |
File details come from the government source that posted it. Updated .