Accounting Information Systems

peckering Information agreements3-1. The text provides seven reasons why enrolmenting AISs is in-chief(postnominal) (1) depicting how the brass drop deads, (2) educate callrs, (3) forming freshly schemas, (4) arrestling carcasss schooling costs, (5) standardizing communication with others, (6) canvassing, and (7) controlling end- consumptionr support costs. Additional reasons include (1) to supporter mea sure as shooting the performance of constitution personnel, (2) to aid evaluate the adequacy or skill of an existing strategy, and (3) to provide design specifications to outside vendors who might be proposing saucy carcasss.Accountants ar interested in system funding for all these reasons. For example, understaffed registeration makes it difficult to use an integrated accounting package effectively, design cardinal for others to use, or audit a system intelligently. Flowcharts and similar systems chronicleation be withal important to auditors. These charts quarter help auditors spot essential control weaknesses that atomic digit 18 not apparent from proto typewrites or not frank when observing a system in use.3-2. history bleed charts are a type of system be givenchart. Whereas system flowcharts are process-oriented, record flowcharts focus on the flow of physical scrolls through the bear upon system. Document and system flowcharts are similar in that they use similar symbols in their construction. A some additional symbols, such as envelopes and hand trucks to depict movement of goods, are more likely to appear in document flowcharts than system flowcharts. scarce system flowcharts contain more detail about processing system of system of logic.Accountants can use entropy flow diagrams (DFDs) to depict the physical flows of information through an AIS (like document flowcharts), or the logical flow of data through an AIS (like system flowcharts). Like document or system flowcharts, their main objective is to document data flows in an familyly, graphic, and easily-understood format. But DFDs use fewer symbols than either document or system flowcharts, and do not require columns (like document flowcharts). platform flowcharts are really the lowest level of system flowcharts because they outline the logic sequence for a particular application architectural plan. Thus, they are more utilize by data processor programmemers and system analysts than by accountants and auditors. Still, auditors will pack to understand these program flowcharts when looking at program logic and program controls. Program flowcharts use many of the same symbols found in system flowcharts, unless also use some special ones such as the decisiveness 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 evalu ating a system to see if for each one department is receiving the prerequisite data and that un incumbent data are not transferred.2. A system designer uses it when there is interest in improving or surrogate an existing 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 inner(a) 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 relevant chapter sections for document flowcharts, system flowcharts, and data flow diagrams.3-5. Data flow diagrams use a square symbol to carry 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 take a crapd in a hierarchy c alled the top-down approach to systems development. In this approach, developers create these diagrams in levels, beginning with the broadest, least-detailed level, and exploding ( playing 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 posteriorly after major system components are specified. However, the process is reiterative, revisions are common, and half-size is considered final until the lowest diagram levels have been specified and approved.The broadest DFD is called a condition diagram. The next 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 usually easier to follow logic with a chart or figure than with a written storey. For example, when reading a long narrative description of a process, it is often difficult to visualize relationships between system elements and a readers attention can wander. In contrast, graphical depictions of the same logic are usually easier to understand because most 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 encounter and indicate the hold litigate to take for each condition. Decision tables can therefore help system designers plan data processing functions and create written scans of the processing logic for later reference. The major advantage of decision tables is that they can add up a potentially large number of conditions and actions in a undertake format. Decision tables are also useful as planning tools to system analysts and related individuals 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 were built into these AISs.3-9. Just as al-Quran processors enable users to create, store, modify, and affect word documents, movement tools enable information technology and accounting personnel to create, store, modify, and print system documentation. The term CASE is an acronym for computer assisted software 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 screens, report formats, screen menus, system flowcharts, and program flowcharts. to the highest degree 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 cypher refers to the computer activities of non-computer employees, especially the development of large spreadsheets and databases. Although such activities are humdrum 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 relieve how to use the software. Documentation 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 rove to run the applications effectively.Problems3-11. workAlternate ProcessDecisionDataPredefined ProcessInternal StorageDocumentMultidocumentTerminatorPreparationManual enterManual OperationConnectorOff-p age ConnectorCardPunched TapeSumming concurrenceOrCollateSortExtractMergeStored Data arrestSequential AccessMagnetic DiskDirect Access marchStorageStorage3-12.Mark Goodwin Convenience StoresGarcia-Lanoue society3-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 on a lower floor. 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 early(prenominal) collectibleXLess than 30 days past dueX31-60 days past dueXXX61-90 days past dueXXX more than than 90 days past dueXXXAccount ActivityNo activityXXXXXWritten communicationsXXXPartial paymentXXXActionDo nothingXXXXXXX organize first letter of inquiryXSend second letter of inquiryXXCollection berth referral XThis exercise requires some creativity on the part of the student. star possibility is to give each customer a rating on the adjacenta) no prior delinquency historyb) only one prior delinquencyc) only 2 prior delinquenciesd) more than deuce 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 olive-sized companies, for example, will try to work with their customers whenever possible instead of writing to them impersonally because written confrontations rarely produce 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 th e directions provided in this case to create the two (program) flowcharts shown as well as the link that connects the two flowcharts together. Students can document their links by printing a model of their formulas. Finally, although using Excels draft repeat tools is straightforward, it still takes time to create even small diagrams with them. Thus, we recommend 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 record control system whitethorn be found after 3 (below).2. The company can fall out one or more copies of the retail store requisition (RSR) form. The document flowchart (and case description) indicate that a retail store prepares one-third copies of the RSR form. unrivalled copy is retained in a charge up at the retail store, and two copies are forwarded to the warehouse. When wareh ouse personnel fill the show, they file one copy of the RSR form in their own files, and forward the uttermost(a) copy of this form to the inventory control department for use in updating its records. The end result of this effort 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 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 upd ate 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 obtain order. These copies are sent to (1) the vendor, (2) accounts collectible, (3) inventory control, and (4) the warehouse. The purchasing department retains the fifth part copy. This seems excessive. It is obvious that the company must send one copy of the acquire 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 coincidence function when goods buzz off 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 include on a repair/maintenance work order document are as follows1) Job identification department (or plant) for which work is to be done, machine or work station, and general description of short letter.2) Starting and pass completion dates both estimated and actual.3) Materials and supplies data estimated and actua l quantities and costs.4) Labor data estimated hours, actual hours cost, and employee number for each logical argument 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 segment and given to the supervisor for review and scheduling. The work order would then be used by the person obligated 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 blameless, the work order would be forwarded to accounting for costing 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 invoice Department for costing and then filed in the Accounting Department.Copy 2 This copy is al so 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 addicted 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 certify 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 arrive at tell collect with the actual charges and the timeliness of the work, (e.g., the estimated and actual starting and completion generation on the Work Order). If the work is not timely or if the actual charges start out considerably from the estimate, the management of the Produ ction Department would contact the supervisor of the R M Department for an explanation.The supervisor of the R M Department would tolerate a selfevaluation by comparing the Work Order Request 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 prospective estimates.The Accounting Department (or some other appropriate department) would probably need 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)