Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

This assignment is about presenting a budget to the legislature and defending it through an excel, power point and word where needed. Use the tables to obtain information

1 answer below »
© Word Microsoft © X |g GrandCanyonUn X @ chen2ebudgel X | StudentPortal|l x | @) ADM626Calend: x | PB https/wawedus x | {Jl Documentsoss7 x | + vo o_o| x

Qa < x »@ 0:
C @ viewer.geu.edu/HGAI





178 of 384
ubmitted to the legislature (meaning the city council, county board of supervi-
slature) to review, act on, and appropriate money for. When the written budget
is submitted, often the executive or a senior official will deliver an oral presentation to the legis-
lature. After the executive delivers the budget, the legislature schedules hearings. During these
hearings, heads of budget units (agencies and departments) are asked to testify about thei
department's budget. They may also be asked to provide material including written testimony to
contribute to a
iefing book.







1. Based on the data in Tabl create totals for each funding source while still showing
the departments associated with each funding source. (Hint: Subtotals and/or pivot tables are
good tools to help you accomplish this in Excel.)
LeGisLative Bupcer Tools

2. Based on the data in Tablef16.2, { 70
eate totals for each funding source Pam artianmte Evmnm
@MBQ xa 2 e m2 B Ar 92500 @0


© Word [Microsoft © X | x Grand CanyonUn X @ chenebudget X | | StudentPortal |i X | @ ADM626 Catend: x | |B ttps/wwwedur x | ll Documents09s7: x | +

C @ viewer.geu.edu/HGAI



®)
(©)
(d)

v =
Qa < x »@ 0:

Capital General Fund 13,363,748
Services Capital Fund 59,849,210
ad all the material on a the “slide.
Prepare a ve
al
iefing of no more than 10 minutes







h r . wy Capital Capital Fund 314,681,043
that reviews the background of the issue, identifies personnel Special Revenue XXXXXXXXXX
why it must be addressed, describes what your pro-J| Services Special Revenue ~~ 325,577,585

posal will do to address the issue, and gives the
amount of your budget request.
Prepare a one-page summary,
with 1inch margins and 12-point
font, that provides the highlights
of your issue and proposal. This
Capital Special Revenue 34,759,758

es by Department and Program
may be the only document a leg- pepartment and Program Expenditure (5)
islator reads on your issue and Goregiong inmate Substance Abuse Recovery 557,850
equest. Co
ections Inmate Education XXXXXXXXXX
Prepare a more thorough fre- Co
ections Inmats Intake and Release XXXXXXXXXX
quently asked questions (FAQ) Co
ections Inmate Housing XXXXXXXXXX
document that could be used Comectons Information and Communications XXXXXXXXXX
Technology
y the department director giv- Troopers Dispatch 2,604,257
ing the
iefing, a legislator hear- Troopers Disaster Response 2,167,148
ing the information, or you as you Troopers Enforcement Support XXXXXXXXXX
give the
iefing to answer ques- Troopers Investigations 1,678,722
tions that require a little more Troopers Patrol XXXXXXXXXX
Troopers Administration XXXXXXXXXX
explaining.
This assignment is about n ok, < D 157
presenting a budget to the exp e (+.
legislature for consideration
through power point, excel and
word where necessary or told .
OMBbQaoao ze 10

Apr29

92700 0

© Word Microsoft © X |g GrandCanyonUn X @ chen2ebudgel’ X | StudentPortal|l: X | @) ADM626Calend: x
presenting a budget to the exp e (+.
legislature for consideration
through power point, excel and
word where necessary or told
to follow by a
ief statement.
Not much wo
ies: just:dosyou
est.
A nttps
www.edu: x | lf Documento09e7! x | + vo _ B x

Qa
% »@0
& viewer gou.edu/HGA!



BunGET TOOLS
Arizona Legislative Council XXXXXXXXXXArizona legislative manual. Retrieved from http:
www
azleg.gov/alispdfs/Council/legman2003.pdf.

Additional Readings
Cu
ie, J. T XXXXXXXXXXTestifying on the Hill: A guide to survival. Fort Belvoir, VA: Defense Technical
Information Center.

Goodman, D., & Clynch, E. J XXXXXXXXXXBudgetary decision making by executive and legislative
udget analy impact of political cues and analytical information. Public Budgeting &
Finance, 24(3)
Grabe
D. A XXXXXXXXXXThe power of communication: Managing information in public organizations.
hington, DC: CQ Press.
B XXXXXXXXXXHearings in the U.S. Sena
Palm A guide for preparation and procedure. In

J.B. Cattler & C. M. Rice (Eds.), Senate of the United States: Committees, rules, and procedures
(Pp

52). New York, NY:
Sachs, R. C XXXXXXXXXXHe:
cedure. In CRS Report for C
Sache RC (9007 Hoa
® © MB 0 CO + e Bl B Ar 92700 ®0

ova Science.

the House of Representatives: A guide for preparation and pro-
ngress (p. 27). Washington, DC: Congressional Research Service.
s in the 11S Senate: A auide for nrenaration and nracedire (RS

© Word Microsoft © X |g GrandCanyonUn X @ chen2ebudgel’ X | StudentPortal|l: X | @) ADM626Calend: x
presenting a budget to the exp e (+.
legislature for consideration
through power point, excel and
word where necessary or told
to follow by a
ief statement.
Not much wo
ies: just:dosyou
est.
A nttps
www.edu: x | lf Documento09e7! x | + vo _ B x

Qa
% »@0
& viewer gou.edu/HGA!



BunGET TOOLS
Arizona Legislative Council XXXXXXXXXXArizona legislative manual. Retrieved from http:
www
azleg.gov/alispdfs/Council/legman2003.pdf.

Additional Readings
Cu
ie, J. T XXXXXXXXXXTestifying on the Hill: A guide to survival. Fort Belvoir, VA: Defense Technical
Information Center.

Goodman, D., & Clynch, E. J XXXXXXXXXXBudgetary decision making by executive and legislative
udget analy impact of political cues and analytical information. Public Budgeting &
Finance, 24(3)
Grabe
D. A XXXXXXXXXXThe power of communication: Managing information in public organizations.
hington, DC: CQ Press.
B XXXXXXXXXXHearings in the U.S. Sena
Palm A guide for preparation and procedure. In

J.B. Cattler & C. M. Rice (Eds.), Senate of the United States: Committees, rules, and procedures
(Pp

52). New York, NY:
Sachs, R. C XXXXXXXXXXHe:
cedure. In CRS Report for C
Sache RC (9007 Hoa
® © MB 0 CO + e Bl B Ar 92700 ®0

ova Science.

the House of Representatives: A guide for preparation and pro-
ngress (p. 27). Washington, DC: Congressional Research Service.
s in the 11S Senate: A auide for nrenaration and nracedire (RS
© Word Microsoft © X |g GrandCanyonUn X @ chen2ebudgel X | StudentPortal|l x | @) ADM626Calend: x | PB https/wawedus x | {Jl Documentsoss7 x | + vo o_o| x
Qa
% »@0
8 viewer.geu.edu/HGA
Note to the expert: This
assignment is about how
to present and defend a
udget to the legislature.
Look in the tables to get
the information to enable
you to answer the
questions. Just do you
est and answer the
qégStions by using powe
point, excel and word
where-needed-oras
equired. No stress.
® © MB 0 CO + e ©. BB m2» XXXXXXXXXX




=






KR




LEGISLATIVE Bunce TooLs
1
Answered 3 days After Apr 29, 2023

Solution

Sandeep answered on May 02 2023
35 Votes
Sheet1
                                        (value in $)
        Table 16.1    Departments
        Particulars    Administration    Attorney    Co
ections    Courts    Education    Transportation    Troopers    Total For Funding Source
    Funding Source    General Fund    51,860,554.00    71,441,747.00    42,410,651.00    77,109,840.00    62,328,934.00        86,584,089.00    391,735,815.00
        Special Source Funding     35,320,649.00    22,287,191.00    40,613,139.00    17,093,360.00    2,260,912.00    106,871,908.00    211,573,117.00    436,020,276.00
        Capital    388553192                    82089011        470,642,203.00
        Totals    475,734,395.00    93,728,938.00    83,023,790.00    94,203,200.00    64,589,846.00    188,960,919.00    298,157,206.00    1,298,398,294.00
        Table 16.2                (value in $)
        Particulars    Personnel    Services     Capital     Total For Funding Source
    Funding Source    General Fund    446,941,184.00    560,931,401.00    13,363,748.00    13,363,748.00
        Special Source Funding     0.00    59,849,210.00    314,681,043.00    59,849,210.00
        Capital    452,049,638.00    325,577,585.00    34,759,758.00    486,809,396.00
        Totals    452,049,638.00    59,849,210.00    362,804,549.00    560,022,354.00
Sheet2
        Table...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here