Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. REA MODELJUST SAY NO TO RUGS Just Say No to Rugs is a manufacturer of high-quality prefinished wood flooring. Their customer base con- sists

9. REA MODELJUST SAY NO TO RUGS Just Say No to Rugs is a manufacturer of high-quality prefinished wood flooring. Their customer base con- sists of private consumers, building and supply retai- lers, and construction companies. The company purchases unfinished exotic woods, stains, and finishes from numerous suppliers. The following describes the companys purchases and cash payments procedures. The inventory control clerk monitors raw material and finished goods inventory levels. When raw mate- rials drop to a predetermined reorder point, the clerk prepares a purchase requisition, which the clerk sends to the purchasing agent, who prepares five copies of a purchase order. Two copies are sent directly to the vendor. One is used to post to the purchases journal and is then placed in an open purchase order file. The AP and the receiving departments also each receive a copy each of the purchase order, which they file tem- porarily. Each week, the purchasing agent prepares a journal voucher from the purchases journal and sends it to the general ledger department for posting. Upon receiving the raw materials, the receiving department clerk creates four copies of the receiving report. One copy is sent to the raw materials ware- house, and one copy is sent to the AP department. One copy is sent to the inventory control department where it is used to update the inventory records. The final copy is sent to the purchasing department where it is filed. Vendors send their invoices to the AP department, where they are reconciled with the receiving reports and purchase orders. The AP clerk then creates an AP record in the AP subsidiary ledger. On the AP due date, the AP clerk sends the pur- chase order, receiving report, and invoice to the cash disbursement clerk who prepares a check and sends it to the vendor. After preparation of the checks, the supporting documents are sent back to the AP department. Each week, the AP clerk sends a journal voucher to the general ledger department for posting to the control accounts. Required a. Prepare the REA model to support the purchase and cash payments process. b. Show the cardinalities for all associations. c. List the tables, keys, and attributes needed to implement this model in a relational database. 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions