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.
Convert the accompanying database to an excel table to find:
a. The total cost of all orders
b. The total quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Yummy Yummy is a Cantonese restaurant. The business employs several staff members who
purchase food, beverages, furniture, and equipment from various suppliers. However, only food and
beverages are counted as inventory. The diagram below illustrates the purchasing process, which
requires at least one inventory item per purchase. The model also assumes that employees and
suppliers are recorded before any purchases are made.
wwwwwwwww
Your task is to construct a table structure to facilitate Yummy Yummy's food procurement process,
highlighting the primary and foreign keys.
Inventory
0..
Purchases
0.."
1..1
Suppliers
1..1
Employees
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
- 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 plantarrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that only one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Units sold Sales Variable expenses Fixed expenses Net operating income (loss) Contribution margin per unit $ Case 1 Case 2 9,400 300,800 $ 406,000 131,600 96,000 $ $ 174,000 116,000 $ 20 $ Case 3 19,200 172,800 213,000 15 Case 4 4,000 $ 108,000 $ 72,000 (36,000)arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Case #1 Case #2 Case #3 Case #4 24 449,000 $ 210,000 $ 293,000 Sales 134,400 79,110 Variable expenses 68,000 469,000 Fixed expenses (6,110) % 2$ 44,150 24 96,380 2$ Net operating income (loss) 81 % 35 % Contribution margin ratio (percent) search 近arrow_forward
- Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Sales Variable expenses Fixed expenses Net operating income (loss) Contribution margin ratio (percent) $ $ Case 1 444,000 64,600 40 % < $ Required A Case 2 196,000 125,440 55,000 % $ Case 3 475,000 118,880 Required B 84 % $ Case 4 309,000 98,880 $ (10,880) %arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a sign.) Sales Variable expenses Contribution margin Fixed expenses Net operating income (loss) Contribution margin ratio (percent) $ Case 1 459,000 55,830 37 % $ Case 2 204,000 134,640 52,000 % $ Case 3 474,000 51,920 76 % $ $ Case 4 300,000 96,000 (27,000) %arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Case #1 Case #2 Case #3 Case #4 Sales $ 459,000 $ 194,000 $ 304,000 Variable expenses 124,160 79,040 Fixed expenses 56,000 475,000 Net operating income (loss) $ 72,600 $ 52,440 $ (1,040) Contribution margin ratio (percent) 40 % 76 % < Required A Required B %24 %24arrow_forward
- Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Sales Variable expenses Fixed expenses Net operating income (loss) Contribution margin ratio (percent) $ $ Case 1 452,000 59,280 39 % Case 2 199,000 121,390 59,000 % Case 3 474,000 51,920 76 % $ Case 4 305,000 82,350 $ (10,350)arrow_forwardConvert the accompanying database to an Excel table to find: a.The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve.arrow_forwardDole 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 ]arrow_forward
- 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_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_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required Assume that more than one product is being sold in each of the four following case situations: (Loss amounts should be sign.) Sales Variable expenses Contribution margin Fixed expenses Net operating income (loss) Contribution margin ratio (percent) $ $ Case 1 446,000 69,320 42 % < $ Required A Case 2 199,000 123,380 53,000 % $ Case 3 472,000 107,740 Required B 82 % $ Case 4 298,000 95,360 $ (23,360) %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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