Agency IT Budget Template and Organizational Chart

Information Technology Consolidation and Coordination Act (HB 1304)

HB 1304, also known as the "Information Technology Consolidation and Coordination Act," was signed into law by Gov. Mary Fallin in May 2011. To comply with the legislation, OSF's Information Services Division needs the following agency information technology and telecommunications functions by Sept. 1. the information should be submitted to isdexecutive@osf.ok.gov.

If you have any questions, please contact the OSF Service Desk at helpdesk@osf.ok.gov or by phone at (405) 521-2444.

• Organization chart – the chart should reflect:
  • Individual’s name
  • Job Title
  • PIN Number
  • Classified or Unclassified
  • Reporting Relationship
  • Salary

>> Organization chart sample

• Budget for Fiscal Year 2012 – Appropriated and Non-Appropriated (revolving) – A template is attached to use to submit the budget. This is an excel spreadsheet. If your agency budgets by department/function, please duplicate the template and prepare a separate budget for each department. The template is password protected so the automatic formulas and links do not get compromised.  

>> FY-2012 Agency IT Budget Template

The template is divided into the following sections:

• Summary by object code.
• Object code detail.
• Payroll cost by month – based on individuals.
• Professional services – accounts 515xxx.
• Travel expenses – accounts 521xxx-522xxx.
• Administrative expenses – accounts 531xxx-537xxx.
• Furniture, Equipment, etc. expenses – accounts 541xxx-549xxx.
• Miscellaneous expenses – accounts 551xxx-end.

The summary by object code and object code detail are populated when the other tabs/sections are filled in. The only field you need to complete on the object code summary is the blue field in the upper left-hand corner (Row 2 / Column B & C). This is where you will indicate the Agency/Department/Function name. If you are only completing a template for the total agency’s information technology function, insert "Total Agency" in the blue field.

On the payroll costs by month sheets, only the yellow fields need to be completed. The remainder of the template will automatically be populated. All other columns are automatically calculated based on the information provided in the yellow fields. Please enter a 4 in the benefits field. The salary page allows for 40 employees to be entered. If you need more fields, please contact the helpdesk and we can provide assistance.

On the professional services sheet, the blue fields need to be completed. The yellow fields (expense description) will automatically populate.

On the travel expense sheet(s), the blue fields need to be completed. The totals will automatically populate.

On the administrative expense sheet(s), the blue fields need to be completed. The yellow fields (expense description and totals) will automatically be populated.

On the furniture, equipment, etc. expense sheet(s), the blue fields need to be completed. The yellow fields (expense description and totals) will automatically be populated.

On the miscellaneous expense sheet(s), the blue fields need to be completed. The yellow fields (expense description and totals) will automatically be populated.