Accounting Information Systems

Accounting In course of actionation Systems3-1. The text provides seven reasons wherefore archiveing AISs is essential (1) depicting how the placement performances, (2) training engagementrs, (3) designing new systems, (4) controlling systems education costs, (5) standardizing communication with others, (6) canvassing, and (7) controlling end-user support costs. Additional reasons include (1) to help evaluate the performance of system mortalnel, (2) to help evaluate the adequacy or efficiency of an alert system, and (3) to provide design specifications to outside vendors who might be proposing new systems.Accountants atomic number 18 interested in system documentation for all these reasons. For example, inadequate documentation makes it herculean to use an integrated accounting package effectively, design angiotensin-converting enzyme for others to use, or audit a system intelligently. Flowcharts and similar systems documentation are too important to auditors. These cha rts rotter help auditors spot internal control weaknesses that are not apparent from prototypes or not obvious when observing a system in use.3-2. register plycharts are a type of system flow sheet. Whereas system flowcharts are process-oriented, document flowcharts focus on the flow of physical documents through the processing system. chronicle and system flowcharts are similar in that they use similar symbols in their construction. A few additional symbols, such as envelopes and hand trucks to depict act of goods, are more likely to appear in document flowcharts than system flowcharts. But system flowcharts contain more detail about processing system of logic.Accountants can use info flow diagrams (DFDs) to depict the physical flows of data through an AIS (like document flowcharts), or the logical flow of data through an AIS (like system flowcharts). the like document or system flowcharts, their main objective is to document data flows in an hunting lodgely, graphic, and easily-understood format. But DFDs use fewer symbols than either document or system flowcharts, and do not require columns (like document flowcharts).Program flowcharts are really the lowest level of system flowcharts because they outline the logic sequence for a bad-tempered application program. Thus, they are more used by programmers and system analysts than by accountants and auditors. Still, auditors will need to understand these program flowcharts when looking at program logic and program controls. Program flowcharts use more of the same symbols found in system flowcharts, but also use some special ones such as the decision symbol.3-3. A document flowchart is a pictorial representation of the physical data flow through the various departments of a business. A document flowchart is used in designing or evaluating an accounting information system.1. A systems analyst uses it when evaluating a system to see if each department is receiving the necessity data and that unnecessar y data are not transferred.2. A system designer uses it when there is interest in improving or replacing an real system.3. A computer programmer can use a document flowchart when preparing system flowcharts.4. An auditor uses it to help define, follow, and evaluate an audit trail.5. An internal data security expert uses it to indicate weaknesses in internal control and data control.3-4. Guidelines for creating document flowcharts, system flowcharts, and data flow diagrams are listed in the text. See germane(predicate) chapter sections for document flowcharts, system flowcharts, and data flow diagrams.3-5. Data flow diagrams use a square symbol to show the source or destination of data. A circle symbol indicates a process. An open rectangle symbol indicates a store of data. Finally, arrows depict a data flow or data stream.3-6. Data flow diagrams are piddled in a hierarchy called the top-down approach to systems development. In this approach, developers create these diagrams in le vels, beginning with the broadest, least-detailed level, and exploding ( shiting towards increasing refinements of) each piece of the preceding level until the system is completely specified. The rationale behind this approach is to keep major system objectives in view at first, and to worry about details by and by after major system components are specified. However, the process is reiterative, revisions are common, and little is considered final until the lowest diagram levels have been specified and approved.The broadest DFD is called a context diagram. The coterminous level (a level-0 diagram) is also called a physical data flow diagram. Lower levels are numbered level-1, level-2, and so forth, and are commonly termed logical data flow diagrams.3-7. It is unremarkably easier to follow logic with a chart or figure than with a indite narrative. For example, when reading a long narrative description of a process, it is frequently difficult to visualize relationships between sy stem elements and a readers attention can wander. In contrast, graphical depictions of the same logic are usually easier to understand because roughly people grasp the use of arrows to show connections or data flows.3-8. Decision tables outline the set of conditions that a given processing task might get wind and indicate the appropriate put through to take for each condition. Decision tables can therefore help system designers plan data processing scarpers and create written records of the processing logic for later reference. The major advantage of decision tables is that they can summarize a potentially large number of conditions and actions in a pile format. Decision tables are also useful as planning tools to system analysts and related mortals who are charged with the task of helping create new AISs. Finally, the accountants who audit AISs rely heavily upon internal documentation, and decision tables can help them verify the processing logic and control procedures that w ere built into these AISs.3-9. Just as word processors modify users to create, store, modify, and affect word documents, CASE tools enable information technology and accounting personnel to create, store, modify, and print system documentation. The term CASE is an acronym for computer assisted parcel engineering. CASE tools automate the development of program and system documentation. Thus, developers use them to create data flow diagrams, entity relationship diagrams, record layouts, data entry covers, report formats, screen menus, system flowcharts, and program flowcharts. Most also include generators for developing data dictionaries.CASE tools are computer programs that typically run on microcomputers. The user selects a particular type of document to develop or modify, and then works on it in much the same way that a secretary uses a word processor to work on a word document. It is not necessary to use CASE programs to develop AIS documentation, but it is difficult to imagine why anyone would not use such capable and time-saving tools.3-10. End user computing refers to the computer activities of non-computer employees, especially the development of large spreadsheets and databases. Although such activities are commonplace today, they also create problems. For example, when non-IT personnel develop important computer applications, a company becomes increasingly dependent upon such individuals to answer questions, or to explain how to use the software. living is also important in end-user computing environments because it provides the training aids, user descriptions, tutorial manuals, and reference materials that other users need in order to run the applications effectively.Problems3-11.Processswitch ProcessDecisionDataPredefined ProcessInternal StorageDocumentMultidocumentTerminatorPreparationManual InputManual Operation joiningOff-page ConnectorCardPunched TapeSumming JunctionOrCollateSortExtractMergeStored DataDelaySequential AccessMagnetic Disk stra ightaway AccessDisplayStorageStorage3-12.Mark Goodwin Convenience StoresGarcia-Lanoue alliance3-15. Ron Mitchell Manufacturing Company3-16. Amanda M Company3-17. Winston Beauchamp Company3-18. LeVitre and Sweezy Credit Union3-19. Jeffrey Getelman Publishing Company3-20. The Bridget Joyce CompanyThe decision table is shown infra. Note that alternate decision rules would also be reasonable here since the case does not specify exactly what action is to be taken for each set of conditions.DECISION TABLERULESAccount Status1234567891011Not past dueXLess than 30 old age past dueX31-60 days past dueXXX61-90 days past dueXXXMore than 90 days past dueXXXAccount ActivityNo activityXXXXXWritten communication theoryXXXPartial paymentXXXActionDo nothingXXXXXXXSend first letter of inquiryXSend second letter of inquiryXX collecting agency referralXThis exercise requires some creativity on the part of the student. One possibility is to give each customer a rating on the followinga) no anteceden t delinquency historyb) only one prior delinquencyc) only twain prior delinquenciesd) more than two prior delinquenciesMr. Smith can now make a decision based upon this categorization of customer account history. It might also be pointed out that many companies handle delinquencies on an individual basis. Most small companies, for example, will try to work with their customers whenever possible instead of writing to them impersonally because written confrontations rarely start desired results.3-21. This problem requires students to draw the flowcharts in Figure 3-20. In a later part of the problem, students are also asked to recreate the flowcharts in Figures 3-3, 3-6, 3-8, 3-11, 3-12, 3-13, 3-14, and 3-15. Because these flowchart are already shown in the text, the outputs are already known.Teaching notes Students should follow the directions provided in this case to create the two (program) flowcharts shown as well as the link that connects the two flowcharts together. Students c an document their links by printing a counterpart of their formulas. Finally, although using Excels drawing tools is straightforward, it still takes time to create even small diagrams with them. Thus, we commend that instructors do not assign all parts of this case (a through h), but only assign a selection of these diagrams.Case Analyses3-22. The Berridge Company (Drawing Document Flowcharts)1. A document flowchart for the Berridge Companys inventory control system may be found after 3 (below).2. The company can eliminate one or more copies of the retail store requisition (RSR) form. The document flowchart (and case description) indicate that a retail store prepares three copies of the RSR form. One copy is retained in a bill at the retail store, and two copies are forwarded to the warehouse. When warehouse personnel fill the order, they lodge one copy of the RSR form in their own files, and forward the last copy of this form to the inventory control department for use in updat ing its records. The end result of this safari is a lot of paperwork. One way to reduce it would be to allow the warehouse personnel to create the computer record that indicates a disbursement to an individual store, thus eliminating the need for the third copy of the RSR form currently sent to inventory control.The company could eliminate all copies of the RSR form by computerizing its warehousing trading operations completely. In this new system, a retail store would create a computer record for each requisition, which the system could then display onscreen or print on a report of similar requisitions for the warehouse each day. When a requisition order is filled, personnel in the warehouse could indicate this by entering the required data into the computer system. This entry would trigger an inventory update in the inventory file and eliminate the pending requisition record from the file of active requisitions.3. The company currently creates five copies of each purchase order . These copies are sent to (1) the vendor, (2) accounts account payable, (3) inventory control, and (4) the warehouse. The purchasing department retains the fifth copy. This seems excessive. It is obvious that the company mustiness send one copy of the purchase order to the vendor. In addition, it makes sense for control purposes to send one copy of the purchase order to the receiving department (for use in comparing against the subsequent bill of lading), and to retain one copy of the PO to document the purchase itself.It is less obvious that the company needs to create the other two copies of the purchase order. In fact, the document flowchart indicates that both the inventory control department and warehouse personnel perform the comparison function when goods arrive a duplication of effort. Similarly, the company can probably eliminate the copy it currently prepares for accounts payable. Instead, warehouse personnel can attach its copy to the receiving report, and the accounts payable department can use the warehouse copy to prepare a check to the vendor.A document flowchart for the Berridge Companys inventory control system.FreezeTime, Inc. (Drawing System Flowcharts)The systems flowchart is valuable because it shows the flow of activities and documents within the sales/collection process. The flowchart is particularly useful for identifying redundant, unnecessary, and risky activities.3-24. The Dinteman Company (Document Analysis)1. a) Data items which should be included on a repair/maintenance work order document are as follows1) Job identification department (or plant) for which work is to be through, machine or work station, and general description of hypothesize.2) Starting and completion dates both estimated and unfeigned.3) Materials and supplies data estimated and actual quantities and costs.4) Labor data estimated hours, actual hours cost, and employee number for each job or person completing the work.5) Applied overhead.b) At least four copies of the work order would be required with a possible fifth copy needed if a work order summary is not prepared. The work order would be prepared in the R M department and given to the supervisor for limited review and scheduling. The work order would then be used by the person responsible for the work by recording the actual hours spent on the job and the actual materials and supplies required to complete the job. After the job is completed, the work order would be forwarded to accounting for cost and charging. The distribution of each copy of the work order would be as followsOriginal (Copy 1) Once the job is completed and all data has been recorded on the work order, this copy is forwarded to the Accounting Department for costing and then filed in the Accounting Department.Copy 2 This copy is also fully completed and is filed in the R M Department in a completed work order file.Copy 3 This copy would be kept by the R M Department in a file of scheduled jobs until the work is completed. A reference file is needed for all work orders while the job is in process. Once this job is completed, Copy 3 would be attached to Copy 2 and filed with Copy 2.Copy 4 This copy would be sent to the Production Department where the work is being done to acknowledge the actual scheduling of the job.An evaluation of the performance of the R M Department would probably be done in three departments as explained belowThe department which requests the work should compare the estimated charges indicated on the execution Order Request with the actual charges and the timeliness of the work, (e.g., the estimated and actual starting and completion times on the model Order). If the work is not timely or if the actual charges vary considerably from the estimate, the management of the Production Department would contact the supervisor of the R M Department for an explanation.The supervisor of the R M Department would conduct a selfevaluation by comparing the Work Order Re quest and the completed Work Order. The supervisor would want to be sure the actual times and charges were close to the original estimates. Such a comparison would be important for evaluating the staff in the department and also for preparing future estimates.The Accounting Department (or some other appropriate department) would probably conduct a review of the R M Departments work. The estimates and actual results shown on the Work Order would be compared. Types of repair and maintenance jobs which have standard times for completion would be compared with actual times required for the work in order to evaluate the departments performance.2. See document flowchart on following page.3-25. Lois Hale and Associates (Drawing Data Flow Diagrams)