Question

In: Accounting

Internal Audit The PIXEL Company performs its expenditure cycle activities using its integrated ERP system as...

Internal Audit

The PIXEL Company performs its expenditure cycle activities using its integrated ERP system as follows:

 Employees in any department can enter purchase requests for items they note as being either out of stock or in small quantity.

 The company maintains a perpetual inventory system.

 Each day, employees in the purchasing department process all purchase requests from the prior day. To the extent possible, requests for items available from the same supplier are combined into one larger purchase order in order to obtain volume discounts. Purchasing agents use the Internet to compare prices in order to select suppliers. If an Internet search discovers a potential new supplier, the purchasing agent enters the relevant information in the system, thereby adding the supplier to the approved supplier list. Purchase orders above $10,000 must be approved by the purchasing department manager. EDI is used to transmit purchase orders to most suppliers, but paper purchase orders are printed and mailed to suppliers who are not EDI capable.

 Receiving department employees have read-only access to outstanding purchase orders. Usually, they check the system to verify existence of a purchase order prior to accepting delivery, but sometimes during rush periods they unload trucks and place the items in a corner of the warehouse where they sit until there is time to use the system to retrieve the relevant purchase order. In such cases, if no purchase order is found, the receiving employee contacts the supplier to arrange for the goods to be returned.

 Receiving department employees compare the quantity delivered to the quantity indicated on the purchase order. Whenever a discrepancy is greater than 5%, the receiving employee sends an email to the purchasing department manager. The receiving employee uses an online terminal to enter the quantity received before moving the material to the inventory stores department.

 Inventory is stored in a locked room. During normal business hours an inventory employee allows any employee wearing an identification badge to enter the storeroom and remove needed items. The inventory storeroom employee counts the quantity removed and enters that information in an online terminal located in the storeroom.

 Occasionally, special items are ordered that are not regularly kept as part of inventory, from a specialty supplier who will not be used for any regular purchases. In these cases, an accounts payable clerk creates a one-time supplier record.  All supplier invoices (both regular and one-time) are routed to accounts payable for review and approval. The system is configured to perform an automatic 3- way match of the supplier invoice with the corresponding purchase order and receiving report.  Each Friday, approved supplier invoices that are due within the next week are routed to the treasurer’s department for payment. The cashier and treasurer are the only employees authorized to disburse funds, either by EFT or by printing a check. Checks are printed on dedicated printer located in the treasurer’s department, using special stock paper that is stored in a locked cabinet accessible only to the treasurer and cashier. The paper checks are sent to accounts payable to be mailed to suppliers.

 Monthly, the treasurer reconciles the bank statements and investigates any discrepancies with recorded cash balances.

Required: a. Identify at least five activities (or sub-processes) within the expenditure process described above. (3 points)

b. Identify five risks associated with the five activities identified on a. (5 points)

c. Propose a control for each risk identified on b. (5 points)

Note:

Present your answer in a risk/ control matrix reduced to only three-column table with these headings: Activity (or Sub-processes), Risks, and Controls.

Solutions

Expert Solution

Internal Controls are techniques and procedures established with a view to ensuring safegaurding of business' assets, preventing fraud,increase efficiency and establish accuracy of finacial records which in turn reflects the performance of the business. Apart from this local laws and regulations may mandate establising and compliance of adequate internal controls.

In the given situation, PIXEL Company has some set rules and procedures surrounding the process of Purchase of items until the vendor has been paid for this. This function is described in the above expenditure cycle activities.

