Please help me solve this linear programming question:

Question:

Write a procedure, tax, to calculate (to the nearest pound) the tax a person owes, depending on his/her income. Calculate the tax using this table:

Income Tax rates

Tax rate: Taxable income

Personal Allowance 0% : 0 to 11,850

Basic rate 20% : 11,850 to 46,350

Higher rate 40% : 46,350 to 150,000

Additional rate 45%: Over 150,000

The procedure should show

i) The salary,

ii) The tax rate,

iii) The amount of tax

iv) The amount left after tax and

v) Be able to deal with any input, valid or not.

Your tests of procedure should include the following values, which should be included in your final presentation.

1. tax (55,000)
2. tax (100,250)
3. tax (270,755)
4. tax (99500)
5. tax (237,570)
6. tax (-40,000)

Note: All stages of the work: the problem formulation, Excel spreadsheet work, interpretation, and documentation should be submitted.

Marking Scheme for Group Coursework:

For each procedure - 7 marks

For each tax calculation - 3 marks each total 15 marks

For negative tax and error message - 3 marks