ASS - Week 9 Lab
pdf
keyboard_arrow_up
School
Temple University *
*We aren’t endorsed by this school
Course
4501
Subject
Accounting
Date
Apr 3, 2024
Type
Pages
5
Uploaded by AgentDiscovery10054
Lab 6-2 (Tableau track) Screenshots
Objective Questions
Objective Questions
Objective Answers
Look at the Benford visual in the top-left
corner of your dashboard. Which digit
appears much greater than its expected value?
L. Bybee
Click the bar for the leading digit 4 to filter
the transactions. What is the grand total of all
transactions that begin with a 4 (rounded to
the nearest dollar)?
13,934
Hover over the individuals in the Benford
Average visualization (you could also create a
new visualization to show the Benford
average and Purchase Order count by user).
What is the name of the individual with the
smallest Benford Average who also has more
than 10 transactions?
D. Bryant
Hover over the individuals in the Benford
Average visualization. What is the average
Benford Expected value for the person (round
to two decimal places) with the smallest
Benford Average who also has more than 10
transactions?
.10
Hover over the individuals in the Benford
Average visualization. Click the bar for the
first individual with more than 10 transactions
to filter the dashboard. What digit do most of
that individual's transactions begin with?
0
Analysis Questions
Analysis Questions
Analysis Answers
What does calculating the Benford Average
tell us about individuals?
Average purchase per individual
What can we learn by looking at an
individual's transactions through the lens of
Benford's law?
That the leading digits in data are going to be
small
As an auditor, why would we be concerned
with a high volume of transactions that
exceed the Benford Expected value?
Yes it should be looked into
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
Lab 6-3 (Microsoft track) Screenshots
Objective Questions
Objective Questions
Objective Answers
How many duplicate records did you locate?
2
What is (are) the invoice number(s) of the
duplicate payments?
4022595
How much money could the company recover
from the supplier from these duplicate
transactions?
Enough to keep the company alive
What data items do you need to combine to be
able to find duplicate payments?
Invoice number, vendor information and
payment amount
Analysis Questions
Analysis Questions
Analysis Answers
Before computerization or Data Analytics,
how would companies find that they had
made duplicate payments?
Manual Review of Records, Reconciliation
and Supplier Communication
What data items do you need to bé able to
find duplicate payments?
Invoice numbers, vendor information and
payment accounts
Would the date of the duplicate payments
usually be the same or different?
Processing delays, Human Error and System
Issues
Related Documents
Related Questions
engageNOWv2 | Online teachir X
* CengageNOWv2| Online teachir x
.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre. *
A eBook
Show Me How
Accounts Receivable Analysis
A company reports the following:
Sales
$671,600
Average accounts receivable (net)
67,160
Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final
answers to one decimal place. Assume a 365-day year.
a. Accounts receivable turnover
b. Number of days' sales in receivables
days
Previous
Next
Check My Work
11:16 AM
67°F Sunny A O E D a ) 12/3/2021
n sc
hone
backsoce
arrow_forward
Question is attached in the screenshot thanks
grealty appreciated
420ti2492i409y490idf9ib0fi90i
arrow_forward
Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.
arrow_forward
Please calculate the ratio and percentage for:
1. acid-test ratio
2. Time interest earned
3. Earnings per common share
arrow_forward
Please rank the websites in order of total number of click-throughs from lowest to highest.
arrow_forward
F
SUM of Outstanding balance Status
Customer
C1003
C1004
C1006
C1010
C1012
C1013
C1026
C1028
C1029
C1036
C1037
C1045
C1048
C1051
G
C1055
C1057
C1058
C1061
C1066
C1069
C1075
C1076
C1082
C1085
Grand Total
H
0-Not Yet Due
30831
30831
I
1-30 Days
25579
3156
2353
31088
J
11791
26748
31-60 Days 61-90 Days 90+ Days
9367
10460
29297
K
25315
103611
25245
24713
L
49958
4115
1659
18793
12116
22957
20307
7791
30907
12102
12235
22997
25366
200712
M
Grand Total
9367
25245
30831
24713
11791
26748
4115
1659
18793
10460
12116
22957
20307
25579
7791
3156
30907
12102
12235
2353
22997
29297
25366
25315
416200
N
arrow_forward
e https://newconnect.mheducation.com/flow/connect.html
X e ezto.mheducation.com
e ezto.mheducation.com
e Portal
eChapter 9 Problems
Saved
Chapter 9 Problems i
Scott Duffney, CPA, has randomly selected and audited a sample of 100 of Will-Mart's accounts receivable. Will-Mart has 3,000
accounts receivable accounts with a total book value of $3.600,000. Duffney has determined that the account's tolerable
misstatement is $850,000.
polnts
His sample results are as follows:
Average audited
value
$1,190
eBook
Average book value
1,198
Print
Required:
Calculate the accounts receivable estimated audited value and projected misstatement using the: (Do not round your intermediate
calculations and round your final answer to nearest whole dollar.)
References
Estimated
Audited Value
Projected
Misstatement
a. Mean-per-unit method.
3,570,000 $
30,000
b. Ratio method.
C.
Difference method.
Mc
Graw
Hill
Education
Chapter 9 Problem...
DELL
%24
arrow_forward
zto.mheducation.com/ext/map/index.html?_con=con&external_browser
Saved
Help
Save & Exit
Required information
Use the following information for the Exercises 12-13 below. (Algo)
[The following information applies to the questions displayed below.]
of 2
Del Gato Clinic's cash account shows an $15,472 debit balance and its bank statement shows $16,254 on deposit at the
close of business on June 30.
a. Outstanding checks as of June 30 total $3,069.
b. The June 30 bank statement lists a $35 bank service charge.
c. Check No. 919, listed with the canceled checks, was correctly drawn for $389 in payment of a utility bill on June 15. Del
Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $398.
d. The June 30 cash receipts of $2,261 were placed in the bank's night depository after banking hours and were not
recorded on the June 30 bank statement.
3251
ok
Exercise 6-13 (Algo) Entries from bank reconciliation LO P3
Prepare any necessary…
arrow_forward
PICTURE ONE IS THE QOU
PICTURE2 IS SAMPLE PLEASE DO THE SAME TABLE STYLE
arrow_forward
Subject - account
Please help me.
Thankyou.
arrow_forward
Please calculate
1. Accounts receivable collection period
2. Return on equity
arrow_forward
please do not give handwritten answer thanku
arrow_forward
Please see below. Be sure to include the appropriate mathematical formula and cell referencing for this. Those were needed.
arrow_forward
.
arrow_forward
I do not know how to do the calculations and I am not about the 2nd boxes next to it
arrow_forward
Questions are attached in the screenshot below
greatly appreciate the hlep
thanks
@%12512oo
o--
arrow_forward
☐mybusinesscourse.com/platform/mod/quiz/attempt.php?attempt=7676745&cmid=418253&page=4
N Dashboard N Current Student Inf... N This course N Technology Suppor... NIT Services N MyNMU N MyUser SNMU EduCat
BusinessCourse
Tab
Stockholders' Equity: Transaction Descriptions from Account Data
The following T-accounts contain keyed entries representing five transactions involving the stockholders' equity of Riverview, Inc.:
Paid-in Capital in Excess of Par
Land
value-Common Stock
33,000 (3)
Common Stock, $10 Par
35,000 (2)
60,000 (3)
(1)
(2)
(5) 6,080
Cash
80,600
35,000
4
*800 shares of common stock
Date
1
OsLock
Preferred Stock, $50 Par
65,000 (1)
Esc
FnLock
12,800 (4)
!
Required
4
Using this information, give detailed descriptions, including number of shares and price per share when applicable, for each of the five transac
General Journal
1
Paid-in-Capital in Excess of Par Value - Preferred Stock
Type here to search
(1)
A
F1
Z
Description
Return to course
@
Paid-in Capital from Treasury…
arrow_forward
Complete this question by entering your answers in the tabs below.
Analyze
General
Joumal
T accounts
Post the entry using T-accounts to represent ledger accounts. (TIP: For right side T-account entries you must use a right side date selection. For left side T-
account entries you must use a left side date selection.)
Cash 101
Office Supplies 124
Date
Amount
Date
Amount
Date
Amount
Date
Amount
End. bal.
End. bal.
Equipment 167
Accounts Payable 201
Date
Amount
Date
Amount
Date
Amount
Date
Amount
End. bal.
End. bal.
Unearned Landscaping Revenue 236
Common Stock 307
Date
Amount
Date
Amount
Date
Amount
Date
Amount
End. bal.
End. bal.
Landscaping Revenue 403
Date
Amount
Date
Amount
End. bal.
Caneral lournal
reounts
arrow_forward
Raymond Autobody Shop has the following accounts:
A (Click the icon to view the accounts.)
Create a chart of accounts for Raymond Autobody Shop using the standard numbering system. Each account is separated by a factor of 10. For example, the first asset account will be 100 and the next asset account will 110.
(Use the first available line under each section, Asset, Liabilities, etc., when selecting the accounts. If a box is not used, leave the box empty; do not select any labels.)
Balance Sheet Accounts
- X
More info
Assets
Liabilities
Equity
Accounts Payable
Service Revenue
Cash
Equipment
Utilities Expense
Common Stock
Automotive Supplies
Advertising Expense
Income Statement Accounts
Dividends
Unearned Revenue
(Part of Equity)
Retained Earnings
Revenues
Expenses
Print
Done
arrow_forward
Please answer questions correctly
arrow_forward
From the following calculate what would be the total of assets on the balance sheet
arrow_forward
Identify the items from the following list that are likely to serve as source documents. (You may select more than one answer. Single.
click the box with the question mark to produce a check mark for a correct answer and double click the box with the question
mark to empty the box for a wrong answer.)
Credit card receipt
O Prepaid insurance account
Company revenue account
OLedger
Telephone bill
Balance sheet
Income statement
Check
Bank statement
5,200
tv
6.
MacBook Air
arrow_forward
If answered within 30mins,it would be helpful!!
Journalize the transactions. Refer to the Chart of Accounts for exact wording of account titles. Round your answers to nearest dollar amount.
CHART OF ACCOUNTS
General Ledger
ASSETS
110
Cash
111
Petty Cash
121
Accounts Receivable-Alan Albertson
122
Accounts Receivable-Jim Dobbs
123
Accounts Receivable-John Groves
124
Accounts Receivable-Jan Lehn
125
Accounts Receivable-Jacob Marley
126
Accounts Receivable-Mr.Potts
127
Accounts Receivable-Chad Thomas
128
Accounts Receivable-Andrew Warren
129
Allowance for Doubtful Accounts
131
Interest Receivable
132
Notes Receivable
141
Inventory
145
Supplies
151
Prepaid Insurance
181
Land
191
Equipment
192
Accumulated Depreciation
LIABILITIES
210
Accounts Payable
211
Salaries Payable
213
Sales Tax Payable
214
Interest Payable
215
Notes Payable
EQUITY
310
Common Stock
311
Retained Earnings
312…
arrow_forward
O Mail - Edjouline X
E Content - ACG2 X
* CengageNOW. X
O (58) YouTube
* from Towards a X
m/ilm/takeAssignment/takeAssignmentMain.do?invoker=assignments&takeAssignmentSessionLocator=assignment-take&inpro. Q < ☆
STIOW Me TOW
Percent of Sales Method
At the end of the current year, Accounts Receivable has a balance of $410,000; Allowance for Doubtful Accounts has a credit balance of $3,500; and sales for the year
total $1,850,000. Bad debt expense is estimated at 3/4 of 1% of sales.
a. Determine the amount of the adjusting entry for uncollectible accounts.
b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense.
Adjusted Balance
Debit (Credit)
Accounts Receivable
Allowance for Doubtful Accounts
Bad Debt Expense
c. Determine the net realizable value of accounts receivable.
Check My Work
Previous
Next
V O 11:51
arrow_forward
Question is attached in the screenshot
greatly appreciate the help
13ylp14y1pl4hp2lhtplhpt3lh3ptlh35bz
arrow_forward
LIUILLUM/ERt/Map/index.html?_con=con&external_browser=0&launchUrl=https%253A%
t.mheducation.com%252F/activity/qu
YouTube
* Maps
5. In-Class Activity i
Saved
Help
Save 8
Case A: Compute cash received for interest
Interest revenue
Interest receivable, beginning of year
Interest receivable, end of year
Case B: Compute cash paid for wages
Wages expense
Wages payable, beginning of year
Wages payable, end of year
$ 5,000
$ 9,000
600
2,200
|1,000
1,700
For each separate case, compute the required cash flow information for BioClean.
Case A
Cash received for interest
Cash paid for wages
Case B:
4 of 6
search
fo
トト
&
7
8.
6.
Y
00
立
arrow_forward
Open your quickbooks online company. complete chapter 2's hands-on work and step-by-
step activities presented on pages 39 to 70. type the answers to the questions below.
required: 1. what is the account number and account type for checking? 2. what is the
account number and account type for accounts payable? 3. what is the account number and
account type for common stock?
arrow_forward
This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J.
Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amounts
arrow_forward
Part of your job is to review customer requests for credit. You have three new credit applications on your desk and part of your analysis
requires that the current ratios and quick ratios be compared
a. Complete the following schedule. (Round the final answers to 2 decimal places.)
Account
Cash
Current non-strategic investments
Current receivables
Inventory
Prepaid expenses
Land
Current liabilities
Current ratio
Quick ratio
$
$
S
$
$
$
$
Kasta
3.900
0
4,320
2,900
460
5,550
3,780
4
1
$
$
$
$
$
$
$
Nasta
1,640
0
1,740
1,610
930
6,380
2,410
$
S
$
$
$
5
5
Dusta
3,300
1,300
310
14,530
4720
25.750
11,080
arrow_forward
F
1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance
2 Is for the year ended December 31, 20X1.
3
Deblt
$37,500
28,600
43,300
2,000
69,000
4.
Account Titles
Cash
6.
Accounts Recelvable
Inventory
8
Prepaid Rent
Equipment
10 Accumulated Depreciation
11 Accounts Payable
$20,700
8,800
20,000
75,000
31,800
175,500
12 Unearned Fees
13 Long-term Notes Payable
14 J. Noodle, Capital
15 Sales Revenue
16 Sales Returns and Allowances
4,700
6,000
17 Sales Discounts
18 Cost of Goods Sold
67,700
19 Salaries and Wages Expense
20 Depreciation Expense
21 Rent Expense
22 Interest Expense
23 Loss on Sale of Equipment
25,900
13,800
24,000
1,600
7,700
Totals
$331,800
$331,800
24
25
26 Required:
27 1. Prepare a multistep income statement that would be used for internal reporting purposes.
28 Note: When more than one correct account could appear in a cell, list items in order of largest to
29 smallest dollar amounts. Use cell referencing to select account titles and…
arrow_forward
myOpenMath
Course Messages Forums Calendar | Gradebook
Home > Math 173-4 Spring 2024> Assessment
Quiz 2 (Sec. 1.5-1.7)
54 points possible 5/12 answered
Question 6
The graph of the function
y = f(x - 39)
can be obtained from the graph of
y = f(x)
by one of the following actions:
> Next Question
Home | My
Oshifting the graph of f(x) to the right 39 units
shifting the graph of f(x) to the left 39 units
shifting the graph of f(x) upwards 39 units
shifting the graph of f(x) downwards 39 units
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- engageNOWv2 | Online teachir X * CengageNOWv2| Online teachir x .com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre. * A eBook Show Me How Accounts Receivable Analysis A company reports the following: Sales $671,600 Average accounts receivable (net) 67,160 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. a. Accounts receivable turnover b. Number of days' sales in receivables days Previous Next Check My Work 11:16 AM 67°F Sunny A O E D a ) 12/3/2021 n sc hone backsocearrow_forwardQuestion is attached in the screenshot thanks grealty appreciated 420ti2492i409y490idf9ib0fi90iarrow_forwardUsing Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.arrow_forward
- Please calculate the ratio and percentage for: 1. acid-test ratio 2. Time interest earned 3. Earnings per common sharearrow_forwardPlease rank the websites in order of total number of click-throughs from lowest to highest.arrow_forwardF SUM of Outstanding balance Status Customer C1003 C1004 C1006 C1010 C1012 C1013 C1026 C1028 C1029 C1036 C1037 C1045 C1048 C1051 G C1055 C1057 C1058 C1061 C1066 C1069 C1075 C1076 C1082 C1085 Grand Total H 0-Not Yet Due 30831 30831 I 1-30 Days 25579 3156 2353 31088 J 11791 26748 31-60 Days 61-90 Days 90+ Days 9367 10460 29297 K 25315 103611 25245 24713 L 49958 4115 1659 18793 12116 22957 20307 7791 30907 12102 12235 22997 25366 200712 M Grand Total 9367 25245 30831 24713 11791 26748 4115 1659 18793 10460 12116 22957 20307 25579 7791 3156 30907 12102 12235 2353 22997 29297 25366 25315 416200 Narrow_forward
- e https://newconnect.mheducation.com/flow/connect.html X e ezto.mheducation.com e ezto.mheducation.com e Portal eChapter 9 Problems Saved Chapter 9 Problems i Scott Duffney, CPA, has randomly selected and audited a sample of 100 of Will-Mart's accounts receivable. Will-Mart has 3,000 accounts receivable accounts with a total book value of $3.600,000. Duffney has determined that the account's tolerable misstatement is $850,000. polnts His sample results are as follows: Average audited value $1,190 eBook Average book value 1,198 Print Required: Calculate the accounts receivable estimated audited value and projected misstatement using the: (Do not round your intermediate calculations and round your final answer to nearest whole dollar.) References Estimated Audited Value Projected Misstatement a. Mean-per-unit method. 3,570,000 $ 30,000 b. Ratio method. C. Difference method. Mc Graw Hill Education Chapter 9 Problem... DELL %24arrow_forwardzto.mheducation.com/ext/map/index.html?_con=con&external_browser Saved Help Save & Exit Required information Use the following information for the Exercises 12-13 below. (Algo) [The following information applies to the questions displayed below.] of 2 Del Gato Clinic's cash account shows an $15,472 debit balance and its bank statement shows $16,254 on deposit at the close of business on June 30. a. Outstanding checks as of June 30 total $3,069. b. The June 30 bank statement lists a $35 bank service charge. c. Check No. 919, listed with the canceled checks, was correctly drawn for $389 in payment of a utility bill on June 15. Del Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $398. d. The June 30 cash receipts of $2,261 were placed in the bank's night depository after banking hours and were not recorded on the June 30 bank statement. 3251 ok Exercise 6-13 (Algo) Entries from bank reconciliation LO P3 Prepare any necessary…arrow_forwardPICTURE ONE IS THE QOU PICTURE2 IS SAMPLE PLEASE DO THE SAME TABLE STYLEarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning