Description
Because of COVID-19, Federal, State, and Local governments have been spending significant amounts of money to respond to the coronavirus pandemic. Some agencies are receiving more funds while others are being asked to cut back on their budgets.
Review ?The Budgetary Effects of Major Laws Enacted in Response to the 2020-21 Coronavirus Pandemic, December 2020 and March 2021
https://www.cbo.gov/system/files/2021-09/57343-Pandemic.pdf
If the agency you are working on IS listed in the article as receiving more funds, your job with this assignment is to INCREASE your budget to add in money from Appropriations (Taxes). For example, the Small Business Association (SBA) received $261 billion for PPP loans. This will mean hiring more staff to manage PPP applications and distribute the money, and more funds to give out to businesses.
If the agency you are working on is NOT listed in the article, your job with this assignment is to REDUCE your budget by 10%.
1. Either INCREASE or REDUCE the budget you created in weeks 2 and 3.
a. If your agency is receiving more funds to respond to the pandemic, identify where costs should be increased to make use of the increase.
-
For example: The Small Businss Association (SBA) will need to:
- Hire more staff to manage Payment Protection Program (PPP) applications and distribute the money
- Create a new cost category called PPP Loans with the money that will be given out to businesses.
b. If your agency is not receiving more funds to respond to the pandemic, identify where costs should be decreased to arrive at a 10% reduction in your budget.
-
For example:
- Eliminate or reduce one or more services
- Furlough (lay-off) staff from one or more programs
- Reduce staff hours (for example, the Los Angeles Department of Mental Health required all staff to take off, without pay, every other Friday to reduce costs)
- Combination of options
Update your Excel budget to reflect the cost increases or reductions ? and be sure to update your revenue line so you have a balanced budget.
Your updated spreadsheet with the increase or reduction will be included in your final project budget package.
You will not upload your updated Excel budget as part of this assignment.
2. Craft a concise and professionally formatted financial management memorandum that conveys financial analysis findings in lay-person terminology.
The memo must have the following sections:
3. Develop an ?infographic? that visually conveys the findings of the memo.
Embed the Infographic at the end of your memo. The Infographic will be uploaded in the same document as the Memo.
Infographic How-To
(1) Avoid visual clutter. The eye should be able to take in the main message at a glance, typically through the relationship between colors, shapes, and numbers. Leave a lot of white space.
(2) Avoid dense narrative. Graphics and their interaction should convey the main message, not sentences or paragraphs. (This is why it is called an “infographic” and not an “infoparagraphic”). Words should function only as labels and titles.
(3) Avoid garish color. Generally it is a good idea to aim for neutral tones and shades. When one puts a house on the market, it is typical to paint it shades of gray, beige, or other colors that are not going to offend. Use a similar logic with infographics; the graphic display should be the main communicator. Color choice can reinforce but should not get in the way.
(4) Avoid rhetorically charged graphics. While use of shocking images is often the trade of political discourse, these are designed to appeal to emotion, not to intellect. This course is emphasizing evidence-based argumentation, and the infographic should highlight evidentiary arguments, not polemics.
Infographic Resources
CAVANA: Canva is a free app that you might consider using to create the required infographic.
https://www.canva.com/
EXPLANATORY WEBSITE: ?What Are the 9 Types of Infographics? (+Infographic Templates)?
VIDEO: ?How to Create an Infographic – Part 1: What Makes a Good Infographic??
INFOGAPHICS AND EDWARD TUFTE, THE FATHER OF DATA VISUALIZATION
NOt: I am working on the US department of Defense. my organization is not in the list, which I have reduce my budget by cut 10% from the total budget that in the excel file. You can reduce the budget by cut all salaries.
BUDGET CATEGORY
REVENUE
Revenue – individual income taxes, social insurance
taxes, and corporation income taxes.
TOTAL REVENUE
PERSONNEL SALARIES
# of
FTEs
Average
Salary
Army National Guard
336,703
$48,477
Army Reserve
Air National Guard
Navy Reserve
Air Force Reserve
Cost Guard Active duty
Coast Guard Reserve
Army Active Duty
Navy Active Duty
Air Force Active Duty
274,518
101,223
40,433
54,995
$42,846
95,079
$54,222
40,558
20,000
79,391
107,414
7,724
55,200
481,254
341,703
58,030
56,542
329,614
TOTAL
GENERAL & ADMINISTRATIVE STAFF
Chief Executive Officer/ Agency Director
Administrative Assistant
Information Technology (IT) Manager
Network Engineer
Contract Specialist
Electrical Engineer
120
130
230
110
214
310
51,000
50,000
65,988
58,711
65,141
72,600
Cyber Security Analyst
Mechanical Engineer
Mechanical Engineer
Aircraft Maintenance Technician
Crew Chief
System Administrator, Computer / Network
Support Technician, Information Technology (IT)
Information Security Officer
Electronics Engineer
Intelligence Analyst
Avionics Technician
Aerospace Engineer
Aircraft Mechanic / Service Technician
Government Program Manager
Aircraft and Powerplant (A&P) Mechanic
Logistics Manager
231
322
223
460
434
233
321
477
233
232
232
442
423
323
454
655
68,172
80,926
80,926
49,590
39,796
61,341
37,940
79,379
81,046
54,337
43,164
84,597
49,938
89,539
54,393
69,874
FINANCE
Chief Financial Officer
Controller
Financial Analyst
Payroll Accountant
Accounts Receivable Accountant
Accounts Payable Clerk
143
322
123
190
189
432
200,000
100,000
80,000
70,000
70,000
55,000
OPERATIONS
Chief Operating Officer
Operations Analyst
541
122
200,000
55,000
INFORMATION TECHNOLOGY
Chief Technology Officer
IT Tech Level 1
IT Tech Level 2
IT Tech Level 3
212
240
190
140
175,000
50,000
70,000
100,000
460
433
354
175,000
65,000
60,000
HUMAN RESOURCES
Chief Human Resources Officer
HR Recruiter
HR Coordinator
TOTAL SALARIES
PERSONNEL FRINGE BENEFITS & TAXES
(employer’s portion)
FICA
Unemployment SUI
% of
Salaries
7.65%
1.00%
Retirement
Life/LTD/AD&D Insurance
Health Insurance
Worker’s Compensation
TOTAL FRINGE BENEFITS
CONSULTANTS & PROFESSIONAL SERVICES
Management Services
Psychologist
Legal
Auditing & Accounting
Property Acquisition
Security
TOTAL CONSULTANTS & PROFESSIONAL
MATERIALS & SUPPLIES
Staff Cell Phone Expense
Office Supplies
Laundry
Educational Materials
Food-Clients
Food-Staff
TOTAL MATERIALS & SUPPLIES
FACILITY COSTS
Rent/Mortgage
Depreciation
Utilities – Electricity
Utilities – Gas
Utilities – Internet
Trash Removal
Snow Removal
Carpentry & Plumbing
Building Maintenance/Repairs
Painting & Decorating
Grounds Maintenance
Liability Insurance
Real Estate Taxes
TOTAL FACILITY COSTS
OTHER
Travel & Transportation
Telephone & Leased Phone Equipment
1.65%
1.00%
12.00%
1.30%
Training, Conferences, Meetings
Dues & Subscriptions
Staff Recruitment
Staff Physical Exams/Vaccines
Staff Mileage/Auto Expense
Postage
Community Relations
Marketing
Professional Liability & Bonding Insurance
Vehicle Insurance
Depreciation Expense
Interest Expense
TOTAL OTHER
TOTAL EXPENSES
Addtioinal table Summy of Expenses
Military Personnel
Operation & Maintenance
Procurement
RDT&E
Military Construction
Family Housing
Revolving and Management Funds
TOTAL
Air Force 1
Army 2
151,457,857,853,906
207,831,453,648
149,415,594,127
151,457,857,853,906
207,831,453,648
149,415,594,127
–
40,433
54,995
–
–
$54,222 20,000
79,391
2,501,465
56,542 –
$42,846
20,000
79,391
55,200 –
20,000
79,391
58,030
–
51,000
50,003
65,988
58,711
65,141
72,600
G&A
$48,477 –
–
–
Navy 3
65,988
58,711
65,141
72,600
51,000
50,003
65,988
58,711
65,141
72,600
68,172
80,926
80,925
49,590
39,796
61,341
37,940
79,379
81,046
54,337
43,164
84,597
49,938
89,539
54,393
69,874
80,926
80,926
49,590
61,341
37,940
79,379
81,046
54,337
43,164
84,597
49,938
89,539
54,393
69,874
68,172
80,926
80,925
49,590
39,796
61,341
37,940
79,379
81,046
54,337
43,164
84,597
49,938
89,539
54,393
69,874
200,000
100,000
80,000
70,000
70,000
55,000
200,000
55,000
175,000
50,000
70,000
100,000
265,150
–
243,501
–
956,785
–
175,000
65,000
60,000
2,481,785
6,120
800
11,929,804
14,111,354
10,442,947
1,320
800
9,600
1,040
19,680
8,930,000,083
2,058,935,454
4,859,035,954
42,594,545,234
878,489,449
89,098,987,565
148,419,993,739
5,959,049,043
4,909,053,203
3,488,909,444
89,894,909,234
805,045,083
98,098,908,554
203,155,874,561
4,900,000,053
2,058,935,454
4,859,035,954
42,594,345,452
886,563,566
87,095,059,645
142,393,940,124
–
18,000,005
12,000,003
45,950,003
20,000,000
40,000,004
77,000,004
212,950,019
12,090,005
14,003,003
34,354,546
509,090,415
139,000,905
155,895,054
864,433,928
190,030,034
11,003,003
39,008,005
210,390,944
50,988,905
88,908,904
590,329,795
–
67,103,506,411
40,100,000
356,040,000
10,100,011
25,000,340
33,959,555
4,500,005
2,000,005
2,500,405
12,300,000
29,545,445
112,320,905
545,990,005
20,023,007
1,194,379,683
10,789,875,624
58,890,000
458,909,584
19,098,590
24,098,590
59,058,495
8,904,005
7,006,895
4,090,985
54,900,504
30,590,495
10,434,895
45,904,900
1,900,490
783,788,428
103,879,075,895
99,586,980
339,098,590
56,909,500
66,509,690
89,059,695
9,059,695
9,059,005
5,543,553
78,098,590
49,895,005
1,958,490,985
435,439,085
2,954,009
3,199,704,382
–
64,300,000
49,490,400
54,890,098
39,075,894
63,300,000
42,490,400
48,990,008
300,500,005
4,000,080
9,006,905
590,800
6,990,945
6,800,045
44,550,006
67,690,000
955,005,905
576,900,000
677,900,095
2,812,715,194
47,098,445
298,905,435
35,894,895
5,453,543
458,987
5,898,874
7,859,045
55,438,906
95,450,987
918,589,875
658,900,987
789,085,905
3,013,001,876
4,759,000
289,000,005
35,430,005
80,055,605
4,505,005
5,904,005
6,400,065
44,110,004
612,390,000
915,105,905
496,900,000
619,870,095
3,220,220,094
151,457,853,906
207,831,453,648
149,415,594,127
42,595 ,000,000
64,359,000,000
48,553,000,000
46,649,000,000
1,315,000,000
434,000,000
96,000,000
65,021,000,000
68,453,000,000
24,757,000,000
13,858,000,000
1,480,000,000
496,000,000
202,000,000
54,654,000,000
68,864,000,000
60,933,000,000
20,054,000,000
2,164,000,000
409,000,000
—
204,001,000,000
174,265,000,000
207,079,000,000
2,501,465
TOTAL
801,641,484,893
16,322,351,331
11,099,586,294
5,907,232,930
4,337,000,658
5,155,373,538
811,160,000
613,216,084
26,565,220,800
19,829,025,090
18,637,034,788
6,120,000
6,500,390
15,177,240
6,458,210
13,940,174
22,506,000
15,747,732
26,058,172
18,046,275
22,811,400
17,271,464
14,292,453
12,178,740
37,863,783
18,883,718
12,606,184
10,014,048
37,391,874
21,123,774
28,921,097
24,694,422
45,767,470
28,600,000
32,200,000
9,840,000
13,300,000
13,230,000
23,760,000
108,200,000
6,710,000
37,100,000
12,000,000
13,300,000
14,000,000
80,500,000
28,145,000
21,240,000
110,153,701,133
752,760
98,400
162,360
98,400
1,180,800
127,920
36,484,105
19,789,049,179
9,026,924,111
13,206,981,352
175,083,799,920
2,570,098,098
274,292,955,764
493,969,808,424
220,120,044
37,006,009
119,312,554
739,481,359
229,989,814
321,803,962
1,667,713,742
181,772,457,930
198,576,980
1,154,048,174
86,108,101
115,608,620
182,077,745
22,463,705
18,065,905
12,134,943
145,299,094
110,030,945
2,081,246,785
1,027,333,990
24,877,506
186,950,330,423
182,490,098
131,056,694
100,847,453
888,405,445
75,324,980
94,516,053
5,554,792
18,793,824
21,059,155
144,098,916
775,530,987
2,788,701,685
1,732,700,987
2,086,856,095
8,863,447,066
801,641,484,893
119,675,000,000
201,676,000,000
134,243,000,000
80,561,000,000
4,959,000,000
1,339,000,000
298,000,000
585,345,000,000
Purchase answer to see full
attachment