Sawicki Music Supply is a mail-order business that accepts merchandise orders by telephone and mail. All payments must be prepaid with a major credit card. Once an order is received, either the item is found in inventory and shipped immediately, the item is not found in inventory and is ordered from the manufacturer, or a notice is sent to the customer indicating that the item is no longer stocked. Required Prepare a context, intermediate, and elementary-level data flow diagram for Sawicki Music Supply. For the elementary-level diagram, explode the inventory function.

Sawicki Music Supply is a mail-order business that accepts merchandise orders by telephone and mail. All payments must be prepaid with a major credit card. Once an order is received, either the item is found in inventory and shipped immediately, the item is not found in inventory and is ordered from the manufacturer, or a notice is sent to the customer indicating that the item is no longer stocked. Required Prepare a context, intermediate, and elementary-level data flow diagram for Sawicki Music Supply. For the elementary-level diagram, explode the inventory function.

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter5: The Expenditure Cycle Part I: Purchases And Cash Disbursements Procedures

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

Given the following business rules, construct an ER diagram so each rule is captured for the database. Presume each rule is to be treated individually. Construct an ER diagram for each rule.a. A retail sales company prepares sales orders for its customers’ purchases. A customer can make many purchases, but a sales order is written for a single customer.b. A retail sales company orders inventory using a purchase order. An inventory item may be ordered many times, and a purchase order may be created for more than one inventory item.c. A company that sells antique cars prepares a sales order for each car sold. The inventory for this company consists of unique automobiles, and only one of these automobiles may be listed on a sales order.d. A grocery store identifies returning customers via a plastic card that the clerk scans at the time of each purchase. The purpose of this card is to track inventory and to maintain a database of customers and their purchases. Obviously, a customer may…
For each of the following processes, state whether OLTP or OLAP is appropriate, and why. a. An order entry system that retrieves customer information, invoice information, and inventory information for local sales. b. An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales informa- tion about both the customer and the inventory items. c. An order entry system that retrieves customer information, invoice information, inventory infor- mation, and information to compare the current sale to sales across several geographic regions. d. An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable informa- tion for sales within one marketing region. e. An insurance company requires a system that will allow it to determine total claims by region, whether a relationship exists between claims and meteorological phenomena, and why one region seems to be more…
OLTP VERSUS OLAP SERVERS For each of the following processes, state whether OLTP or OLAP is appropriate, and why. An order entry system that retrieves customer information, invoice information, and inventory information for local sales. An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales information about both the customer and the inventory items. An order entry system that retrieves customer information, invoice information, inventory information, and information to compare the current sale to sales across several geographic regions. An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable information for sales within one marketing region. An insurance company requires a system that will allow it to determine total claims by region, whether a relationship exists between claims and meteorological phenomena, and why one region seems to be…
Sales ledger control Account is known to have a debit balance. Explain, using numerical example why at certain instances the account has both debit and credit balance brought down? Construct a Purchase Ledger Control Account, using your own numerical example, with five items? Briefly discuss the role of the control accounts in the identification of missing figures in the financial statements of organizations ?
For each of the following processes, state whether OLTP or OLAP is appropriate and why.a. An order entry system that retrieves customer information, invoice information, and inventory information for local sales.b. An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales information about both the customer and the inventory items.c. An order entry system that retrieves customer information, invoice information, inventory information, and information to compare the current sale to sales across several geographic regions.d. An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable information for sales within one marketing region. e. An insurance company requires a system that will allow it to determine total claims by region, determine whether a relationship exists between claims and meteorological phenomenon, and why one region seems to be more…
Required: A sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Sales Table Invoice# Date Amount S-101 10/05/2021 2549.90 S-105 11/01/2021 949.95 S-107 11/02/2021 1209.70 S-108 11/06/2021 699.90 ?Salesperson # ? Customer # ? Receipt # ? Inventory # ? Remittance Advice # ? Sales # ?Cashier # ?Cash
Describe the data flow in the buying process that begins when the purchasing organization sends a check to a vendor to settle an invoice for goods bought.
The purchases and disbursements cycle usually begins when Group of answer choices A user department requests for acquisition of goods or services and submits purchase requisition to the purchasing department. A check is issued to the vendor or supplier. The warehouse received the goods from the vendor or supplier. The accounting posts the purchase transaction in the accounts payable ledger.
All of the following are examples of sales order entry system controls except? Digital signatures/written signatures Credit Limits Approving invoices before paying Training
A company is trying to set up proper internal controls for their accounts payable/inventory purchasing system. Currently the purchase order is generated by the same person who receives the inventory. Together the purchase order and the receiving ticket are sent to accounts payable for payment. What changes would you make to improve the internal control structure? Group of answer choices 1.The person in accounts payable should generate the purchase order. 2.The person in accounts payable should generate the receiving ticket once the invoice from the supplier is received. 3.No changes would be made since the person paying the bills is different from the person ordering the inventory. 4.The responsibilities of generating the purchase order and receiving the inventory should be separated among two different people.
Compare and contrast a manual accounting system with a computerized accounting system for process vendors transactions. What uses are there for using tje vendor balance summary and AP aging summary reports? Explain why the balance in merchandise inventory different than in accounts payable? Be sure to include at least one reference from an online resource.
12.1 Match the term in the left column with its definition in the right column. 1. CRM system a. Document used to authorize reducing the balance in a customer account 2. Open-invoice method b. Process of dividing customer account master file into subsets and preparing invoices for one subset at a time 3. Credit memo C. System that integrates EFT and EDI information 4. Credit limit d. System that contains customer-related data organized in a manner to facilitate customer service, sales, and retention 5. Cycle billing e. Electronic transfer of funds 6. FEDI f. Method of maintaining accounts receivable that generates one payment for all sales made the previous month