7236

4- 0
GI (23,335 unread) X rs’ao ADP Secure Clie X * My VU Collabor X BA05524 Assig x
wid Mail – yashvardl X 1
I Secure I https://yucollaborate.vu.edu.au/d21/1e/content/147412/viewContent/2163147/View
air
0
Irtri Apps W Potentiometer – Wik ( et Welcome to UPSEE 2 Q University of Petrole www.facilitiesnetcor www.cse.iitb.ac.in/cc pi What is Virtualizatioa. A The Benefits of Virtu. ( www.ijetae.com/files
CD P — +
SECTION M CASE STUDY USING ACTIVE DATA FOR EXCEL John Alexander, the financial controller of Ecochemicals Ltd (ECL), has provided you with the following computerised data files: • Authorised Suppliers (ECL_Supplier.xls) • Random sample of ECL’s purchases (extracted under the supervision of a member of your team; ECL_Purch_Trans.xls)
Key field details of these data files are listed below:
ECL Supplier.xls Field Type Description Supplier_No Supplier_Name Address 1 Address 2 State Post_Code Last Active ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) DATE Approved Supplier Code Supplier Name Supplier address Date of last transaction
ECL_Purch_Trans.xls Field Type Description Supplier No ASCII (Text) Approved Supplier Code Invoice_Date DATE Invoice_Date Invoice_No ASCII (Text) Supplier’s Invoice No Invoice Amt Numerical(2 decimals) Invoice Amount Product No ASCII (Text) ECL’s Item identification code Quantity Numerical Number of units purchased Unit Cost Numerical(2 decimals) Price per unit
t
6
/10
tri
‘Sr
III
12:05 PM •lli 6/1/2018

Attachments:

auditing.pngauditing-2.pngECL-FinST-G6…..xlsxexcel-file-2…..xlsx

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now