Question: Please show formulas in excel. Calabrese City allocates some indirect or overhead costs to each of its police stations. The city charges each station for

Please show formulas in excel.

Calabrese City allocates some indirect or overhead costs to each of its police stations. The city charges each station for common services such as the city food service and for administrative services, such as payroll. For the coming year, the Washington Square Police Station will have a total budget allocation of $1,400,000. That will be its only revenue. All direct and indirect charges have to be paid from that budgeted amount. Each police station must pay $100,000 for processing of its payroll. In addition, once arrests are made, the prisoners spend a day or two at the local police station, where the city must feed them. On average, the city food service charges each police station $40 for meal service for each arrest. The station would like to maximize its number of arrests to reduce the number of criminals on the street. However, more arrests require not only more food, but also more police officers. The personnel employed by the Washington Square Station are supervisors, desk clerks and police officers. The minimum staffing levels based on total budgeted arrests are as follows: Annual salaries for each class of employee are as follows: supervising officer $68,500; desk clerks, $59,000; and police officers, $54,000. Note that this police station cannot process more than 4,000 arrests per year due to size.

Calculate the surplus or deficit at each maximum annual number of arrests staffing levels (1,000; 2,000; 3,000, and 4,000).

Calculate the maximum number of arrests that Washington Square can budget for and still expect to break even for the coming year.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!