Chat with us, powered by LiveChat quick and easy excel spreadsheet: Utilizing the dataset to develop a Revenue /Expenditure spreadsheet in EXCEL | All Paper
+1(978)310-4246 credencewriters@gmail.com
  

ALSO ! can you answer
these questions: THIS IS DUE TOMORROW FRIDAY AT 11:59PM CENTRAL TIME IM FROM
CALIFORNIA 1.Did the department meet its goal of generating
revenues sufficient to cover direct expenditures for each of the years for
which data are available?2.Did the department adopt a balanced budget for
the current year? What issues might arise when defining a balanced budget?3.Are the department’s services public or
private goods? Discuss the reasons for your choice4.Given your preliminary projections, will the
department be able to adopt a balanced budget next year? If not, what options
does the department have to ensure that revenues meet expenditures?5.2 part question: Briefly describe what you
garnered by developing the Excel spreadsheet. Briefly describe what you valued
from your time in taking this course.6.Conclude the exam with providing a faith
integration piece for better understanding how biblical principles can help
guide decision makers when they have this type of information in hand.
20190425203215excel.pdf

20190425203216excel_exercise_1_1.xlsx

Unformatted Attachment Preview

DEVELOPMENT EXPENDITURE HISTORY
ACCOUNT
NUMBER
1−11−1110
1−11−1130
1−11−1120
1−11−1140
1−11−1150
1−12−1230
1−12−1240
2−22−2110
2−22−2220
2−22−2240
2−23−2310
2−23−2340
3−31−3110
3−31−3120
3−31−3150
3−31−3160
3−32−3210
3−32−3220
3−33−3310
3−33−3320
3−33−3330
3−34−3410
3−34−3420
3−35−3510
3−35−3520
3−35−3560
3−35−3570
3−35−3580
3−35−3590
3−37−3710
3−37−3720
3−37−3730
FUND: GENERL (101-401-4010-X-XX-XXXX)
SALARIES OF REGULAR EMPLOYEES
OVERTIME
SCHEDULED TEMPORARIES
LONGEVITY PAY
BILINGUAL PAY
GROUP HEALTH INSURANCE
CONTRIBUTIONS TO EMPLOYEE RETIREMENT
OFFICE SUPPLIES
OPERATING SUPPLIES
MOTOR VEHICLE FUEL
MOTOR VEHICLE REPAIR
MINOR EQUIPMENT
TRAINING
TUITION REIMBURSEMENT
ENGINEERING SERVICES
LEASE OF EQUIPMENT
TRAVEL EXPENSES
ADVERTISING AND LEGAL NOTICES
TELEPHONE BASIC LINE CHARGES
TELEPHONE-LONG DISTANCE
CELLULAR/MOBILE PHONES
BUILDING REPAIR AND MANTENANCE
MACHINERY AND EQUIPMENT MAINTENANCE
IT CHARGES
COURT FILING FEES
PROFESSIONAL LICENSES
DUES AND MEMBERSHIPS
MESSENGER AND MAIL
OTHER CONTRACTUAL
BUILDING CONSTRUCTION
MOTOR VEHICLE PURCHASES
OFFICE EQUIPMENT PURCHASES
FY2007-08
ACTUAL
EXP
$3,561,200
143,700
95,800
30,700
4,300
376,000
431,100
24,500
25,900
16,800
176,300
53,200
17,700
2,400
23,900
23,900
19,200
11,500
76,600
10,100
3,400
21,100
72,800
35,400
6,200
15,300
1,000
5,300
1,400
335,300
191,600
71,800
FY2008-09
ACTUAL
EXP
$3,774,900
152,300
101,500
32,500
4,600
398,500
456,900
26,000
27,400
17,800
186,800
56,400
18,800
2,500
25,400
25,400
20,300
12,200
81,200
10,700
3,600
22,300
77,200
37,600
6,600
16,200
1,000
5,600
1,500
355,400
203,100
76,200
FY2009-10
ACTUAL
EXP
$3,963,600
159,900
106,600
34,100
4,800
418,500
479,800
27,300
28,800
18,700
196,200
59,200
19,700
2,700
26,700
26,700
21,300
12,800
85,300
11,200
3,700
23,500
81,000
39,400
6,900
17,100
1,100
5,900
1,600
373,100
213,200
80,000
FY2010-11
ACTUAL
EXP
$4,082,500
164,700
109,800
35,100
4,900
431,000
494,200
28,100
29,600
19,200
202,100
60,900
20,300
2,700
27,500
27,500
22,000
13,200
87,900
11,500
3,800
24,200
83,500
40,600
7,100
17,600
1,100
6,000
1,600
384,300
219,600
82,400
FY2011-12
ACTUAL
EXP
$4,184,600
168,800
112,600
36,000
5,100
441,800
506,500
28,800
30,400
19,700
207,100
62,500
20,800
2,800
28,100
28,100
22,500
13,500
90,000
11,800
3,900
24,800
85,500
41,600
7,300
18,000
1,100
6,200
1,700
394,000
225,100
84,400
FY2012-13
ACTUAL
EXP
$4,268,300
172,200
114,800
36,700
5,200
450,600
516,600
29,400
31,000
20,100
211,200
63,700
21,200
2,900
28,700
28,700
23,000
13,800
91,800
12,100
4,000
25,300
87,300
42,500
7,500
18,400
1,100
6,300
1,700
401,800
229,600
86,100
FY2013-14
ADOPTED
BUDGET
$4,319,500
174,300
116,200
37,200
5,200
456,000
522,800
29,700
31,400
20,300
213,800
64,500
21,500
2,900
29,000
29,000
23,200
13,900
92,900
12,200
4,100
25,600
88,300
43,000
7,600
18,600
1,200
6,400
1,700
406,700
232,400
87,100
FY2013-14
REVISED
ESTIMATE
$4,332,300
174,800
116,500
37,300
5,200
457,400
524,400
29,800
31,500
20,400
214,400
64,700
21,600
2,900
29,100
29,100
23,300
14,000
93,200
12,200
4,100
25,600
88,600
43,100
7,600
18,600
1,200
6,400
1,700
407,900
233,100
87,400
DEVELOPMENT REVENUE HISTORY
ACCOUNT
NUMBER
2-40-4120
2-40-4121
2-40-4122
2-40-4123
2-40-4124
2-40-4125
2-40-4126
2-40-4127
2-40-4128
2-41-4210
2-41-4220
2-41-4221
2-41-4222
2-41-4223
2-41-4224
2-41-4225
2-40-4129
2-41-4226
2-40-4130
2-42-4310
2-40-4131
2-40-4132
2-40-4133
2-40-4134
2-41-4227
2-40-4135
2-40-4136
2-41-4228
2-42-4311
2-41-4229
2-41-4230
2-41-4231
2-42-4312
2-42-4313
FUND: GENERL (101-401-4010-X-XX-XXXX)
TEMP ENCROACHMEMENTS
WRECKING/MOVING PMTS
HOUSE MOVERS PERMITS
CERTIFICATE OF OCCUPANCY
GAS WELL DRILLING PERMITS
PLUMBING BUS REGISTR
MECH LIC & REG
SIGN LIC & REG
TEMP POWER PERMITS
BOARD OF ADJUSTMENT
ZONING COMMISSION FEE
BED & BREAKFAST FEES
DEV PROC MANUAL
PLANNING COMMISSION
BUILDING PERMITS
ORDINANCE INSPECTION
ELECTRICAL PERMITS
ANNEXATION FEES
BILLBOARD REGISTRATION
ENCROACHMENT LETTERS
MECHANICAL PERMITS
PLUMBING PERMITS
THIRD PARTY-PLUMBING
THIRD PARTY-BUILDING
EXAMINATION FEES
SIGN PERMITS
RESID REMODEL PERMIT
BOARD APPEALS FEE
CONST CODE BOOK SALE
MOBILE HOME INSPECTION FEE
REINSPECTION FEES
AFTER HOURS FEE
MISCELLANEOUS REVENUE
MAP SALE REVENUE
FY2007-08
ACTUAL
REV
$137,000
$23,200
$2,100
$2,500
$24,900
$51,500
$70,600
$9,100
$8,300
$83,700
$161,900
$800
$12,500
$340,300
$3,486,000
$199,200
$257,300
$2,900
$6,200
$1,200
$91,300
$265,600
$3,700
$564,400
$6,600
$49,800
$14,900
$4,200
$20,800
$2,500
$5,000
$3,700
$10,000
$1,200
FY2008-09
ACTUAL
REV
$145,200
$24,600
$2,200
$2,600
$26,400
$54,500
$74,800
$9,700
$8,800
$88,800
$171,600
$900
$13,200
$360,700
$3,695,200
$211,200
$272,700
$3,100
$6,600
$1,300
$96,800
$281,500
$4,000
$598,300
$7,000
$52,800
$15,800
$4,400
$22,000
$2,600
$5,300
$4,000
$10,600
$1,300
FY2009-10
ACTUAL
REV
$152,400
$25,900
$2,300
$2,800
$27,700
$57,300
$78,500
$10,200
$9,200
$93,200
$180,100
$900
$13,900
$378,800
$3,879,900
$221,700
$286,400
$3,200
$6,900
$1,400
$101,600
$295,600
$4,200
$628,200
$7,400
$55,400
$16,600
$4,600
$23,100
$2,800
$5,500
$4,200
$11,100
$1,400
FY2010-11
ACTUAL
REV
$157,000
$26,600
$2,400
$2,900
$28,500
$59,000
$80,900
$10,500
$9,500
$96,000
$185,500
$1,000
$14,300
$390,100
$3,996,300
$228,400
$295,000
$3,300
$7,100
$1,400
$104,700
$304,500
$4,300
$647,000
$7,600
$57,100
$17,100
$4,800
$23,800
$2,900
$5,700
$4,300
$11,400
$1,400
FY2011-12
ACTUAL
REV
$160,900
$27,300
$2,400
$2,900
$29,300
$60,500
$82,900
$10,700
$9,800
$98,400
$190,200
$1,000
$14,600
$399,900
$4,096,200
$234,100
$302,300
$3,400
$7,300
$1,500
$107,300
$312,100
$4,400
$663,200
$7,800
$58,500
$17,600
$4,900
$24,400
$2,900
$5,900
$4,400
$11,700
$1,500
FY2012-13
ACTUAL
REV
$163,800
$27,800
$2,500
$3,000
$29,800
$61,600
$84,400
$10,900
$9,900
$100,200
$193,600
$1,000
$14,900
$407,100
$4,170,000
$238,300
$307,800
$3,500
$7,400
$1,500
$109,200
$317,700
$4,500
$675,100
$7,900
$59,600
$17,900
$5,000
$24,800
$3,000
$6,000
$4,500
$11,900
$1,500
FY2013-14
ADOPTED
BUDGET
$165,000
$28,000
$2,500
$3,000
$30,000
$62,000
$85,000
$11,000
$10,000
$100,900
$195,000
$1,000
$15,000
$410,000
$4,200,000
$240,000
$310,000
$3,500
$7,500
$1,500
$110,000
$320,000
$4,500
$680,000
$8,000
$60,000
$18,000
$5,000
$25,000
$3,000
$6,000
$4,500
$12,000
$1,500
FY2013-14
REVISED
ESTIMATE
$165,500
$28,100
$2,500
$3,000
$30,100
$62,200
$85,200
$11,000
$10,000
$101,200
$195,500
$1,000
$15,000
$411,100
$4,211,700
$240,700
$310,900
$3,500
$7,500
$1,500
$110,300
$320,900
$4,500
$681,900
$8,000
$60,200
$18,000
$5,000
$25,100
$3,000
$6,000
$4,500
$12,000
$1,500
FY 2013-14
Adopted Budget
FY2013-14
Revised Estimate
FY2014-15
Proposed Budget
Total Revenues
Total Expenditures
#REF!
#REF!
#REF!
Net
#REF!
#REF!
#REF!

Our essay writing service fulfills every request with the highest level of urgency.
attachment

error: Content is protected !!