Loading...
HomeMy WebLinkAboutReso 47-20 Resolution of Intention TBID AssessmentFY 20-21 Budget WorksheetG/L Account Number Account Description 2018 Actual Amount 2019 Actual Amount2020 Actual Amount as of 3/3/202020 Amended Budget 2021 Level 1007-3170 3400 Advertising - Guides and Magazines 4,293.5000 4,894.1300 949.6200 0.0000 0.0000$4,293.50 $4,894.13 $949.62 $0.00 $0.00007-3170 3990 Other Misc Revenues 0.0000 32,388.0000 0.0000 0.0000 0.0000$0.00 $32,388.00 $0.00 $0.00 $0.00$4,293.50 $37,282.13 $949.62 $0.00 $0.00007-3510 3064 Transient Occupancy Tax 802,877.2500 829,289.2200 489,298.0900 823,644.0000 550,000.0000$802,877.25 $829,289.22 $489,298.09 $823,644.00 $550,000.00$802,877.25 $829,289.22 $489,298.09 $823,644.00 $550,000.00007-7710 3801 Transfers In 125,428.0000 145,837.0000 60,000.0000 60,000.0000 0.0000$125,428.00 $145,837.00 $60,000.00 $60,000.00 $0.00007-7710 3802 Intrafund Revenue Transfers 0.0000 65,000.0000 0.0000 0.0000 0.0000$0.00 $65,000.00 $0.00 $0.00 $0.00$125,428.00 $210,837.00 $60,000.00 $60,000.00 $0.00$932,598.75 $1,077,408.35 $550,247.71 $883,644.00 $550,000.00007-1111 8710 Loss on Investment 590.0000 0.0000 0.0000 0.0000 0.0000$590.00 $0.00 $0.00 $0.00 $0.00$590.00 $0.00 $0.00 $0.00 $0.00007-3170 4110 Regular Pay 85,268.9000 91,740.8600 60,070.3400 95,451.0000 0.0000007-3170 4310 Part-Time Pay 50,270.5700 49,730.6000 40,468.5000 69,136.0000 22,880.0000007-3170 4599 Other Pay 0.0000 2,040.4800 2,098.0800 1,500.0000 0.0000007-3170 4910 Employer Paid Benefits 37,955.8800 30,136.1000 20,926.0800 27,414.0000 1,299.5100007-3170 4911 Pension Normal Cost 0.0000 6,054.4900 4,310.5900 6,667.0000 0.0000007-3170 4912 PERS Unfunded Accrued Liability 0.0000 14,600.4900 17,725.2500 18,919.0000 0.0000007-3170 4913 Other Post Employment Benefit (OPEB) Expense 0.0000 1,163.7100 0.0000 0.0000 0.0000$173,495.35 $195,466.73 $145,598.84 $219,087.00 $24,179.51007-3170 5110 Fuel Oil & Lubricants 0.0000 0.0000 22.3700 0.0000 0.0000007-3170 5201 Other Expense 1,255.8800 0.0000 0.0000 0.0000 0.0000007-3170 5301 General Office Supplies 3,974.1000 4,628.9400 2,923.5600 0.0000 1,000.0000007-3170 5302 Copying Supplies 0.0000 0.0000 0.0000 3,000.0000 2,000.0000007-3170 5305 Forms Printing 0.0000 244.4900 429.9700 500.0000 200.0000$5,229.98 $4,873.43 $3,375.90 $3,500.00 $3,200.00007-3170 6105 Consulting Services 18,130.1900 12,500.1000 13,308.5000 11,600.0000 14,000.0000007-3170 6106 Contractual Services 193,013.5900 282,426.7200 109,808.5700 165,000.0000 0.0000007-3170 6107 Promotion & Advertising 229,265.0500 50.0000 17,399.4700 12,000.0000 0.0000007-3170 6108 Marketing Consulting 15,870.4800 43,250.5100 0.0000 0.0000 0.0000007-3170 6113 Print Ads - So. Region 0.0000 0.0000 0.0000 4,500.0000 0.0000007-3170 6114 Community Event Support 85,547.5800 105,806.1800 46,756.2400 50,000.0000 8,000.0000007-3170 6116 Print Ads - Other Regions 3,650.0000 0.0000 0.0000 0.0000 0.0000Account Classification Total: 110-Other - Other ExpenseDepartment Total: 1111 - Undistributed/Non-Dept.Department: 3170 - Promotion & Advertising10-Personnel - Personnel ServicesAccount Classification Total: 10-Personnel - Personnel Services60-Supplies - SuppliesAccount Classification Total: 60-Supplies - Supplies70-Services - Services110-Other - Other ExpenseAccount Classification Total: 300-Rev Taxes - Revenues From TaxesDepartment Total: 3510 - Accounting & TreasuryDepartment: 7710 - Interfund Transactions100-Interfund - Interfund TransfersAccount Classification Total: 100-Interfund - Interfund Transfers380-Interfund - Interfund Revenue TransfersAccount Classification Total: 380-Interfund - Interfund Revenue TransfersDepartment Total: 7710 - Interfund TransactionsREVENUES TotalEXPENSESDepartment: 1111 - Undistributed/Non-Dept.300-Rev Taxes - Revenues From TaxesCity of Morro BayFund: 007 - MBT-BIDREVENUESDepartment: 3170 - Promotion & Advertising350-Rev Cursvc - Revenues From Current ServicesAccount Classification Total: 350-Rev Cursvc - Revenues From Current Services390-Misc Rev - Miscellaneous RevenuesAccount Classification Total: 390-Misc Rev - Miscellaneous RevenuesDepartment Total: 3170 - Promotion & AdvertisingDepartment: 3510 - Accounting & Treasury FY 20-21 Budget WorksheetG/L Account Number Account Description 2018 Actual Amount 2019 Actual Amount2020 Actual Amount as of 3/3/202020 Amended Budget 2021 Level 1City of Morro Bay007-3170 6118 Promotion - Media 81,982.4000 13,137.3200 580.0100 8,000.0000 1,000.0000007-3170 6119 Promotion - Other 17,603.1300 14,868.1800 12,922.8200 13,000.0000 0.0000007-3170 6120 Trade Shows - Space Rent 6,654.4000 5,369.7300 0.0000 7,600.0000 0.0000007-3170 6121 Trade Shows - Trans. 3,203.0000 0.0000 0.0000 500.0000 0.0000007-3170 6124 Advertising Sponsorships 30,827.0000 21,157.5000 0.0000 13,000.0000 27,200.0000007-3170 6125 Professional Development 0.0000 0.0000 0.0000 500.0000 0.0000007-3170 6127 Digital Media 0.0000 281,712.2800 190,535.5200 272,000.0000 214,000.0000007-3170 6128 Out of Home Media 0.0000 9,800.0000 3,659.3000 6,600.0000 6,600.0000007-3170 6129 Digital Services 340.9800 24,694.7500 28,594.2700 45,000.0000 58,000.0000007-3170 6130 Digital Assets 49.0000 2,406.9700 1,958.0000 0.0000 1,000.0000007-3170 6132 Promotion - Visiting Journalist 2,349.4500 19,118.1000 11,513.9200 10,000.0000 0.0000007-3170 6199 Other Professional Services 14,799.0000 6.4900 0.0000 500.0000 0.0000007-3170 6201 Telephone 89.7100 1,435.1400 958.8900 0.0000 0.0000007-3170 6220 Postage 3,867.6400 630.1400 1,189.2600 700.0000 100.0000007-3170 6300 Utilities 1,747.9100 0.0000 0.0000 0.0000 0.0000007-3170 6308 Internet/Cable TV 0.0000 890.9300 0.0000 2,000.0000 0.0000007-3170 6451 Workers Comp Insurance 0.0000 0.0000 0.0000 1,200.0000 0.0000007-3170 6461 Unemployment Insurance 0.0000 0.0000 0.0000 900.0000 0.0000007-3170 6510 Meetings & Conferences 2,870.4300 3,663.2100 2,332.5400 2,000.0000 0.0000007-3170 6511 Mileage Reimbursement 19.5500 0.0000 0.0000 500.0000 0.0000007-3170 6513 Meals & Lodging 3,722.9500 1,995.8000 0.0000 4,500.0000 0.0000007-3170 6514 Travel Expense 1,232.7300 1,629.0500 98.0200 2,000.0000 0.0000007-3170 6519 Association Membership 2,226.6700 1,195.0000 1,195.0000 1,500.0000 1,200.0000$719,062.84 $847,744.10 $442,810.33 $635,100.00 $331,100.00$897,788.17 $1,048,084.26 $591,785.07 $857,687.00 $358,479.51007-7710 8501 Transfers Out 19,482.5400 20,204.5300 18,215.1500 31,394.0000 25,827.0000$19,482.54 $20,204.53 $18,215.15 $31,394.00 $25,827.00$19,482.54 $20,204.53 $18,215.15 $31,394.00 $25,827.00$917,860.71 $1,068,288.79 $610,000.22 $889,081.00 $384,306.51$932,598.75 $1,077,408.35 $550,247.71 $883,644.00 $550,000.00$917,860.71 $1,068,288.79 $610,000.22 $889,081.00 $384,306.51$14,738.04 $9,119.56 ($59,752.51) ($5,437.00) $165,693.49Fund Total: 007 - MBT-BIDAccount Classification Total: 100-Interfund - Interfund TransfersDepartment Total: 7710 - Interfund TransactionsEXPENSES TotalFund REVENUE Total: 007 - MBT-BIDFund EXPENSE Total: 007 - MBT-BID100-Interfund - Interfund TransfersAccount Classification Total: 70-Services - ServicesDepartment Total: 3170 - Promotion & AdvertisingDepartment: 7710 - Interfund Transactions