A data audit is a critical activity that must be done at the beginning of any...

A data audit is a critical activity that must be done at the beginning of any analytics project when you are working with an existing workbook or are given a dataset from another person. The purpose of this exercise is to conduct a data audit on a worksheet that contains sales data for a hypothetical apparel retailer.

The data shown in the file named Chapter 1 DA Exercise 2 contains data that was provided to you by a coworker. The Excel file should contain sales data for two years by month. You intend to use this data to evaluate the company’s sales trend by season. In addition, you will need to analyze the average price per month to determine if there are months where customers are spending more money for each item purchased. The data should contain sales in units and dollars. For any given month, the sales in units multiplied by the average price should equal the sales in dollars. Open the file named Chapter 1 DA Exercise 2. Audit the data in the Sheet1 worksheet. Record any problems you find in the dataset in the AnswerSheet worksheet. Note that there are more rows to document problems in the dataset than are needed.

*Company Sales Data*
Year	Month	Unit Sales	Average Price	Sales Dollars
2017	January	6,000	9.99	$ 59,940
2017	February	4,500	12.49	$ 56,205
2017	March	4,500	14.99	$ 67,455
2017	April	3,000	16.99	$ 50,970
2017	May	3,000	17.99	$ 53,970
2017	June	1,500	14.99	$ 22,485
2017	June	1,500	14.99	$ 22,485
2017	August	3,000	17.49	$ 52,470
2017	September	4,000	19.99	$ 79,960
2017	October	5,000	19.99	$ 99,950
2017	November	6,000	17.49	$ 104,940
2017	December	7,500	14.99	$ 112,425
2018	January	6,250	8.49	$ 53,063
2018	February	5,000	12.99	$ 64,950
2018	March	6,000	12.99	$ 950
2018	April	3,500	17.49	$ 61,215
2018	May	2,500	16.49	$ 41,225
2018	June	2,000	14.99	$ 29,980
2018	July	3,000	10.99	$ 32,970
2018	August	3,000	10.99	$ 32,970
2018	September	4,500	19.49	$ 87,705
2018	October	5,200	21.49	$ 111,748
2018	December	8,000	13.99	$ 111,920

*Use this worksheet to answer any written questions for this exercise.*
Write your answer in the merged open cell next to each Question number.
Question	Response
1
		2
			3
				4
5
		6
			7
				8
9

Expert Solution

to evalute the sales by season wise
	2017
	Pre Winter ( Nov to Dec)	Winter (Jna to Feb)	Spring ( Mar to April )	Summer (May to June )	Monsoon (July to Aug)	Autumn (Sep to Oct)	Totoal
Jna		59,940					59,940
Feb		56,205					56,205
Mar			67,455				67,455
April			50,970				50,970
May				53,970			53,970
June				22,485			22,485
July					22,485		22,485
Aug					52,470		52,470
Sep						79,960	79,960
Oct						99,950	99,950
Nov	104,940						104,940
Dec	112,425						112,425
	217,365	116,145	118,425	76,455	74,955	179,910	783,255
% of sales each season wise	28	15	15	10	10	23

based on above analysis in 2017 two season Autumn and pre vinter are more sales compare to other seasons.

	2018
	Pre Winter ( Nov to Dec)	Winter (Jna to Feb)	Spring ( Mar to April )	Summer (May to June )	Monsoon (July to Aug)	Autumn (Sep to Oct)
Jna		53,605					53,605
Feb		64,950					64,950
Mar			950				950
April			61,215				61,215
May				41,225			41,225
June				29,980			29,980
July					32,970		32,970
Aug					32,970		32,970
Sep						87,705	87,705
Oct						111,748	111,748
Nov	-						-
Dec	111,920						111,920
	111,920	118,555	62,165	71,205	65,940	199,453	629,238
% of sales each season wise	18	19	10	11	10	32

based on above analysis in 2018 there is no sales given in Nov but still two season Autumn and pre vinter are more sales compare to other seasons.

To determine the average price per month for more sepending customers.

In basic mathematics, an average price is a representative measure of a range of prices that is calculated by taking the sum of the values and dividing it by the number of prices being examined. The average price reduces the range into a single value, which can then be compared to any point to determine if the value is higher or lower than what would be expected.

	2017	2018
Sep	19.99	19.49
Oct	19.99	21.49
Nov	17.49
Dec	14.99	13.99
	72.46	54.97
Average price per month	18.12	18.32

in 2018 theree month only taken.

ekkarill92 answered 1 year ago

The success of any internal audit depends on the management of the entire activity in order...

The success of any internal audit depends on the management of the entire activity in order to add value to the organization. Discuss this statement. Highlighting the key things to be considered

For each audit activity, identify the audit procedure. Each activity has one answer, but the audit...

For each audit activity, identify the audit procedure. Each activity has one answer, but the audit procedures can be used more than once. - A. B. C. D. E. F. G. H. I. J. Review lease agreements for capital leases. - A. B. C. D. ...

Question (statistics) (Data below) (to be done with EVIEWS or any data processor) Millions of investors...

Question (statistics) (Data below) (to be done with EVIEWS or any data processor) Millions of investors buy mutual funds, choosing from thousands of possibilities. Some funds can be purchased directly from banks or other financial institutions (direct) whereas others must be purchased through brokers (broker), who charge a fee for this service. A group of researchers randomly sampled 50 annual returns from mutual funds that can be acquired directly and 50 from mutual funds that are bought through brokers and...

(Data below) (to be done with EVIEWS or any data processor) Millions of investors buy mutual...

(Data below) (to be done with EVIEWS or any data processor) Millions of investors buy mutual funds, choosing from thousands of possibilities. Some funds can be purchased directly from banks or other financial institutions (direct) whereas others must be purchased through brokers (broker), who charge a fee for this service. A group of researchers randomly sampled 50 annual returns from mutual funds that can be acquired directly and 50 from mutual funds that are bought through brokers and recorded their...

Suppose price levels are fixed, what must be done, if any, so that the equlibrium expenditure...

Suppose price levels are fixed, what must be done, if any, so that the equlibrium expenditure (Keynesian cross) stays in the same spot?

Statistics Question Data provided below (To be done with EVIEWS or any other data processor) d)...

Statistics Question Data provided below (To be done with EVIEWS or any other data processor) d) e) In general, we can conduct hypothesis tests on a population central location with EViews by performing the (one sample) t-test, the sign test or the Wilcoxon signed ranks test.2 Suppose we would like to know whether there is evidence at the 5% level of significance that the population central location of NAR is larger than 5%. which test(s) offered by EViews would be...

Provide any 4 issues that a manager must consider in implementing an activity-based costing system.

Why isn’t all audit work done simultaneously?

Select any CSR activity for any major university. And develop a plan of implementing that activity...

Select any CSR activity for any major university. And develop a plan of implementing that activity with the help of the decision-making matrix. The report should contain following information (headings): The CSR activity: You will define the activity i.e. it can be related to environment, society, workforce. CSR objective and goals: Define the goals and objectives that a university can achieve through that activity. Decision making matrix factors: Evaluate the CSR activity in terms of its profit, purpose and other...

Describe in detail the audit process required in performing an audit from beginning to end. Identify...

Describe in detail the audit process required in performing an audit from beginning to end. Identify how you would address auditing standards in your work.

Question