$944\mathrm{.}001020\mathrm{.}00$

$7891725\mathrm{.}000\mathrm{.}00725\mathrm{.}00100\mathrm{.}00625\mathrm{.}00$

Second, you need to formulate and show your test plan. In other words, how do you know that the output of the program is correct?

Finally, are there any errors in the logic of the program that were found by using the test plan? If there were, what were they and what needs to be done to fix the program?

NOTE: There are different approaches to doing this. The brute force method would be to write down the variables and update these are you trace through each step of the program. Using this method, when you get to the end you should have the values that will be entered into the table. Make sure you take into account the two ways that an employee can get overtime.

Employee Number

Regular Pay

OT Pay

Gross Pay

Taxes Due

$5555$

$994\mathrm{.}00$

$100\mathrm{.}00$

$1094\mathrm{.}00$

$150\mathrm{.}00$

$1234$

$950\mathrm{.}00$

$250\mathrm{.}00$

$1200\mathrm{.}00$

$180\mathrm{.}00$

Statement of the Problem

I have a small company with $20$ employees. I need a payroll system that calculates the pay and taxes for each employee. I have the following input files:

Employee Data $$ Contains the employee information with their hourly pay rate.

Tax Table $$ A lookup table that specifies the taxes to be withheld for ranges of values, starting at zero and ending at $2,500\mathrm{.}00.$

Time Card Data $$ Each line is a sum of the hours that the employee worked each day.

Employees can also earn overtime

If the total hours in a day is more than $8,$ the OT rate is $1\mathrm{.}5$ times their hourly rate.

If the total hours in a week is more than $40,$ the OT rate is $1\mathrm{.}5$ times their hourly rate. $($Saturday is a regular work day and OT is only counted if it meets one or both of the above conditions$).$

After processing, I need an output file called Weekly Payroll. There should be one line in the

file for

$$

each employee that contains these fields:

Employee Number

Regular Pay $($earnings without overtime$)$ OT Pay $($overtime earnings$)$

Gross Pay $($total pay due$)$

Taxes Due $($value from lookup$)$

Net Pay $($Gross $$ Taxes$)$

Example:

$5555994\mathrm{.}00100\mathrm{.}001094\mathrm{.}00150\mathrm{.}00$

Net Pay $944\mathrm{.}00$

Employee Number

Regular Pay

OT Pay

Gross Pay

Taxes Due

Note: Employees are scheduled on an as needed basis and employees may have zero hours for the week.

TEST DATA INPUT FILES

Employee Data EmployeeNumber EmployeeName HourlyRate

Time Card Data

EmpNum DayofWeek TotalDailyHours

$1101$ MON $81998$ MON $82945$ MON $85304$ MON $86447$ MON $76614$ MON $107886$ MON $108356$ MON $108466$ MON $101101$ TUE $81998$ TUE $82945$ TUE $85304$ TUE $86447$ TUE $76614$ TUE $107886$ TUE $88356$ TUE $88466$ TUE $101101$ WED $81998$ WED $82945$ WED $85304$ WED $86447$ WED $76614$ WED $107886$ WED $88356$ WED $88466$ WED $81101$ THU $81998$ THU $82945$ THU $85304$ THU $86447$ THU $97886$ THU $88356$ THU $88466$ THU $81101$ FRI $82945$ FRI $85304$ FRI $86447$ FRI $107886$ FRI $88356$ FRI $88466$ FRI $102945$ SAT $85304$ SAT $47886$ SAT $88356$ SAT $4$

Please provide a table of the program output and a test plan that shows how you verified the program output and a statement of any logic errors found and how to correct them