Assignment:
You are an accountant setting up a payroll system for a small firm. Each line of the table in Appendix G indicates an employee’s salary range and corresponding base tax amount and tax percentage. Given a salary amount, the tax is calculated by adding the base tax for that salary range and the product of percentage of excess and the amount of salary over the minimum salary for that range.
• Design a program that solves this problem
In the following example, the second line of the table specifies that tax due on a salary of $2000.00 is $225.00 plus 16% of excess salary over $1500.00 (that is, 16% of $500.00). Therefore, the total tax is $225.00 + $80.00, or $305.00.
|
|
Salary Range in Dollars
|
Base Tax in Dollars
|
Percentage of Excess
|
|
1. 1
|
0.00-1,499.99
|
0.00
|
15 %
|
|
2. 2
|
1,500.00-2,999.99
|
225.00
|
16 %
|
|
3. 3
|
3,000.00-4,999.99
|
465.00
|
18 %
|
|
4. 4
|
5,000.00-7,999.99
|
825.00
|
20 %
|
|
5. 5
|
8,000.00-14,999.99
|
1425.00
|
25 %
|
Provide complete and step by step solution for the question and show calculations and use formulas.