Lester’s Rentals is located in Cincinnati, Ohio. The company rents party equipment such as tents, tables, chairs, linens, and china for small occasions and large weddings. They also rent a variety of home improvement tools and contractor equipment including generators, grinders, power hammers, and drills. The company serves approximately 5,000 repeat customers and has more than 1,200 different inventory items for rent in stock. Lester’s purchases replacement stock from 45 different vendors. Each vendor supplies different items, but Lestor’s may purchase the same item from different vendors. Other business rules include (1) each inventory type has multiple quantities on hand (2) customers use their telephone numbers to uniquely identify themselves for rentals; (3) customers may rent more than one item of the same type.
Required
Create a normalized data model for Lester’s Rentals. Include the primary keys, data attributes, and foreign keys.
Trending nowThis is a popular solution!
Chapter 9 Solutions
Accounting Information Systems
- Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?arrow_forwardDURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardDURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forward
- DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardDURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardLakeesha Barnett owns and operates a package mailing store in a college town. Her store, Send It Packing, helps customers wrap items and send them via UPS, FedEx, and the USPS. Send It Packing also rents mailboxes to customers by the month. In May, purchases of materials (stamps, cardboard boxes, tape, Styrofoam peanuts, bubble wrap, etc.) equaled 11,450; the beginning inventory of materials was 1,050, and the ending inventory of materials was 950. Payments for direct labor during the month totaled 25,570. Overhead incurred was 18,130 (including rent, utilities, and insurance, as well as payments of 14,050 to UPS and FedEx for the delivery services sold). Since Send It Packing is a franchise, Lakeesha owes a monthly franchise fee of 5 percent of sales. She spent 2,750 on advertising during the month. Other administrative costs (including accounting and legal services and a trip to Dallas for training) amounted to 3,650 for the month. Revenues for May were 102,100. Required: 1. What was the cost of materials used for packaging and mailing services during May? 2. What was the prime cost for May? 3. What was the conversion cost for May? 4. What was the total cost of services for May? 5. Prepare an income statement for May. 6. Of the overhead incurred, is any of it direct? Indirect? Explain.arrow_forward
- Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next months sales are in the finished goods inventory. Ingles also purchases sufficient materials to ensure that materials inventory is 60 percent of the following months scheduled production. Ingless sales budget in units for the next quarter is as follows: Ingless ending inventories in units for July 31 are as follows: Required: 1. Calculate the number of tables to be produced during August. 2. Disregarding your response to Requirement 1, assume the required production units for August and September are 2,100 and 1,900, respectively, and the July 31 materials inventory is 4,000 units. Compute the number of table legs to be purchased in August. 3. Assume that Ingles Corporation will produce 2,340 units in September. How many employees will be required for the Assembly Department in September? (Fractional employees are acceptable since employees can be hired on a part-time basis. Assume a 40-hour week and a 4-week month.) (CMA adapted)arrow_forwardJW Office Supplies, Inc., is a wholesale distributor of office supplies. It sells pencils and pens, paper goods (including computer paper and forms), staplers, calendars, and other items, excluding furniture and other major items such as copy machines that you would expect to find in an office. Sales have been growing at 5 percent per year during the past several years. Mr. Kay, the president of JW Office Supplies, recently attended a national office supplies convention. In conversations during that convention, he discovered that sales for ABC Office Supplies competitors have been growing at 15 percent per year. Arriving back home, he did a quick investigation and discovered the following: JW Office Supplies customer turnover is significantly higher than the industry average. JW Office Supplies vendor turnover is significantly lower than the industry average. The new market analysis system was supposed to be ready two years ago but has been delayed for more than one year in systems development. A staff position, reporting to the president, for a person to prepare and analyze cash budgets was created two years ago but has never been filled. Mr. Kay has called on you to conduct a systems survey of this situation. You are to assume that a request for systems development has been prepared and approved. The information system at JW Office Supplies is much like that depicted in Chapters 10 through 16. Make and describe all assumptions that you believe are necessary to solve any of the following: a. What are the specific tasks of this systems survey? b. Indicate specific quantifiable benefits and costs that should be examined in assessing the economic feasibility of any solutions that might be proposed. Explain how you would go about quantifying each benefit or cost. c. Propose and explain three different scopes for the systems analysis. Use a context diagram to describe each scope alternative. Hint: What subsystems might be involved in an analysis?arrow_forwardPosavek is a wholesale supplier of building supplies building contractors, hardware stores, and home-improvement centers in the Boston metropolitan area. Over the years, Posavek has expanded its operations to serve customers across the nation and now employs over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently, Posavek has experienced fierce competition from the large online discount stores. In addition, the company is suffering from operational inefficiencies related to its archaic information system. Posavek revenue cycle procedures are described in the following paragraphs. Revenue Cycle Posaveks sales department representatives receive orders via traditional mail, e-mail, telephone, and the occasional walk-in customer. Because Posavek is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customers order into the centralized computer sales order system. The computer and file server are housed in Posaveks small data processing department. If the customer has done business with Posavek in the past, his or her data are already on file. If the customer is a first-time buyer, however, the clerk creates a new record in the customer account file. The system then creates a record of the transaction in the open sales order file. When the order is entered, an electronic copy of it is sent to the customers e-mail address as confirmation. A clerk in the warehouse department periodically reviews the open sales order file from a terminal and prints two copies of a stock release document for each new sale, which he uses to pick the items sold from the shelves. The warehouse clerk sends one copy of the stock release to the sales department and the second copy, along with the goods, to the shipping department. The warehouse clerk then updates the inventory subsidiary file to reflect the items and quantities shipped. Upon receipt of the stock release document, the sales clerk accesses the open sales order file from a terminal, closes the sales order, and files the stock release document in the sales department. The sales order system automatically posts these transactions to the sales, inventory control, and cost-of-goods-sold accounts in the general ledger file. Upon receipt of the goods and the stock release, the shipping department clerk prepares the goods for shipment to the customer. The clerk prepares three copies of the bill of lading. Two of these go with the goods to the carrier and the third, along with the stock release document, is filed in the shipping department. The billing department clerk reviews the closed sales orders from a terminal and prepares two copies of the sales invoice. One copy is mailed to the customer, and the other is filed in the billing department. The clerk then creates a new record in the accounts receivable subsidiary file. The sales order system automatically updates the accounts receivable control account in the general ledger file. CASH RECEIPTS PROCEDURES Mail room clerks open customer cash receipts, reviews the check and remittance advices for completeness, and prepares two copies of a remittance list. One copy is sent with the checks to the cash receipts department. The second copy of the remittance advices are sent to the billing department. When the cash receipts clerk receives the checks and remittance list, he verifies the checks received against those on the remittance list and signs the checks For Deposit Only. Once the checks are endorsed, he records the receipts in the cash receipts journal from his terminal. The clerk then fills out a deposit slip and deposits the checks in the bank. Upon receipt of the remittances, the billing department clerk records the amounts in the accounts receivable subsidiary ledger from the department terminal. The system automatically updates the AR control account in the general ledger Posavek has hired your public accounting firm to review its sales order procedures for internal control compliance and to make recommendations for changes. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.arrow_forward
- *Merriweather Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Merriweather, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 20 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40% of next month's sales are in the finished goods inventory. Merriweather also purchases sufficient raw materials (legs) to ensure that raw materials (legs) inventory is 60% of the following month's scheduled production needs. Merriweather's sales budget in units for the next quarter is as follows: (CMA adapted) July 2,500 August 2,700 September 2,300 Merriweather's ending inventories in units for June 30 are: Finished goods 2,100 Raw materials (legs) 4,200 Assume the required production for August and…arrow_forwardIngles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month’s sales are in the finished goods inventory. Ingles also purchases sufficient materials to ensure that materials inventory is 60 percent of the following month’s scheduled production. Ingles’s sales budget inunits for the next quarter is as follows: July 2,450August 2,900September 2,100Ingles’s ending inventories in units for July 31 are as follows:Finished goods 1,900Materials (legs) 4,000 Required:1. Calculate the number of tables to be produced during August. 2. Disregarding your response to Requirement 1, assume the required…arrow_forwardSunrise Tours, a company owned by David Bartlett that sells motor coach tours to schools and other groups. Sunshine Tours owns a fleet of 10 motor coaches and employs 12 drivers, 1 maintenance technician, 3 sales representatives, and an office manager. Sunshine Tours pays for all fuel and maintenance on the coaches. Drivers are paid $0.50 per mile while in transit, plus $15 per hour while idle (time spent waiting while tour groups are visiting their destinations). The maintenance technician and office manager are both full-time salaried employees. The sales representatives work on straight commission. Q.Regular preventive maintenance of the motor coaches has been proven to improve fuel efficiency and reduce overall operating costs by averting costly repairs. During busy months, however, it is difficult for the maintenance technician to complete all of the maintenance tasks within his 40-hour workweek.arrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub