Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel problem: employees should not approve their

EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the...

60.1K

Verified Solution

Question

Accounting

EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the approver; however, someone other than the employee should approve a claim for segregation of duties purposes. Test the data to see which employees approved their own expenses. (Hint: Create a true/false calculation.) What are their names? How much, in total, did the employees from question 4 approve for themselves?

I have a data set with these categories:

Expense Tracking Number

Approver Employee Number

Approver Name

Expense Approved Date

Reimbursement Paid Date

Expense Type

Description

Expense Category

Ticket Number

Ticket Status

Transaction Date

Vendor

Employee Number

Employee Name

Department

Payment Description

Mileage Rate

Miles

Number Guests

Transaction Amt

How do I create this TRUE/FALSE calculation to solve this?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Which of the following situations described is a good situation to use an abstract class, and...

Programming
Q

how do adhesion and cohesion explain capillary action? how does water dissolve a substance like NaCl?...

Chemistry
Q

Psychologists like B. F. Skinner have studied how we can use operant conditioning to change the...

Psychology
Q

Question: Of the financial ratios that are used for the industry standard, which do you feel...

Accounting
Q

Each of the following are features of a cloning vector exceptSelect one:a. origin of replication.b....

Biology
Q

What is the main difference between the diathesis stress model and the gene environment correlation...

Biology
Q

00 00 09 Question 1 of 60 The type of listing that places listing brokers...

Algebra
Q

Which of the following is a characteristic of relevance? Select one: a. It represents faithfully...

Accounting
Q

Stock Investment Transactions, Equity Method and Available-for-Sale Securities Roman Products, Inc., is a wholesaler of...

Accounting
Q

historical maximum 15 year mortgage rate?time for the max? historical minimum 15 year mortgage rate...

Accounting
Q

please do not put down income summary as an answer its wrong and not even...

Accounting
Q

Laker Company reported the following January purchases and sales data for its only product. Date...

Accounting