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.
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
Dole Foods Inc uses activity-based costing to calculate product costs. For each activity in the left column, match it to the
appropriate activity base on the right.
Order shipping
[Choose]
[Choose]
Number of customer orders
INumber of sales orders
Number of purchasc orders
Number of customcr rcttums
Number of employces
TChoosc
Purchasing
Invoice and collecting
Customer rcturn procesSIng
(Choose ]
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
- 2. a) A company manufactures and retails tablet computers. You are required to group the costs which are listed below and numbered (1)-(10) into the following classifications i-v (each cost is intended to belong to only one classification): 1- Wiring for the tablet 2-The maintenance contract from the machines 3- Aftersales customer service 4- The Chief Executive Salary 5- Shipping costs from the warehouse to the retailer 6- Marketing Costs 7- Interest on bank overdraft 8- Staff Training costs 9- Electricity to run the production line 10- Warehouse storage rent for the tablets. i. ii. iii. iv. V. Direct materials 1 Indirect production overhead 2 Selling and distribution costs Administration costs Finance costsarrow_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_forwardConvert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.arrow_forward
- You have determined that the purchases system operates as follows: • When materials are required for production, the production manager sends a handwritten note to the buying manager. For orders of other items, the department manager or managing director sends a handwritten note to the buying manager. The buying manager finds a suitable supplier and raises a purchase order. The purchase orders are signed by the managing director. Purchase orders are not issued for all goods and services received by the company.• Materials for production are received by the Goods Received Department, who issue a goods received note (GRN), and sends a copy to the accounts clerk. There is no system for recording receipt of other goods and services.• The accounts clerk receives the purchase invoice and matches it with goods received notes and purchase order (if available). The managing director authorises the invoice for posting to the purchase ledger.• The accounts clerk analyses the invoice into relevant…arrow_forwardWhat will you use to allocate the cost of the purchasing department? a.Number of purchase orders generated b.Number of machines c.None of the answers are correct d.Number of employeesarrow_forwardEx 5-35 (Algo) ABC; Selling Costs (LO 5-2, 5-4) Textile Crafts Company (TCC) sells craft kits and supplies to retail outlets and through online sites such as Etsy.com. Some of the items are manufactured by TCC, while others are purchased for resale. For the products it manufactures, the company currently bases its selling prices on a product-costing system that accounts for direct material, direct labor, and the associated overhead costs. In addition to these product costs, TCC incurs substantial selling costs, and Roger Jackson, controller, has suggested that these selling costs should be included in the product pricing structure. After studying the costs incurred over the past two years for one of its products, skeins of knitting yarn, Jackson has selected four categories of selling costs and chosen cost drivers for each of these costs. The selling costs actually incurred during the past year and the cost drivers are as follows: Cost Category Sales commissions Pay-per-click/Search…arrow_forward
- 6. Using the following account names, prepare the journal entries for the independent transactions listed below: Raw Materials Inventory Manufacturing Overhead Wages Payable Work in Process: Packaging Accounts Receivable Cost of Goods Sold Factory Wages Expense Finished Goods Inventory Work in Process: Shaping Work in Process: Production Sales Conversion Costs PLEASE NOTE #1: For similar accounting treatment (DR or CR), you are to record accounts in the same order as shown in the problem. PLEASE NOTE #2: You must enter the account names exactly as written above and all whole dollar amounts will be with "$" and commas as needed (i.e. $12,345). Overhead is assigned to the manufacturing department at the rate of $10 per machine hour. There were 3,500 machine hours during October in the shaping department and 2,500 in the packaging department. Prepare the journal entry to apply overhead to the manufacturing departments. DR ? ? DR ? ? CR ? ? Prepare the…arrow_forwardcreate a schedule showing TCC’s total selling cost for each order size and the per-skein selling cost within each order sizearrow_forwardMatch each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Labor time to repair products under warranty 2. Radio commercials 3. Labor costs of delivering customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for online sales 7. Design 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 Business Functionarrow_forward
- Cost drivers and functions. The representative cost drivers in the right column of this table are randomized so they do not match the list of functions in the left column. Representative Cost Driver A Number of imvoices sent B. Number of purchase orders C. Number of units manufactured D. Number of computers on the network E Number of employees hired F. Number of bills received from vendors G. Number of pallets moved Function 1. Accounts payable 2. Recruiting 3. Network Maintenance 4. Production 5. Purchasing 6. Warehousing 1. Billing 1. Match each function with its representative cost driver. 2 Give a second example of a cost driver for each function.arrow_forwardA manufacturer reports three activities: assembling components into products; product design; and sales order processing. Determine whether each of the following cost drivers relates to assembly, design, or order processing. Cost Driver 1. Direct labor hours to assemble components 2. Number of design changes 3. Number of components assembled 4. Number of design hours 5. Number of shipments made 6. Number of sales orders processed Activityarrow_forwardell Computer incurs the following costs: LOADING... (Click the icon to view the costs.) Requirement Classify each of the cost items (a-h) into one of the business functions of the value chain. Cost Item Value Chain Business Function a. Utility costs for the plant assembling the Latitude computer line of products b. Distribution costs for shipping the Latitude line of products to a retail chain c. Payment to David Newbury Designs for design of the XPS 2-in-1 laptop d. Salary of computer scientist working on the next generation of servers e. Cost of Dell employees' visit to a major customer to demonstrate Dell'sarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education