I. Introduction
The Cost Per Person (CPP) Model is an Excel-based tool designed to compute and benchmark the cost per person for workspace, information technology (IT), and telecommunications. The CPP Model can also calculate potential cost savings resulting from alternative work environments such as telework centers, hoteling, or desk sharing. Enabling Macros: To enable the spreadsheet macros, adjust the security level. Click Tools, Macro, Security, and Security Level on the Excel toolbar to adjust the security level. Select Medium security level, close and then reopen the file.
II. Overview of workbook
The CPP Model has tabs on the bottom of each screen which take the user to any of the model's sections: CPP MODEL Allows users to input data and generate results. CPP MODEL CALCULATIONS Provides explanation of total office workplace cost for organization as well as cost per person. CPP GRAPHS Illustrates cost per person results graphically. SCENARIO TOOL Calculates potential net savings resulting from the use of different work environments. SCENARIO GRAPHS Graphically illustrates costs savings calculated by the Scenario Tool. DEFINITIONS Defines data inputs for CPP Model. U.S. REGIONAL MAP Divides the United States into seven geographical areas.
III. Getting Started:
Enabling Macros Double-click the Excel file ?Cost Per Person 2005.? Depending on one?s current computer settings, a user may see a message regarding macros (Figure 1). If this message is received, choose Enable Macros.
Figure 1 - Enabling Macros " If this message is not received, enable the spreadsheet macros by adjusting the security level. Click Tools, Macro, Security, and Security Level on the Excel toolbar to adjust the security level. A dialog box will then appear (Figure 2). Select Medium. Close and then reopen the file. If your computer is running on Windows 2000 operating system, you will need to select the Low security level in order for the model to function." "
Figure 2 - Security Level" To unprotect the model, click Tools, Protection, and Unprotect Sheet.
The CPP MODEL tab enables users to input specific organization information and estimate the cost per person
for the following components:
- Real Estate
- Telecommunications
- IT and Additional Devices
- Alternative Work Environment
-
Input data in only the un-shaded spreadsheet cells. Work through each component and use suggested values where applicable, or refer to the DEFINITIONS tab for more information.
Complete the CPP MODEL worksheet from top to bottom, since some calculations depend on prior inputs. The CPP Model displays a Cumulative Cost Per Person at the top of each spreadsheet. This number allows the user to see the impact of a single model component. A user may click CPP MODEL CALCULATIONS at any time for details of each calculation in the model. In order to save the results under a new file name, click Save As on the Excel toolbar. A dialog box will ask for a new file name. Once the new name is entered, click Close to overwrite the existing file.
Contact Us.
For questions or comments regarding the Cost Per Person Model, please contact:
Ray Wynter
Office of Real Property Management
Performance Measurement Division
GSA's Office of Governmentwide Policy
202-501-3802
ray.wynter@gsa.gov .
