Question: Quadrex Computers is a store that buys computer components, assembles the components into computers, and then sells the computers at high prices. Each computer is


Quadrex Computers is a store that buys computer components, assembles the components into computers, and then sells the computers at high prices. Each computer is assigned a unique identification number, and computers that have common configurations are categorized into types (laptop, desktop, etc.). Categories can be entered into the dataset before any computers in the categories are actually assembled. All agents can be entered into the dataset before they are involved in any transactions. (This paragraph just reminds you of what Quadrex does to make money.) The computer components are purchased from wholesalers. One of Quadrex's purchasing agents submits an order to the wholesaler that has listed a given component for sale. If the order is accepted, one of Quadrex's inventory clerks receives the items. Multiple orders accepted by the same supplier may be consolidated into one purchase. Orders are accepted in their entirety or not at all. Nearly all of Quadrex's orders are accepted. Sometimes the incorrect components are delivered to Quadrex and it has to return them to the appropriate supplier. Sometimes Quadrex returns components to suppliers for other reasons, such as the result of a change in planned production of a certain category of computers. Only about 10 percent of Quadrex's purchased components are returned to suppliers, and any return would result from only one purchase. There are no partial returns on a delivery. When payment is due for a purchase, one of Quadrex's cashiers issues one check for payment in full for the items on that purchase. If multiple purchases have been made from the same supplier within a short time, Quadrex pays for those purchases with one check. One of Quadrex's managers authorizes all purchase orders greater than $5,000 and signs all checks (Do not model the signing of checks). There are cash disbursements for expenditures other than purchases of computer components. Purchasing Agent ID (PAID) Purchasing Agent name (PA name) Location of Cash account (Ca-loc) Cash Account Number (Ca#) Supplier ID (SupID) Purchase date (purch-date) Purchase order # (PO-ID) Manager ID (Man ID) Manager name (Man name) Component ID code (CompoID) Quantity of a computer component received on a purchase (Qty-rec) Purchase order date (PO-date) Component standard cost (stdcost) Supplier name (Supp-name) Inventory Clerk ID (IC ID) Inventory Clerk name (IC name) Receiving report # ( RR) Cash disbursement # (CD#) Actual cost of a computer component on a particular purchase (unit-cost) Quantity of a computer component ordered on purchase order (Qty-Ord) Purchase return date (PR-date) Cash disbursement date (CD-date) Ordered cost for a computer component on a purchase order (Ord-unitcost) Component description (descrip) Supplier type (Supp-type) Cashier ID (Cashier ID) Cashier name (Cashier name) Current balance of cash account (AcctBal) Cash disbursement amount (CDamt) Purchase return ID# (PR-ID) Quadrex Computers is a store that buys computer components, assembles the components into computers, and then sells the computers at high prices. Each computer is assigned a unique identification number, and computers that have common configurations are categorized into types (laptop, desktop, etc.). Categories can be entered into the dataset before any computers in the categories are actually assembled. All agents can be entered into the dataset before they are involved in any transactions. (This paragraph just reminds you of what Quadrex does to make money.) The computer components are purchased from wholesalers. One of Quadrex's purchasing agents submits an order to the wholesaler that has listed a given component for sale. If the order is accepted, one of Quadrex's inventory clerks receives the items. Multiple orders accepted by the same supplier may be consolidated into one purchase. Orders are accepted in their entirety or not at all. Nearly all of Quadrex's orders are accepted. Sometimes the incorrect components are delivered to Quadrex and it has to return them to the appropriate supplier. Sometimes Quadrex returns components to suppliers for other reasons, such as the result of a change in planned production of a certain category of computers. Only about 10 percent of Quadrex's purchased components are returned to suppliers, and any return would result from only one purchase. There are no partial returns on a delivery. When payment is due for a purchase, one of Quadrex's cashiers issues one check for payment in full for the items on that purchase. If multiple purchases have been made from the same supplier within a short time, Quadrex pays for those purchases with one check. One of Quadrex's managers authorizes all purchase orders greater than $5,000 and signs all checks (Do not model the signing of checks). There are cash disbursements for expenditures other than purchases of computer components. Purchasing Agent ID (PAID) Purchasing Agent name (PA name) Location of Cash account (Ca-loc) Cash Account Number (Ca#) Supplier ID (SupID) Purchase date (purch-date) Purchase order # (PO-ID) Manager ID (Man ID) Manager name (Man name) Component ID code (CompoID) Quantity of a computer component received on a purchase (Qty-rec) Purchase order date (PO-date) Component standard cost (stdcost) Supplier name (Supp-name) Inventory Clerk ID (IC ID) Inventory Clerk name (IC name) Receiving report # ( RR) Cash disbursement # (CD#) Actual cost of a computer component on a particular purchase (unit-cost) Quantity of a computer component ordered on purchase order (Qty-Ord) Purchase return date (PR-date) Cash disbursement date (CD-date) Ordered cost for a computer component on a purchase order (Ord-unitcost) Component description (descrip) Supplier type (Supp-type) Cashier ID (Cashier ID) Cashier name (Cashier name) Current balance of cash account (AcctBal) Cash disbursement amount (CDamt) Purchase return ID# (PR-ID)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
