Magnolia Trace Employee Appreciation Fund!


This is a suggested program for computing the EAF checks for Magnolia Trace employees.

The program can be used by an EAF Administrator who Logins to the program with a Username and Password.

Once logged in, the Administrator can upload a csv (comma separated values - Excel) file with the required employees' information.
This file, provided by MT HR (Lisa Morris), should contain the following information for each employee:

   DEPARTMENT, EMP_NUMBER, FIRST_NAME, LAST_NAME, ADJ_HIRE_DATE, EMP_STATUS

The Administrator also enters the available EAF funds for the year, with the amount to hold in reserve and the amount to disperse to the employees.

The program uses a set of 'allocation parameters' based on the employee's time of employment and status (e.g. full-time, part-time, etc.)
These allocation parameters can be modified by the Administrator as desired.

Using the allocation parameters, the program computes the corresponding check amounts for all eligible employees.
This is carried out via an iterative process such that the total of all the employees' checks is as close as possible to the desired disperal amount.

Finally, the Administrator has the option to display a table that shows the current check amounts for each employee compared with their checks in the prior year.

When everything looks correct, a csv file -- in the same format as that currently used to print the checks -- can be downloaded to a local computer for printing the checks.

LOGIN