1 Required Item Telecom Fund 0433 FY 2025 Actual Cost 1 Task 1: Telecom Fund 0433 FY 2025 Actual Cost Allocation Plan & Federal Submittal 1.1 Establish Financial Controls. Identify revenues, expenditures per State Financial Statements. Obtain detail level costs, revenues, and usage data. Reconcile detail data to Financial Statements. Identify any federal unallowable items. 1.2 Prepare Telecom Fund 0433 FY 2025 Actual Cost Allocation Plan Obtain all necessary data including allocation statistics. Summarize and prepare for entry into MAXCAPTM. Run MAXCAPTM and verify results. Calculate allowable costs by service and charges by agency. Prepare variance analysis (Over/Under Recoveries by Service and Agency). 1.3 Determine Federal Participation Rates Obtain federal claiming data from agencies. Summarize in format required for federal reporting. Calculate federal Over/Under-Charges. Review with Management. 1.4 Prepare Telecom Fund 0433 FY 2025 Federal Submission Package Review with OIT and the Finance Department. Submit to Cost Allocation Services (CAS) as directed. Advise OIT on progress of CAS review. Coordinate with OIT, the State and CAS to resolve any issues/questions. Facilitate final resolution of CAS review. 1.5 Continue Monitoring Prior Federal Submissions Advise OIT and the State on progress of CAS reviews for fiscal years 2007-2024. Coordinate with the State of Alabama and CAS to resolve any issues/questions. Facilitate final resolution of CAS reviews. Federal negotiation assistance related to payback of potential federal program overcharges to be handled in Task 4, Provide Advisory Services As Necessary. 91800 - CONSULTING SERVICES 1.00 Each 2 Required Item Provide Implementation Guidance for FY27 2 Task 2: Provide Implementation Guidance for FY 2027 OIT Charge-Back Rates Facilitate reviews of the FY 2027 charge-back rate plan with OIT managers to assure effective implementation of the rates for FY 2027 as well as integration of the rates into the OIT Service Catalog. 91800 - CONSULTING SERVICES 1.00 Each 3 Required Item Telecom Fund 0433 FY 2028 Forecast Cost 3 Task 3: Telecom Fund 0433 FY 2028 Forecast Cost Allocation and Rate Plan 3.1 Data Collection Determine data to be used as sources for forecasting both costs and service usage levels; identify trends that may impact cost/service growth or declines; identify new services planned for implementation (or discontinuance) before or during FY 2028; identify other factors that could impact forecasts; assemble base data; review with OIT and the Finance Department management. 3.2 Develop Cost Forecast Using base data and forecast parameters, prepare detail schedules of costs by Organization, Activity and Object; summarize for review; prepare for entry to MAXCAPTM. 3.3 Develop Usage Forecast Using base data and forecast parameters, prepare detail schedules of service usage; summarize for review; prepare for entry to MAXCAPTM. 3.4 Prepare FY 2028 Forecast Cost Allocation Plan Enter required cost, usage, and statistical data to MAXCAPTM; run MAXCAPTM; review for errors, inconsistencies; rerun as necessary; calculate initial rates; review with OIT management; revise forecast data as appropriate, and rerun MAXCAPTM; finalize rates. 3.5 Prepare Final Report Materials Including final MAXCAPTM Plan and rate schedule. 91800 - CONSULTING SERVICES 1.00 Each 4 Required Item Provide Advisory Services as Necessary 4 Task 4: Provide Advisory Services as Necessary It is recognized that from time-to-time various issues may arise that could require input and/or analysis on the part of the Contractor’s cost allocation analyst. Such issues may include undertakings like adapting funding/cost recovery methods for changes in the OIT organization structure, completing the transition to VoIP services, implementing Disaster/Recovery Plans or others that may have potential impact on OIT’s rates, financial status, or federal compliance. Other matters may involve assisting in negotiations of a settlement with the Federal government for potential service overcharges to federal programs. The issues may also include updating, revising, or expanding charges for services provided by the State Business Systems unit and/or the Comptroller’s Office of the Department of Finance. Under this SOW, the Contractor will review requirements of each identified initiative with the State, determine the tasks required to conduct the analysis, and prepare reports for the State’s management. A schedule and labor-hour allowance will be identified and with approval of the Director of State Business Systems or the Secretary of Information Technology as appropriate, the analysis will be completed. Only tasks approved in writing by the Director of State Business Systems or the Secretary of Information Technology will be undertaken. Total hours for all assigned tasks will not exceed the Purchase Order which this SOW accompanies. 91800 - CONSULTING SERVICES 1.00 Each All correspondence must be made through the Vendor Portal.
