All correspondence must be made through the Vendor Portal. Please note: This is a Sole Source Notification. Specifications include, but are not limited to: Telecom Fund 0433 FY 2023 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 2023 Actual Cost Allocation Plan Obtain all necessary data including allocation statistics. Summarize and prepare for entry into MAXCARSTM or MAXCAPTM. Run MAXCARSTM or 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 2022 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 of Prior Federal Submissions Advise OIT and the State on progress of CAS reviews for fiscal years 2007-2022. Coordinate with the State of Alabama and CAS to resolve any issues/questions. Facilitate final resolution of CAS reviews. Task 1 Deliverables: 1.6 Telecom Fund 0433 FY 2023 Actual Cost Allocation Plan and Over/Under- Charge Analysis 1.7 Status reports on CAS reviews of prior years’ submissions (ad hoc reports) 1.8 Federal Submission Package for Telecom Fund 0433 FY 2023 Task 1: Telecom Fund 0433 FY 2023 Actual Cost Allocation Plan& Federal Submittal1.1 Establish Financial Controls.Identify revenues, expenditures per State Financial Statements. Obtain detaillevel costs, revenues, and usage data. Reconcile detail data to FinancialStatements. Identify any federal unallowable items.1.2 Prepare Telecom Fund 0433 FY 2023 Actual Cost Allocation PlanObtain all necessary data including allocation statistics. Summarize and preparefor entry into MAXCARSTM or MAXCAPTM. Run MAXCARSTM or MAXCAPTM andverify 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 RatesObtain federal claiming data from agencies. Summarize in format required forfederal reporting. Calculate federal Over/Under-Charges. Review withManagement.1.4 Prepare Telecom Fund 0433 FY 2022 Federal Submission PackageReview with OIT and the Finance Department. Submit to Cost AllocationServices (CAS) as directed. Advise OIT on progress of CAS review. Coordinatewith OIT, the State and CAS to resolve any issues/questions. Facilitate finalresolution of CAS review.1.5 Continue Monitoring of Prior Federal SubmissionsAdvise OIT and the State on progress of CAS reviews for fiscal years 2007-2022.Coordinate with the State of Alabama and CAS to resolve any issues/questions.Facilitate final resolution of CAS reviews.Task 1 Deliverables:1.6 Telecom Fund 0433 FY 2023 Actual Cost Allocation Plan and Over/Under-Charge Analysis1.7 Status reports on CAS reviews of prior years’ submissions (ad hoc reports)1.8 Federal Submission Package for Telecom Fund 0433 FY 2023
