Homework answers / question archive / ACC555 Data Analytics  Practice Lab Problems-Chapter 6 Problem 1: Required information NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document

ACC555 Data Analytics  Practice Lab Problems-Chapter 6 Problem 1: Required information NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document

Accounting

Share With

---

ACC555 Data Analytics 

Practice Lab Problems-Chapter 6

Problem 1:

Required information

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Part 1: Identify the questions.
Part 2: Master the purchase order and payment data.
Part 3: Perform the analysis.

Refer to Chapter 6 pages 235 through 240 for instructions and steps for each of the lab parts.

Software needed

• Excel

Data

• Lab_6_2_SlainteAging_Dec.xlsx
• Lab_6_2_SlainteAging_Sept.xlsx 

After completing Lab Part 1, answer the following questions.

1. What data do you need to calculate the account balances? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Sales order itemsunanswered
• Sales order amountunanswered
• Customer account number or IDunanswered
• Sales order dateunanswered
• Cash receipt amountunanswered
• Cash receipt dateunanswered
• Customer addressunanswered
• Salesperson IDunanswered

2. What is the formula needed to compute the balance in accounts receivable? Fill in the blanks shown below.

Problem 2:

Upload the Word or PDF document containing your Lab screenshots using the button below.

Problem 3:

Required information

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Part 1: Identify the questions.
Part 2: Master the purchase order and payment data.
Part 3: Perform the analysis.

Refer to Chapter 6 pages 240 through 241 for instructions and steps for each of the lab parts.

Software needed

• Excel or IDEA

Data

Lab 6 Current Audit Files - If you have already downloaded these files from Lab 5-1, you do not need to download again. 

After completing Lab Part 1, answer the following question.

Before computerization or data analytics, how would companies find that they had made duplicate payments? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Auditor samplingunanswered
• Evaluation of all paymentsunanswered
• Reported by vendorunanswered
• Random chance

Problem 4:

After completing Lab Part 2, answer the following question.

What data items do you need to be able to find duplicate payments? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Vendor IDunanswered
• Payment amountunanswered
• Payment dateunanswered
• Employee IDunanswered
• Invoice numberunanswered
• Vendor address

Problem 5:

After completing Lab Part 3, answer the following question.

1. How many duplicate records did you locate?

2. What course(s) of action would you recommend? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Try to make many duplicate paymentsunanswered
• Do nothingunanswered
• Recover payment from vendorunanswered
• Follow up with accounts payable departmentunanswered
• Implement better internal controls

Problem 6:

Upload the Word or PDF document containing your Lab screenshots using the button below.

 Problem 7:

Required information

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:
Test a hypothesis in Excel. Specifically, we will see if the returns in January are greater than the rest of the year.

Part 1: Identify the Questions
Part 2: Master the Data
Part 3: Perform an Analysis of the Data
Part 4: Address and Refine the Results
Part 5: Communicate Insights and Track Outcomes

Refer to Chapter 6 pages 241 through 247 for instructions and steps for each of the lab parts.

Software needed

• Microsoft SQL Server Management Studio (available on the Remote Desktop at the University of Arkansas)
• Excel 2016 (available on the Remote Desktop at the University of Arkansas)
• PowerPivot add-in for Excel (available on the Remote Desktop at the University of Arkansas). If you do not see the PowerPivot tab on the Excel ribbon, you will need to enable the add-in.

Data

The data for this lab and all other Dillard's labs must be accessed through the University of Arkansas Remote Desktop. Documentation on how to connect and log in to the remote desktop can be found below and on the Additional Student Resources page.
Once you have a remote access account, you can log in to access the University of Arkansas server using any web browser. Instructions for logging in can be found below:

Logging into UARK Remote Desktop - VMWare
Accessing the Dillard’s dataset in Excel

After completing Lab Part 4, answer the following questions.

1. Using the p-values (or the t-statistic and critical values), answer the questions presented in the statement below.

The p-value for the january is -----------the rest of the year, so returns as a percentage of sales for january are --------the returns as a percent of sales for the rest of the year. (options were higher, lesser, greater, lower, same as)

Problem 8:

Upload the Word or PDF document containing your Lab screenshots using the button below.

 

Note: Problem 2, 8 are not answered in this document.