Assignment 9
.docx
keyboard_arrow_up
School
American Public University *
*We aren’t endorsed by this school
Course
3800405
Subject
Communications
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by savpickle1
Assignment 9: Communication Analysis and Financial Analysis
Please complete both parts of this assignment and submit the Microsoft Word document to
Brightspace by April 12
th
at 11:59pm. Fill out all of your answers within this document. Please
note: the case we are examining for this assignment is the same case we examined for
assignment 8. You may want to go back to assignment 8 to refresh your memory on the case, the
key individuals, etc. This will help you better understand what you’re seeing when you begin to
examine phone and bank records and may help you come up with new investigative leads or
theories on this investigation.
Part 1: Communication Analysis
The following are outgoing calls from Steve Brown’s mother’s phone (304.622.7889). Examine the phone records and complete the worksheet, then draw some conclusions and make recommendations.
Date
Time
State
Number Called
Duration
2/5
10:25AM
OH
304.654.7888
21
2/9
11:03AM
OH
304.654.7888
14
2/10
4:15PM
OH
304.654.7888
3
2/11
12:33PM
OH
304.656.1234
1
2/12
6:14PM
OH
304.218.0063
1
2/13
11:22PM
OH
304.654.7888
45
2/15
10:56AM
OH
304.654.7888
22
2/18
11:05AM
OH
304.655.2120
1
2/18
11:14AM
OH
304.656.1234
3
2/19
9:12AM
OH
304.218.0063
1
2/20
10:45AM
OH
304.654.7888
31
2/21
10:34AM
OH
304.654.7888
11
2/27
10:55AM
OH
304.659.4011
35
3/11
9:45AM
OH
304.654.7888
2
3/11
3:15PM
OH
304.654.7888
17
3/12
11:02AM
OH
304.288.4174
12
3/16
4:50PM
OH
304.656.1234
2
3/17
9:46AM
OH
304.218.0063
1
3/18
10:33PM
OH
304.654.7888
41
3/21
10:20PM
OH
304.659.4011
3
3/22
10:46AM
OH
304.288.1119
14
3/23
4:37PM
DC
202.211.6659
3
3/26
1:15PM
OH
304.656.1234
1
3/28
9:00AM
OH
304.218.0063
2
3/29
3:20AM
OH
304.654.7888
3
3/29
3:24AM
DC
202.211.6659
5
1.
Conclusions (patterns)
Tiffany was lying about not knowing Steve they’ve had a ton of contact for long & short periods of time.
Tiffany and Steve had a ton of communication between the two of them suggesting the activities between the two is true.
Steve is the one who reached out to Harrisons investigator.
Reached out to Anthony after the fight & days before the murder.
He probably went to DC and why people can’t find him. 2.
Recommendations (where to take this case from here/what should law enforcement do/what other information do you want to know?)
Find out why Steve has been using his mother’s phone? Does he have his own cell phone? Find his cell phone records if he does have his own phone?
Find out who the unknown number is? G. Thompson? J. Stevenson? and the unknown person? And the connection that they have to Steve?
Primary Listing Worksheet
# Called
Total # Calls
Date Range
Total Duration
304-654-7888 (Tiffany Jones)
11
2/5-3/29
210 Mins 304-656-1234
(Anthony Brown)
4
2/11-3/26
7 Mins
304-218-0063
(Harrison Inv)
4
2/12-3/28
5 Mins
304-659-4011
(J. Stevenson)
2
2/27-3/21
38 Mins
202-211-6659
(Daniel Morris)
2
3/23-3/29
8 Mins
304-655-2120
(Smith Tuxedos)
1 2/18
1 Min
304-288-4174
(G. Thompson)
1
3/12
12 Mins
304-288-1119
(Unknown)
1
3/22
14 Mins We have learned that Steve’s mother has been in the hospital since February 3
rd
and Steve is reported to be the only one staying at the house in her absence. Who is being called from Steve’s Mother’s phone?
202.211.6659
Daniel Morris
304.218.0063
Harrison Investigations
304.288.4174
G. Thompson
304.654.7888
Tiffany Jones
304.655.2120
Smith Tuxedos
304.656.1234
Anthony Brown
304.659.4011
J. Stevenson
Part 2: Financial Analysis
Examine the bank records for Smith Tuxedos contained in the Excel sheet (found on Brightspace
in the folder for this week). Use the bank record analysis worksheet on the following page to help you organize the information. You will look at the Excel sheet in order to calculate the information you will include on the worksheet. Look for the starting balance in Excel, calculate the amount of all of the deposits made, calculate the amount of all of the withdrawals made and then calculate the ending balance. For sources of income you can look at sales receipts and cash deposits and calculate the totals for both of those categories. For payees you will examine who Smith Tuxedoes is paying and can see which payments are looking in the memo category (there are only two). For facilities expenses you will be looking at what payments Smith Tuxedoes is making to remain open (think about power, telephone, etc.). For other business you can include salaries and other expenses that you don’t think meet any of the above categories. Finally, include if there are any transfers made, ATM withdrawals or other payments, and then identify if
you see any patterns. Develop your critical questions, conclusions, and recommendations and note them below.
1.
Critical questions
Why did salaries increase?
Why did they have so many insufficient funds?
Why were they not paying bills at the beginning of the month?
Why did they have a storage unit for one month?
2.
Conclusions
They were very inconsistent with their money.
They spend a lot of money on vendors. 3.
Recommendation
Investigate where their deposits were coming from.
Investigate why they raised their incomes.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help