Develop a formula that calculates fraud expenses

Assignment Help Accounting Basics

Reference no: EM133922637

Problem

Scenario

The potential for corporate fraud is always a consideration when using or even adopting an AIS. Even simple tools like Excel are useful in drawing information from accounting records found in an AIS. S&S is not exempted from this concern. Although this is not a normal duty for you, Ashton has asked you to analyze sales data for its stores. He expects this task will pay dividends later as you evaluate AIS solution controls. He did not share any expenses or specific fraud data.

Instructions

Update the Historical Sales Data Download Historical Sales Datafile to generate a descriptive status of sales and fraud data.

Do the following:

I. In Column F, Row 1, add the title "Estimated_Fraud"

II. Develop a formula that calculates fraud expenses at 5 % of weekly sales. Get the instant assignment help.

III. Generate a descriptive status of sales and fraud data. You will store the results in a separate workbook.

IV. Develop pivot tables that identify the following:

i. Top 5 stores with estimated fraudulent expenses.
ii. Top 5 departments with estimated fraudulent expenses.
iii. Top 5 holidays with estimated fraudulent expenses.

Reference no: EM133922637

Questions Cloud

What did you think of the story of the greening of detroit : What did you think of the story of the Greening of Detroit and Can you think of a time when you have been overly judgmental of someone for not supporting

What do you a trained forensic accountant : Respond to the following: What do you, a trained forensic accountant; look for when investigating this type of potential fraud activity?

Community medically underserved population : Hospital emergency departments continue to be used as a source of primary medical care by large numbers of the community's medically underserved population.

Various barriers to change in healthcare : Explain the Identify and the various barriers to change in healthcare, as too how the steps used by managers in the change process can overcome these barriers?

Develop a formula that calculates fraud expenses : Develop a formula that calculates fraud expenses at 5 % of weekly sales. Generate a descriptive status of sales and fraud data.

Document reason for not administering medication : At Meridien Medical Center, hospital policy is to document the "reason" for not administering a medication that is ordered but not administered.

Evaluate examples of preventative controls : Evaluate examples of preventative controls and detective controls for the company AT&T including how an auditor might assess each.

Explore the depth of the marketing industry : Describe the interrelationships that exist among the 4P's you have identified across the four articles. Using the findings from the four articles

Protocol-health center on hiv screening : Make a summary about the Protocol: Health Center on HIV screening. What is the definition of HIV? What is the purpose?

User Account

All Pages