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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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