A new president has just been elected and has set the following economic goals (listed from highest to lowest priority):  ■ Goal 1: Balance the budget (this means revenues are at least as large as...

A new president has just been elected and has set the following economic goals (listed from highest to lowest priority):

■ Goal 1: Balance the budget (this means revenues are at least as large as costs).


■ Goal 2: Cut spending by at most $150 billion.


■ Goal 3: Raise at most $550 billion in taxes from the upper class.


■ Goal 4: Raise at most $350 billion in taxes from the lower class.

Currently the government spends $1 trillion per year. Revenue can be raised in two ways: through a gas tax and through an income tax. You must determine G, the per-gallon tax rate (in cents); T₁, the tax rate charged on the first $30,000 of income; T₂, the tax rate charged on any income earned over $30,000; and C, the cut in spending (in billions). If the government chooses G, T₁, and T₂, then we assume that the revenue given in the file P09_15.xlsx (in billions of dollars) is raised. Of course, the tax rate on income over $30,000 must be at least as large as the tax rate on the first $30,000 of income. Use goal programming to help the president meet his goals