Investigation of Spending This assignment aligns with Outcome 3: Explore the role of artificial intelligence in enabling fraud detection and business valuation. Tom is a senior-level project manager at a small construction management company. The company is comprised of less than 20 individuals and has brought in revenue of over $5 million each year for the past five years. Due to the close working relationships of all coworkers, many of the day-to-day responsibilities are shared and there seems to be a lack of segregation of duties. This is especially true on the upper-management level. Tom is currently the acting CFO and works with the accountants in the preparation of financial statements. Two other senior-level coworkers have noticed a change in Tom’s lifestyle and have become concerned regarding the source of his finances. He shows up to work in expensive vehicles, brags about his lavish weekend trips, and his choice in work attire has certainly upgraded over the past year. His coworkers are concerned because net profit is down and the firm keeps committing to large supply contracts with the same vendor. When confronted in a meeting, Tom is argumentative and dismissive, which are characteristics not seen from the Tom his coworkers have grown to respect. The firm hires you to conduct an investigation into this. Below is a general outline of Tom’s spending for the year: In Excel, use the data below to create a Form 4822 similar to the one in Figure 6.2 of your textbook to determine Tom’s living expenses. Analyze the data and form an opinion on Tom’s spending. Is there enough evidence to determine that a fraud may be taking place? What areas within the company can you look at to determine whether fraud has occurred? Total Yearly Gross Income: $130,000.00 Groceries and outside meals: $18,000 Clothing: $15,000 Laundry dry cleaning: $500 Education: $750 (student loans) Recreation, entertainment, vacations: $25,000 Subscriptions: $750 Gifts and allowances: $6,000 Life and accident insurance: $1,800 Federal taxes: $30,000 Rent or mortgage: $3,500/month Utilities: $3,750 Domestic help: $0 Home insurance: $1,500 Repairs and improvements: $5,000 Child care: $0 Gasoline, oil, grease, wash: $1,500 Tires, batteries, repairs, tags: $2,000 Insurance: $3,000 Auto payments (including interest): $0 Lease of auto: $18,000 Other personal assets: $10,000 All medical expenses paid by employer’s generous health plan.

Accounting Information Systems
10th Edition
ISBN:9781337619202
Author:Hall, James A.
Publisher:Hall, James A.
Chapter3: Ethics, Fraud, And Internal Control
Section: Chapter Questions
Problem 17P
icon
Related questions
Question

 Investigation of Spending

This assignment aligns with Outcome 3: Explore the role of artificial intelligence in enabling fraud detection and business valuation.

Tom is a senior-level project manager at a small construction management company. The company is comprised of less than 20 individuals and has brought in revenue of over $5 million each year for the past five years. Due to the close working relationships of all coworkers, many of the day-to-day responsibilities are shared and there seems to be a lack of segregation of duties. This is especially true on the upper-management level. Tom is currently the acting CFO and works with the accountants in the preparation of financial statements.

Two other senior-level coworkers have noticed a change in Tom’s lifestyle and have become concerned regarding the source of his finances. He shows up to work in expensive vehicles, brags about his lavish weekend trips, and his choice in work attire has certainly upgraded over the past year. His coworkers are concerned because net profit is down and the firm keeps committing to large supply contracts with the same vendor. When confronted in a meeting, Tom is argumentative and dismissive, which are characteristics not seen from the Tom his coworkers have grown to respect.

The firm hires you to conduct an investigation into this. Below is a general outline of Tom’s spending for the year:

  • In Excel, use the data below to create a Form 4822 similar to the one in Figure 6.2 of your textbook to determine Tom’s living expenses.
  • Analyze the data and form an opinion on Tom’s spending.
  • Is there enough evidence to determine that a fraud may be taking place?
  • What areas within the company can you look at to determine whether fraud has occurred?

Total Yearly Gross Income: $130,000.00

Groceries and outside meals: $18,000

Clothing: $15,000

Laundry dry cleaning: $500

Education: $750 (student loans)

Recreation, entertainment, vacations: $25,000

Subscriptions: $750

Gifts and allowances: $6,000

Life and accident insurance: $1,800

Federal taxes: $30,000

Rent or mortgage: $3,500/month

Utilities: $3,750

Domestic help: $0

Home insurance: $1,500

Repairs and improvements: $5,000

Child care: $0

Gasoline, oil, grease, wash: $1,500

Tires, batteries, repairs, tags: $2,000

Insurance: $3,000

Auto payments (including interest): $0

Lease of auto: $18,000

Other personal assets: $10,000

All medical expenses paid by employer’s generous health plan.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,