Question: [ 5 points ] Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk

[5 points] Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and analytics center has provided you with a set of Tableau visualizations to consider:
1. Three-way match of SalesOrder, Invoice, and Ship files based solely on SalesOrders
2. Sales by territory
3. Sales by distributor
4. Sales by quarter
5. Sales by territory by quarter
6. Product sales by territory
7. Fourth quarter sales by territory
8. Sales vs. sales goals for fourth quarter by territory
9. Sales by quarter by territory vs fourth Q sales goals
  1. Using the data visualizations, compose a memo that identifies any patterns in the data that you believe may be indicative of specific audit risks. In your memo, be sure to link the identified risks to the appropriate significant account and relevant assertions.

StartHere

SalesSummaryView

SalesbyQTRbyTeritory vs4thQTRSales

ProductSalesTimeline

ProductSalesb QTR

Helio Case

StartHere

SalesSummaryView

SalesbyQTRbyTeritory vs4thQTRSales

ProductSalesTimeline

ProductSalesb QTR

Sales

$1.4M $8.3M

SalesbyTeritorybyQuarter

Midwest Northeast Southeast Southwest West

HingedTitanium Axle ArticularTibialComponent HumeralHead AcetabularShel ModularFemoralHead GlenoidComponent FemoralKneeStem TibialKneeStem Glenosphere TibialBaseplate PatelaComponent Metaglene

TibialInsert CementedStem

TeritoryName

Midwest Northeast Southeast Southwest West

Q1 Q2 Q3 Q4

$5.5M	$3.9M	$3.2M	$4.1M
$3.6M	$4.5M	$5.5M	$4.6M
$4.8M	$6.6M	$6.4M	$8.3M
$1.8M	$1.8M	$1.4M	$1.5M
$3.5M	$4.5M	$3.7M	$5.8M

ProductSales

$0 $5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

StartHere

SalesSummaryView

SalesbyQTRbyTeritory vs4thQTRSales

ProductSalesTimeline

ProductSalesbyQTR

SalesbyTeritorybyQTRvs4thQTRSales

|=SalesGoal=Sales

Sales:$3,232,560 QuotaAchieved:67.35%

Sales:$5,471,490 QuotaAchieved:91.19%

Sales:$6,351,015 QuotaAchieved:79.39%

Sales:$1,379,955 QuotaAchieved:61.33%

Sales:$3,669,945 QuotaAchieved:63.83%

Over/UnderSalesGoal

Over Under

Midwest

Northeast

Southeast

Southwest

West

Sales:$5,547,010 QuotaAchieved:115.56%

Sales:$3,601,205 QuotaAchieved:60.02%

Sales:$4,780,480 QuotaAchieved:59.76%

Sales:$1,801,800 QuotaAchieved:80.08%

Sales:$3,537,625 QuotaAchieved:61.52%

Sales:$3,920,960 QuotaAchieved:81.69%

Sales:$4,483,860 QuotaAchieved:74.73%

Sales:$6,571,365 QuotaAchieved:82.14%

Sales:$1,770,960 QuotaAchieved:78.71%

Sales:$4,501,235 QuotaAchieved:78.28%

Sales:$4,095,690 QuotaAchieved:85.33%

Sales:$4,563,280 QuotaAchieved:76.05%

Sales:$8,274,225 QuotaAchieved:103.43%

Sales:$1,508,055 QuotaAchieved:67.02%

Sales:$5,805,140 QuotaAchieved:100.96%

Q1 Q2 Q3 Q4

SalesSummaryView

SalesbyQTRbyTeritory vs4thQTRSales

ProductSalesTimeline

ProductSalesbyQTR

3WayMatchTest

$2,199,600 $1,295,320

$739,860 $857,565

$698,360 $451,880 $600,600 $887,250

$334,200 $849,425 $492,900 $156,085

$458,615 $210,715 $270,010 $435,500

$88,050 $170,050 $116,350

$93,445 $42,475 $180,960 $50,895

$2,321,800 $2,321,800$1,955,200

$840,750 $454,005 $823,935

$924,300 $790,790 $698,360

