13. INPUT: [5-Data-Fields] for All Employees -Used for [Activity Base #2] Global Forecasting

[M/S -13] is one-of-four model segments required to be populated with its respective data each month to fully utilize all the functionality features designed into FastBooks Solutions Software which includes generating monthly and annual business financial statements.

A principle design structure throughout the software is only [yellow highlighted cells] are formatted for entering [data].  All other cells are protected, and cannot be changed or altered in any way.  Therefore; entering incorrect data is the only possible mistake or error a user can make when using FastBooks Solutions Service-Based Service Business Accounting Model.

The best first step to quickly gain a basic understanding and appreciation for the business purpose of [M/S -13] is to review the [2] images below.  The first image populated with the [simulated-business-data] contained in the Practice Software. 

The second is an image of how [M/S -13] appears before populating any [data] in the software.  Take note of the protected cell coordinates designed to display calculations or information appear as blank cells.  Displaying cell coordinates not requiring a calculation as a blank cell is a principle design structure throughout the software to by design limit the [number of numbers] displayed in each respective software segment.  For example; cell coordinates designed to display actual vs. forecast better or worse calculations will appear as blank cells when the software does not contain a future forecast.Model Segment 13 of 18 -FastBooks Solutions Microsoft Excel Service Business Accounting ModelLeft click on the image above to open an enlarged image in a new tab.

Click the link to open [M/S -13] in an Adobe PDF file:

Click the link to open [M/S -13] in an Excel file:Model Segment 13 of 18 -FastBooks Solutions Microsoft Excel Service Business Accounting Model

Click the link to open [M/S -13] in an Adobe PDF file:

Click the link to open [M/S -13] in an Excel file:

[M/S -13] -[Enter] Employee Register Data for [Activity Base #2]

The purpose of this model segment 13 is to collect the payroll information for the business employees.  The software organizational structure provides for [3] functional employee Workgroups. The first two Workgroups in [M/S -13] is for service or billing employees each structured to accommodate up to [15] employees. The 3rd Workgroup is for all other employees; and can accommodate up to 25 non-service based employees.

Within this organizational employee structure, “What-if” employees can be added to column [C] for business planning purposes.  This feature enables management to evaluate the potential financial impact of adding new employees before hired.

Planning names for “What-if” service-based employees in column [C] are carried over to [M/S -9] and in the same manner, as Workgroup employees combined to calculate a [“What-if” Service-Based Revenue Forecast] reflected in [M/S -9] cell [R46]. The “What-if” forecast reflected in the cell [R46] is carried over as the Service Based Revenue Forecast reflected in [M/S -1] cell [N9].

Model segment [13] contains a [Part-2] set of columns that are not required to be populated. This optional [Part-2] is structured to generate and provide a fully functional business direct deposit payroll system.