
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.
to generate a solution
a solution
- The Carla Vista Burkett Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using a system of responsibility reports and return on investment calculations. The allocation of resources within the company and the segment managers' bonuses are based in part on the results shown in these reports. Recently, the company was the victim of a computer virus that deleted portions of the company's accounting records. This was discovered when the current period's responsibility reports were being prepared. The actual operating results appeared as follows. Determine the missing amounts. (Round Return on Investment to 1 decimal place, e.g. 52.7%.) Service revenue Variable costs Contribution margin Controllable fixed costs Controllable margin Average operating assets Return on investment $ Planes 5,018,000 1,518,000 25,018,000 12% Taxis $459,000 $ 189,000 79,000 10% Limos 329,000 389,000…arrow_forwardThe Medford Burkett Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using a system of responsibility reports and return on investment calculations. The allocation of resources within the company and the segment managers' bonuses are based in part on the results shown in these reports. Recently, the company was the victim of a computer virus that deleted portions of the company's accounting records. This was discovered when the current period's responsibility reports were being prepared. The printout of the actual operating results appeared as follows. 3 # E D Determine the missing pieces of information. Format all dollar amounts with $, commas, and zero decimal places. Format percentages with % and zero decimal places. F3 + C Service revenue Variable costs Contribution margin Controllable fixed costs. Controllable margin Average operating assets Return on Investment F4 4…arrow_forwardCompany B uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using a system of responsibility reports and return on investment calculations. The allocation of resources within the company and the segment managers’ bonuses are based in part on the results shown in these reports.Recently, the company was the victim of a computer virus that deleted portions of the company’s accounting records. This was discovered when the current period’s responsibility reports were being prepared. The printout of the actual operating results appeared as follows. Planes Taxis Limos Service revenue $ ? $450,000 $ ? Variable costs 5,000,000 ? 320,000 Contribution margin ? 180,000 380,000 Controllable fixed costs 1,500,000 ? ? Controllable margin ? 70,000 176,000 Average operating assets 25,000,000 ? 1,600,000 Return on investment 12% 10% ? InstructionsDetermine the missing pieces…arrow_forward
- The Ferrell Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured usinga system of responsibility reports and return on investment calculations. The allocation of resources within the company and the segment managers' bonuses are based in part on the results shown in these reports. Recently, the company was the victim of a computer virus that deleted portions of the company's accounting records. This was discovered when the current period's responsibility reports were being prepared. The printout of the actual operating results appeared as follows. Determine the missing pieces of information below. (Round intermediate calculations and final answers to 0 decimal places, eg. 1,255.) Planes Taxis Limos Service revenue 24 $504,700 $4 Variable costs 5,502,300 296,900 Contribution margin 255.000 485 420arrow_forwardYour answer is partially correct. As a new intern for the local branch office of a national brokerage firm, you are excited to get an assignment that allows you to use your accounting expertise. Your supervisor provides you with the spreadsheet below, which contains data for the most recent quarter for three companies that the firm has been recommending to its clients as "buys." Each of the companies' returns on assets has outperformed their industry cohorts in the past. But, given recent challenges in their markets, there is concern that the companies may experience operating challenges and lower earnings. (All numbers in millions, except return on assets.) Company Sprint Nextel Washington Mutual E* Trade Financial Fair Value of Company $36,351 11,582 Loss on Impairment Account Titles and Explanation Goodwill 1,628 eTextbook and Medial Book Value (Net Assets Including Goodwill) $51,201 23,941 4,024 Carrying Value of Goodwill $30,618 9,052 2,015 (c) Estimate the amount of goodwill…arrow_forwardThe desire to maximize profits can work against racial and other types of discrimination. To see why, consider two equally productive accountants named Ted and Jared. Ted is black, and Jared is white. Both can complete 10 audits per month. Instructions: Enter your answers as a whole number. In part b, round your answer for profit rate to 1 decimal place. a. Suppose that for any accounting firm that hires either Ted or Jared, all the other costs of performing an audit (besides paying either Ted or Jared) come to $1,000 per audit. If the going rate that must be paid to hire an accountant is $7,000 per month, how much will it cost an accounting firm to produce one audit if it hires either Ted or Jared to do the work? $1,700 b. If the market price that accounting firms charge their clients for an audit is $1,800, what would the accounting profit per audit be for a firm that hired either Ted or Jared? $ 100 What is the profit rate as a percentage? 5.88 percent c. Suppose that firm A…arrow_forward
- Subject: acountingarrow_forwardSystems Planning A new systems development project is being planned for the Reindeer Christmas Supplies Company. The invoicing, cash receipts, and accounts payable modules are all going to be updated. The controller, Kris K. Ringle, is a little anxious about this project. The last systems development project that affected his department was not very successful,and the employees in the accounting department did not accept the new system very well at first. He feels that the systems personnel did not interact sufficiently with the users of the systems in the accounting department. Prepare a memo from Ringle to the head of the information systems department, Sandy Klaus. In this memo, provide some suggestions for including the accounting personnel in the systems development project. Give some very persuasive arguments why prototyping would be helpful to the workers in the accounting department.arrow_forwardCorrecting internal control weakness Each of the following situations has an internal control weakness. Upside-Down Applications develops custom programs to customer’s specifications. Recently, the development of a new program stopped while the programmers redesigned Upside-Down’s accounting system. Upside-Down’s accountants could have performed this task. Norma Rottler has been your trusted employee for 24 years. She performs all cash- handling and accounting duties. Ms. Rottler just purchased a new luxury car and a new home in an expensive suburb. As an owner of the company, you wonder how she can afford these luxuries because you pay her only $30,000 a year and she has no source of outside income. Izzie Hardwoods, a private company, falsified sales and inventory figures in order to get an important loan. The loan went through, but Izzie later went bankrupt and could not repay the bank.</p> <p>d. The office supply company where Pet Grooming Goods purchases sales receipts…arrow_forward
- what is the potential consequences and give each of the question a prevention technique. 1)A company has recently installed a new computer network. The operating philosophy adopted by the new network administrator was to establish an open system that would foster work group date to the network users. To accomplish this objective, the data administrator assigned employee access privileges to data based on department and functional affiliation rather than specific tasks. 2)Sara is a system programmer who was told she would be terminated in three weeks due to poor performance and was asked to conclude all of her projects during the three-week period. Two weeks later Sara created a logic bomb designed to get activated three months after her departure. Subsequently, the bomb destroyed hundreds of records in her previous employer’s accounts receivable invoice file. 3)Matt discovered a new sensitivity analysis public-domain program on the Internet. He downloaded the software to his laptop at…arrow_forwardYou are a member of a project team for the implementation of a new bank reconciliation accounting software for your company. Due to the size of your company, the daily transaction volumes are over 5,000. The project team has narrowed down five suppliers for the software. From these you are required to make your input as to which would be the most suitable for your company. we selected a software, BANKDOC1. At implementation, the information was correctly loaded to the system and the daily reconciliations were performed accurately. During week 2, your Bank communicated that there would be a change in their system as they were now utilizing a new platform. As such, some of the required fields for BANKDOC1 would now be eliminated on the Bank side. Required: - Define the problem. - What are the core issues? - What actions would you take to solve the problem?arrow_forwardAvatar Financials, Inc., located on Madison Avenue, New York City, is a company that provides financial advice to individuals and small to mid-sized businesses.Its primary operations are in wealth management and financial advice. Each client has an account where basic personal information is stored on a server within the main office in New York City. The company also keeps the information about the amount of investment of each client on a separate server at their data center in Bethlehem, Pennsylvania. This information includes the total value of the portfolio, type of investments made, the income structure of each client, and associated tax liabilities.In the last few years, larger commercial banks have started providing such services and are competing for the same set of customers. Avatar, which prides itself in personal consumer relations, is now trying to set up additional services to keep its current customers. It has recently upgraded its Web site, which formerly only allowed…arrow_forward
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning


