The City is in the process of reactivating its moving violation camera program to promote safer streets. The program was shut down in Fiscal 2015 due to technical issues. The first iteration of the new program includes the deployment of speed cameras located in the school and/or construction zones, to capture vehicles driving at least 12mph above the speed limit. Starting on January 1, 2022, the Citys Department of Transportation (DOT) is planning to deploy 100 cameras at a rate of 10 cameras per month. The cameras will be initially deployed at fixed locations; however, these cameras are equipped to be eventually moved. The annual fixed cost of the program is $60,000, plus an annual cost of $4,300 per camera. An additional $1,200 is assessed each time a camera is relocated. By State law, the fine for speed violations is $40. Moving violations tickets are normally received three weeks after the violation occurred and must be paid 30 days after the citation is received. The attached spreadsheetshows monthly issuance data from the prior moving violation program. During this 20- month period, the City was able to collect $5.2 million from speed camera violations(This data represents the full rollout of the original program.) DOT has full confidence that this new iteration of the program will not encounter any previously experienced technical or operational issues, and it would enable the City to increase the rate of collections by 10%

Questions

1- How much should the Fiscal 2023 Budget (July 1 2022 June 30 2023) include for Speed Camera revenues?

2- How to develop the revenue forecast.

3- Are there ways the City could maximize net profit (revenues minus operational costs) for the speed camera program?

Can you please help me to solve this questions.

EEE ST 986 266 378 156 ES 19 102 29 101 EST EET 116 09 1.615 065 Revenue Task - Moving Violation Data May 13 Jun 13 Jul-13 Aug 13 Sep-13 Oct-13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May-14 Jun-14 Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 180 251 520 402 415 661 389 475 372 483 423 1.539 370 2,760 3,127 283 248 217 3,420 3,346 190 166 145 4.972 2.568 2.594 3,465 3,629 2,752 2,774 3.201 3.1.20 2.730 2389 2.090 557 2.296 4,006 2 195 2.085 2.189 4,124 3,206 2,140 1,333 1,624 1.494 1,271 1.632 62 1,050 1,694 71 1,787 1.564 1.368 1.197 151 398 355 184 1,257 1.194 1.254 121 51 45 39 34 30 26 23 20 18 833 1,169 16 528 15 16 574 361 881 519 454 348 304 233 88 204 156 164 163 237 247 89 78 68 1,328 1,771 1,356 52 46 40 40 1,025 588 425 489 365 319 279 245 214 187 164 125 1,200 143 1.410 1,320 110 115 109 115 1,099 567 922 854 669 58S 512 448 392 1,009 343 300 263 230 1,010 201 211 201 211 724 713 435 545 477 417 365 319 280 245 214 187 164 302 172 203 163 172 337 222 270 455 282 247 216 189 165 145 127 111 97 8S 89 432 463 470 411 360 315 312 321 334 222 330 339 625 343 605 598 458 401 402 396 418 408 424 431 420 437 375 425 435 452 396 346 303 307 300 312 316 308 321 326 317 426 330 612 601 526 460 403 409 398 414 1,312 1,602 1,666 1.458 1.276 1.116 56 60 71 82 72 73 72 75 76 74 72 225 197 172 151 149 155 157 154 160 162 164 160 167 32 41 36 31 27 28 22 28 29 28 29 30 29 30 55 48 42 37 32 33 32 33 34 33 32 34 45 152 16 9 10 21 14 19 19 19 1.225 20 1,385 1,422 1,318 1.153 1.009 883 896 874 255 485 7,065 11.966 12,466 11,830 10,669 13,318 11.635 11,126 11,410 10.482 360 8,885 9,1329,1029,0529,1376,0887,8237,8087,292 7 317 SES Fixed Location 1 Fixed Location 2 Fixed Location 3 Fixed Location 4 Fixed Location Fixed Location 6 Fixed Location 7 Fixed Location & Fixed Location 9 Fixed Location 10 Portable Camera 1 Portable Camera 2 Portable Camera 3 Portable Camere 4 Portable Camera 5 Portable Camera 6 Portable Camera 7 Portable Camera Portable Camera 9 Portable Camera 10 58 SET 320 329 ETS 59 OL EST 09 EE SET 9 ST Indicates relocation of the cameras EEE ST 986 266 378 156 ES 19 102 29 101 EST EET 116 09 1.615 065 Revenue Task - Moving Violation Data May 13 Jun 13 Jul-13 Aug 13 Sep-13 Oct-13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May-14 Jun-14 Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 180 251 520 402 415 661 389 475 372 483 423 1.539 370 2,760 3,127 283 248 217 3,420 3,346 190 166 145 4.972 2.568 2.594 3,465 3,629 2,752 2,774 3.201 3.1.20 2.730 2389 2.090 557 2.296 4,006 2 195 2.085 2.189 4,124 3,206 2,140 1,333 1,624 1.494 1,271 1.632 62 1,050 1,694 71 1,787 1.564 1.368 1.197 151 398 355 184 1,257 1.194 1.254 121 51 45 39 34 30 26 23 20 18 833 1,169 16 528 15 16 574 361 881 519 454 348 304 233 88 204 156 164 163 237 247 89 78 68 1,328 1,771 1,356 52 46 40 40 1,025 588 425 489 365 319 279 245 214 187 164 125 1,200 143 1.410 1,320 110 115 109 115 1,099 567 922 854 669 58S 512 448 392 1,009 343 300 263 230 1,010 201 211 201 211 724 713 435 545 477 417 365 319 280 245 214 187 164 302 172 203 163 172 337 222 270 455 282 247 216 189 165 145 127 111 97 8S 89 432 463 470 411 360 315 312 321 334 222 330 339 625 343 605 598 458 401 402 396 418 408 424 431 420 437 375 425 435 452 396 346 303 307 300 312 316 308 321 326 317 426 330 612 601 526 460 403 409 398 414 1,312 1,602 1,666 1.458 1.276 1.116 56 60 71 82 72 73 72 75 76 74 72 225 197 172 151 149 155 157 154 160 162 164 160 167 32 41 36 31 27 28 22 28 29 28 29 30 29 30 55 48 42 37 32 33 32 33 34 33 32 34 45 152 16 9 10 21 14 19 19 19 1.225 20 1,385 1,422 1,318 1.153 1.009 883 896 874 255 485 7,065 11.966 12,466 11,830 10,669 13,318 11.635 11,126 11,410 10.482 360 8,885 9,1329,1029,0529,1376,0887,8237,8087,292 7 317 SES Fixed Location 1 Fixed Location 2 Fixed Location 3 Fixed Location 4 Fixed Location Fixed Location 6 Fixed Location 7 Fixed Location & Fixed Location 9 Fixed Location 10 Portable Camera 1 Portable Camera 2 Portable Camera 3 Portable Camere 4 Portable Camera 5 Portable Camera 6 Portable Camera 7 Portable Camera Portable Camera 9 Portable Camera 10 58 SET 320 329 ETS 59 OL EST 09 EE SET 9 ST Indicates relocation of the cameras