$627,900 $723,450 $696,150

$612,700 $264,575 $431,675 $443,610 $665,415 $640,770

$297,480 $520,590 $247,900 $304,850 $209,040 $322,270 $290,565 $26,415 $493,080 $205,850 $31,325 $170,050 $101,940 $280,335 $195,385

$2,199,600

$1,277,940

$544,310 $982,800

$236,725 $624,340

$260,295 $383,240

$35,220 $286,400

$288,830 $113,100

$104,880 $132,480 $88,320 $66,240

HingedTitanium Axle ArticularTibialComponent HumeralHead AcetabularShel ModularFemoralHead GlenoidComponent FemoralKneeStem TibialKneeStem Glenosphere TibialBaseplate PatelaComponent Metaglene

TibialInsert CementedStem

$2,541,760

$2,052,960 $588,525 $655,785

$513,500 $688,090 $354,900 $1,010,100

$946,900 $543,075 $246,450 $418,965

$136,345 $148,740 $113,230 $357,110 $299,370 $440,250

$116,350 $232,700 $67,960 $348,295

$1,661,920 $3,690,440 $635,440 $2,297,360

$226,200 $124,410 $181,740 $65,240 $60,580 $121,160 $144,460

$186,615 $141,375 $55,920 $65,240 $83,880

$521,265 $698,360

$395,850

$375,975 $254,665

$508,195

$139,360 $290,565 $425,125 $339,800

$107,445

$228,340

$908,010 $840,750 $1,378,830 $1,242,670 $821,600 $1,109,160

$573,300 $423,150 $969,150 $1,100,075 $905,125 $946,900

$271,095 $492,900 $410,750 $446,220 $371,850 $495,800

$200,330 $69,680 $357,110 $246,540 $272,955 $255,345 $183,475 $465,400 $129,775

$33,980 $118,930 $178,395

$67,860 $175,305 $305,370

$177,080 $69,900 $130,480

$132,480 $104,880 $138,000

$149,040 $33,120 $226,320 $33,120 $126,960

Jan Feb Mar Apr May

Jun Jul Aug Sep

Oct Nov Dec

SalesbyQTRby Teritoryvs4thQTR Sales

ProductSalesTimeline

ProductSalesbyQTR

3WayMatchTest

SalesbyDistributor (CustomerID)

HingedTitanium Axle ArticularTibialComponent HumeralHead AcetabularShel ModularFemoralHead GlenoidComponent FemoralKneeStem TibialKneeStem Glenosphere TibialBaseplate PatelaComponent Metaglene

TibialInsert CementedStem

TeritoryName

Midwest Northeast Southeast Southwest West

$0 $5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

ProductSales Timeline

3WayMatchI

ProductSalesbyQTR

3WayMatchTest

SalesbyDistributor (CustomerID)

SalesbyTeritory

SalesAmt

$8,950 $244,400

Sizeofcirclerelatestothe salesamount.Therefore thelargerthecirclethe largerthesalesamount.

NOTE:Alsalesmeetthe threewaymatchcriteria.

ProductSalesby QTR

3WayMatchTest

SalesbyDistributor (CustomerID)

SalesbyTeritory

SalesbyQuarter

SalesbyDistributor

$2,000,000 $1,500,000 $1,000,000

$500,000 $0

$1,500,000

$1,000,000

$500,000

CustID

TeritoryName

Midwest Northeast Southeast Southwest West

CustID

42 58 56 37 44 65 69 64 72 48 45 50 71 39 57 51 54 38 53 60 40 66 43 52 70 41 61 63 46 73 67 55 62 47 49 68 59

22 14 19 20 17 18

Sales

1 6 3

24 36 15 16 26 13 27 31

5 8 2

32 35 33 21 30 34 11 25 12 28

4 7 9

23 10 29

3WayMatchTest

SalesbyDistributor (CustomerID)

SalesbyTeritory

SalesbyQuarter

SalesbyQuarterfor EachTeritory

$25,977,085

$18,119,835

$17,513,945

$16,796,220

$6,460,770

Southeast

Northeast

West

Midwest

Southwest

$0 $5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

Sales

SalesbyDistributor (CustomerID)

SalesbyTeritory

SalesbyQuarter

SalesbyQuarterforEach Teritory

4thQTRSalesby Teritory

$24,246,39

$21,248,380

$20,104,965

$19,268,120

$24,000,000 $22,000,000 $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000

$8,000,000 $6,000,000 $4,000,000

$2,000,000 $0

Q1 Q2 Q3 Q4

QuarterofInvoiceDate[2017]

Sales

SalesbyTeritory

SalesbyQuarter

SalesbyQuarterforEach Teritory

4thQTRSalesbyTeritory

4thQTRSalesvsSale Goals

Q1 Q2 Q3 Q4

Sales

$1.4M $8.3M

$5.5M	$3.9M	$3.2M
$3.6M	$4.5M	$5.5M
$4.8M	$6.6M	$6.4M
$1.8M	$1.8M	$1.4M
$3.5M	$4.5M	$3.7M

Midwest

Northeast

Southeast

Southwest

West

$4.1M

$4.6M

$8.3M

$1.5M

$5.8M

SalesbyQuarter

SalesbyQuarterforEach Teritory

4thQTRSalesbyTeritory

4thQTRSalesvsSales Goals

Resources

$8,274,225

$5,805,140

$4,563,280

$4,095,690

$1,508,055

Southeast

West

Northeast

Midwest

Southwest

Sales

$1,508,055

$8,274,225

SalesbyQuarterfor EachTeritory

4thQTRSalesbyTeritory

4thQTRSalesvsSales Goals

Resources

Thankyou!

Sales4thQtrvsBudget

SalesVP

DanKwin

AnthonyLinn

DougPetersen

MarvinLouis

BruceEryans

|=SalesGoal=Sales

TeritoryName

Southeast

West

Northeast

Midwest

Southwest

QuotaAchieved:103.43% Sales:$8,274,225

QuotaAchieved:100.96% Sales:$5,805,140

QuotaAchieved:76.05% Sales:$4,563,280

QuotaAchieved:85.33% Sales:$4,095,690

QuotaAchieved:67.02% Sales:$1,508,055

QtrofInvoiceDate Q4

Over/UnderSalesGoal

Over Under

$2,000,000

$4,000,000

Sales

$6,000,000

$8,000,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Exercise G.64-G.69 require the use of the Urgent Medical Device Inc . case from KPMG University. Your professor will provide you with access to the UMD case from...

Brainstorm with your group about fraud risks! Based on your understanding of fraud risk assessment and the case information, identify at least four specific fraud risk factors related to Urgent....

Urgent Medical Device, Inc.: A Teaching Case Designed to Integrate Data and Analytics in the Financial Statement Auditing Classroom By Allen Blay - Florida State University Jay C. Thibodeau - Bentley...

PLEASE HELP WITH A) AND B) 3) Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and...

3. Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and analytics center has provided...

G.66 Assessing Risk with Visualizations. Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your...

PLEASE HELP WITH A) AND B) 3) Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and...

G.67Assessing Risk through Data Analysis. Technology tools like IDEA can also be used to help audit teams identify items with potentially higher risks within an entire population of items in an...

Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and analytics center has provided you...

1. Identify some of the weaknesses in KU's internal controls that allowed fraud to occur in the athletic department. Explain your answer. 2. Do you think that the sentences given to the perpetrators...

Present your analysis using the case analysis format, and answer the questions following the case. Joe Harshner was recently hired as a lathe operator m a rough turning department of Atlas...

Brady Construction Company contracted to build an apartment complex for a price of $ 5 , 6 0 0 , 0 0 0 . Construction began in 2 0 2 4 and was completed in 2 0 2 6 . The following is a series of...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

LO6 Define recruiting measurement and metrics and illustrate how analytics can be used to improve talent acquisition.

1. The mass retirement of Baby Boomers and the smaller generation that follows puts candidates in the drivers seat. Organizations will need to woo prospective employees and manage the candidate...

LO4 Identify three internal recruiting sources and issues associated with their use.