Activity Risk Control Proposed
Purchase requisition 1) No system of approval of purchase requisitions
2) Employee from any dept can raise purchase requisition
1) User dept head to approve purchase requisitions
2) Only user dept to request to ensure items are purchased only on need basis
Processing of purchase orders 1) Addition of supplier to approved supplier list without appproval of purchase manager
2) Selection of supplier apart from approved vendor list on the sole basis of price might affect quality
1) Approved vendor list to be amended only with approval and concurrence of purchase manager
2) Selection of supplier apart from approved vendor list must be with the concurrence of purchase manager
Receiving of purchased goods Receiving dept has access to qty details of PO Receiving report to be created at time of receiving on actual quanitity receipt basis. PO view access provided to Receiving dept. not to have quantity details. Receiving dept to match invoice with actual quantity received & inform Purchase dept & Accounts payable in case of any discrepanices
Issue of Inventory Request for inventory issue / approval missing. Inventory to be issued to employees only on the basis of request as approved by the user dept head
Special Purchase Approval of purchase manager missing. No segregation of duties ensured if the accounts payable clerk itself creates a one-time supplier record and is prone to abuse. One-time suppliers must be created by purchase agents only after approval of both the user dept head and the purchase manager.

Related Solutions

The PIXEL Company performs its expenditure cycle activities using its integrated ERP system as follows: ...
The PIXEL Company performs its expenditure cycle activities using its integrated ERP system as follows:  Employees in any department can enter purchase requests for items they note as being either out of stock or in small quantity.  The company maintains a perpetual inventory system.  Each day, employees in the purchasing department process all purchase requests from the prior day. To the extent possible, requests for items available from the same supplier are combined into one larger purchase...
Audit of Internal Control Over Financial Reporting that is Integrated with an Audit of Financial Statements,"...
Audit of Internal Control Over Financial Reporting that is Integrated with an Audit of Financial Statements," provides a guide for auditors when performing integrated audits. by visiting PCAOB website How should the auditor determine which controls to test? How might the auditor use evidence obtained in the audit of the financial statements when concluding on the effectiveness of internal control over financial reporting?
Explains how IT can be used to change expenditure cycle activities.
Explains how IT can be used to change expenditure cycle activities.
audit cycle Crossties of 1-Gather information about the client Internal control system 2-Testing the client internal...
audit cycle Crossties of 1-Gather information about the client Internal control system 2-Testing the client internal control system (Sufficiency and effectiveness) 3-Testing the financial statements. 4-Review and completion. 5-Communicate report explain each term
Which of the following expenditure cycle activities can be eliminated through the use of IT or...
Which of the following expenditure cycle activities can be eliminated through the use of IT or reengineering? ordering goods receiving goods approving vendor invoices cash disbursements Which   of   the   following   revenue   cycle   activities   can   potentially   be eliminated by technology? sales order entry shipping cash collections billing Which of the following matches is performed in evaluated receipt settlement (ERS)? the vendor invoice with the receiving report the purchase order with the receiving report the vendor invoice with the purchase order the...
Using the integrated audit framework, develop an audit program presentation using relevant financial and operational information...
Using the integrated audit framework, develop an audit program presentation using relevant financial and operational information provided in the case. For this assignment, be sure to identify relevant areas that will be audited, objectives, control tests, substantive tests, documentation, and sampling procedures. The audit program should be developed based one of the following business cycles: Review process Purchasing process Human resource management process Inventory management process Financing and investing process The relevant assertions to be used as audit objectives are...
Analyze PepsiCO company using  Porter’s competitive forces model in term of ERP system which use SAPs ERP...
Analyze PepsiCO company using  Porter’s competitive forces model in term of ERP system which use SAPs ERP ?? FOR PEPSICO IN TERM OF IT'S ERP SYSTEM
ERP System recommendation for Nike Company.
ERP System recommendation for Nike Company.
Prepare a report for John that compares and contrasts in detail the advantages and disadvantages of attempting to develop a system in house against purchasing an integrated system such as a proprietary ERP.
Background and Content:John Smith is the CEO of Alpha Manufacturing Pty Ltd. This company manufactures high value products in the form of small model aircraft jet engines that are mainly sold online.  The raw materials input for the Jet engines are a series of high value easily marketable items mainly exotic metals and electronic systems that support the engine controllers. There are five models of engine produced, each requiring about 25 components, including screws and fuel connectors. About ten of these...
TYPES OF AUDIT 1. Is there an internal audit function within your organisation? What is its...
TYPES OF AUDIT 1. Is there an internal audit function within your organisation? What is its role and how do you view it? 2. Is there an external auditor for your organisation? What functions does the auditor carry out and how do you view it?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT