Prepare a control matrix for sparkles business process

Assignment Help Accounting Basics
Reference no: EM13847274

Module- Purchase-to-Pay Controls

Problem 1:

You are presented with 6 unique problems below that could have been prevented, detected and/or corrected by using an appropriate control plan. Use the various control plans listed in your text (see pages listed below) to choose the BEST plan to handle each problem that is presented. In your answer, explain WHY you believe this is the best control plan to address this issue. When in doubt, it is always better to choose a preventive control plan rather than a detective/corrective control plan.

• Chapter 12 list of control plans: pp. 482-484

• Chapter 13 list of control plans: pp. 522-524

(a) Schmoe Manufacturing works with a few vendors who provide good quality raw materials at a competitive price, but who are sometimes negligent in providing timely invoices to Schmoe. Schmoe has a policy of taking advantage of cash discounts possible, but it hasn't always gotten discounts since invoices are arriving too late to take advantage of the discounts.

(b) Receiving dock employees at Schmoe have allowed a few inventory orders to be recorded and forwarded to the warehouse that were never ordered.

(c) Schmoe's new cash disbursements clerk, Mindy, prepares payments in batches twice per week as payment due dates arrive. She has discovered a way to prepare one payment each week to herself by attaching a fake invoice that she creates on her local printer. Her friend, Karen the cashier, approves each batch, and the two enjoy a day the spa each week on Schmoe's dime.

(d) Schmoe Manufacturing buys fabric to make a variety of sportswear. On its most order to Snerd, it ordered 100 bolts of navy blue nylon. When the fabric arrived, 90 bolts were in the shipment, and receiving appropriately recorded the 90 as received. The other 10 appropriately remained on backorder at Snerd. Snerd sent an invoice for the entire order of 100 bolts, which was promptly approved and paid
by Schmoe.

(e) Schmoe Manufacturing buys fabric to make a variety of sportswear. It recently decided to try a new vendor for its cotton. When the cotton was used in production, workers noted that it was much more prone to tear on the machines than the previous cotton that had been used in the past.

(f) Joe works in the purchasing department as a buyer for Schmoe Manufacturing. His friend, Jed, works at a supplier that does not currently do business with Schmoe. Jed gets commissions on sales that he makes, so Joe has decided to get a percentage of Jed's commissions by ordering inventory from Jed's company that is not needed or used by Schmoe.

Problem 2:

The narrative and flowchart below provide information about Sparkle Inc., a janitorial supply company. Please complete the following two tasks:

(a) Using Excel, prepare a control matrix and the associated explanations for Sparkle's business process as described in the narrative on the next page and shown in the flowchart on the page that follows that. Note that it should be either a "purchasing" process or an "AP/CD" process. You must decide which fits the narrative and flowchart.

For purposes of preparing the "effectiveness" columns of your flowchart, you should assume that you have the following 2 goals:

1. Optimize cash discounts

2. Ensure that the amount of cash maintained in demand deposit accounts is sufficient (but not excessive) to satisfy expected cash disbursements.

Tip: Find the corresponding example of a control matrix in the textbook, based on your choice of process (purchasing or AP/CD as described above). Set up a "skeleton" in Excel (e.g., column headings and room for the control plans you identify in rows) that is like the match you find in the text. The only real differences should be in the "Present" and "Missing" control plans that you list in each row-these must be custom-tailored to the narrative/flowchart for Sparkle on the next pages-and the cell entries that you make (choose the correct match of control plans to control goals-note that some control plans meet more than one control goal).

(b) Annotate the flowchart that I have attached once your control matrix and explanations are complete. You can literally write or type on the flowchart that I have created, then scan it into a pdf file or take a GOOD picture of it with your phone's camera and save it as a jpeg, png or pdf file.

The narrative appears on the next page, and the flowchart follows on the page after that. Narrative for Sparkle, Inc.:

Sparkle, Inc. is a distributor of industrial cleaning supplies, selling to a variety of businesses in southern California. Its entire "purchase-to-pay" process is run using MS Dynamics GP ERP software. The MS SQL Server database that stores the data for the enterprise system is run on a server in a central computer area, where all of the data is stored. Sparkle also uses this same software for other areas of the business, including sales financials (i.e., general ledger).

Sparkle has not implemented EDI, but instead relies on manual invoices from its various vendors to initiate its AP/CD process. When the accounts payable department receives invoices from vendors, an AP clerk, using his/her own desktop computer, uses the Dynamics GP interface to locate the corresponding PO number that is associated with the invoice that was received. When the clerk locates the PO number, the screen displays the existing PO. At this point, the clerk enters any data from the invoice that is necessary to adjust the PO. The computer then matches the newly entered invoice data to the existing PO data and the data that was recorded at the time the goods were received. If there are price or quantity differences, the ERP's workflow capability automatically routes the invoice to the purchasing department for approval. Upon approval, the computer records the invoice and updates the PO and general ledger master data.

On Tuesdays and Fridays of each week, a clerk in the accounts payable department reviews unpaid invoices using the Dynamics GP software to view these items on his/her screen. The clerk places a checkmark in the box for each invoice that will be paid. Once this step is performed, the checks are printed in the accounts payable department.

Simultaneously, the system updates the accounts payable and general ledger master data. Accounts payable runs the batch of checks through a check-signing machine and mails them to the vendor.

2481_flowchart.png

Reference no: EM13847274

Questions Cloud

How will you ensure informed consent : How will you approach data protection issues during your research - Does this project require that the researcher applies for a Disclosure Barring Service (DBS) check?
Completing the weekly self-reflection process worksheet : Throughout the course, as you worked on your community agency observation, you have been: Completing the Weekly Self-Reflection Process Worksheet. Researching your organization, significant multicultural issues, and other pertinent scholarly researc..
Analyze the impact of changes in technology on accounting : Evaluate the usefulness of accounting in any area of your future career ( e.g.as actuarist/ manager, etc). Analyze the impact of changes in technology on accounting.
Various aspects of multiculturalism : Throughout this course, you have learned about various aspects of multiculturalism. You have also been asked to critically analyze various components of culture and discuss how and whether they relate to the human services industry
Prepare a control matrix for sparkles business process : Using Excel, prepare a control matrix and the associated explanations for Sparkle's business process as described in the narrative on the next page and shown in the flowchart on the page that follows that.
Demonstrates the legal and ethical issues entrepreneurs face : There are many journals and periodicals targeting entrepreneurs. Research these publications. Identify an article or case study that demonstrates the legal and ethical issues entrepreneurs face. Provide the citation for the article and a brief sum..
Explain why is it important to prepare an exit plan : What legal agreements are needed for the day-to-day management of your business project. Why is it important to prepare an exit plan. Develop an exit strategy for your project.
Some possible solutions that qatars government : some possible solutions that Qatar's government
Discuss the issue and compare the web sites : the Web sites in terms of their appropriateness for graduate-level research. Be sure to include the concepts of authority, accuracy, and objectivity in your discussion of each Web site. In addition, be sure to include an APA-formatted bibliography..

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