Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 1MCQ
To determine
Identify the items which would be currently out of scope for Data Analytics.
Expert Solution & Answer
Answer to Problem 1MCQ
Option a. Direct observation of processes would be currently out of scope for Data Analytics.
Explanation of Solution
The items which would be currently using the data analytics are as follows:
- Evaluation of time stamps to evaluate workflow
- Evaluation of phantom vendors
- Duplicate payment of invoices
Justification for correct and incorrect answer:
a.
Direct observation of processes: This is the correct choice as the direct observation of processes involves the application of direct processes in the evaluation. The use of data analytics in direct observation is restricted to the theory only. It is not expanded to practical areas for directly evaluating the processes. Thus, the direct observation of processes is currently out of scope for Data Analytics.
b.
Evaluation of time stamps to evaluate workflow: This option is an incorrect option because data analytics is used on the time stamps of the tasks. It determines the sequence of approvals in the form of a workflow along with the amount of time which is spent on each task.
c.
Evaluation of phantom vendors: This option is incorrect because the evaluation of phantom vendors is made via the use of data analytics. Thus, it cannot be said that the evaluation of phantom vendors is out of scope for Data Analytics.
d.
Duplicate payment of invoices: This is an incorrect option because the duplicate payment of invoice can be verified by using the big data analytics approach. Thus, it cannot be said as out of scope for Data Analytics.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
B2
A
1 DATE VALUE
X✓ fx
2
1
3
9
4
548
56
3835
40468
VALUE
B
C
D
E
F
G
H
MEASURE
Current Date (TODAY)
VALUE
FORMULA
MEASURE
VALUE
FORMULA
Current Time (NOW)
#N/A
#N/A
Use E6 "Problem Date" for green cells in col. E & I
Cumulative full days this year
#N/A
Year to date fraction (YEARFRAC)
#N/A
Use E6 "Problem Date" for green cells in col. E & I
Month to date fraction of year
#N/A
10/8/2019
Day of the week
#N/A
6
Problem Date
7
Year (YEAR)
8 Date Value
Fractional Date
Month (MONTH)
9
40468.25
Day (DAY)
10
40468.375
11
40468.625
12
13
14
15 DATE DATA CLEANUP and MANIPULATION
End of month
Start of month
Start of next month
First day of the year
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
TIP: Use custom date format to display
as the name of the day (dddd)
Name of month
Workdays in current month
#N/A
#N/A
30 workdays (excluding weekends) from today
Days between today and 30 workdays from now
#N/A
#N/A
16
Target
$2,000
17
18 DATE
REVENUE
MONTH
DAY OF WEEK
Hit Target?
MONTH
DAY OF WEEK
FORMULAS for…
I need help finding the correct solution to this financial accounting problem with valid methods.
Can you explain the process for solving this financial accounting question accurately?
Knowledge Booster
Similar questions
- I need guidance on solving this financial accounting problem with appropriate financial standards.arrow_forwardCan you solve this general accounting problem using appropriate accounting principles?arrow_forwardA42 ☑✓ fx A 1 TASK 2 Name data to proper case 3 Number of characters in a text string 4 Find first 4 characters of a text string B C D E FUNCTION TO LEARN DATA PRACTICE FORMULAS PROPER hayden anderson #N/A LEN Hayden #N/A LEFT Anderson #N/A RIGHT Anderson #N/A MID Hayden #N/A CONCAT C3 and C4 #N/A CONCAT C3 and C4 #N/A C3 and C4 #N/A 51085 4033 #N/A #N/A handerson@nowhere.edu handerson@nowhere.edu #N/A #N/A 5 Find final 3 characters of a text string 6 Get three characters from a text string starting on the third character 7 Concatenate (bring together) text strings 8 Concatenate (bring together) text strings adding a space, 9 Concatenate (with space) using ampersands 10 Convert a number (like a zip code) to text "" 11 Convert a number (like a zip code) to text adding back leading zero 12 Search for the location of the text string "@" within an email address 13 Split off username from email address. Hint: search for @ symbol 14 TEXT TEXT SEARCH LEFT and SEARCH 15 Raw name data Zip Codes…arrow_forward
- Please explain this financial accounting problem by applying valid financial principles.arrow_forwardRight answerarrow_forwardA42 ☑✓ fx A 1 TASK 2 Name data to proper case 3 Number of characters in a text string 4 Find first 4 characters of a text string B C D E FUNCTION TO LEARN DATA PRACTICE FORMULAS PROPER hayden anderson #N/A LEN Hayden #N/A LEFT Anderson #N/A RIGHT Anderson #N/A MID Hayden #N/A CONCAT C3 and C4 #N/A CONCAT C3 and C4 #N/A C3 and C4 #N/A 51085 4033 #N/A #N/A handerson@nowhere.edu handerson@nowhere.edu #N/A #N/A 5 Find final 3 characters of a text string 6 Get three characters from a text string starting on the third character 7 Concatenate (bring together) text strings 8 Concatenate (bring together) text strings adding a space, 9 Concatenate (with space) using ampersands 10 Convert a number (like a zip code) to text "" 11 Convert a number (like a zip code) to text adding back leading zero 12 Search for the location of the text string "@" within an email address 13 Split off username from email address. Hint: search for @ symbol 14 TEXT TEXT SEARCH LEFT and SEARCH 15 Raw name data Zip Codes…arrow_forward
- Income from operations for Division M is $275,000, total service department charges are $350,000, and operating expenses are $2,600,000. What are the revenues for Division M?arrow_forwardCan you solve this general accounting question with accurate accounting calculations?arrow_forwardB2 A 1 DATE VALUE X✓ fx 2 1 3 9 4 548 56 3835 40468 VALUE B C D E F G H MEASURE Current Date (TODAY) VALUE FORMULA MEASURE VALUE FORMULA Current Time (NOW) #N/A #N/A Use E6 "Problem Date" for green cells in col. E & I Cumulative full days this year #N/A Year to date fraction (YEARFRAC) #N/A Use E6 "Problem Date" for green cells in col. E & I Month to date fraction of year #N/A 10/8/2019 Day of the week #N/A 6 Problem Date 7 Year (YEAR) 8 Date Value Fractional Date Month (MONTH) 9 40468.25 Day (DAY) 10 40468.375 11 40468.625 12 13 14 15 DATE DATA CLEANUP and MANIPULATION End of month Start of month Start of next month First day of the year #N/A #N/A #N/A #N/A #N/A #N/A #N/A TIP: Use custom date format to display as the name of the day (dddd) Name of month Workdays in current month #N/A #N/A 30 workdays (excluding weekends) from today Days between today and 30 workdays from now #N/A #N/A 16 Target $2,000 17 18 DATE REVENUE MONTH DAY OF WEEK Hit Target? MONTH DAY OF WEEK FORMULAS for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub