The project is to create a calculator in Flash that determines the Labor Burden rate of an employee. An excel spreadsheet is provided with the existing calculations.
The project requires Flash skills and design skills (a wireframe image is provided).
The project has been well documented and includes.
1. Working Excel spreadsheet for the calculations
2. Product Requirements document outlining the behavior if the calculator.
3. Wireframe of the layout of the calculator.
**Labor Burden Calculator**
HWIT would like to covert an Excel based calculator into an online calculator built using Flash 8 or earlier technology.
Compiled SWF file compatible with the following browsers
FLA file and associated external file (XML or TXT and CSS)
Internet Explorer 6 and 7
Firefox 2 and 3 (Mac and PC)
Safari 2 (Mac Only)
The default numeric values should be contained in an external XML or TXT file that can be edited within modifying the SWF.
HWIT will maintain all rights to compiled assets and source code.
The attached graphics file is a “wireframe??. It is not meant to reflect the final look and feel. The bidder will need to submit a design based on the wireframes before Flash development work can begin. The colors used in the calculator should be pulled from an external CSS file which can be modified without recompiling the SWF.
The maximum horizontal dimension is 570 pixels.
Please assume 2-3 rounds of design feedback. Feedback from HWIT will occur within 24 hours.
Take design cues from the following calculators
1. NY Times <[url removed, login to view]>
2. <[url removed, login to view]>
Description of the calculator
Default values, max and min
Tables? Health ??" come up with default value or table with PPO for family vs individual. What % does the company pay.
Comparison Calculator:Run the calculator twice and show side results.
What is Labor Burden? For a single person, not all employees
Sal will write short description. Fringe benefits, total compensation, fully burdened, cost of employees, use these terms for SEO reasons, cost above wages.
What to charge for employees, hourly billing rates
Make general enough for any small business
We need short 1-2 sentence descriptions for the following terms to show in pop up Help Text. Here is an example for Health Care. Include a dollar figure, % and if it’s yearly or monthly as well as a description.
1. Health Care: Enter the total dollar cost of the employee’s yearly health care benefits.
2. Companies’ % of Health Care
3. FICA Wage Limits
4. FUTA wage limits
5. SUTA Wage Limits
9. Worker’s Compensation
10. G/L insurance
11. Picnics and Parties
13. Sick Personal Days
14. Company Meetings
16. Vehicle Maintenance and Insurance
18. Profit Share/Pension/401k
19. Additional Bonus
20. Advanced Settings
21. Labor Burden as % of wages
22. Cost per billable hour
23. Billable hours
24. Annual gross wages
25. Total labor burden
26. Total annual burdened cost
The following outlines general functionality of the calculator.
**Sliders**: Sliders allow values to be entered into the text entry box when they are present. The slider can be overridden by the user when they hand enter an exact value into the entry box. The override values entered can be OUTSIDE the normal min/max of the slider.
**Entry Fields**: Data entered into a field overrides the values input by the slider. If a default value is present in the field it will disappear when the user clicks on the field. The user will not need to highlight and erase the value.
* **Dollar fields** will automatically have a $ before the value. Text Values are not permitted. The value should work with or without a comma in the numeric values. An error message should be presented if letters are entered which reads “Please enter numeric values into this field.??
* **Percentage fields** should have a % after the value and be limited to three decimal places. Must be able to put decimal value for percentage to second decimal place.
**(?) Icon**: When a user clicks on a (?) icon a pop up block of text will appear explaining the term. The definitions to display are provided in this document.
The flash object is printable with current values entered by the user.
Result recalculate as they are entered AND when the “calculate?? button is pressed. Recalculation should occur 1 second after the last keypress so that the user can finish entering their numeric value.
**Equations and Calculations**
The equations and calculations are in the Excel file provided. ONE DIFFERENCE: The calculator introduces one new field that must be accounted for. This is “Health Insurance % paid by company??.
**Employee Name**: This is an optional field that does not play a part in the calculation, but should be shown if the calculator is printed.
**Base Pay Area** (Upper Left)
The calculator calculates based on “Yearly?? OR “Hourly?? rates. The radio button allows the user to choose between these two modes. The Excel document takes this into account. In the calculator the entry box for the selection NOT chosen should disappear. For example: If “Yearly Salary?? is chosen then the text entry box and the “per hour?? label should disappear. The opposite is true if the “Hourly Wage?? radio button is chosen.
The slider should remain in either case but the values it enters will change.
* Yearly Salary: min $10,000 max 150,000 In $1000 increments.
* Hourly Wage: min $5 max $250. In $5 increments.
The values can be either hand entered or entered by using the slider. Values outside the normal min/max can be entered by hand.
The advanced setting has three clickable objects. These default values are stored in an external XML or TXT file so they can be reset without recompiling the SWF.
FICA: When FICA is clicked a pop up appears with a brief explanation of what FICA is and two text entry boxes with values that can be modified. The two entry fields and their defaults are
1. FICA: [url removed, login to view]%
2. FICA Wages Limit: $110
FUTA: When FUTA is clicked a pop up appears with a brief explanation of what FUTA is and two text entry boxes with values that can be modified. The two entry fields and their defaults are
1. FUTA: 0.8%
2. FUTA Wages Limit: $900
SUTA: When SUTA is clicked a pop up appears with a brief explanation of what SUTA is and two text entry boxes with values that can be modified. The two entry fields and their defaults are
1. SUTA: [url removed, login to view]%
2. SUTA Wages Limit: $15,000
This area has default values that can be overridden by the user.
**Labor Burden Results Area**
When the calculator initially loads this area contains simple instructions on the use of the calculator. When values are entered or the calculate button is pressed the are then begins to show the calculated results.
If pie chart is possible we would like that.