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 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
REVENUE CYCLE CASE STUDY
__________________________________________________________________________
__________________________________________________________________________
ARCHITECT’S DEPOT
(NETWORKED COMPUTER SYSTEM WITH MANUAL PROCEDURES)
Architect’s Depot (AD) is an online company that supplies a range of architectural products to building contractors and private individuals. Their product line includes such items as gable vents, shutters, vinyl sidings, and decorative trim in various materials.
The company employs a combination of manual procedures and a networked accounting system with distributed terminals in several departments.
After years of satisfactory performance, however, AD is now experiencing operational inefficiencies and accounting errors. Your firm has been hired to evaluate AD’s business processes and internal controls. The revenue cycle is described in the following paragraph.
Sales Order Procedures
AD’s revenue process is initiated when a customer…
Gemma Company is a midsize manufacturing company with 120 employees and approximately $45 million in sales. Management has established a set of processes to purchase fixed assets, described in the following paragraphs:
When a user department decides to purchase a new fixed asset, the departmental manager prepares an asset request form. When completing the form, the manager must describe the fixed asset, the advantages or efficiencies offered by the asset, and estimates of costs and benefits. The asset request form is forwarded to the director of finance. Personnel in the finance department review estimates of costs and benefits and revise these if necessary. A discounted cash flow analysis is prepared and forwarded to the vice president of operations, who reviews the asset request forms and the discounted cash flow analysis, and then interviews user department managers if he or she feels it is warranted. After this review, she selects assets to purchase until she has exhausted the…
The following is a list of various departments in a diesel engine manufacturing/rebuilding facility. The company makes diesel engines for the locomotive industry. It also remanufactures its own previously built engines that need to be overhauled after several years of use. Classify each department below as either a support department or a production department.
Cost Accounting Department—collects costs of raw materials, labor, and overhead to be applied to engines
Remanufacturing Department—works on engines needing overhauled
Tooling Department—ensures that tools for all production areas are where they need to be to build the engines
Production Data Entry Department—records data such as raw material usage for each production line
Engine Department—builds new engines
Production
Support
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
- Internal Control Cases UTICA LIGHTING COMPANY (CENTRALIZED SYSTEM WITH DISTRIBUTED TERMINALS) Utica Lighting Company (ULC) is a manufacturer of outdoor lighting systems for patios, walkways, and public areas. It markets its product to landscaping companies and local municipalities. ULC employs a centralized computer system with distributed terminals in the various departments. Recently the company has been having manufacturing delays and cost overruns. ULC has hired your auditing firm to assess its operations and internal control procedures. ULCs conversion cycle is triggered by a report from the finished goods warehouse. The warehouse clerk periodically reviews the inventory records in a search for low-stock items. When the quantity on hand of an inventory item in the finished goods warehouse falls below its pre-established minimum, the warehouse clerk sends a digital inventory status report from the warehouse terminal to production planning and control advising them to schedule a production batch run for the item in question. Upon receipt of the report the production planning and control department clerk accesses the digital bill of materials and the routing sheet files for the items to be produced and adds the production details to the digital production schedule. The system automatically adds a record to the open work order file and sends a digital work order to the work center supervisors terminal and to the cost accounting clerks terminal. The work center supervisor accesses the work order from his terminal and prints hard-copy move tickets and material requisitions for each stage in the production process. Production employees take the materials requisitions to the storekeeper and secure the components, subassemblies, and raw materials needed to perform their production tasks. If excess materials beyond the standard amount are needed, the supervisor prepares additional materials requisitions. The employees also complete job time tickets after each stage in the process to reflect the time spent on the job. When the employees complete their tasks, they send the move tickets and time tickets to the cost accounting department. The storekeeper receives the materials requisitions and releases the materials into production. He then updates the raw material inventory records and sends the requisition to cost accounting. When inventories of component parts and raw materials fall to their reorder points, the storekeeper prepares purchase orders and sends them to the respective vendors. Vendors deliver raw material inventories directly to the storeroom, at which time the storeroom clerk inspects them and updates the digital raw materials subsidiary ledger. Each day the storekeeper prepares a journal voucher and posts to the general ledger raw material control account. The cost accounting clerk receives the digital work order and initiates a new WEP account for the batch. During the production process, the clerk receives hard-copy move tickets, materials requisitions, and job tickets from the work centers, which the clerk uses to update WIP account. When production is complete, the clerk closes the WIP account for the batch and transfers it to the finished good inventory subsidiary ledger. At the days end, the cost accounting clerk prepares a digital journal voucher reflecting the WIP status and any transfers from WIP to finished goods inventory. The clerk then posts the journal voucher to the WEP and FG general ledger control accounts. Required a. Prepare a data flow diagram of the current system. b. Prepare a system flowchart of the existing system. c. Describe the internal control weaknesses.arrow_forwardMantenga 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_forwardEmery Manufacturing Company produces component parts for the farm equipment industry and has recently undergone a major computer system conversion. Jake Murray, the controller, has established a troubleshooting team to alleviate accounting problems that have occurred since the conversion. Jake has chosen Gus Swanson, assistant controller, to head the team that will include Linda Wheeler, cost accountant; Cindy Madsen, financial analyst; Randy Lewis, general accounting supervisor; and Max Crandall, financial accountant. The team has been meeting weekly for the last month. Gus insists on being part of all the team conversations in order to gather information, to make the final decision on any ideas or actions that the team develops, and to prepare a weekly report for Jake. He has also used this team as a forum to discuss issues and disputes about him and other members of Emerys top management team. At last weeks meeting, Gus told the team that he thought a competitor might purchase the common stock of Emery, because he had overheard Jake talking about this on the telephone. As a result, most of Emerys employees now informally discuss the sale of Emerys common stock and how it will affect their jobs. Required: Is Gus Swansons discussion with the team about the prospective sale of Emery unethical? Discuss, citing specific standards from the code of ethical conduct to support your position. (CMA adapted)arrow_forward
- A CIA’s client, The Outsider, Inc., is a medium-sized manufacturer of products for the leisure time activities market (camping equipment, scuba gear, bows and arrows, and so on). During the past year, a computer system was installed, and inventory records of finished goods and parts were converted to a computer processing. The inventory master life is maintained on a disk. Each recorded of the file contains the following information: Item or part number Description Size Unit of measure code Quantity on hand Cost per unit Total value of inventory on hand at cost Date of last sale or usage Quantity sold or used this year Economic order quantity Code number of major vendor Code number of secondary vendor In preparation for year-end inventory, the client has two identical sets of preprinted inventory count cards. One set is for the client’s inventory counts and the other is for the CIA’s use to make audit test counts. The following information has been keypunched into the cards and…arrow_forwardValue chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Business Function Cost Item Answera. Research and development 1. Purchase of raw materialsb. Design 2. Advertisingc. Production 3. Salary of research scientistsd. Marketing 4. Shipping expensese. Distribution 5. Reengineering of product assembly processf. Customer service 6. Replacement parts for warranty repairs7. Manufacturing supplies8. Sales commissions9. Purchase of CAD (computer-aideddesign) software10. Salary of website designerarrow_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 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 purchases department.A few days later, the supplier ships the order and thegoods arrive at the receiving department. The receiving clerk reviews the digital purchase order from his terminal, inspects the goods, creates a…arrow_forward
- Blackburn Inc. uses Otavalo Manufacturing and Piura Company to buy two precision machined parts used in the manufacture of its permanent-magnet motors: Part #625 and Part #827. Consider two activities: testing parts and reordering parts. After the two parts are inserted, testing is done to ensure that the two parts work as intended. Reordering occurs because one or both of the parts have failed the test and it is necessary to replenish part inventories. Activity cost information and other data needed for supplier costing are as follows: I. Activity Costs Caused by Suppliers (testing failures and reordering as a result) Activity Costs Testing parts $4,500,000 Reordering parts 1,125,000 II. Supplier Data Otavalo Manufacturing Piura Company Part #625 Part #827 Part #625 Part #827 Unit purchase price $30 $78 $36 $84 Units purchased 450,000 225,000 56,250 56,250 Failed tests 4,500…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_forwardSullivan Ranch Corporation has purchased a new tractor and has provided you with the information related to the purchase. The Controller has asked you to calculate the depreciation for the new piece of equipment using different methods: Straight-Line depreciation, Units-of-Production depreciation, and Double-Declining-Balance depreciation. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B8" was entered, the formula would output the result from cell B8, or 360 in this example. Absolute Reference: Allows you to maintain the original cell reference when a formula is copied to another cell. The cell reference is "locked" by putting a dollar sign ($) before the column and row references. By default a cell reference is relative, so when you copy a formula to another cell the values update…arrow_forward
- Jade Ltd is now considering how to obtain a computer software. The director of Jade Ltd has noticed that over the last 20 years, many companies have spent a great deal of money internally developing new intangible assets, such as software. You have been asked by the director to provide your advice on the accounting treatments of the two possibilities below: (i) Employ its own programmers to write software that the company will use (ii) Purchase computer software externally, including packages for payroll and general ledger. Required: In accordance with IAS 38 / AASB 138 Intangible Assets, discuss whether internally developed intangible assets should be recognised, and explain the differ in the accounting treatments for the two possible options.arrow_forwardMarketing system provides some useful insights regarding the sales order. Different departmentsuse this information. For instance, the production process uses this information to forecast theexpected sale for next month. The production clerk uses this to create an online productionschedule. From this schedule, the system automatically prepares weekly online work orders to beused 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, thesupervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based job…arrow_forwardFollowing items belong to the revenue, expenditure, human resources/payroll, production, or financing cycle. Classify each item based on the cycle it belongs to. a. Pay pay-as-you-earn (PAYE) payroll taxes b. Send material requisition to inventory c. Issue stock to investors d. Borrow money from the bank to purchase a new factory e. Complete receiving report f. Appoint replacement purchasing clerk g. Measure employee performance using a performance management system h. Choose suitable supplier of raw materials i. Ensure employees are up to date with the latest tax provisions j. Record personal and tax information for new employeesarrow_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
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher: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
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning