Scenario 4.0 Scenario Building

1. Scenario 4.0 Scenario Building “Demonstrate the tool’s ability to track multiple scenarios based on different funding alternatives.”

2. 4.1 Demonstrate the tool’s ability to manage multiple reduction scenarios concurrently (e.g., 10% reduction, 5% reduction, etc.) allowing Bureau level users to automatically distribute the reduction evenly or through manual targeted adjustments. BFEM Methods • Use Formula GDP to automatically distribute across the board reductions. • Use “Bulk Modification” Modification Types to allow users to make manual prioritized reductions. • B2E workbooks may also be used to run budget cutting Customers using Method • Treasury • CNCS • DOI Demonstration • Use “Budget reduction Scenarios” preference profile in Example Customer/FY 2013 Activity level Test set to show three different methods of managing scenarios: Formula GDP, GDP Limit, and Modificat

3. 4.1 Demonstrate the tool’s ability to manage multiple reduction scenarios concurrently (e.g., 10% reduction, 5% reduction, etc.) allowing Bureau level users to automatically distribute the reduction evenly or through manual targeted adjustments. Configurable Budget Worksheet allows users to view and work on multiple scenarios concurrently. Manual Automatic Manual Manual Baseline set without cuts 5% Across the board using formula GDP Cuts with add-back requests 5% Across the board using budget mods Final decisions about add-back requests

4. 4.1 Demonstrate the tool’s ability to manage multiple reduction scenarios concurrently (e.g., 10% reduction, 5% reduction, etc.) allowing Bureau level users to automatically distribute the reduction evenly or through manual targeted adjustments. Use either Formula GDP or Bulk Modification to automatically distribute cuts. Bulk Modification Use Bulk Mod feature to apply modifications with a % cut to selected organizations Formula GDP Use the Formula GDP feature to apply cuts by object class

5. 4.2 Demonstrate the tool’s ability to support an Across the Board (ATB) reduction. BFEM Methods • Formula GDP is useful if you want to set cut levels by object class. For example, 5% cut to salaries, 10 % cut to contracts, and 7% cut to travel. • Modification Types are useful if you want to allow organizations to identify their own cuts or add backs. Customers using Method • All BFEM customers when applicable Demonstration • Use sample set to show formula GDP and bulk modification type methods for managing an across the board cut

6. 4.2 Demonstrate the tool’s ability to support an Across the Board (ATB) reduction. Object Class Cut Configure formula to cut each object class by specific % Configure profile to show Formula GDP on worksheet

7. 4.3 Demonstrate the tool’s ability to collect multiple over target data (i.e., prioritized add-backs assuming a reduced target scenario). BFEM Methods • Modification Add backs in combination with GDP limits can achieve this. • B2E reloadable worksheets can also be used to collect requested add-backs from agencies and to create scoring and decision tracking worksheets. • Generic attributes can be used to allow comments on requested increases Customers using Method • Treasury • State Demonstration • Use sample customer to demonstrate how modifications can be priortized.

8. 4.3 Demonstrate the tool’s ability to collect multiple over target data (i.e., prioritized add-backs assuming a reduced target scenario). 10% cut Add back scenario Modification cuts budget by 10% Bureau requests for add backs/prioritized by sort order Final decisions on add backs

9. 4.3 Demonstrate the tool’s ability to collect multiple over target data (i.e., prioritized add-backs assuming a reduced target scenario). Treasury’s use of Modification Types to manage request. For scenarios, Treasury uses two mod types: Above Guidance Request and Further Reduction Proposal. The sort orders start at 20000+ so that the mods types are not calculated in the Budget Adjustment tables. Additional tables and tags are created to include these mod types.

10. 4.4 Demonstrate the tool’s ability to import and export data to and from Excel. BFEM Methods • BFEM can produce Excel reports in any format compatible with Excel • BFEM’s Import/Export feature enables data in most excel reports to be imported. • The B2E and E2B tool allows users to collect data in defined formats • The new export Budget Worksheet (due August 1, 2013) feature will able users to export data in formats defined by Preference Profiles Customers using Method • All Demonstration • Show Export and Import function in DOI Sample Set • Show DHS B2E

11. 4.4 Demonstrate the tool’s ability to import and export data to and from Excel. DHS Reloadable Workbooks

12. 4.4 Demonstrate the tool’s ability to import and export data to and from Excel. BFEM has a standard Export/Import feature • Export/Import data from list organization screen • Data is exported in a standard format • Data must be in the same format to be imported • Can use macros to translate data into standard format for input • Can custom build imports to fit specific needs

13. 4.5 Demonstrate the tool’s ability to create pseudo entities or assign aliases to bin money not available to others (e.g., Secretarial Reserve, undistributed increases, undistributed decreases, etc.). BFEM Methods • User can create a “psuedo organization” anywhere in the model you desire. • User can create a modification Type called “Undistributed” and then create individual modifications wherever needed. Customers using Method • All use the organization feature but no customers have created a Secretary’s reserve. Demonstration • Demonstrate in DOI sample set.