ABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date information about the processing and current location of each shipped item. To do this, the company relies on a company-wide information system. Shipped items are the heart of the company's product tracking system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the company's system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard transportation events (i.e., flights, truck deliveries). These transportation ever are characterized by a unique schedule number, a type (e.g., flight, truck), and a delivery route. For this assignment. I want you to provide the names of all the tables that would be needed to save data about the scenario discussed above. For each table, please write down the corresponding column/field names. Try to identify as many tables as possible. You do not have to create the tables on MySQL. Just type in the tables and their fields/ columns on Word.

ABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date information about the processing and current location of each shipped item. To do this, the company relies on a company-wide information system. Shipped items are the heart of the company's product tracking system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the company's system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard transportation events (i.e., flights, truck deliveries). These transportation ever are characterized by a unique schedule number, a type (e.g., flight, truck), and a delivery route. For this assignment. I want you to provide the names of all the tables that would be needed to save data about the scenario discussed above. For each table, please write down the corresponding column/field names. Try to identify as many tables as possible. You do not have to create the tables on MySQL. Just type in the tables and their fields/ columns on Word.

Auditing: A Risk Based-Approach to Conducting a Quality Audit

10th Edition

ISBN:9781305080577

Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg

Publisher:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg

Chapter9: Auditing The Revenue Cycle

Section: Chapter Questions

Problem 24MCQ

See similar textbooks

Similar questions

The following is a description of manufacturing com-pany’s purchasing procedures. All computers in the com-pany are networked to a centralized accounting system sothat each terminal has full access to a common database.The inventory control clerk periodically checks in-ventory levels from a computer terminal to identifyitems that need to be ordered. Once the clerk feels in-ventory is too low, he chooses a supplier and creates apurchase order from the terminal by adding a record tothe purchase order file. The clerk prints a hard copy ofthe purchase order and mails it to the vendor. An elec-tronic notification is also sent to accounts payable andreceiving, giving the clerks of each department accessto the purchase order from their respective terminals.When the raw materials arrive at the unloading dock,a receiving clerk prints a copy of the purchase orderfrom his terminal and reconciles it to the packing slip.The clerk then creates a receiving report on a computersystem. An electronic…
The following is a description of manufacturing com-pany’s purchasing procedures. All computers in the com-pany are networked to a centralized accounting system sothat each terminal has full access to a common database.The inventory control clerk periodically checks in-ventory levels from a computer terminal to identifyitems that need to be ordered. Once the clerk feels in-ventory is too low, he chooses a supplier and creates apurchase order from the terminal by adding a record tothe purchase order file. The clerk prints a hard copy ofthe purchase order and mails it to the vendor. An elec-tronic notification is also sent to accounts payable andreceiving, giving the clerks of each department accessto the purchase order from their respective terminals.When the raw materials arrive at the unloading dock,a receiving clerk prints a copy of the purchase orderfrom his terminal and reconciles it to the packing slip.The clerk then creates a receiving report on a computersystem. An electronic…
SYSTEM DOCUMENTATION-EXPENDITURE CYCLE (MANUAL AND COMPUTER PROCEDURES) The following describes the expenditure cycle for a hypothetical company. The company has a centralized computer system with terminals located in various departments. The terminals are networked to a computer application, and digital accounting records are hosted on a server in the data processing department. Each day, the computer in the data processing center scans the inventory records looking for items that must be replenished. For each item below its reorder point, the system creates a digital purchase order and prints two hard copies. A technician in the data center sends the purchase orders to the purchasing department clerk. Upon receipt of the purchase orders, the purchasing clerk reviews and signs them. He sends Copy 1 to the supplier and files Copy 2 in the purchasing department. A few days later, the supplier ships the order and the goods arrive at the receiving department. The receiving clerk reviews…
Walsh & Coggins, a professional accounting firm, collects cost information about the services they provide to their clients. Describe the types of cost data they would collect and explain the importance of analyzing this cost data.
Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?
.Internal Controls and RiskReview the following description of the purchasing and AP procedures for a company and answer the questions at the end.The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP…
An entrepreneur of a custom sign company is reviewing reports showing the cost of printing machines, supplies, and labor so that she can make comparisons to the revenue being generated. What reports are being reviewed? a) Customer records. b) Financial statements. c) Asset reports. O d) Operation schedules.
Value chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item Answer Business Function a. Research and development b. Design c. Production d. Marketing e. Distribution t Customer service 1. Labor time to repair products under warranty 2. TV commercial spots 3. Labor costs of filling customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for the Internet 7. Printing cost of new product brochures 8. Hours spent designing childproof bottles 9. Training costs for representatives to staff the customer call center 10. Installation of robotics equipment in manufacturing plant
Tests of Controls: Input Controls. Knight Company is a medium-size manufacturingentity that uses an automated transaction system to process its customer orders. Orders arecollected and processed on a daily basis in batches. In its processing of customer orders,Knight requires input of the following information into a daily customer order file (# represents a numeric field; A represents an alphabetic field):∙ Customer number (###).∙ Item number (AA###).∙ Quantities (##).After this information has been entered, the computer program accesses the valid customer master file to ensure that the sale is to an authorized customer and does not exceedthat customer’s credit limit. The program then accesses the inventory master file, verifiesthat the appropriate quantities are on hand, and identifies the most current price. The program then prepares an invoice by multiplying the quantities the customer ordered by theappropriate price and generates a total amount for the sale.To prevent and detect…
The conversion cycle of the company is triggered by a report from the warehouse. When the quantity of an inventory item falls below a pre-set minimum level, the warehouse manager sends an online inventory status report to the production department advising them to schedule a production batch run for the item. Upon receipt of the report, the production clerk assesses the digital bill of materials and the route sheet files for the item to be produced and adds the production details to the online production schedule. The system automatically adds a record to the openwork order file and sends an online work order to the work center supervisor’s computer and to the accounting clerk’s computer. The work center supervisor receives the work order from his computer and print hard-copy move tickets and materials requisitions for each production process. Production employees take the materials requisitions to store clerk and receive the materials and subassemblies needed to perform the production…
NTERNAL CONTROLThe following is a description of manufacturing com-pany’s purchasing procedures. All computers in the com-pany are networked to a centralized accounting system sothat each terminal has full access to a common database.The inventory control clerk periodically checks in-ventory levels from a computer terminal to identifyitems that need to be ordered. Once the clerk feels in-ventory is too low, he chooses a supplier and creates apurchase order from the terminal by adding a record tothe purchase order file. The clerk prints a hard copy ofthe purchase order and mails it to the vendor. An elec-tronic notification is also sent to accounts payable andreceiving, giving the clerks of each department accessto the purchase order from their respective terminals.When the raw materials arrive at the unloading dock,a receiving clerk prints a copy of the purchase orderfrom his terminal and reconciles it to the packing slip.The clerk then creates a receiving report on a computersystem.…
Successful ERP systems support the core business processes in a company's operations. Every function within the ERP is called a module. Listed below are four key features. Which is a key feature of the production module? (a) Inventory (b) Bill of material (c) Receive payment (d) Marketing Management