You are working on the Devon Inc. audit. The company is responsible for managing large-scale construction projects for its customers. During the risk assessment phase, you noted a higher risk in the area of contract management that provides the costs for each project, and therefore you need to conduct testing in this area. You decide to perform an ADA.

You have been provided with the construction project file, and you would like to use visualization as a technique to identify customers that have notable items related to them. The target gross margin on all projects is approximately 50 percent, with a variance of +/– 3 percent.

Required

Using a visualization tool of your choice (Excel, Power BI, or Tableau), access the construction project file through the chapter resources on WileyPLUS and:

a. Identify any notable item(s) given the targeted gross margin provided.

b. Identify two or three potential causes for the notable item(s).

c. Explain how you will follow up on the notable item(s).

d. What visual did you select? Why? Discuss your visualization with respect to level of detail, axis scaling, and use of colour.

e. What should be documented with respect to this test to meet the documentation requirements?