solution

System Documentation—Expenditure Cycle (Manual Procedures)

The following describes the expenditure cycle manual procedures for a hypothetical company.
The inventory control clerk examines the inventory records for items that must be replenished and prepares a two-part purchase requisition. Copy 1 of the requisition is sent to the purchasing department and Copy 2 is filed.
Upon receipt of the requisition, the purchasing clerk selects a supplier from the valid vendor file (reference file) and prepares a three-part purchase order. Copy 1 is sent to the supplier, Copy 2 is sent to the accounts payable department where it is filed temporarily, and Copy 3 is filed in the purchases department.
A few days after the supplier ships the order, the goods arrive at the receiving department. They are inspected, and the receiving clerk prepares a three-part receiving report describing the number and quality of the items received. Copy 1 of the receiving report accompanies the goods to the stores, where they are secured. Copy 2 is sent to inventory control, where the clerk posts it to the inventory records and files the document. Copy 3 is sent to the accounts payable department, where it is filed with the purchase order.
A day or two later, the accounts payable clerk receives the supplier’s invoice (bill) for the items shipped. The clerk pulls the purchase order and receiving report from the temporary file and compares the quantity ordered, quantity received, and the price charged. After reconciling the three documents, the clerk enters the purchase in the purchases journal and posts the amount owed to the accounts payable subsidiary account.
On the payment due date, the accounts payable clerk posts to the accounts payable subsidiary account to remove the liability and prepares a voucher authorizing payment to the vendor. The voucher is then sent to the cash disbursements clerk. Upon receipt of the voucher, the cash disbursements clerk prepares a check and sends it to the supplier. The clerk records the check in the check register and files a copy of the check in the department filing cabinet.

Required:

Prepare a data flow diagram and a system flowchart of the expenditure cycle procedures previously described.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

System Flowchart

Figure 6.4 illustrates how a customer order is transformed into a source document, a product document, and a turnaround document. Develop a similar flowchart for the process of paying hourly employees. Assume time sheets are used and the payroll department must total the hours. Each hour worked by any employee must be charged to some account (a cost center). Each week, the manager of each cost center receives a report listing the employee’s name and the number of hours charged to this center. The manager is required to verify that this information is correct by signing the form and noting any discrepancies, then sending this form back to the payroll department. Any discrepancies noted must be corrected by the payroll department.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Systems Selection

Your company, Kitchen Works, is employing the SDLC for its new information system. The company is currently performing a number of feasibility studies, including the economic feasibility study. A draft of the economic feasibility study has been presented to you for your review. You have been charged with determining whether only escapable costs have been used, the present value of cash flows is accurate, the one-time and recurring costs are correct, realistic useful lives have been used, and the intangible benefits listed in the study are reasonable. Although you are a member of the development team because of your strong accounting background, you have questions about whether some costs are escapable, the interest rates used to perform present value analysis, and the estimated useful lives that have been used. How might you resolve your questions?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Audit of Systems Development

The Balcar Company’s auditors are developing an audit plan to review the company’s systems development procedures. Their audit objectives are to ensure that

1. The system was judged necessary and justified at various checkpoints throughout the SDLC.

2. Systems development activities are applied consistently and in accordance with management’s policies to all systems development projects.

3. The system as originally implemented was free from material errors and fraud.

4. System documentation is sufficiently accurate and complete to facilitate audit and maintenance activities.

The following six controllable activities have been identified as sources of audit evidence for meeting these objectives: systems authorization, user specification, technical design, internal audit participation, program testing, and user testing and acceptance.

Required:

a. Explain the importance of each of the six activities in promoting effective control.

b. Outline the tests of controls that the auditor would perform in meeting audit objectives.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"