MindTap Accounting, 1 term (6 months) Printed Access Card for Hall's Accounting Information Systems, 10th
10th Edition
ISBN: 9781337619257
Author: Hall, James A.
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 22P
1.
To determine
Prepare a data model containing entities and cardinality between those entities to support the tasks and user views depicted in the given situation.
2.
To determine
Prepare normalized model with attributes, keys, and cardinalities.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
SYSTEM DOCUMENTATION-EXPENDITURE CYCLE (MANUAL AND COMPUTER PROCEDURES)
The following describes the expenditure cycle for a hypothetical company.
The company has a centralized computer system with terminals located in various departments. The terminals are networked to a computer application, and digital accounting records are hosted on a server in the data processing department.
Each day, the computer in the data processing center scans the inventory records looking for items that must be replenished. For each item below its reorder point, the system creates a digital purchase order and prints two hard copies. A technician in the data center sends the purchase orders to the purchasing department clerk.
Upon receipt of the purchase orders, the purchasing clerk reviews and signs them. He sends Copy 1 to the supplier and files Copy 2 in the purchasing department. A few days later, the supplier ships the order and the goods arrive at the receiving department. The receiving clerk reviews…
Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…
Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department.The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions.Work centre employees record their work hours on paper-based…
Chapter 9 Solutions
MindTap Accounting, 1 term (6 months) Printed Access Card for Hall's Accounting Information Systems, 10th
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
- Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…arrow_forwardWhen Mr. Avila orders materials for his construction business, he sends a duplicate copy of the purchase order to the receiving department. During the delivery of materials, Mr. Nobles, the receiving clerk, records the receipt of shipment of this purchase order. After recording, Mr. Nobles sends the purchase order to the accounting department where it is used to record materials purchased and accounts payable. The materials are trasported to the storage area by forklifts. The additional purchased quantities are recorded on storage records. Required: Identify the weakness/weaknesses in internal control and opposite the identified weakness or weaknesses, enumerate the control procedure/s that you will recommend to avoid or mitigate the risk of loss.arrow_forwardThe following describes the expenditure cycle for a hypothetical company. The company has a centralized computer system with terminals located in various departments. The terminals are networked to a computer application, and digital accounting records are hosted on a serverin the data processing department. Each day, the computer in the data processing center scans the inventory records looking for items that must be replenished. For each item below itsreorder point, the system creates a digital purchase order and prints two hard copies. A technician in the data center sends the purchase orders to the purchasing department clerk.Upon receipt of the purchase orders, the purchasing clerk reviews and signs them. He sends Copy 1 to the supplier and files Copy 2 in the purchasing department.A few days later, the supplier ships the order and the goods arrive at the receiving department. The receiving clerk reviews the digital purchase order from his terminal, inspects the goods,…arrow_forward
- Mantenga Company provides routine maintenance services for heavy moving and transportation vehicles. Although the vehicles vary, the maintenance services provided follow a fairly standard pattern. Recently, a potential customer has approached the company, requesting a new maintenance service for a radically different type of vehicle. New servicing equipment and some new labor skills will be needed to provide the maintenance service. The customer is placing an initial order to service 150 vehicles and has indicated that if the service is satisfactory, several additional orders of the same size will be placed every 3 months over the next 3 to 5 years. Mantenga uses a standard costing system and wants to develop a set of standards for the new vehicle. The usage standards for direct materials such as oil, lubricants, and transmission fluids were easily established. The usage standard is 25 quarts per servicing, with a standard cost of 4 per quart. Management has also decided on standard rates for labor and overhead. The standard labor rate is 15 per direct labor hour, the standard variable overhead rate is 8 per direct labor hour, and the standard fixed overhead rate is 12 per direct labor hour. The only remaining decision is the standard for labor usage. To assist in developing this standard, the engineering department has estimated the following relationship between units serviced and average direct labor hours used: As the workers learn more about servicing the new vehicles, they become more efficient, and the average time needed to service one unit declines. Engineering estimates that all of the learning effects will be achieved by the time that 320 units are produced. No further improvement will be realized past this level. Required: 1. Assume that the average labor time is 0.768 hour per unit after the learning effects are achieved. Using this information, prepare a standard cost sheet that details the standard service cost per unit. (Note: Round costs to two decimal places.) 2. CONCEPTUAL CONNECTION Given the per-unit labor standard set, would you expect a favorable or an unfavorable labor efficiency? Explain. Calculate the labor efficiency variance for servicing the first 320 units. 3. CONCEPTUAL CONNECTION Assuming no further improvement in labor time per unit is possible past 320 units, explain why the cumulative average time per unit at 640 units is lower than the time at 320 units. Show that the standard labor time should be 0.768 hour per unit. Explain why this value is a good choice for the per-unit labor standard.arrow_forwardProcess Activity Analysis The procurement process for Jarom Wholesale Company includes a series of activities that transforms a materials requisition into a vendor payment. The process begins with a request for materials. The requesting department prepares and sends a materials request form to the Purchasing Department. The Purchasing Department then places a request for a quote to vendors. Vendors prepare bids in response to the request for a quote. A vendor is selected based on the lowest bid. A purchase order to the low-bid vendor is prepared. The vendor delivers the materials to the company, whereupon a receiving ticket is prepared. Payment to the vendor is authorized if the materials request form, receiving ticket, and vendor invoice are in agreement. These three documents fail to agree 40% of the time, initiating effort to reconcile the differences. Once the three documents agree, a payment is made. The process can be diagrammed as follows: An activity analysis indicated the…arrow_forwardABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date information about the processing and current location of each shipped item. To do this, the company relies on a company-wide information system. Shipped items are the heart of the company's product tracking system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the company's system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard transportation events (i.e., flights, truck deliveries). These transportation ever are characterized by a unique schedule number, a type (e.g., flight, truck), and a delivery route. For this assignment. I want you to provide the names of all the tables that would be needed to save data about the scenario discussed…arrow_forward
- Superior Co. manufactures automobile parts for sale to the major U.S. automakers. Superior’s internal audit staff is to review the internal controls over machinery and equipment and make recommendations for improvements when appropriate. The internal auditors obtained the following information during the assignment: Requests for purchase of machinery and equipment are normally initiated by the supervisor in need of the asset. The supervisor discusses the proposed acquisition with the plant manager. A purchase requisition is submitted to the purchasing department when the plan manager is satisfied that the request is reasonable and that there is a remaining balance in the plant’s share of the total corporate budget for capital acquisitions. Upon receiving a purchase requisition for machinery or equipment, the purchasing department manager looks through the records for an appropriate supplier. A formal purchase order is then completed and mailed. When the machine or equipment is…arrow_forwardCase StudyCarosel Limited is a specialty motor vehicle parts supplier, procuring parts from a largenumber of suppliers. As part of the interim audit work four weeks prior to the companyyear’s end, you are testing the procurement/purchases systems, attending the inventory countand examining the sales and cash receipts.Purchasing/Procurement System When the quantity of a specific part falls below re-order level, an e-mail is sent to theprocurement department detailing the part required and the quantity to order. Partsinventory is monitored by the store’s manager with a copy of the e-mail filed on thestore manager's computer. Procurement department staff check the e-mail, allocate the order to an authorisedsupplier and send the order to that supplier using Electronic Data Interchange (EDI).The order is identified by a unique order number with a copy of the EDI order filed inthe order database by the computer system. When goods are received at Carosel, the stores clerk confirms that the…arrow_forwardThe following activities occur at Greenwich Corporation, a company that manufactures a variety of products. a. Receive raw materials from suppliers. b. Manage parts inventories. c. Do rough milling work on products. d. Interview and process new employees in the personnel department. e. Design new products. f. Perform periodic preventive maintenance on general-use equipment. g. Use the general factory building. h. Issue purchase orders for a job. Required: Classify each of the activities above as either a unit-level, batch-level, product-level, or organization-sustaining activity. a. Receive raw materials from suppliers. b. Manage parts inventories. c. Do rough milling work on products. d. Interview and process new employees in the personnel department. e. Design new products. f. Perform periodic preventive maintenance on general-use equipment. g. Use the general factory building. h. Issue purchase orders for a job.arrow_forward
- An entrepreneur of a custom sign company is reviewing reports showing the cost of printing machines, supplies, and labor so that she can make comparisons to the revenue being generated. What reports are being reviewed? a) Customer records. b) Financial statements. c) Asset reports. O d) Operation schedules.arrow_forwardMeagher Solutions Inc. manufactures memory chips for personal computers. An activity analysis was conducted, and the following activity costs were identified with the manufacture and sale of memory chips: a. Identify the cost of quality classification for each activity. Quality Activities Correct shipment errors Disposing of scrap Emergency equipment maintenance Employee training Final inspection Inspecting incoming materials Preventive equipment maintenance Processing customer returns Scrap reporting Supplier development Warranty claims. Total Quality Cost Classification Prevention b. Prepare a cost of quality report. Assume that the sales for the period were $4,000,000. If required, round percents to one decimal place. Activity Cost Appraisal Internal failure External failure Total $150,000 95,000 125,000 50,000 80,000 60,000 40,000 90,000 45,000 15,000 250,000 $1,000,000 Meagher Solutions Inc. Cost of Quality Report Percent of Total Quality Cost Quality Cost % % % % Quality Cost…arrow_forwardThe following is a description of the conversion cycle of Central Production Limited: The conversion cycle of the company is triggered by a report from the warehouse. When the quantity of an inventory item falls below a pre-set minimum level, the warehouse manager sends an online inventory status report to production department advising them to schedule a production batch run for the item. Upon receipt of the report, the production clerk assesses the digital bill of materials and the route sheet files for the item to be produced and adds the production details to the online production schedule. The system automatically adds a record to the open work order file and sends an online work orderto the work centre supervisor’s computer and to the accounting clerk’s computer. The work centre supervisor receives the work order from his computer and print hard-copy move tickets and materials requisitions for each production process. Production employees take the materials requisitions to store…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,
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
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
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,