You€™ve been hired by the nation of Utopia to computerize its approach to calculating taxes. Utopia€™s progressive tax system contains only two brackets that are applicable to all households. These are as follows.
Income ..... Rate
Under $30,000 ..20%
Over $30,000 ....30%
The treatment of personal exemptions and itemized deductions is similar to the U.S. system, but the exemption amount is permanently fixed at $2,550 per person. No special consideration is given to capital gains and losses or dividends.

Write a spreadsheet program to compute taxes for a typical Utopian household.
Test your program with the following cases.
Verify that your program works by calculating the Utopian taxes manually.

Transcribed Image Text:

$28,950 Income Number of people Deductions $96,250 5 $14,457 2,800