Question

In: Accounting

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 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

Answer :


Related Solutions

Explains how IT can be used to change expenditure cycle activities.
Explains how IT can be used to change expenditure cycle activities.
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...
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...
Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting...
Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting activities. ERP system provides an integrated and continuously updated view of core business processes. The system can track business resources, i.e. cash, raw materials, etc., and shares data across various departments (manufacturing, purchasing, sales, accounting, etc.), and various stakeholders of the company. The system also can provide timely information and report to variable users within the company. On December 31, 2019 ERP system generated...
Your company is moving its ERP (enterprise resource planning) system to the cloud. While previously requiring...
Your company is moving its ERP (enterprise resource planning) system to the cloud. While previously requiring multiple development and support teams to enhance and maintain, it will be moving to Software-as-a-Service. This will cause significant change within your company's organizational structure. This system contains sensitive HR and financial data, as well as critical business data. Assume you have a traditional corporate network and functional but highly internalized (not documented) processes in place around your on-prem system.   Identify key risks associated...
Listed below are system development activities. Identify the stage of the system development life cycle that...
Listed below are system development activities. Identify the stage of the system development life cycle that each activity belongs to SYSTEM DEVELOPMENT ACTIVITIY SDLC STAGE Create the data dictionary for the system. For each table in the database, identify the primary key. While the system is in operation, change the frequency of output of the sales report. The report was output weekly. It is now changed to daily output. Create the Level 0 DFD based on the content DFD. Interview...
GBI decided to modify the ERP system to suit its business processes. Given the level of...
GBI decided to modify the ERP system to suit its business processes. Given the level of skill in the project team, was this a good decision? (b)    As GBI has now decided to modify the ERP system, explain three important things that GBI should be aware of.
Please, Complete the following information, with short answers: - Expenditure Cycle: - What is its Purpose?...
Please, Complete the following information, with short answers: - Expenditure Cycle: - What is its Purpose? What are its Resources? What are its Documents? What are its Reports? What is its Information? What are its Activities? What are its Sub-Processes? Diagram the Process with the Input & Outputs?
Explain how activity-based costing would be implemented using an ERP system. In doing that, explain the...
Explain how activity-based costing would be implemented using an ERP system. In doing that, explain the advantage of using ERP with activity-based costing.
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing...
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing customers, processing customer credit applications, and performing collection activities. During interviews, the employee survey reports that they spend 15 percent of their time invoicing customers, 55 percent of their time processing credit applications, and 30 percent of their time on collection activities. The accounts receivable department employs 10 associates for a total monthly cost of $50,000. Assume each associate works 8 hours per day,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT