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 6P
To determine
Draw partial relational database for Company PGP. Also, label database tables assigning necessary attributes, foreign and primary key assuming that invoice, purchase orders and receipts contains many items.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Green Pond Nursery Supply (GPNS) is a gardencenter wholesaler in eastern Pennsylvania that sellsand distributes a wide range of garden productsand equipment including organic fertilizers, premiumflower and grass seeds, organic pesticides, and gardenspreaders. GPNS’s customers are primarilysmall garden centers and landscape companies in theMid-Atlantic states. Sales are on credit.GPNS’s current information system includes manualprocedures supported by independent (nonnetworked)PCs in each department. Communicationsbetween departments are entirely throughhard-copy documents. Recently, GPNS has beenreceiving complaints from suppliers regarding paymenterrors. Management believes that these complaintsstem, in part, from their antiquated computersystem. You have been hired to assess GPNS’s proceduresand internal controls. The following is adescription of GPNS’s expenditure cycle.Purchasing ProcessThe purchasing agent receives an inventory statusreport from the inventory control…
Arcontica Classic Furniture manufactures a of rustic chairs, lawn furniture, and interior purnishing including lamps, desks and bed frames. AFC's customer base comprises both private customers and retail outlets. consumer's sales are for cash or by credit card, but business costumers are for cash or by credit card, but business costumers are extended by a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepare a sales order, and sends stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department update the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department where…
GREEN POND NURSERY (STAND ALONE PC-BASED ACCOUNTINGSYSTEM)Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and gar den spreaders. GPNS's customers are primarily small garden centers and landscape companies in the Mid-Atlantic states. Sales are on credit.GPNS's current information system includes manual procedures supported by independent (non networked) PCs in each department. Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these com plaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS's procedures and internal controls. The following is a description of GPNS's expenditure cycle.Purchasing ProcessThe purchasing…
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
- GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING SYSTEM) Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNSs customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit. GPNSs current information system includes manual procedures supported by independent (non-networked) PCs in each department Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNSs procedures and internal controls. The following is a description of GPNSs expenditure cycle. Purchasing Process The purchasing agent receives an inventory status report from the inventory control department, which identifies the items that need to be reordered. The agent selects the suppliers, enters this information into the computer terminal to create a digital purchase order, and then prints three hard copies of the purchase order. He sends one copy to the supplier; one copy to the AP department, where it is filed temporarily, and files the third copy in the purchasing department. When the goods are received, the receiving department inspects and verifies them using the packing slip, which is attached to the goods. The receiving clerk manually prepares two hard copies of a receiving report. One copy accompanies the goods to the warehouse for storage. The receiving clerk sends the second copy to the purchasing agent who closes the open purchase order. The purchase agent then forwards the receiving report to the inventory control clerk. The inventory control clerk receives the receiving report and updates the inventory subsidiary. At the close of business, the clerk prepares an inventory summary, which he sends to the general ledger clerk. Accounts Payable and Cash Disbursements Procedures The AP clerk receives the suppliers invoice and reconciles it with the purchase order in the temporary file. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger. The purchases order and invoice are then filed in the department. Each day, the AP clerk visually searches the AP subsidiary ledger from her terminal for invoices that are due to be paid. The clerk prepares the check and records it in the digital check register. The negotiable portion of the check is mailed to the vendor, and a check copy is filed. The clerk then closes the liability in the AP subsidiary ledger and prepares a journal voucher, which she sends to the general ledger clerk. Upon receipt of the inventory summary and journal voucher, the general ledger clerk updates the inventory control, AP control, and cash accounts. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.arrow_forwardMighty Tools Hardware runs a network of small hardware retail outlets across the state. All sales are made for cash or on credit card and processed through electronic tills. A wide range of goods are stocked by the stores, meaning that the business deals with a large number of suppliers. All goods are purchased on credit with varying terms, depending on the supplier. Invoices are paid by cheque after a package of documents is collated and approved for payment. Ordering of goods and subsequent payments are processed by the central office with delivery direct from supplier to the stores — no central warehouse is used. Mighty Tools uses a perpetual stock system and conducts test counts at regular periods throughout the year. Required: (a) What controls should exist for inventory movements at the local store level and the central office? (b) Explain how the stocktake for Mighty Tools Hardware should be audited. What details are most important?arrow_forwardMighty Tools Hardware runs a network of small hardware retail outlets across the state. All sales are made for cash or on credit card and processed through electronic tills. A wide range of goods are stocked by the stores, meaning that the business deals with a large number of suppliers. All goods are purchased on credit with varying terms, depending on the supplier. Invoices are paid by cheque after a package of documents is collated and approved for payment. Ordering of goods and subsequent payments are processed by the central office with delivery direct from supplier to the stores — no central warehouse is used. Mighty Tools uses a perpetual stock system and conducts test counts at regular periods throughout the year. Required: What controls should exist for inventory movements at the local store level and the central office? Explain how the stocktake for Mighty Tools Hardware should be audited. What details are most important?arrow_forward
- Mighty Tools Hardware runs a network of small hardware retail outlets across the state. All salesare made for cash or on credit card and processed through electronic tills. A wide range of goodsare stocked by the stores, meaning that the business deals with a large number of suppliers. Allgoods are purchased on credit with varying terms, depending on the supplier. Invoices are paidby cheque after a package of documents is collated and approved for payment. Ordering of goodsand subsequent payments are processed by the central office with delivery direct from supplierto the stores — no central warehouse is used. Mighty Tools uses a perpetual stock system andconducts test counts at regular periods throughout the year.Required:(a) What controls should exist for inventory movements at the local store level and the centraloffice? (150-180 words)(b) Explain how the stocktake for Mighty Tools Hardware should be audited. What details aremost important? (230-250 words)arrow_forwardFeinman Computers sells desktop computer systems that it manufactures from parts and software that thirdparty vendors provide. Customers are both private consumers and small businesses. Consumers pay cash or by credit card, but business customers buy on credit. A credit check is made of all new business customers before approving a line of credit. Sales are made online or by a hard-copy order document that customers mail or fax to the company.When a credit order is received, the sales clerk verifies inventory availability, prepares a sales order and sends the stock release copy to Willy, a warehouse employee who picks the goods and arranges shipment. Willy then prepares the bills of lading and shipping notices. Barb in the billing department receives the shipping notice from Willy and updates the inventory subsidiary ledger to account for the reduction in inventory. Barb files the stock release, prepares the invoice, and mails a copy of it to the customer. Barb then updates the sales…arrow_forwardJC Company sells various merchandize ( building materials, stationery, house hold goods, and assortd groceries) to the general public and government workers on both cash and credit basis. You are a student at one of the universities and the sole trader for JC Company approaches you to write a company profile for him.arrow_forward
- Martin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales orders to Martin’s network nightly for updating the company’s sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. When the billing department receives a payment, the billing clerk credits the customer’s account and records the cash received. Requirements 1.…arrow_forwardWholesome and Happy Foods is a farm-to-family grocery store located in the Pacific Northwest. The company recently installed four self-checkout lanes that allow customers to scan their own groceries and pay for their purchases using an automated checkout kiosk. The kiosks are monitoredby a single attendant. In recent weeks, management has become concerned that some customers are not scanning all of the items when using the self-checkout lanes. Write a brief memo to your instructor suggesting features and capabilities for the kiosks that would serve as control procedures, ensuring that all items brought through the self-checkout lanes are properly scanned and purchased.arrow_forwardArcontica Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and interior furnishing including lamps, desks, and bed frames. ACF's customer base comprises both private customers and retail outlets. Consumer's sales are for cash or by credit card, but business customers are for cash or by credit card, but business customers are extended a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online, by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepares a sales order, and sends the stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR…arrow_forward
- 2. GREEN POND NURSERY (STAND-ALONE PC-BASED ACCOUNTING SYSTEM)Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNS’s customersare primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit.GPNS’s current information system includes manual procedures supported by independent (nonnetworked) PCs in each department. Communications between departments is entirely through hard-copy documents. Recently, GPNS has been receiving complaints from customers andsuppliers about billing, shipping, and payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS’s procedures and internal controls. The following is a description of GPNS’s revenue cycle. Sales…arrow_forwardThe A-to-Z Office Supply Company Christine Yamaguchi is the manager of the A-to-Z Office Supply Company in Charlotte. The company attempts to gain an advantage over its competitors by providing quality customer service, which includes prompt delivery of orders by truck or van and always being able to meet customer demand from its stock. To achieve this degree of customer service, A-to-Z must stock a large volume of items on a daily basis at a central warehouse and at three retail stores in the city and suburbs. Christine maintains these inventory levels by borrowing cash on a daily basis from the First Piedmont Bank. She estimates that for the coming fiscal year, the company’s demand for cash to pay for inventory will be $17,000 per day for 305 working days. Any money she borrows during the year must be repaid with interest by the end of the year. The annual interest rate currently charged by the bank is 9%. Any time Christine takes out a loan to purchase inventory, the bank charges…arrow_forwardThe following narrative describes the processing of customer mail orders at Eye- Dee- A- Pet, Inc.: Eye- Dee- A- Pet, Inc. is a small manufacturing operation engaged in the selling of digital identification chips that can be implanted into household pets, such as cats and dogs. Customers (e. g., veterinary clinics, animal hospitals) send orders by mail to the sales order department, where sales order clerks open the orders and review them for accuracy. For each order, the clerks enter the customer number, and the computer displays the customer record. The clerk matches the customer information on the screen with the customer order. Assuming that they match, the clerk enters the items and quantities being ordered. The computer edits the order by comparing the input data to customer and inventory master data. Assuming that the order passes the edits, the computer records the order on the sales event data and the sales order master data and then updates the inventory to allocate the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L