Prepare an as-is data flow diagram

Assignment Help Accounting Basics
Reference no: EM131787157

TVR CLASSICS (MANUAL AND STAND-ALONE COMPUTER PROCESSING)

TVR Classics specializes in the sale of original and reproduction restoration parts for classic sports cars and muscle cars of the 1960s and 1970s. The classic car industry has grown significantly in recent years as the baby boomers age, has become wealthier, and wants to relive fond memories.

Classic car sales and restoration is a multibillion dollar industry that employs more than 30,000 people in the United States. It is, however, a highly fragmented industry comprised of many small businesses. TVR is headquartered in Los Angeles, California and currently employs 95 full-time employees, including a sales staff, sales representatives, and general office staff.

TVR's primary customer base consists of small restoration shops and classic car dealers on the west coast. They source many of their parts from abroad, but a growing percentage of these are now being manufactured in the United States.

TVR has a legacy accounting system that employs a combination of manual procedures supported by standalone PCs in the various departments. Recently, they have experienced business inefficiencies that have been linked to their antiquated accounting system. You have been retained by
TVR management to review their procedures for compliance with effective internal control standards.

TVR's expenditure cycle procedures are presented in the following paragraphs.

Expenditure Cycle

When the quantity on hand of a particular product falls to a low level, the warehouse clerk selects a vendor and manually prepares two hard copies of a purchase order. The clerk sends one copy of the purchase order to the vendor and the other to the receiving department. When the goods arrive from the vendor, the receiving clerk matches the packing slip in the shipment to the purchase order that the warehouse clerk had previously sent. If everything is in order the receiving clerk signs the purchase order and sends it to the accounting department. The clerk then manually prepares a hard-copy receiving report, which he sends with the goods to the warehouse.

From his department PC, the warehouse clerk uses the receiving report to update the inventory subsidiary ledger to reflect the receipt of the goods.
Subsequently, the accounting department's accounts payable clerk receives the supplier's invoice, which she matches and reconciles to the previously
received purchase order from the receiving clerk. From her department PC, the accounts payable clerk then updates the digital accounts payable
subsidiary ledger to reflect the new liability and records the event in the digital purchases journal.

Cash Disbursements Procedures

The accounts payable clerk in the accounting department reviews the liabilities that are due by searching the accounts payable subsidiary ledger from the department PC. The clerk then prints out a hard-copy cash disbursement voucher for each item due for payment. The clerk then sends a cash disbursement voucher to the cash disbursements department for payment. At the end of the day, the clerk prints a hard-copy accounts payable summary from the department PC and sends it to the general ledger department.

From his department PC, the cash disbursements clerk uses the cash disbursement voucher to record the payment in the digital check register and then prints a three-part check. The clerk signs the negotiable portion of the check and sends it to the vendor. One check copy is filed in the department, and the clerk sends the second check copy, along with the original cash disbursement voucher, to the accounting department
accounts payable clerk. At the end of the day, the clerk prints a hard-copy summary of the check register and sends it to the general ledger department.

From the accounting department PC, the accounts payable clerk uses the check copy and cash disbursement voucher to record the payment
in the voucher register and to close out the liability in the accounts payable subsidiary ledger. The clerk then files the hard-copy cash disbursement voucher and check copy in the department. From the department PC, the general ledger clerk posts the summaries received from the accounting
and cash disbursement departments to the appropriate general ledger accounts. The clerk files the hardcopy summaries in the general ledger department.

a. Prepare an As-Is Data Flow Diagram and an As-Is System Flowchart.

b. Identify, circle and number it on the As-Is System Flowchart at where the exposure is.A maximum of 6 exposures is needed.

c. In tabular form, against each numbered exposure, describe ONE possible risk and suggestONE control procedure that can mitigate the exposure identified. (given: The company doesnot have the resources for any computerization or networking the stand-alone computers)

d. Prepare a To-Be System Flowchart that incorporate your recommendations in c above.

Reference no: EM131787157

Questions Cloud

What was her recognized gain or loss : On April 18, 2010, Jane Juniper purchased 30 shares of Bryan Corp. stock for $1210, What was her recognized gain or loss
Introduction to business strategy competency : Introduction to Business Strategy Competency-Assess strategic development in practical management concepts as they relate to strategic processes
Which figures show the most varibration : In truth, the top fifth (in terms of wealth) actually held about what percentage of the wealth? Which figures show the least variation?
What amount of net capital gain and net ordinary income : The ABC stock was purchased for $1,800 and sold for $3,200. In 2010, Jack should report what amount of net capital gain and net ordinary income
Prepare an as-is data flow diagram : Prepare an As-Is Data Flow Diagram and an As-Is System Flowchart
Verify the accuracy of this charitable deduction : Do you have a duty to verify the accuracy of this charitable deduction?
Three children as dependents on individual tax return : When you prepare Henry’s tax return, may he claim the three children as dependents on his individual tax return? Explain?
What is rob basis for gain : The donor paid a gift tax of $10,000 on the taxable gift of $188,000. What is Rob's basis for gain
What powers does a president have to influence the economy : What powers does a president have to influence the economy? Illustrate these powers with a news article from the last eight weeks.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Calculate and evaluate the contribution margin ratio

Prepare an Income Statement in appropriate format for your business. Calculate and evaluate the Weighted Average Contribution Margin (WACM). Calculate and evaluate the Contribution Margin Ratio (CMR)

  During september the capital expenditure budget indicates a

during september the capital expenditure budget indicates a 420000 purchase of equipment. the ending september cash

  Compute cc expected cash receipts from customers

Compute CC's expected cash receipts from customers

  What are the two ways for a company to reacquire stock

What are the two ways for a company to reacquire stock? Please also discuss when a company reacquires stock and whether there is a difference between the amount the shares were originally sold for and the cash paid to buy the shares back.

  Financing and operating plan for current year

Revenue Outlook The primary source of revenue for Amazon.com is the sale of products and services to customers.

  Should the new layout be adopted

Should the new layout be adopted? Assume the variances are attributable to the new layout. If so, what would be the projected annual saving.

  Explain how reported accounting numbers might affect an

explain how reported accounting numbers might affect an individuals perceptions and actions. cite two examples. ca1-7

  Trade deficits and trade surpluses

Many individuals believe that trade deficits are troubling economic condition which points out weakness in economy while trade surpluses are sign of strength and rising prominence for economy.

  Assessment of physical ability to perform the job

The police department of Mason, IL consists of 90 full-time officers varying in ages, from 21 to 59. The tenure of the officers also varies with some being newly hired and others with 10 or more years of service to the force.

  How would you record correctly the cash dividends

Gourmet Donuts owns 800 shares of Coffee Express. How would you record correctly the cash dividends received by Gourmet Donuts

  Will the inventory turnover ratio increase or decrease

A manufacturer reported an inventory turnover ratio of 8.6 during 2007. Will the inventory turnover ratio increase or decrease during 2008

  Mini corp acquires a patent from maxi co in exchange for

mini corp. acquires a patent from maxi co. in exchange for 3000 shares of mini corp.s 1 par value common stock and

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd