Types of property taxes, The city currently levies five

Types of property taxes

Assignment Help Project Management

Reference no: EM133337263

Assignment:

Goal Programming Application

This problem is based on the following research article that you must read. "Multi-objective Linear programming Methodology for Public Sector Tax Planning," by James Chrisman, Timothy Fry, Gary Reeves, Holly Lewis, and Robert Weinstein, Interfaces Vol. 19, No. 5, (1989) pp. 13 - 30.

Suppose that you have been hired by the city council of Peoria, Illinois to help them meet their overall tax goals. Suppose the city government came up with the following four goals listed below in order of descending of priority:

1. Limit the tax burden on Lower Income (LI) people to 1.75 billion.

2. Keep the property tax rate at 1%.

3. Minimize the "flight to the suburbs" by keeping the tax burden on Middle Income (MI) people,

less than $2.5 billion and keeping the tax burden on High Income (HI) people to less than 2.25 billion.

4. Try to eliminate the food and drug sales tax if possible.

The city currently levies five types of taxes: (a) property taxes (where p is the tax rate). (b) sales tax on general items except on food and drug and durable goods (where s is the general tax rate), (c) sales tax on food and drugs (where f is the tax rate on food & drug), (d) sales tax on durable goods (where d is the sales tax on durable goods), and (e) gasoline tax (where g is the gasoline tax rate).

Relevant information on revenue generated by a 1% tax is provided in the table seen below

Assume that 10% of the LI people will move out of the city into the suburbs if their tax burden exceeds 1.75 billion, 20% of MI people will move out of the city into the suburbs if their tax burden exceeds 2.5 billion, and 30% of HI people will move out of the city into the suburbs if their tax burden exceeds 1.25 billion. You must work within the following "hard" constraints:

The sales tax must be between 1% and 3%, as indicated in the accompanying research article.
The total revenue raised must exceed the current level of $6.0 billion.
The tax burden on the HI people can't exceed $1.5 billion
The tax burden on the MI people can't exceed $3.0 billion

Build an Excel Model to model the problem and answer the following questions (provide a model template of each question).

(a) Use goal programming proposed in the article to formulate this model (hint: you can learn from and modify the model of the article to answer this question).

(b) From your proposed model solution, stated which goals can be satisfied?

Reference no: EM133337263

Questions Cloud

Explain approaches to managing dysfunctional conflict : What could Susan do resolve the situation. Your answer should use an appropriate conflict for managing conflict.

What might your r&d dollars be spent toward : Assume you're approaching the marketplace with a broad differentiation strategy based upon speed. What might your R&D dollars be spent toward?

Developing an online banking system : Fundamental Software Testing Principles, identify most important principle in uncovering defects when testing a software application using automation testing.

Key component of process improvement : Self-reflection is a key component of process improvement as both a project manager and a leader of technical teams.

Types of property taxes : The city currently levies five types of taxes: (a) property taxes (where p is the tax rate). (b) sales tax on general items except on food and drug.

Discuss any 2 management issues using appropriate example : Matching organisational structure with strategy is one of the key management issues in strategy implementation. Discuss any TWO (2) management issues using

Read a report on hot consumer trends for the next decade : As project manager for a new product development project, you read a report on hot consumer trends for the next decade.

Identify and assess the planning premises for bongani : Identify and assess the planning premises for Bongani's new clothing boutique.Bongani is the owner of a new clothing boutique, which is almost ready to open

Explain why the conclusions of the production manager : Explain what apparently caused the drop in cost from P7.00 per unit to P6.25 per unit when budgeted production increased from 50,000 to 80,000 units.

User Account

All Pages