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 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.
Trending nowThis is a popular solution!
Chapter 4 Solutions
Accounting Information Systems
- Maxwell 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_forwardAt the beginning of the last quarter of 20x1, Youngston, Inc., a consumer products firm, hired Maria Carrillo to take over one of its divisions. The division manufactured small home appliances and was struggling to survive in a very competitive market. Maria immediately requested a projected income statement for 20x1. In response, the controller provided the following statement: After some investigation, Maria soon realized that the products being produced had a serious problem with quality. She once again requested a special study by the controllers office to supply a report on the level of quality costs. By the middle of November, Maria received the following report from the controller: Maria was surprised at the level of quality costs. They represented 30 percent of sales, which was certainly excessive. She knew that the division had to produce high-quality products to survive. The number of defective units produced needed to be reduced dramatically. Thus, Maria decided to pursue a quality-driven turnaround strategy. Revenue growth and cost reduction could both be achieved if quality could be improved. By growing revenues and decreasing costs, profitability could be increased. After meeting with the managers of production, marketing, purchasing, and human resources, Maria made the following decisions, effective immediately (end of November 20x1): a. More will be invested in employee training. Workers will be trained to detect quality problems and empowered to make improvements. Workers will be allowed a bonus of 10 percent of any cost savings produced by their suggested improvements. b. Two design engineers will be hired immediately, with expectations of hiring one or two more within a year. These engineers will be in charge of redesigning processes and products with the objective of improving quality. They will also be given the responsibility of working with selected suppliers to help improve the quality of their products and processes. Design engineers were considered a strategic necessity. c. Implement a new process: evaluation and selection of suppliers. This new process has the objective of selecting a group of suppliers that are willing and capable of providing nondefective components. d. Effective immediately, the division will begin inspecting purchased components. According to production, many of the quality problems are caused by defective components purchased from outside suppliers. Incoming inspection is viewed as a transitional activity. Once the division has developed a group of suppliers capable of delivering nondefective components, this activity will be eliminated. e. Within three years, the goal is to produce products with a defect rate less than 0.10 percent. By reducing the defect rate to this level, marketing is confident that market share will increase by at least 50 percent (as a consequence of increased customer satisfaction). Products with better quality will help establish an improved product image and reputation, allowing the division to capture new customers and increase market share. f. Accounting will be given the charge to install a quality information reporting system. Daily reports on operational quality data (e.g., percentage of defective units), weekly updates of trend graphs (posted throughout the division), and quarterly cost reports are the types of information required. g. To help direct the improvements in quality activities, kaizen costing is to be implemented. For example, for the year 20x1, a kaizen standard of 6 percent of the selling price per unit was set for rework costs, a 25 percent reduction from the current actual cost. To ensure that the quality improvements were directed and translated into concrete financial outcomes, Maria also began to implement a Balanced Scorecard for the division. By the end of 20x2, progress was being made. Sales had increased to 26,000,000, and the kaizen improvements were meeting or beating expectations. For example, rework costs had dropped to 1,500,000. At the end of 20x3, two years after the turnaround quality strategy was implemented, Maria received the following quality cost report: Maria also received an income statement for 20x3: Maria was pleased with the outcomes. Revenues had grown, and costs had been reduced by at least as much as she had projected for the two-year period. Growth next year should be even greater as she was beginning to observe a favorable effect from the higher-quality products. Also, further quality cost reductions should materialize as incoming inspections were showing much higher-quality purchased components. Required: 1. Identify the strategic objectives, classified by the Balanced Scorecard perspective. Next, suggest measures for each objective. 2. Using the results from Requirement 1, describe Marias strategy using a series of if-then statements. Next, prepare a strategy map. 3. Explain how you would evaluate the success of the quality-driven turnaround strategy. What additional information would you like to have for this evaluation? 4. Explain why Maria felt that the Balanced Scorecard would increase the likelihood that the turnaround strategy would actually produce good financial outcomes. 5. Advise Maria on how to encourage her employees to align their actions and behavior with the turnaround strategy.arrow_forwardPaul Golding and his wife, Nancy, established Crunchy Chips in 1938. Over the past 60 years, the company has established distribution channels in 11 western states, with production facilities in Utah, New Mexico, and Colorado. In 1980, Pauls son, Edward, took control of the business. By 2017, it was clear that the companys plants needed to gain better control over production costs to stay competitive. Edward hired a consultant to install a standard costing system. To help the consultant establish the necessary standards, Edward sent her the following memo: The manufacturing process for potato chips begins when the potatoes are placed into a large vat in which they are automatically washed. After washing, the potatoes flow directly to an automatic peeler. The peeled potatoes then pass by inspectors, who manually cut out deep eyes or other blemishes. After inspection, the potatoes are automatically sliced and dropped into the cooking oil. The frying process is closely monitored by an employee. After the chips are cooked, they pass under a salting device and then pass by more inspectors, who sort out the unacceptable finished chips (those that are discolored or too small). The chips then continue on the conveyor belt to a bagging machine that bags them in 1-pound bags. After bagging, the bags are placed in a box and shipped. The box holds 15 bags. The raw potato pieces (eyes and blemishes), peelings, and rejected finished chips are sold to animal feed producers for 0.16 per pound. The company uses this revenue to reduce the cost of potatoes. We would like this reflected in the price standard relating to potatoes. Crunchy Chips purchases high-quality potatoes at a cost of 0.245 per pound. Each potato averages 4.25 ounces. Under efficient operating conditions, it takes four potatoes to produce one 16-ounce bag of plain chips. Although we label bags as containing 16 ounces, we actually place 16.3 ounces in each bag. We plan to continue this policy to ensure customer satisfaction. In addition to potatoes, other raw materials are the cooking oil, salt, bags, and boxes. Cooking oil costs 0.04 per ounce, and we use 3.3 ounces of oil per bag of chips. The cost of salt is so small that we add it to overhead. Bags cost 0.11 each and boxes 0.52 each. Our plant produces 8.8 million bags of chips per year. A recent engineering study revealed that we would need the following direct labor hours to produce this quantity if our plant operates at peak efficiency: Im not sure that we can achieve the level of efficiency advocated by the study. In my opinion, the plant is operating efficiently for the level of output indicated if the hours allowed are about 10% higher. The hourly labor rates agreed upon with the union are: Overhead is applied on the basis of direct labor dollars. We have found that variable overhead averages about 116% of our direct labor cost. Our fixed overhead is budgeted at 1,135,216 for the coming year. Required: 1. Discuss the benefits of a standard costing system for Crunchy Chips. 2. Discuss the presidents concern about using the result of the engineering study to set the labor standards. What standard would you recommend? 3. Form a group with two or three other students. Develop a standard cost sheet for Crunchy Chips plain potato chips. Round all computations to four decimal places. 4. Suppose that the level of production was 8.8 million bags of potato chips for the year as planned. If 9.5 million pounds of potatoes were used, compute the materials usage variance for potatoes.arrow_forward
- Paterson Company, a U.S.-based company, manufactures and sells electronic components worldwide. Virtually all its manufacturing takes place in the United States. The company has marketing divisions throughout Europe, including France. Debbie Kishimoto, manager of this division, was hired from a competitor 3 years ago. Debbie, recently informed of a price increase in one of the major product lines, requested a meeting with Jeff Phillips, marketing vice president. Their conversation follows. Debbie: Jeff, I simply dont understand why the price of our main product has increased from 5.00 to 5.50 per unit. We negotiated an agreement earlier in the year with our manufacturing division in Philadelphia for a price of 5.00 for the entire year. I called the manager of that division. He said that the original price was still acceptablethat the increase was a directive from headquarters. Thats why I wanted to meet with you. I need some explanations. When I was hired, I was told that pricing decisions were made by the divisions. This directive interferes with this decentralized philosophy and will lower my divisions profits. Given current market conditions, there is no way we can pass on the cost increase. Profits for my division will drop at least 600,000 if this price is maintained. I think a midyear increase of this magnitude is unfair to my division. Jeff: Under normal operating conditions, headquarters would not interfere with divisional decisions. But as a company, we are having some problems. What you just told me is exactly why the price of your product has been increased. We want the profits of all our European marketing divisions to drop. Debbie: What do you mean that you want the profits to drop? That doesnt make any sense. Arent we in business to make money? Jeff: Debbie, what you lack is corporate perspective. We are in business to make money, and thats why we want European profits to decrease. Our U.S. divisions are not doing well this year. Projections show significant losses. At the same time, projections for European operations show good profitability. By increasing the cost of key products transferred to Europeto your division, for examplewe increase revenues and profits in the United States. By decreasing your profits, we avoid paying taxes in France. With losses on other U.S. operations to offset the corresponding increase in domestic profits, we avoid paying taxes in the United States as well. The net effect is a much-needed increase in our cash flow. Besides, you know how hard it is in some of these European countries to transfer out capital. This is a clean way of doing it. Debbie: Im not so sure that its clean. I cant imagine the tax laws permitting this type of scheme. There is another problem, too. You know that the companys bonus plans are tied to a divisions profits. This plan could cost all of the European managers a lot of money. Jeff: Debbie, you have no reason to worry about the effect on your bonusor on our evaluation of your performance. Corporate management has already taken steps to ensure no loss of compensation. The plan is to compute what income would have been if the old price had prevailed and base bonuses on that figure. Ill meet with the other divisional managers and explain the situation to them as well. Debbie: The bonus adjustment seems fair, although I wonder if the reasons for the drop in profits will be remembered in a couple of years when Im being considered for promotion. Anyway, I still have some strong ethical concerns about this. How does this scheme relate to the tax laws? Jeff: We will be in technical compliance with the tax laws. In the United States, Section 482 of the Internal Revenue Code governs this type of transaction. The key to this law, as well as most European laws, is evidence of an arms-length price. Since youre a distributor, we can use the resale price method to determine such a price. Essentially, the arms-length price for the transferred good is backed into by starting with the price at which you sell the product and then adjusting that price for the markup and other legitimate differences, such as tariffs and transportation. Debbie: If I were a French tax auditor, I would wonder why the markup dropped from last year to this year. Are we being good citizens and meeting the fiscal responsibilities imposed on us by each country in which we operate? Jeff: Well, a French tax auditor might wonder about the drop in markup. But, the markup is still within reason, and we can make a good argument for increased costs. In fact, weve already instructed the managers of our manufacturing divisions to legitimately reassign as many costs as they can to the European product lines. So far, they have been very successful. I think our records will support the increase that you are receiving. You really do not need to be concerned with the tax authorities. Our tax department assures me that this has been carefully researchedits unlikely that a tax audit will create any difficulties. Itll all be legal and above board. Weve done this several times in the past with total success. Required: 1. Do you think that the tax-minimization scheme described to Debbie Kishimoto is in harmony with the ethical behavior that should be displayed by top corporate executives? Why or why not? What would you do if you were Debbie? 2. Apparently, the tax department of Paterson Company has been strongly involved in developing the tax-minimization scheme. Assume that the accountants responsible for the decision are CMAs and members of the IMA, subject to the IMA standards of ethical conduct. Review the IMA standards for ethical conduct in Chapter 1. Are any of these standards being violated by the accountants in Patersons tax department? If so, identify them. What should these tax accountants do if requested to develop a questionable taxminimization scheme?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
- 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_forwardMaxwell 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_forwardWestern Boot Co. sells men’s, women’s, and children’s boots. For each type of boot sold, it operates a separate department that has its own manager. The manager of the men’s department has a sales staff of nine employees, the manager of the women’s department has six employees, and the manager of the children’s department has three employees. All departments are housed in a single store. In recent years, the children’s department has operated at a net loss and is expected to continue to do so. Last year’s income statements follow. *Before the paragraph it stated under check figures " a. Contribution to profit: $4,000"arrow_forward
- Grant's Western Wear is a retailer of western hats located in Atlanta, Georgia. Although Grant's carries numerous styles of western hats, each hat has approximately the same price and invoice purchase cost, as shown below. Sales personnel receive large commissions to encourage them to be more aggressive in their sales efforts. Currently the economy of Atlanta is really humming, and sales growth at Grant's has been great. However, the business is very competitive, and Grant has relied on its knowledgeable and courteous staff to attract and retain customers, who otherwise might go to other western wear stores. Also, because of the rapid growth in sales, Grant is finding it more difficult to manage certain aspects of the business, such as restocking of inventory and hiring and training new salespeople. Sales price $ 39.00 Per-unit variable costs: Invoice cost 18.75 Sales commissions 5.55 Total per-unit variable costs $ 24.30 Total annual fixed…arrow_forwardLasting Impressions (LI) Company is a medium-sized commercial printer of promotional advertising brochures, booklets, and other direct-mail pieces. The firm's major clients are ad agencies based in New York and Chicago. The typical job is characterized by high quality and production runs of more than 50,000 units. LI has not been able to compete effectively with larger printers because of its existing older, inefficient presses. The firm is currently having problems meeting run length requirements as well as meeting quality standards in a cost- effective manner.The general manager has proposed the purchase of one of two large, six-color presses designed for long, high-quality runs. The purchase of a new press would enable LI to reduce its cost of labor and therefore the price to the client, putting the firm in a more competitive position. The key financial characteristics of the old press and of the two proposed presses are summarized as follows: Old press Originally purchased 3 years…arrow_forwardMuscat Tubes Manufacturing LLC is a manufacturer of television picture tubes. The company must keep various types of materials on hand for the manufacturing process. The store manager is having difficulty keeping track of all the inventory. When compared to last year, the amount of material lost has increased, which is a source of concern for the store manager. He wishes to employ an effective tool for controlling material loss. While exploring, he came across the concept of ABC analysis, which is used by many MNCs around the world. Because he has no background in costing, he is unable to grasp the concept. He asked you to explain the following because you are the company's cost accounting executive: Working/Application of ABC analysis?arrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning