To start the payroll program development process, the team must establish a detailed plan encompassing

activities like gathering hours worked, computing taxes, and other related tasks. Each team member will be

allocated a section to execute the payroll program. It is crucial to verify all input data and highlight any

inconsistencies. For instance, if the regular work hours are $40$ hours per week, submitting $80$ hours would be

deemed atypical and must be handled accordingly. A minimum of ten test cases $($for which the team will

fabricate fictitious data$)$ should be utilized.

If you require assistance with getting started, consider outlining the necessary steps for gathering

information and performing calculations. Visualize utilizing an EXCEL Spreadsheet to input all

relevant details. Begin by gathering demographics, followed by creating calculations, and so forth.

Assign a team member to handle testing and ensure security measures are in place to prevent

inaccuracies in data entry. Your studies will cover testing procedures, so designate a responsible

individual for this task. Your team can peek ahead to see how you will be expanding your expertise

each week by previewing upcoming topics and incorporating them into your plan. Best of luck as

effective communication and coordination are essential for success.

You will need to include the following in your program.

$$ Entry of the employee's first and last name, ID$,$ number of dependents, hours worked.

$$ The hourly rate should be pulled from a database using the employee ID as the primary key.

$$ Calculate Gross Pay Amount

$$ Overtime will be calculated on hours over $40$ at $1\mathrm{.}5$ times the hourly rate.

$$ Calculate the number of dependents x $$25.$

$$ Calculate State Tax at $5\mathrm{.}6\%$