# Prioritization Tool Overview

Step 1: Enter all applicable Solution Details. These are the paint point ID(s), solution type(s), and potential solution(s) columnsStep 2: Once you have finished entering the solution details information, please review the "Value Score" and "Cost Score" columns. Please rank each solution by importance/priority on scale of 0 to 5 (0 is N/A, 1 is lowest, 2 is low-medium, 3 is medium, 4 is medium-high, 5 is highest)Step 3: Once completed, please go to to the 'Output' tab to review and discuss the solution prioritization results. The Solution Prioritization matrix can be leveraged to discuss the potential solution cost and value implications for solving the applicable pain point. 

The Federal government is instrumental in delivering services for the public, yet many business processes we rely on today are manual, costly, and do not meet the needs of the public. Digital and emerging technologies present significant opportunities to identify cost savings, improve customer experience, and enhance controls via digital transformation.Bureau of the Fiscal Service’s Office of Financial Innovation and Transformation (FIT) estimates there are significant government-wide cost savings opportunities by transforming end-to-end processes. FIT developed the Digital End-to-End Efficiency (DEEE) Playbook to accelerate digitization through reducing unnecessary process steps, boosting automation, and innovation to achieve large-scale efficiencies. 

Please follow the numbered instructions below to use the tool. Any cells that require a user change to be made are denoted in the following light blue highlight                  .Please do not attempt to manipulate any of cells or formulas in this tool as it will undermine the tool's logic and accuracy. In order for the tool to function properly, the user MUST refresh ALL data connections after any data inputs have been updated. To refresh data connections, please navigate to the "Data" tab on the Excel ribbon and click "Refresh all".

To prioritize potential pain point / solution combinations using criteria and agency goals/priorities to identify the best use of resources to resolve each pain point 

Solution Prioritization ToolDetailed Overview

Input Form and Output Tab:

Purpose:

1)  Enter the Point ID, Pain Point Description, and Solution Type in the "Input Form" tab based on the output information from Assess Solutions Tool.  2) For the value score columns, please rank by importance/priority on scale of 1 to 5 (Scale: 1 is lowest, 2 is low-medium, 3 is medium, 4 is medium-high, 5 is highest). 3) For the cost score columns, please rank by importance/priority on scale of 1 to 5 (Scale 0-5; 0 is N/A, 1 is $0-1M, 2 is $1-2M, 3 is $2-3M, 4 is $3-4M, 5 is $4-5M - the cost scale can be updated by tool users)4) Once complete, please go to the 'Output' tab to see your Solution Prioritization tool results

Instructions:

Required Data Inputs from User

Solution Prioritization Tool User Guide

# Input Form

# Output

Solution Prioritization Matrix

[CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE][CELLRANGE]15	9	0	0	0	0	0	0	0	0	5	6	0	0	0	0	0	0	0	0	Test-1, RPA	Test-2, Machine Learning	-, -	-, -	-, -	-, -	-, -	-, -	-, -	-, -	ValueCostimage1.pngimage2.jpegimage3.pngimage4.pngimage5.pngimage6.pngimage7.jpeg