Accounting Information Systems
This assignment aims to provide students with a detailed understanding of business activities performed in the major business cycle and the flow of accounting data and information in those accounting information system. Upon completion of this assignment, students would be able to appreciate and practically apply the different methods in building, using and implementing accounting information systems to meet organisation goals which are taught through BACS2703 Accounting Information Systems. It introduces and manages the use of information communication technology and accounting information systems in the actual business environment in order to optimize business benefits.
2. Learning Outcomes
Upon the completion of this assignment, the students will be able to:- Comprehend the basic business activities and related information processing operation performed in the accounting information system. Demonstrate the application of Data Flow Diagram (DFD) and flowcharting modelling tools to design an accounting information system to provide information needed to make key decisions. Recommend various control internal methods of using and implementing accounting information systems in an organization.
3. Group Formation
Students will be assigned to groups of 3 to 4 members per team by the tutor in-charge, depending on the class size.
Every member in the team is expected to contribute and participate actively in the entire process of completing this assignment. Each of the group members will be responsible for individual activity; the task depends on the allocation by the respective group leader. Sharing of ideas, extensive group discussion, and brainstorming among group members are required to complete this given assignment.
4. Assignment Tasks
Due to the converging role of accounting and information systems in AB Hi-Fi, students are required to discuss with their group members and prepare a report according to the attached case study below.
Case Study: AB Hi-Fi
AB Hi-Fi is a multi-store retail business that sells products such as DVDs, CDs, mp3 players, game consoles and TVs. In addition, AB Hi-Fi also sells music, games and DVDs via its website. AB Hi-Fi has a central warehouse that is located in Melbourne. All products purchased by the business are delivered to this central warehouse. The narrative of the revenue cycle, recording payments process and expenditure cycle are as follows.
Customers browse the AB Hi-Fi online store looking for products to purchase from the product catalogue. When they have located an item they wish to purchase they click on a ‘buy this item’ link located underneath the item required. The computer displays a screen showing the product ID number and asks the customer to enter the quantity of the item required. The customer keys in the quantity required. The computer then displays a screen asking the customer if they want to continue shopping. Once the customer indicates that they do not want to continue shopping the computer calculates and displays an order confirmation screen containing the product ID number, product price, quantity and total cost per item for each different item ordered, the shipping amount (AB has a standard shipping rate within Australia of $10 per delivery) and a total for all items and shipping costs.
The screen asks the customer to input their credit card and delivery details to complete the order. The customer inputs the delivery details (name and address and credit card details (card number and expiry date) into the order confirmation screen. The computer assigns the next sales order number to the transaction, then displays a screen for the customer which provides the sales order number and confirms that the order has been completed. The computer records the sales order details in the sales event data store. At 11 pm every evening the computer extracts details of the day’s sales and updates the inventory levels. The computer prints a picking ticket (barcoded sales order number, items and quantities) on the warehouse printer and produces an electronic credit card check file listing all the credit card details (customer name, credit card number and expiry date) from the previous day’s sales.
At 8 am every morning the warehouse clerk collects the picking tickets from the warehouse printer and picks the required goods from the shelf . lf any of the goods are not available the warehouse clerk puts back any goods they have already picked for the order and places the picking ticket in a folder on their desk labelled ‘awaiting goods’. lf all the goods are available the warehouse clerk takes the goods and the picking ticket to the shipping department. The shipping clerk scans the sales order number from the picking ticket, and the computer displays the order on the screen. The shipping clerk manually checks each item picked against the original sales order, and the picking ticket.
The shipping clerk also checks the name on the sales order against the names highlighted on the credit card status report. lf the name on the order matches a name on the credit card status report, the goods and the picking ticket are sent back to the warehouse with a note attached indicating they cannot be shipped due to non-payment. Once they are satisfied that the credit card payment is not invalid, and that the correct items are being shipped, the shipping clerk checks a box on the sales order to indicate that shipping is complete. The computer updates the sales order and inventory data. The computer also prints a delivery slip for the order on a printer in the shipping department. The shipping clerk attaches the delivery slip to the goods and places them on the loading dock. Every day at 3 pm a carrier picks up the goods from the loading dock and delivers them to the customer.
The computer sends the electronic credit card check file that was produced at 11 pm to the bank’s computer for verification. At 1 pm every day the bank sends an electronic report via email to the accounts receivable clerk indicating the status of each of the credit card orders (valid/invalid). The accounts receivable clerk prints out two copies of the credit card status report. The accounts receivable clerk files one copy of the credit card status report and uses a highlighter pen to mark out on the second copy the name of any customers whose credit card was reported as invalid. The accounts receivable clerk takes the highlighted report to the shipping clerk who is responsible for checking that these customers do not receive any goods.
Immediately after the bank sends the electronic status report the funds for all valid credit card orders are transferred into the company’s bank account. The accounts receivable clerk receives an email from the bank advising them of the total amount of the funds transferred. The accounts receivable clerk compares the total in the email to the total in the credit card status report. lf these totals agree the amount is input into the computer and the cash receipt data store is updated. lf the totals do not match the problem is referred to the accounts receivable manager for resolution.
Besides prepaid online sales and retail cash sales, AB Hi-Fi offers a credit facility to selected larger customers. These customers receive invoices when they purchase goods, and are sent a statement at the end of each month. Payments made by these customers are received by the cashier. Every morning the accounts receivable clerk receives a report of customer receipts from the cashier. The customer receipts report contains the customer number and name, the amount received from each customer and the total of the customer receipts. The accounts receivable clerk logs on to the computer and opens a new cash receipts batch.
The accounts receivable clerk enters the first customer number from the customer receipts report. The computer displays details of the open (unpaid) invoices for that customer. The accounts receivable clerk selects the invoices that have been paid by clicking on a check box. The computer calculates a total for the customer based on the invoices checked. Once the accounts receivable clerk has checked that they have selected the correct invoices and that the customer total matches the total received by the cashier from that customer, they authorise the receipt allocation.
The computer records the cash receipt total and changes the status of the selected invoices from ‘open’ to ‘closed’ (paid). The accounts receivable clerk does this for every customer receipt on the report. 0nce all the customer receipts have been entered, the accounts receivable clerk updates the computer to record the cash receipts batch as complete. The computer automatically prints out a report that contains details of the cash receipts batch. The accounts receivable clerk attaches the cash receipts batch report to the customer receipts report and files them away.
Purchase clerks at AB Hi-Fi monitor stock levels via the computer. The computer has predefined reorder points and reorder quantities for each inventory item. When stock levels for a particular item drop down to this reorder point a purchase requisition is automatically generated by the computer and forwarded via email to the purchase clerk responsible for these items. The purchase clerk is responsible for reviewing sales trends for this item, and deciding whether to reorder the goods listed on the purchase requisition. The purchase clerk can cancel the order if they feel that the goods are not worth reordering, amend the purchase requisition if they think that the quantity is too high or too low, or accept the requisition without change. Once the purchase clerk has made a decision about the purchase requisition they log on to the computer and open the purchase requisition. They make any changes required to the quantities and products on the purchase requisition, and then mark the requisition as complete by ticking on a check box.
The completed purchase requisition is then sent via email to the purchasing manager for review. The purchasing manager logs onto the computer and opens the purchase requisition. The purchasing manager is offered a choice of two tick boxes for each open purchase requisition. lf the manager selects the ‘reject’ box the purchase requisition is cancelled and no further action is taken. lf the purchasing manager selects the ‘accept’ box an email is sent to the purchase clerk informing them that the purchase requisition has been approved.
When the purchase clerk receives the approved purchase requisition email they log on to the computer and request a list of approved suppliers for each of the items on the approved requisition. The purchase clerk sends an electronic copy of the purchase requisition via email to each of the approved suppliers, requesting quotes for product and delivery costs, and an estimated delivery date.
When all the quotes have been received the purchase clerk decides which supplier to place the order with. The purchase clerk logs on to the computer and opens the relevant purchase requisition. They select the option to create a purchase order by ticking on a check box. The computer requests input of a valid supplier number then uses the supplier data and the purchase requisition data to produce a purchase order. The purchase order is sent via email to the supplier, the purchase clerk and the warehouse clerk responsible for these products.
As part of their trading agreement with AB Hi-Fi all suppliers are required to provide a delivery docket that lists the items they are delivering, the number of cartons being delivered and the purchase order number the delivery relates to. On arrival at the warehouse the delivery driver hands the warehouse clerk two copies of the delivery docket. lf there is no purchase order number included on the delivery docket, the warehouse clerk will refuse to take delivery of the items. The warehouse clerk enters the purchase order number from the delivery docket into the computer. The computers extracts the purchase order status from the purchase order data store.
lf the purchase order number is invalid, or the status of the purchase order is ‘closed’, the computer will display an error message, and the warehouse clerk will refuse to take delivery of the items. lf the purchase order number is valid, the computer will display a message indicating that it is OK to accept a delivery for this purchase order, and asking if the warehouse clerk would like to print a goods received report for the purchase order. The warehouse clerk requests the computer to print the goods received report. The computer retrieves a list of the items ordered from the purchase order data store and the supplier details from the supplier data store. The computer prints the goods received report on a printer in the office of the warehouse clerk.
The warehouse clerk counts the number of cartons, and verifies the count against the delivery docket. Once the warehouse clerk has checked that the number of cartons delivered matches the number of cartons on the delivery docket the warehouse clerk signs the first copy of the delivery docket and gives the signed delivery docket to the delivery driver.
The warehouse clerk opens the cartons and checks and counts the items delivered, and writes the quantity of each item on the printed goods received report. Some orders are quite large, so individual boxes are not always opened and counted; in this case. the warehouse clerk relies on the external label stuck to the outside of the carton. Once all the items are counted and checked the warehouse clerk dates and signs the goods received report. The warehouse clerk staples the completed goods received report to the second copy of the delivery docket then puts the completed goods received reports in a tray on the desk of the goods receiving clerk.
Each morning the goods receiving clerk retrieves the previous day’s completed goods received reports from the tray on their desk. The goods receiving clerk inputs the purchase order number from the goods received report into the computer. The computer retrieves and displays the purchase order data, without the item quantities. The goods receiving clerk works through line by line and inputs the quantities received for each item from the goods received report. Once the goods receiving clerk has accounted for all the items on the goods received report they tick a box on the computer screen to indicate that the goods received report input is complete.
The computer will update the purchase order and inventory data stores with the goods received information and then display a message confirming the completion. The goods receiving clerk dates and signs the goods received report, and then sends the completed input goods received report to the accounts payable clerk. The goods receiving clerk processes each completed goods received report in the tray in the same way. The accounts payable clerk receives the completed input goods receiving report from the warehouse clerk. The goods receiving report is filed in an awaiting invoice folder.
As part of their trading agreement with AB Hi-Fi all suppliers are required to provide the related purchase order number on their invoice. When the accounts payable clerk receives an invoice from a supplier they enter the purchase order number from the invoice into the computer. The computer extracts the purchase order status from the purchase order data store. lf the purchase order number is invalid, or the status of the purchase order is ‘paid’, the computer will display an error message.
lf the purchase order number is valid and unpaid the computer will display a message indicating that it is OK to make a payment against this purchase order, and asking if the accounts payable clerk would like to print the purchase order. The accounts payable clerk requests the computer to print the purchase order. The computer retrieves details of the items ordered from the purchase order data store and the supplier details from the supplier data store. The computer prints the purchase order on a printer in the office of the accounts payable clerk.
The accounts payable clerk retrieves the relevant goods receiving report from the awaiting invoice folder. The accounts payable clerk attaches the goods receiving report to the purchase order report and the invoice, then checks to identify if there are any quantity discrepancies between the three documents. If any quantity discrepancies are identified the accounts payable clerk sends the reports to the warehouse supervisor. lf no quantity discrepancies are identified the accounts payable clerk inputs the purchase order number into the computer and requests a payment screen. The computer displays a payment screen containing the purchase order details. The accounts payable clerk enters the invoice data (item quantity and price). The computer extracts the purchase order price from the purchase order data store and compares the invoice price with the purchase order price.
lf there is a price variation of more than 5 per cent the computer displays a price variation message and routes the payment data to the accounts payable supervisor for approval. lf the invoice price is within 5 per cent of the purchase order price the computer displays a payment accepted message. The computer calculates the payment due date based on details held in the supplier data store, records the invoice in the accounts payable data store, and updates the purchase order and general ledger data stores. The accounts payable clerk files the goods receiving report, purchase order and invoice documents in an awaiting payment folder.
At the end of each week the computer extracts details of payments due from the accounts payable data store and produces a payments file which is forwarded electronically to AB Hi-Fi’s bank. The bank transfers money from AB Hi-Fi’s bank account to the relevant suppliers in accordance with the details in the payments file. After the payments file has been successfully transferred to the bank the computer prints a report of payments made on the central printer, then updates the accounts payable and general ledger data stores. The accounts payable clerk collects the printed report of payments made and retrieves the appropriate documentation from the awaiting payment folder. The accounts payable clerk matches documents in the awaiting payment folder with the payments listed on the payments made report. Matched sets of documents are attached to the payments made report, then filed in a paid folder.
a) Explore and analyze the usage of AIS in the current business processes of AB Hi-Fi using DFD context diagram, DFD level 0, DFD level 1and system flowchart. (30 marks)
b) Analyze the degree of exposure to each of risk and weaknesses for the current business processes of AB Hi-Fi. (10 marks)
c) Based on your analysis in part (b), propose control internal methods and recommended changes to AB Hi-Fi to reduce the identified risks. (10 marks)
d) Explain how the use of technologies can improve AB Hi-Fi’s decision making and business processes. (10 marks)
e) Others*: format, knowledge and originality. (10 marks) [Total: 70 marks]
* Students are encouraged to do research through Internet sites, acquire
further information from reference books and obtain additional ideas from other resources.
5. Distribution of Assignment & Submission Date
Assignment question distribution date: 12th May 2014, Monday (Week 1) Assignment report submission date: 25th July 2014, Friday (Week 11)*
* Only tutorial groups on Saturday allowed to submit on 26th July 2014 (Week 11).
6. Assignment Report Format
The final assignment report should consist of the following components: – (a) Cover sheet (Appendix – FORM 1)
(b) Assignment Final Report Assessment Criteria. (Appendix – FORM 2 ) (c) Plagiarism statement with student signatures. (Appendix – FORM 3 ) (d) Clear listing on individual task allocation for this assignment. (Appendix – FORM 4 ) (e) Acknowledgement
Students should express their appreciation towards any 3rd party for assistance and provision of information used in the report. (f) Table of contents
It should indicate the various headings or sub-headings covered in the assignment and page numbers.
Students should give preface about the structure of the information system chosen, background of the company using the system and etc. (h) Body of answer-research, findings, recommendations, and evaluation section Students are required to write their answers and comments as well as to print the attachments of the menu of the accounting information system in this section. This is the main part of the report and students are to follow the requirements of the assignment task as stated earlier.
The entire answers / findings should be concluded.
(j) Reference section
Students should only include a list of references which they have used. Brief
details of reference books, magazine, articles, or Internet sources are not allowed. (Students are required to use Harvard Referencing System format) (k) Appendices section
Students should try to include all relevant materials, figures, or diagrams in the main body rather than in the Appendix in order to enhance the understanding of the assignment. This section is reserved for items which may not be directly relevant or essential to enhance a reader’s understanding of the assignment or which may interrupt the reading of the assignment (e.g. too voluminous).
The report must be type-written using MS-Word and written in the format of the following requirements:-
A body text of font size 11 is required while for headings and subheadings a larger font size must be used. Font Style
Use Times New Roman for body text. Main headings and sub-headings should be clearly stated using suitable font styles (eg. Arial). Line Spacing
Typed material should be single-line spaced.
Use Justify for alignment.
Headers and Footers
Appropriate footers and headers should be used to enhance clarity and presentation. Page Numbering
Ensure that all pages (except cover page) are numbered.
Use A4 paper (29.7cm x 21cm).
All pages should be tape-bind. Use only one side of the paper. Table 1: Written Report Format
This assignment will contribute a total of 70 precents to the coursework marks of the course. A report shall be produced as an outcome of the research, findings, and evaluation.
The students will be assessed on an oral presentation and a written report in NOT more than 30 pages, where this will be assessed based on the following criteria:- Clarity of explanation
Reasonable command of English
Reasonable coverage of discussion, information and evaluation. Numbers of pages for cover sheet, assessment criteria, plagiarism statement, list of tasks allocation, acknowledgement, table of contents, references, diagrams used and appendices are NOT counted.
8. Late Submission
All assignments should be submitted by the stated due date (week 11, Friday, before 2pm) unless it is revised and approved by the respective lecturer / tutor. Marks will be deducted for late submissions of the written report at 5% per day (include weekends), unless reasons or application for extension and approval is given before the due date of the assignment. Therefore the responsibility is upon the students to ensure that an assignment is substantially prepared prior to the submission date. Late submissions for more than SEVEN (7) days (from due date) will not be accepted.
At a general rule, no extension of time will be granted. The assignment question and its due dates are normally disclosed in advance to students in order that they will be able to manage their time according to different subject study progress and complete this assignment on time.
Students are required to redo the entire assignment (depends on the seriousness of inaccuracy of the answer) if the contents of any part of the assignment does not comply with the requirements of the assignment as requested by the subject lecturer/tutor.
A written feedback on the assignment will be returned to the students latest by week 14, by the tutor in-charge.
11. Plagiarism & Collusion
The Faculty of Accountancy, Finance & Business views cases of plagiarism or collusion by students very seriously. Any students who intentionally plagiarize or collude in any part of their assignments/projects or written work threatens the values of academic work and undermines the credibility and integrity of the University College’s awards. Plagiarism or collusion discovered at any stage of the student’s course of study will be dealt with appropriately by the Faculty. Such offender shall appear before a panel of enquiry at the Faculty and appropriate punishment will be meted out. Punishment may include failing the student for the assignment or project, re-submission of another piece of work or downgrading of the work the maximum of a pass grade even if actual grade achieved was higher.
What constitutes “Plagiarism” and “Collusion”?
Plagiarism according to the Oxford Advanced Learner’s Dictionary of Current English means “take and use somebody else’s ideas, words, etc as if they were one’s own.” Plagiarism can take the form of reproduction without acknowledgement from published or unpublished works of others including materials download from computer files an the Internet
Student’s work submitted for assessment is accepted on understanding that it is the students’ own effort without falsification of any kind. Acknowledgement to the source must be made if students had relied on any sources for information with appropriate reference being made in their work. In particular, you need to cite sources discovered on the Internet or any other publications. Given the explosion of electronic publications in recent years, students need to be careful that their assignments do not become an exercise in cutting and pasting existing abstracts or portions of World Wide Web pages. Rarely will such an approach produce acceptable results.
Collusion can be deemed to be a form of plagiarism involving the unauthorized co-operation between two or more people with deceptive intention.
Collusion can take the form of two or more students producing a piece of work together but with one intentionally passing it off as his work with the knowledge of the others. Student may have submitted the work of another as his own with consent from that other student. In such cases, both parties are guilty of collusion.
As this assignment is considered as a group assignment, the forming of a group to share ideas and assist in the development of assignments or projects is an accepted and encouraged practice. However, it is NOT acceptable for members of one group to submit identical answers to assignment, by simply copying the work done from another group and cosmetically disguised it with some modifications.
All assignments must be submitted individually as a group and the lecturer is entitled to consider identical layout, identical mistakes, identical argument and identical presentation to be prima facie evidence of collusion.
Obligations of students
Students are required to sign a declaration that the work submitted such as course work assignment, essays and projects, etc is their own original work/effort and that they have not in any way knowingly or allowing another student to copy it. It will be assumed that all submitted work is that of the students’ own work.
Students are expected to familiarize themselves with or make use of method(s) of citing other people’s work in accordance with acceptable referencing.
Students are required to submit their report to SafeAssign which is provided in University College CeL to check their work against a database containing other student reports, websites, and any other media sources. The matching contents of your report returned from SafeAssign shall NOT more than 20 percents. Before you submit your final assignment outcome for SafeAssign checking, please ensure that all work submitted must be original and NOT previously submitted for assessment in this University College or elsewhere. Otherwise, penalty of mark action may be taken by course tutor and students are required to review their report appropriately and re-submit again to SafeAssign.
Remark: For each group, please assign only ONE member to use his/her account for uploading of whole assignment outcome for SafeAssign submission and checking.
The following contains various forms used at various stages of the assignment. You may make copies where necessary.
Tunku Abdul Rahman University College
Faculty of Accountancy, Finance & Business
Bachelor of Accounting
RAC (Tutorial Group)
BACS2703 Accounting Information Systems
(For Tutor use)
Tutor’s Name: ________________
Date of Submission: ________________
Assignment Final Report Assessment Criteria
The assessment of this final assignment report is based on the following criteria:
Understanding of AIS DFDs and Flowcharts
Correct and complete identification of AIS implemented.
Able to provide clear description of AIS details DFDs and Flowcharts. (21%-30%)
Average to provide clear & complete identification of AIS implemented. Average to provide clear description of AIS details DFDs and Flowcharts. (11%-20%)
Poor to provide clear & complete identification of AIS implemented. Poor to provide clear description of AIS details DFDs and Flowcharts. (1%-10%)
Unable to identify the AIS implemented.
Unable to provide description AIS details DFDs and Flowcharts. (0%)
Analysis of risks and weaknesses for the current AIS
Able to provide clear and reasonable evaluation with very details explanations. (8%-10%)
Average to provide reasonable evaluation. However, some explanations are not clear. (4%-7%)
Poor to provide reasonable evaluation with limited explanation of the answers. (1%-3%)
Unable to evaluate the risks and weaknesses of AIS with no explanation at all. (0%)
Proposal of control internal methods and enhancement or new solutions to the current AIS application (10%)
Able to propose control internal methods and enhancement or a new solution with very details and reasonable justification given. (8%-10%)
Able to propose few control internal methods and enhancement or a new solution with fair justification given. (4%-7%)
Able to propose very few control internal methods and enhancement or a new solution with very limited justification given. However, some methods of control or the new solution is not relevant. (1%-3%)
Unable to propose any control internal methods and enhancement or a new solution with no justification at all. (0%)
Justification of technologies used to change / manage the organization decision making and business process (10%)
Able to provide clear and reasonable assessment & justification with very details explanations. (4%)
Average to provide clear assessment & justification. However, some explanations are not clear. (2%-3%)
Poor to provide clear assessment & justification with limited explanation of the answers. (1%)
Unable to justify and access the use of technology with no explanation at all. (0%)
Professional format and structure. Logically arranged. (3%)
Clear and recognizable format with an adequate logical structure. (2%) Recognizable format and structure, although occasionally unclear. (1%)
Little attempt to use the appropriate format or to structure content. (0.5%)
Thorough display of taught knowledge indicating high level of details. (3%)
Some display of relevant taught knowledge at certain level. (2%)
Some evidence of taught knowledge displayed, but just in minimum level. (1%)
No evidence of taught knowledge displayed. All are not related to the subject. (0%)
Adequate evidence of proving appropriate & relevant of research & information. (4%) Sufficient evidence of originality of work.
Minimal evidence of originality of work. (2%)
Lacks or no evidence of originality of work. (1%)
Faculty of Accountancy, Finance & Business
Read, complete, and sign this statement to be submitted with the written report.
We confirm that the submitted work are all our own work and are in our own words.
Name (Block Capitals)Registration No.Signature
1.……………………… ……………………………. ………………
2.……………………… ……………………………. ………………
3.……………………… ……………………………. ………………
4.……………………… ……………………………. ………………
Tutorial Group: ………………………………….
Date : ………………………………….
BACS2703 ACCOUNTING INFORMATION SYSTEMS
Individual Tasks Allocation
Indicate (√) in member name column if he/she have involved in that task.