subject
Business, 28.07.2020 19:01 kana13

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: Limit the tax burden on Lower Income (LI) people to 1.75 billion. 1. Keep the property tax rate at 1%. 2. Minimize the "flight to the suburbs" by keeping the tax burden on Middle Income (MI) people 3. less than $2.5 billion and keeping the tax burden on High Income (HI) people to less than 2.25 billion. Try to eliminate the food and drug sales tax if possible. 4. The city currently levies five types of taxės: (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), (d) sales tax on durable goods (d is the sales tax on durable goods), and (e) gasoline tax (g is the gasoline tax rate). Relevant information on revenue generated by a 1% tax is provided in the table seen below Food & Drug Income Level Sales Durable Gasoline Property Low (LI) Middle (MI) High (HI) 300 200 50 120 400 450 125 30 80 1500 150 80 15 60 1200 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?

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 21:00
Following is a list of various costs incurred in producing replacement automobile parts. with respect to the production and sale of these auto parts, classify each cost as either variable costs, fixed costs, or mixed costs. 1. oil used in manufacturing equipment 2. plastic 3. property taxes, $165,000 per year on factory building and equipment 4. salary of plant manager 5. cost of labor for hourly workers 6. packaging 7. factory cleaning costs, $6,000 per month 8. metal 9. rent on warehouse, $10,000 per month plus $25 per square foot of storage used 10. property insurance premiums, $3,600 per month plus $0.01 for each dollar of property over $1,200,000 11. straight-line depreciation on the production equipment 12. hourly wages of machine operators 13. electricity costs, $0.20 per kilowatt-hour 14. computer chip (purchased from a vendor) 15. pension cost, $1.00 per employee hour on the job
Answers: 3
question
Business, 22.06.2019 08:00
Compare the sources of consumer credit(there's not just one answer)1. consumers use a prearranged loan using special checks2. consumers use cards with no interest and non -revolving balances3. consumers pay off debt and credit is automatically renewed4. consumers take out a loan with a repayment date and have a specific purposea. travel and entertainment creditb. revolving check creditc. closed-end creditd. revolving credit
Answers: 2
question
Business, 22.06.2019 22:20
Mattress wholesalers, inc. is constantly trying to reduce inventory in its supply chain. last year, cogs was $7.47 million and inventory was $1.47 million. this year, cogs is $8.65 million and inventory investment is $1.64 million.a) what was its weeks of supply last ) what is its weeks of supply this ) is mattress wholesalers making progress in its inventory reduction effort? since the number of weeks that cover the supply has mattress wholesalers is making in its inventory reduction effort.
Answers: 3
question
Business, 23.06.2019 11:40
Tony is a wheat farmer, but he also spends part of his day teaching guitar lessons, due to the popularity of his local country western band, farmer tony has more students requesting lessons than he has time for if he is to also maintain his farming business. farmer tony charges $25 an hour for his guitar lessons. one spring day, he spends 10 hours in his fields planting $130 with of seeds on his farm. he expects that the seeds he planted will yield $300 worth of wheat a. 130 b. 260 c. 170 d. $-80
Answers: 1
You know the right answer?
This problem is based on the following research article that you must read. "Multi-objective Linear...
Questions
question
World Languages, 03.07.2019 19:40
question
Mathematics, 03.07.2019 19:40
question
Mathematics, 03.07.2019 19:40