Custom Fabrication (Stand-Alone-PC-Based Accounting System)

CUSTOM FABRICATIONS INC, is a bicycle manufacturing firm founded in 2000 that currently employs 126 people. The company produces custom bicycles in its factory located near Los Angeles, CA. Each bicycle is tailored to a rider based on a number of different measurements, including height, weight, inseam, and arm length. These measurements are taken at 30 professional bicycle shops around Southern California, which are certified to a CUSTOM FABRICATIONS' cycles. By accepting orders only though licensed dealers. CUSTOM FABRICATIONS ensures that each bike matches its rider precisely. CUSTOM FABRICATIONS custom bikes are considered extremely high quality and the company takes pride in using only the best components sourced from around the world. Accordingly, CUSTOM FABRICATIONS purchase from a cast of hundreds of suppliers, chosen for their commitment to quality and reliability. Demand for CUSTOM FABRICATIONS' cycles has grown exponentially in recent years. The surge in demand was somewhat unexpected and the company's factory has been operating at capacity for over a year. As a result, current orders face a production backlog of approximately 5-6 weeks. The company's operations have been further hampered by severe inefficiencies and control weaknesses attributed to its legacy accounting system. Your Firm has been hired as an outside consultant to suggest improvements in the company's accounting procedures. The following paragraphs describe the company's expenditure cycle.

Purchase System

All purchases of raw materials are initiated in the CUSTOM FABRICATIONS' purchasing department. A clerk in the department monitors inventory levels from his PC, which is linked to the inventory subsidiary ledger. Once a part needs to be replenished, he creates a hard-copy purchase order. One copy is mailed to the vendor, a blind copy of the purchase order is sent to the warehouse, and the third copy is filed in the purchasing department. Typically within 3-5 business days, the warehouse receives, the ordered parts and the packing slip from the vendor, which the warehouse clerk reconciles with the blind copy of the purchase order. Once the reconciliation is complete, the warehouse clerk prepares a three-part hard-copy receiving report stating the quantity and condition of the items received. One copy of the receiving report is sent to the general ledger department to update the digital inventory control account. The second copy is sent to the accounts payable department, and the third is sent to the purchasing department to update the inventory subsidiary ledger. Within a week, the mail room receives the supplier's invoice, which is immediately sent to the accounts payable department. The AP clerk reconciles the invoice with the receiving report and then records a liability in the AP subsidiary ledger from the department PC. Finally, the clerk prints an AP summary from the terminal and sends it to the general ledger clerk.

Cash Disbursements System

The accounts payable clerk regularly checks the accounts payable subsidiary account at his terminal to ensure timely payment to vendors. For those items due for payments, he sends approval in the form of a payment voucher to the cash disbursements department. For control purposes, cash disbursements are processed manually. The details of the check are recorded in the hard-copy cash disbursements journal, and the check is mailed to the vendor. The clerk then prepares a journal voucher and sends it to the general ledger. Once the general ledger clerk receives the journal voucher, the AP summary, and the receiving report, she updates the affected general ledger accounts from the department PC. Required:

a.)Make a data flow diagram of the current system

b.)Make a system flowchart of the existing system

c.)C. Analyze the physical internal control weaknesses in the system.

d.)Describe the risks associated with these control weaknesses.