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
When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount
should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature
of the expenditure and the use of judgment.
Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined
and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering
costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating
expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair
expenditure, the costs of doing the analysis could easily outweigh the benefits.
SouthEast Equipment has a large number of machines and equipment that are available for…
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
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
- 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_forwardA CPA’s client, Boos & Baumkirchner, Inc., is a medium-sizemanufacturer of products for the leisure-time activities market (camping equipment,scuba gear, bows and arrows, and so forth). During the past year, a computer system wasinstalled and inventory records of finished goods and parts were converted to computerprocessing. The inventory master file is maintained on a disk. Each record of the filecontains the following information:• Item or part number • Total value of inventory on hand at cost• Description • Date of last sale or usage• Size • Quantity used or sold this year• Unit-of-measure code • Economic order quantity• Quantity on hand • Code number of major vendor• Cost per unit • Code number of secondary vendorIn preparation for year-end inventory, the client has two identical sets of preprintedinventory count cards. One set is for the client’s inventory counts, and the other is for theCPA’s use to make audit test counts. The following information is on each card:• Item or…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_forwardK Cannon, Inc., is a manufacturer of portable CD players. The company purchases raw materials such as plastics and computer chips for its conversion cycle. The following describes K Cannon’s purchases and payments procedures. John, the purchasing department clerk, monitors raw materials inventory levels and prepares a purchase requisition when purchases are necessary. These are sent to the purchasing agent, who prepares six copies of a purchase order. Two purchase orders are sent directly to the vendor. One is placed in an open purchase order file in the purchasing department, and one is used to post to the purchases journal. Each week the purchasing department clerk prepares a journal voucher from the purchases journal and sends it to the general ledger department for posting. The AP and the receiving departments also each receive a copy of the purchase order, which they file temporarily. Upon receiving the raw materials, the receiving department clerk creates five copies of the…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_forward
- Davidson Engine Repairs provides maintenance and repair services for small engines such as those found in lawn mowers, power saws, and snow throwers. The repair shop costs include the salaries for the mechanics, insurance and depreciation on the repair equipment, materials and parts used for the jobs, and utilities. The repair shop manager would like to develop a model for predicting repair costs and over the past 10 months has carefully recorded the total repair costs incurred, along with the number of maintenance and repair jobs completed each month. The data are shown below: Month January February March 250 246 313 278 217 193 September 163 October 116 April May June July August Jobs Repair Costs $36,610 242 284 $41,395 Y = $37,950 $36,840 $44,340 $40,120 $33,660 $28,990 $25,275 $18,730 Required: 1. Not available in Connect. 2. Using the high-low method, estimate a cost formula for repair costs. Express the formula in the form Y = a + bX. Xarrow_forwardOhio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?arrow_forwardSYSTEM DOCUMENTATION- REVENUE CYCLE (MANUALAND COMPUTER PROCESSES)The following describes the revenue cycle procedures for a hypotheticalcompany. The sales department clerk receives hard-copy customer orders andmanually prepares a six-part hard-copy sales order. Copies of the salesorder are distributed to various departments as follows: Copies 1, 2, and3 go to the shipping department, and Copies 4, 5, and 6 are sent to thebilling department where they are temporarily filed by the billing clerk. Upon receipt of the sales order copies, the shipping clerk picks the goodsfrom the warehouse shelves and ships them to the customer. Theclerk sends Copy 1 of the sales order along with the goods to thecustomer. Copy 2 is sent to the billing department, and Copy 3 is filed inthe shipping department. When the billing clerk receives Copy 2 from the warehouse, she pulls theother copies from the temporary file and completes the documents byadding prices, taxes, and freight charges. Then, using the…arrow_forward
- In March 2021, Price Company began developing a new software system to be used internally for managing its inventory. The software integrates customer orders with inventory on hand to automatically place orders for additional inventory when needed. The software then automatically records inventory as the shipment is received and read by scanners. The software development was completed in October 2021 at a cost of $150,000. Of this amount, $25,000 was spent before the application development stage was established. Price expects to use the software for at least five years. Determine the initial amount that Price should capitalize as software development costs.arrow_forwardMartin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales orders to Martin’s network nightly for updating the company’s sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. When the billing department receives a payment, the billing clerk credits the customer’s account and records the cash received. Requirements 1.…arrow_forwardPlease help I am having trouble with this question. I will attach Images with better quality and some parts I have answered and parts I am missing. Thank you :) Kim's Asphalt does driveway and parking lot resurfacing work for large commercial clients as well as small residential clients. An inventory of materials and equipment is on hand at all times so that work can start as quickly as possible. Special equipment is ordered as required. On May 1, the Materials and Equipment Inventory account had a balance of $39,000. The Work-in-Process Inventory account is maintained to record costs of work not yet complete. There were two such jobs on May 1 with the following costs. Job 27Highlands Mall Job 33Pine Ridge Estates Materials and equipment $ 15,825 $ 52,800 Direct labor 13,800 26,400 Overhead (applied) 5,520 10,560 Overhead has been applied at 40 percent of the costs of direct labor. During May, Kim's Asphalt started two new jobs. Additional…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
Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:Cengage
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
Business Its Legal Ethical & Global Environment
Accounting
ISBN:9781305224414
Author:JENNINGS
Publisher:Cengage
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College