POSAVEK REMODELING AND BUILDING SUPPLY COMPANY (CENTRALIZED SMALL BUSINESS ACCOUNTING SYSTEM)
Posavek is a wholesale supplier of building supplies to 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’s expenditure cycle procedures are described in the following paragraphs.
Expenditure Cycle
Posavek uses a centralized
Purchasing
The process begins in the purchasing department. Each morning the purchasing agent reviews the inventory levels from his department terminal and searches for items that have fallen to their reorder points and need to be replenished. The purchasing agent then selects the vendors and creates digital purchase orders in the purchase order file. He then prints two hard copies of each purchase order and sends them to the respective vendors.
Receiving
When the items are received, the receiving department clerk reconciles the goods with the attached packing slip and the digital purchase order, which he accesses from his computer terminal. The clerk then creates a digital receiving report, stating the condition of the materials received. The system automatically closes the purchase order previously created by the purchasing agent. In addition, the receiving clerk prints a hard copy of the receiving report, which he sends with the inventory to the warehouse where the items are stored.
Warehouse
Upon receipt of the inventory, the warehouse cleric reconciles the items with the receiving report and updates the inventory subsidiary ledger. The accounting system automatically and immediately updates the inventory control account in the general ledger.
Accounts Payable
Once the AP clerk receives the vendor’s invoice, she reconciles it with the purchase order and receiving report from her terminal. The clerk then creates a digital vendor invoice record and sets a due date for payment. The system automatically updates the AP control account in the general ledger. Daily, the AP clerk reviews the open vendor invoice records from her terminal, looking for items that need to be paid. The clerk then records the payment in the digital check register and closes the open vendor invoice. Finally, the clerk prints a hard copy of the check and sends it to the vendor. The system automatically updates the AP and cash GL accounts.
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 5 Solutions
Accounting Information Systems
- 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 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_forwardIdentify the type of responsibility center (revenue center, cost center, profit center, or investment center) for each of the following situations. A. the legal department for Avon Manufacturing B. the Macys store in Mansfield, Ohio C. the food and beverage division of the Best Western D. the marketing department of the Hershey Company E. the Walmart #5030 on Central Avenue in Toledo, Ohio F. Apples Braeburn Capital Inc., where most of Apples billions of dollars are invested G. Zappos department store H. the mens clothing department in the Walmart #5030 in Toledo, Ohioarrow_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_forwardRead the case below and answer the questions following it. DURAPLAST Company Ltd., opened its doors in 1979 as awholesale 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 andpart-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in.…arrow_forwardRead the case below and answer the questions following it. DURAPLAST Company Ltd., opened its doors in 1979 as awholesale 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 andpart-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in.…arrow_forward
- Read the case below and answer the questions following it. 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 theiroperations 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.…arrow_forwardRead the case below and answer the questions following it. 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 theiroperations 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.…arrow_forwardCamila’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is measured each month. The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the past. For the month of May, the district…arrow_forward
- Cathy’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is mea-sured each month.The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the…arrow_forwardThe A-to-Z Office Supply Company Christine Yamaguchi is the manager of the A-to-Z Office Supply Company in Charlotte. The company attempts to gain an advantage over its competitors by providing quality customer service, which includes prompt delivery of orders by truck or van and always being able to meet customer demand from its stock. To achieve this degree of customer service, A-to-Z must stock a large volume of items on a daily basis at a central warehouse and at three retail stores in the city and suburbs. Christine maintains these inventory levels by borrowing cash on a daily basis from the First Piedmont Bank. She estimates that for the coming fiscal year, the company’s demand for cash to pay for inventory will be $17,000 per day for 305 working days. Any money she borrows during the year must be repaid with interest by the end of the year. The annual interest rate currently charged by the bank is 9%. Any time Christine takes out a loan to purchase inventory, the bank charges…arrow_forwardCranshaw Business Services (CBS) operates an information technology (IT) consulting firm out of two offices: Detroit and Los Angeles. Corporate services, such as legal, finance, and personnel, are centralized at the main office and the costs of these services are allocated to the two offices for the purposes of profitability assessment. The Detroit office is the original unit of the company and is well established, having long-time clients from the automotive and other manufacturing industries. The Los Angeles office is new with a smaller, much more varied, clientele. The costs of personnel services at CBS are currently allocated on the basis of the number of employees in each office. The annual costs of the personnel department total $350,000. Data for the fiscal year just ended show the following: Detroit Los Angeles Number of employees 380 120 Number of new hires 7 20 Number of employees departing 3 10 Exercise 9-31 (Static) Unitwide versus Department…arrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub