Posavek 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
Posavek’s 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 customer’s order into the centralized computer sales order system. The computer and file server are housed in Posavek’s 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 customer’s 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
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
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.
Trending nowThis is a popular solution!
Chapter 4 Solutions
Accounting Information Systems
- Exeter Group is a large retail company that has brick-and-mortar outlets throughout the Southeast. They have been in business for many years, but two years ago started an online sales channel to offset slowing in-store sales. The human resources (HR) department at Exeter handles tasks for the two divisions that make up Exeter: Retail and Online. Retail Division manages the company's traditional business line. This business, although still profitable, is currently not growing and may be shrinking slightly. Online Division, on the other hand, has experienced double-digit growth from the beginning. The cost allocation system at Exeter allocates all corporate costs to the divisions based on a variety of cost allocation bases. HR costs are allocated based on the average number of employees in the two divisions. There are two basic activities in the HR Department. The first is employee maintenance (payroll administration, benefits, and so on), which is an ongoing activity and requires the…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
- Mercury, Incorporated, produces cell phones at its plant in Texas. In recent years, the company's market share has been eroded by stiff competition from overseas. Price and product quality are the two key areas in which companies compete in this market. A year ago, the company's cell phones had been ranked low in product quality in a consumer survey. Shocked by this result, Jorge Gomez, Mercury's president, initiated an intense effort to improve product quality. Gomez set up a task force to implement a formal quality improvement program. Included on this task force were representatives from the Engineering, Marketing, Customer Service, Production, and Accounting departments. The broad representation was needed because Gomez believed that this was a companywide program and that all employees should share the responsibility for its success. After the first meeting of the task force, Holly Elsoe, manager of the Marketing Department, asked John Tran, production manager, what he thought of…arrow_forwardMaxwell Company produces a variety of kitchen appliances, including cooking ranges and dishwashers. Over the past several years, competition has intensified. In order to maintainand perhaps increaseits market share, Maxwells management decided that the overall quality of its products had to be increased. Furthermore, costs needed to be reduced so that the selling prices of its products could be reduced. After some investigation, Maxwell concluded that many of its problems could be traced to the unreliability of the parts that were purchased from outside suppliers. Many of these components failed to work as intended, causing performance problems. Over the years, the company had increased its inspection activity of the final products. If a problem could be detected internally, then it was usually possible to rework the appliance so that the desired performance was achieved. Management also had increased its warranty coverage; warranty work had been increasing over the years. David Haight, president of Maxwell Company, called a meeting with his executive committee. Lee Linsenmeyer, chief engineer; Kit Applegate, controller; and Jeannie Mitchell, purchasing manager, were all in attendance. How to improve the companys competitive position was the meetings topic. The conversation of the meeting was recorded as seen on the following page: DAVID: We need to find a way to improve the quality of our products and at the same time reduce costs. Lee, you said that you have done some research in this area. Would you share your findings? LEE: As you know, a major source of our quality problems relates to the poor quality of the parts we acquire from the outside. We have a lot of different parts, and this adds to the complexity of the problem. What I thought would be helpful would be to redesign our products so that they can use as many interchangeable parts as possible. This will cut down the number of different parts, make it easier to inspect, and cheaper to repair when it comes to warranty work. My engineering staff has already come up with some new designs that will do this for us. JEANNIE: I like this idea. It will simplify the purchasing activity significantly. With fewer parts, I can envision some significant savings for my area. Lee has shown me the designs so I know exactly what parts would be needed. I also have a suggestion. We need to embark on a supplier evaluation program. We have too many suppliers. By reducing the number of different parts, we will need fewer suppliers. And we really dont need to use all the suppliers that produce the parts demanded by the new designs. We should pick suppliers that will work with us and provide the quality of parts that we need. I have done some preliminary research and have identified five suppliers that seem willing to work with us and assure us of the quality we need. Lee may need to send some of his engineers into their plants to make sure that they can do what they are claiming. DAVID: This sounds promising. Kit, can you look over the proposals and their estimates and give us some idea if this approach will save us any money? And if so, how much can we expect to save? KIT: Actually, I am ahead of the game here. Lee and Jeannie have both been in contact with me and have provided me with some estimates on how these actions would affect different activities. I have prepared a handout that includes an activity table revealing what I think are the key activities affected. I have also assembled some tentative information about activity costs. The table gives the current demand and the expected demand after the changes are implemented. With this information, we should be able to assess the expected cost savings. Additionally, the following activity cost data are provided: Purchasing parts: Variable activity cost: 30 per part number; 20 salaried clerks, each earning a 45,000 annual salary. Each clerk is capable of processing orders associated with 100 part numbers. Inspecting parts: Twenty-five inspectors, each earning a salary of 40,000 per year. Each inspector is capable of 2,000 hours of inspection. Reworking products: Variable activity cost: 25 per unit reworked (labor and parts). Warranty: Twenty repair agents, each paid a salary of 35,000 per year. Each repair agent is capable of repairing 500 units per year. Variable activity costs: 15 per product repaired. Required: 1. Compute the total savings possible as reflected by Kits handout. Assume that resource spending is reduced where possible. 2. Explain how redesign and supplier evaluation are linked to the savings computed in Requirement 1. Discuss the importance of recognizing and exploiting internal and external linkages. 3. Identify the organizational and operational activities involved in the strategy being considered by Maxwell Company. What is the relationship between organizational and operational activities?arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $2,037,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Personal Commercial Total Direct materials $ 1,445,000 $ 620,000 $ 2,065,000 Direct labor 1,030,000 667,500 1,697,500 Management has determined that overhead costs are caused by three cost…arrow_forward
- Asbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $2,023,500 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Personal Commercial Total Direct materials $ 1,444,200 $ 609,750 $ 2,053,950 Direct labor 1,029,000 657,250 1,686,250 Management has determined that overhead costs are caused by three cost…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $1,902,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Personal $ 1,437,000 1,020,000 Commercial $ 517,500 565,000 Total $ 1,954,500 1,585,000 Management has determined that overhead costs are caused by three cost drivers. These…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders. Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $1,929,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Cost Driver Number of production runs Quality tests performed Shipping orders processed Total overhead Management has determined that overhead costs are caused by three cost…arrow_forward
- Maxwell Company produces a variety of kitchen appliances, including cooking ranges and dishwashers. Over the past several years, competition has intensified. In order to maintain—and perhaps increase—its market share, Maxwell’s management decided that the overall quality of its products had to be increased. Furthermore, costs needed to be reduced so that the selling prices of its products could be reduced. After some investigation, Maxwell concluded that many of its problems could be traced to the unreliability of the parts that were purchased from outside suppliers. Many of these components failed to work as intended, causing performance problems. Over the years, the company had increased its inspection activity of the final products. If a problem could be detected internally, then it was usually possible to rework the appliance so that the desired performance was achieved. Management also had increased its warranty coverage; warranty work had been increasing over the years. DAVID…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the Introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE belleves that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which Is representative, manufacturing overhead totaled $2,091,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Personal $ 1,448,200 1,034,000 Commercial $ 661,000 708,500 Total $ 2,109,200 1,742,500 Management has determined that overhead costs are caused by three cost drivers. These…arrow_forwardBetty’s Fashions operates retail stores in both downtown and suburban locations. The company has two responsibility centers: the City Division, which contains stores in downtown locations, and the Mall Division, which contains stores in suburban locations. Betty’s CEO is concerned about the profitability of the City Division, which has been operating at a loss for the last several years. The most recent City Division income statement follows. The CEO has asked for your advice on shutting down the City Division’s operations. If the City Division is eliminated, corporate administration is not expected to change, nor are any other changes expected in the operations or costs of the Mall Division.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