Ask a question from expert

Ask now

Auditing and Assurance Service Name of the Author: Answer to Question No 2

6 Pages873 Words349 Views
   

Added on  2019-10-30

About This Document

The process that needs to be undertaken by taking help of the processes involve: Importing the accounting data into the Microsoft Excel Summarising and sorting the data Exemptions reporting making use of the advanced filters Pivot tables for data evaluation Charting the outcomes Handling the report files Choosing the random sample Locating the matching data or joining The accounting data with respect to the inventory accessories would be importing the sub total values of the excel sheet and then making use of the master data to sort the data within various stratum

Auditing and Assurance Service Name of the Author: Answer to Question No 2

   Added on 2019-10-30

BookmarkShareRelated Documents
Running head: AUDITING AND ASSURANCE SERVICE Auditing and Assurance ServiceName of the Author: Name of the University: Author’s Note:
Auditing and Assurance Service Name of the Author: Answer to Question No 2_1
1AUDITING AND ASSURANCE SERVICE Table of ContentsAnswer to Question No 1................................................................................................................2Answer to Question No 2................................................................................................................3Bibliography....................................................................................................................................5
Auditing and Assurance Service Name of the Author: Answer to Question No 2_2
2AUDITING AND ASSURANCE SERVICE Answer to Question No 1 The first question requires to list and explain the audit work that would be performed on thedata data master file. It is seen that the master file that has been provided is in text format andrequires to be converted into excel in order to undertake analysis. With respect to the data file that has been provided in the excel sheet, master data withrespect to the inventory would be undergoing the process of stratum where the count, averageand sum of six layers would be evaluated. The six layers are constructed with the help of thevalues that are available for each each of the product numbers. Stratum 1 comprises of the valuesthat are below 0. Stratum 2 collects the values that are more than 0 but are less than 1000.Stratum 3 has values that are more than 1000 and are less than 5000. Stratum 4 has values morethan 5000 but are less than 10000. Stratum 5 has figures that are more than 10000 but is less than50000. The last layer has values that are more than 50000 but less than 100000. The count,average and sum of the figures would provide answers that would aid in the process of auditing.The next process comprises of computing the age of the products that are within the inventoryand it is seen that the value comprises to more than 360. The next performance will becomputing the LOC 6 and values that are above 5000. The process after this would be computingthe margin so that the inventory level can be evaluated in an effective manner. The last workwould be computing the sub total that would be influential for the completion of the audit work.
Auditing and Assurance Service Name of the Author: Answer to Question No 2_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
BSBFIM501A Manage Budgets and Financial Plans Assignment
|7
|1927
|157

Management Accounting Report
|6
|717
|28

Assignment of Accounting Systems and Processes
|25
|1450
|36