Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 14P
To determine
Prepare database tables in 3NF form to produce purchase order.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Acme Plywood Company uses the purchase order shown in the diagram. Acme business rules: 1. Each vendor may supply many items; an item is supplied by only one vendor. 2. A purchase order may list many items; an item may be listed on many purchase orders. 3. An employee may complete several purchase orders, but only one employee may fill out an individual PO. Prepare the 3FN base tables needed to produce this purchase order.
K Cannon, Inc., is a manufacturer of portable CD players. The company purchases raw materials such as plastics and computer chips for its conversion cycle. The following describes K Cannon’s purchases and payments procedures. John, the purchasing department clerk, monitors raw materials inventory levels and prepares a purchase requisition when purchases are necessary. These are sent to the purchasing agent, who prepares six copies of a purchase order. Two purchase orders are sent directly to the vendor. One is placed in an open purchase order file in the purchasing department, and one is used to post to the purchases journal. Each week the purchasing department clerk prepares a journal voucher from the purchases journal and sends it to the general ledger department for posting. The AP and the receiving departments also each receive a copy of the purchase order, which they file temporarily. Upon receiving the raw materials, the receiving department clerk creates five copies of the…
Ngai Nhung is the sales manager at Hung Technologies. At lunch with the company CEO, Ngai proudly announced that he had received a __ from a client. The client had just requested a large quantity of components from Hung.
A. purchase order
B. purchase requisition
C. back order
D. voucher
E. bill of lading
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
Knowledge Booster
Similar questions
- Unilever ltd is a company that manufactures and sells various consumer products in Kenya. The Company performs its purchasing transaction cycle activities using its integrated ERP system as follows:Employees in any department can prepare purchase requisitions for items they note as being either out of stock or in small quantity. 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,000 must be approved by the purchasing department manager. Paper purchase orders are printed and mailed to…arrow_forwardValue chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Business Function Cost Item Answera. Research and development 1. Labor time to repair products under warrantyb. Design 2. TV commercial spotsc. Production 3. Labor costs of fi lling customer ordersd. Marketing 4. Testing of competitor’s producte. Distribution 5. Direct manufacturing labor costsf. Customer service 6. Development of order tracking system forthe Internet7. Printing cost of new product brochures8. Hours spent designing childproof bottles9. Training costs for representatives to staff the customer call center10. Installation of robotics equipment in manufacturing plantarrow_forwardCD Express, Inc., provides CD duplicating services for its customers. An order from a customer can be for a single copy or for thousands of copies. Most jobs are broken down into batches to allow smaller jobs, with higher priorities, to have access to the machines.A number of activities carried out at CD Express are listed below.a. Sales representatives’ periodic visits to customers to keep them informed about the services provided by CD Express.b. Ordering labels from the printer for a particular CD.c. Setting up the CD duplicating machine to make copies from a particular master CD.d. Loading the automatic labeling machine with labels for a particular CD.e. Visually inspecting CDs and placing them by hand into protective plastic cases prior to shipping.f. Preparation of the shipping documents for the order.g. Periodic maintenance of equipment.h. Lighting and heating the company’s production facility.i. Preparation of quarterly financial reports.Required:Classify each of the activities…arrow_forward
- Moss Manufacturing produces several types of bolts. The products are produced in batches according to customer order. Although there are a variety of bolts, they can be grouped into three product families. The number of units sold is the same for each family. The selling prices for the three families range from 0.50 to 0.80 per unit. Because the product families are used in different kinds of products, customers also can be grouped into three categories, corresponding to the product family they purchase. Historically, the costs of order entry, processing, and handling were expensed and not traced to individual products. These costs are not trivial and totaled 6,300,000 for the most recent year. Furthermore, these costs had been increasing over time. Recently, the company had begun to emphasize a cost reduction strategy; however, any cost reduction decisions had to contribute to the creation of a competitive advantage. Because of the magnitude and growth of order-filling costs, management decided to explore the causes of these costs. They discovered that order-filling costs were driven by the number of customer orders processed. Further investigation revealed the following cost behavior: Step-fixed cost component: 70,000 per step; 2,000 orders define a step Variable cost component: 28 per order Moss currently has sufficient steps to process 100,000 orders. The expected customer orders for the year total 140,000. The expected usage of the order-filling activity and the average size of an order by product family are as follows: As a result of the cost behavior analysis, the marketing manager recommended the imposition of a charge per customer order. The president of the company concurred. The charge was implemented by adding the cost per order to the price of each order (computed using the projected ordering costs and expected orders). This ordering cost was then reduced as the size of the order increased and eliminated as the order size reached 2,000 units. (The marketing manager indicated that any penalties imposed for orders greater than this size would lose sales from some of the smaller customers.) Within a short period of communicating this new price information to customers, the average order size for all three product families increased to 2,000 units. Required: 1. Moss traditionally has expensed order-filling costs (following GAAP guidelines). Under this approach, how much cost is assigned to customers? Do you agree with this practice? Explain. 2. Consider the following claim: by expensing the order-filling costs, all products were undercosted; furthermore, products ordered in small batches are significantly undercosted. Explain, with supporting computations where possible. Explain how this analysis also reveals the costs of various customer categories. 3. Calculate the reduction in order-filling costs produced by the change in pricing strategy. (Assume that resource spending is reduced as much as possible and that the total units sold remain unchanged.) Explain how exploiting customer linkages produced this cost reduction. Moss also noticed that other activity costs, such as those for setups, scheduling, and materials handling costs, were reduced significantly as a result of this new policy. Explain this outcome, and discuss its implications. 4. Suppose that one of the customers complains about the new pricing policy. This buyer is a lean, JIT firm that relies on small, frequent orders. In fact, this customer accounted for 30 percent of the Family A orders. How should Moss deal with this customer? 5. One of Mosss goals is to reduce costs so that a competitive advantage might be created. Describe how the management of Moss might use this outcome to help create a competitive advantage.arrow_forwardOhio 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?arrow_forwardAssign the customer-related activity costs to each customer type using activity rates. Now calculate the profitability of each customer category. As a manager, how would you use this information? Emery Company sells small machine parts to heavy equipment manufacturers for an average price of 1.05 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plants manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customers specifications have been met Inspection takes essentially the same time regardless of the type of part being produced. Emerys Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Calculate the profitability of each customer type. Discuss the problems with this measure of customer profitability.arrow_forward
- Assume you are the warehouse manager for Vinnies Vinyls, a multi-location business specializing in vinyl records. Vinniess operates under a cost-based transfer structure and the warehouse supplies all stores with the records. The stores can purchase records only from the warehouse, and the warehouse can only sell to Vinnies stores. The manager of the West store has some concerns relating to the stores financial performance and has asked for your help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. (Hint: it may be helpful to perform a vertical analysis.)arrow_forwardABC Company is a manufacturing company that produces furniture. To improve efficiency and usefulness, ABC Company is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forward
- Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day andforwards the total to the General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning