Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The city of Arlington is determining its tax rate structure for the coming year. The city needs to generate $ 6 million in tax revenue

The city of Arlington is determining its tax rate structure for the coming year. The city needs to generate $6 million in tax revenue via taxes of property, sales, prepared food, and utilities. The following table summerizes how much tax revenue would be generated from each segment of the population by the 1% increase in each tax category. (For instance. a 2% tax on prepared food would generate $240,000 in tax revenue from upper income residents.)
Revenues (in $1,000s) per 1% Tax Rate.
Income Group Sales Property Food Utility
Low $200 $600 $50 $80
Middle $250 $800 $100 $110
Upper $400 $1200 $130 $120
City commissioners have specified that the tax rate for each revenue category must be between 1% and 3% and the tax rate on prepared food cannot exceed half the sales tax rate. Ideally, the commissioners have a goal of making up the $6 million tax budget with $1.5million from low income residents, $2.1 million from middle income residents, and $2.3 million from high income residents. If that is not possible, the commissioners would like a solution that minimizes the maximum percentage deviation from these tax revenue goals for each income group.
a. Create a spreadsheet model for this problem.
b. What is the optimal solution?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And The Arts

Authors: William J. Byrnes

5th Edition

0415663296, 978-0415663298

More Books

Students also viewed these General Management questions