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

  Payment of cash dividends are recorded

Payment of cash dividends are recorded as a decrease in cash and an increase in expenses a decrease in cash and a decrease in retained earnings an increase in dividend expense and a decrease in cash a decrease in cash and a decrease in..

  Journalize the entries to record the operations

Journalize the entries to record the operations, identifying each entry by letter. Compute the July 31 balances of the inventory accounts. Compute the July 31 balances of the factory overhead accounts.

  How these payments will affect the tax liabilities of al

Both Al and Jay are in the 35% income tax bracket as individual taxpayers. Discuss how these payments will affect the tax liabilities of Al, Jay, and the corporations.

  Explain the products and the production process

Explain the products and the production process and discuss specific costs you believe would be incurred prior to the cut off point.

  Balance in phillips company''s investment account

The balance in Phillips Company's investment account on 31st December, 2003, was $54,000.

  Find the forecast for robert''s year-end net income

The tax rate is expected to remain at 40 percent and On the basis of this information, what will be the forecast for Robert's year-end net income?

  Production technique of revenue recognition

Which of the subsequent situations is not need in order to use the completed-production technique of revenue recognition?

  Calculate the cost in ending finished goods inventory

What will be the new COGM and computation of Cost per unit: COGM/units produced, calculate the cost in ending finished goods inventory at the end of the year.

  The exchange qualifies as what type of transaction

I n exchange for all of the Quartz stock, Hugh receives 1,000 shares of Turquoise Corporation common stock (value $20,000), and Stacy receives 50 shares of Turquoise preferred (value $20,000). Hugh also receives $160,000 in bonds. The exchange qu..

  Role and power of accountants in society

Write a research essay addressing the above assignment question. You are required to fully explain your viewpoints and support your decision by academic research papers

  Compute cholati branch profi ts tax

Compute Cholati’s branch profi ts tax, and determine its branch interest withholding tax obligations. Assume that Cholati does not reside in a treaty country.

  Show the preparation of segmented income statement

Show the Preparation of segmented income statement

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