Question1 using microsoft excel prepare a flowchart

Assignment Help Financial Accounting
Reference no: EM13348641

Question:

1. Using Microsoft Excel, prepare a flowchart documenting the acquisition/payment process for ABC Corporation. Someone looking at your finished flowchart should be able to "read" it and end up with the details presented below. Make sure you use proper symbols, clear labels, and proper flowcharting methods (for example, make sure to identify documents used where required).

ABC Corp. replaces one-third of its computers every year, so that every employee has a new computer every three years. In January of each year, the IT division accesses the corporate database to calculate which computers are eligible for replacement. David, the IT division manager consults with Mike, the CFO, to evaluate the budget for computer replacement. David then asks each employee whose computer is eligible to be replaced for a list of three "must have" features and three "wish list" features for his or her new computer. ?A committee comprised of the IT manager, the CFO, and three employees prepares a request for proposal (RFP) to send to diverse computer vendors. Vendors typically have about 30 days to respond to the RFP. At the end of the RFP period, the committee ranks the proposals based on a standard set of criteria. ?After discussion, they choose the best proposal and contact the vendor. Nancy, the purchasing clerk, issues a purchase order; the original goes to the vendor, while Kayla, the accounting clerk gets a copy. Joe from the receiving department gets a "blind copy" of the purchase order. ?When the computers arrive, Joe inspects them for quality; any computers that do not meet quality specifications are returned to the vendor. Joe then purpose a receiving report of all good computers received. A copy of the receiving report is sent to Kayla. The good computers are transferred to the IT department. IT staff install them for the employees, classically in April of each year. Kayla receives vendor invoices when all ordered computers are accepted. Kayla performs a three-way matching between the purchase order, the receiving report, and the vendor invoice. Kayla then prepares a check and mails it to the vendor. ?On a monthly basis, Kathy, the accounting supervisor prepares and reviews the expense report summarizing all payments made in a particular month. Kathy verifies that the payments are supported by appropriate requisitions/RFPs, purchase orders, vendor invoices and receiving reports.

2. Using Microsoft Word, write a narrative describing risks ABC faces and any internal controls ABC should implement to mitigate those risks in the process described above. Recall that controls can be preventive, detective, and/or corrective. Be sure to clearly identify where the controls should be implemented and the risk(s) each control is designed to mitigate.

Reference no: EM13348641

Questions Cloud

Questiona describe what the term preventive legal : questiona describe what the term preventive legal management addresses. b explain any 5 stakeholders that have a legal
Question 1show the tests developed by court cases to : question 1show the tests developed by court cases to differentiate between losses and outgoings on revenue account and
Questionit is our plan to be global market leader by 2015 : questionit is our plan to be global market leader by 2015 and we are moving towards this goal with the implementation
Questionquestion 1show the issues to consider when deciding : questionquestion 1show the issues to consider when deciding whether a receipt is income according to ordinary
Question1 using microsoft excel prepare a flowchart : question1. using microsoft excel prepare a flowchart documenting the acquisitionpayment process for abc corporation.
Questionacme company uses the weighted-average method in to : questionacme company uses the weighted-average method in to compute product costs and reports the subsequent costs for
Questionace company produces a product that sells for 142 : questionace company produces a product that sells for 142 per unit. ace in june and july the first 2 months of
Questionat the starting of 2014 ace company estimated the : questionat the starting of 2014 ace company estimated the subsequent costs to produce one unit of product 5 pounds of
Question1a chester corporation is launching a new product : question1a chester corporation is launching a new product that is expected to cost 75 in direct materials 50 in direct

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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