FSSI Wireless Economic Model (EM)
Purpose and Limitations:
The Economic Model (EM) is a market research tool for estimating the costs of services on the Federal Strategic Sourcing Initiative (FSSI) Wireless Blanket Purchase Agreements (BPAs). It uses current-year prices listed in the BPAs. The list prices may change as the result of a contract modification. Therefore, users of the EM should check back here to ensure they are using the most current version. The EM is intended to be an aid, not a substitute, for a Request for Information (RFI), communications with contractors, and quotes from contractors. Agencies must consult the contractors or their specific BPAs for ordering in accordance with Federal Acquisition Regulation (FAR) 8.405-3(c)(2).
The EM is a customized Microsoft (MS) Excel spreadsheet that will work with a standard MS Office desktop implementation (see the EM Setup Instructions for important settings). Visually impaired users requiring assisted technology should use the “508 Estimate” worksheet in the EM. For issues, please contact the Customer Service Center (see contact information in the upper right hand section of this web page).
Download: FSSI Wireless Economic Model v1.1 (Excel, 487KB)
In addition to estimating your organization’s wireless costs for market research, you can use the EM to:
- Provide the information in the “Service Plans Under Consideration” section of the EM’s “Estimate” worksheet as part of a Request For Quote (RFQ).
- Compare price quotes and amounts from contractors’ RFQ responses. Use the “Plan Calculator” worksheet to determine the Average Cost per Unit for the plans and features shown.
- Optimize the expected number of each type of service plan (shown on the EM’s “Detailed Plan Information” worksheet). These numbers could be included in a Request for Quote (RFQ) to the contractors.
1. Gather your agency’s wireless device and usage information
The Data Survey Template (Excel, 33KB) will help you gather information to input into the EM, such as the average voice and data usage amounts and the number of devices.
Work with your organization and current service provider(s) (if applicable) to determine usage data and inventory of your existing and future wireless services. Existing services data should include average domestic monthly recurring service costs, overage and usage charges, and tethering costs (as applicable). These numbers should exclude taxes and contractor fees, international charges, zero usage devices, and features other than tethering. If you do not have this data, contact your Office of the Chief Information Officer (OCIO) or your contractor(s) for this information.
2. Download and familiarize yourself with FSSI Wireless Economic Model
After saving the EM to your computer, open the EM and begin by reviewing the brief tutorial in the “Read Me” worksheet. This provides an overview of the EM and its different worksheets. The “Estimate” worksheet is the start page, where input data is entered in the left column of tables and output results are summarized in the right column of tables.
To see the current year BPA list pricing for all contractors, see the worksheet “BPA List Pricing.” This includes the list of service plans and features used by the current version of the EM and some that are for informational purposes only. It is not a complete list of all offerings and prices on the BPAs. To find a complete list, see the contractors’ BPAs on their websites or contact the contractors themselves.
3. Input your information
After gathering your requirements and familiarizing yourself with the EM tool, input your data into the input cells under the “Service Plans Under Consideration” section of the “Estimate” worksheet. See the applicable information icons in the worksheet for instructions regarding individual data entries.
4. Analyzing the results
As data is entered, the EM calculates and provides results for optimized cost and plan allocations. The results show the allocation of plan types to achieve the lowest cost. If data is entered under the “Average Monthly Cost of Existing Plans” in the “Estimate” worksheet, the results will include both a comparison to the existing costs and the estimated achievable savings, using current BPA List Pricing. Some data entry errors will generate exclamation points to the right of the cells containing the errors. For Microsoft Excel 2010 users, error rows will also be highlighted in red. Review and correct your data inputs to clear the error conditions in the “Estimate” worksheet. After the input data entry is completed, the results for optimized plans can be found in the “Detailed Plan Information” worksheet.