Concept explainers
DISASTER RECOVERY PLAN
Hexagon is an online retailer of exotic foods including spices from around the world, canned sauces, and prepackaged breads such as tortillas and naan. The company does 100 percent of its business over the Internet to consumers and through private networks with retail trading partners. Recently, Hexagon moved its sales and business headquarters functions into a warehouse on the outskirts of San Francisco. Prior to the move, the company engaged the services of an architect to redesign the facility to be modern yet in keeping with the original character of the building. While remodeling the warehouse, the architects retained the wooden-shingled exterior and the exposed wooden beams throughout the interior. The data processing center, which contained the servers and networked terminals, was situated in a large open area with high ceilings and skylights. The center was made accessible to the rest of the staff to be consistent with the firm’s philosophy of removing barriers and encouraging a team approach to problem solving. Before occupying the new facility, city inspectors declared the building to be compliant with all relevant building codes.
In a recent compliance audit, Hexagon’s auditors advised the company’s management to develop a disaster recovery plan. Toward this end, the company entered into a mutual aid agreement with several other firms in the area that had similar technology systems. These firms all agreed verbally to provide emergency assistance to each other in the event of disasters or emergencies. In addition, Hexagon implemented a data backup system in which all files are copied daily to tapes and disks and each week the backup storage devices are taken to an offsite facility where they are secured.
The operator’s manual with instructions on how to restore the system is stored in the main data processing area along with a list of names and phone numbers of key IT professionals to contact in case of an emergency.
Required
- a. Describe the internal control weaknesses present at Hexagon.
- b. List the components that should be included in a disaster recovery plan for a company like Hexagon.
- c. What factors, other than those included in the plan itself, should a company consider when formulating a disaster recovery plan?
Trending nowThis is a popular solution!
Chapter 14 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_forwardBasuras Waste Disposal Company has a long-term contract with several large cities to collect garbage and trash from residential customers. To facilitate the collection, Basuras places a large plastic container with each household. Because of wear and tear, growth, and other factors, Basuras places about 200,000 new containers each year (about 20% of the total households). Several years ago, Basuras decided to manufacture its own containers as a cost-saving measure. A strategically located plant involved in this type of manufacturing was acquired. To help ensure cost efficiency, a standard cost system was installed in the plant. The following standards have been established for the products variable inputs: During the first week in January, Basuras had the following actual results: The purchasing agent located a new source of slightly higher-quality plastic, and this material was used during the first week in January. Also, a new manufacturing process was implemented on a trial basis. The new process required a slightly higher level of skilled labor. The higher- quality material has no effect on labor utilization. However, the new manufacturing process was expected to reduce materials usage by 0.25 pound per container. Required: 1. CONCEPTUAL CONNECTION Compute the materials price and usage variances. Assume that the 0.25 pound per container reduction of materials occurred as expected and that the remaining effects are all attributable to the higher-quality material. Would you recommend that the purchasing agent continue to buy this quality, or should the usual quality be purchased? Assume that the quality of the end product is not affected significantly. 2. CONCEPTUAL CONNECTION Compute the labor rate and efficiency variances. Assuming that the labor variances are attributable to the new manufacturing process, should it be continued or discontinued? In answering, consider the new processs materials reduction effect as well. Explain. 3. CONCEPTUAL CONNECTION Refer to Requirement 2. Suppose that the industrial engineer argued that the new process should not be evaluated after only one week. His reasoning was that it would take at least a week for the workers to become efficient with the new approach. Suppose that the production is the same the second week and that the actual labor hours were 9,000 and the labor cost was 99,000. Should the new process be adopted? Assume the variances are attributable to the new process. Assuming production of 6,000 units per week, what would be the projected annual savings? (Include the materials reduction effect.)arrow_forwardThe Cloud Burst Sprinkler Company of Benicia, California has been manufacturing and selling a water efficient sprinkler exclusively to Home Depot for the last two years. Although there is not a binding contract that gives Home Depot exclusive rights to buy and stock the sprinkler in their network of locations, Cloud Burst has placed a great deal of importance on keeping Home Depot locations across the country and Canada fully stocked with their water efficient sprinkler. ACE Hardware has approached Cloudburst indicating they would like to stock the water efficient sprinkler in their 2,350 stores west of the Mississippi. The initial proposal submitted by ACE is to purchase 56,400 sprinklers which will result in two dozen sprinklers stocked in each store. The proposal received from ACE will NOT affect fixed costs, however, ACE has requested a special onetime quantity wholesale discount price of $5.25 per sprinkler Cloud Burst Sprinkler Company achieved the following operating results…arrow_forward
- your employer is a large local softdrink manufacturer that has started looking into importing cans, as local can manufacturers have had major service issues over the last 12 months. put forward a proposal to your board of directors discussing a proposed import processarrow_forwardComm Devices (CD) is a division of Worldwide Communications, Inc. CD produces restaurant pagers and other personal communication devices. These devices are sold to other Worldwide divisions, as well as to other communication companies. CD was recently approached by the manager of the Personal Communications Division regarding a request to make a special emergency- response pager designed to receive signals from anywhere in the world. The Personal Communications Division has requested that CD produce 12,000 units of this special pager. The following facts are available regarding the Comm Devices Division. Selling price of standard pager Variable cost of standard pager Additional variable cost of special pager For each of the following independent situations, calculate the minimum transfer price, and determine whether the Personal Communications Division should accept or reject the offer. (a) The Personal Communications Division has offered to pay the CD Division $105 per pager. The CD…arrow_forwardWanKea Berhad is the biggest retailer of ofice stationeries in Malaysia. The company buys the stationeries from several major suppliers and sells to walk-in customers as well as over 500 business customers. In line with its business expansion and digitalisation, WanKea Berhad plans to upgrade its Information Systems Department and to integrate new IT equipment and software into its business process. As a result of this modernisation exercise.WanKea Berhad will reduce its employees from 587 to 73 staf. Those will be affected are mainly clerks and junior managers.The modernisation exercises will include the integration of computer-based cash registers directly with account receivable, sales. perpetual inventory records and sales commission expenses. The total amount of the sales.including sales tax. is automatically computed by the systems and displayed on cash register's screen. The only printed information for cash sales is the cash register receipt. which is given to walk-in…arrow_forward
- Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows: Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. Graphical and numerical summaries for the length of time the shopper spends on the web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week? Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser? Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings.arrow_forwardChilton Peripherals manufactures printers, scanners, and other computer peripheral equipment. In the past, thecompany purchased equipment used in manufacturing from an outside vendor. In March 2018, Chilton decidedto design and build equipment to replace some obsolete equipment. A section of the manufacturing plant was setaside to develop and produce the equipment. Additional personnel were hired for the project. The equipment wascompleted and ready for use in September.Required:1. In general, what costs should be capitalized for a self-constructed asset?2. Discuss two alternatives for the inclusion of overhead costs in the cost of the equipment constructed by Chilton. Which alternative is generally accepted for financial reporting purposes?3. Under what circumstance(s) would interest be included in the cost of the equipment?arrow_forwardAs a recent hire of B-Well, your job is to evaluate whether the company should open a traditional grocery store in Astoria or start online shopping option instead. Before deciding which project to undertake, the Board of Directors has already agreed that they will hire a consultant to verify their decision. The consultant is charging $16, 580 total. They have also agreed that they will hire an NYC marketing agency to promote B-Well's reputation. They are not sure what the charge will be for the marketing services. For now, they just have to decide which project they will undertake. Brick & Mortar Store. B-Well Health Mart has to rent and renovate a space in Astoria. The estimates for the up-front renovation costs range from $2,250,000 to $2,650,000 to be depreciated over the life of the project using straight-line with a zero salvage value. There is a foreclosed warehouse in the area that their lenders are offering at a large discount since the lenders are losing money on it. The…arrow_forward
- Walmart (WMT) is robotic janitors in some of its stores. Walmart has purchased several Autonomous Cleaner (Auto-C) robots from Brain Corporation. An Auto-C robot looks like a Zamboni, the machine used to clean ice rinks. The robots scrub floors and clean store aisles, Sensors in the robots allow them to navigate around customers and other objects, so the robots can be used during store operating hours. her Management at Walmart has stated that the robots are to be used to free up employee time. Management reasons that if the robots do the repetitive taşks, employees will be better able to help shoppers and do other tasks. Management estimates that an employee at each store with the Auto- C robot would have spent two hours per day doing the cleaning that the Auto-C will perform. athe Walmart is also using Auto-S robots in its stores, which scan shelves in the stores to help keep track of inventory that is out of stock, mislabeled, or priced incorrectly. The Auto-S robots are three times…arrow_forwardKeep-U-Safe Systems (KSS) sells security solutions to large corporations. KSS offers electronic security systems for buildings (complete with cameras and keypad entry), perimeter security fencing (both physical and electronic) and offers an optional 24-hour security monitoring service. The solutions can be purchased individually, or as a package. The security systems and security fencing are sold as completed items (installation included). The security monitoring consists of two years of monitoring by KSS's call centre, who alert businesses in the event that an alarm is triggered, as well as dispatch emergency personnel if nobody can be reached. Each sales order is customized to the needs of the customer. On September 30, 2021, KSS sold a security solution that consisted of a building security system, fencing for a warehouse location, and the 24-hour security monitoring service. The solution was sold to Charleston Manufacturers for a price of $38,000, with payment due on…arrow_forwardHappyville, Inc., operates a chain of department stores located in the northwest. The first store began operations in 1965, and the company has steadily grown to its present size of 44 stores. Two years ago, the board of directors of Happyville approved a large-scale remodeling of its stores to attract a more upscale clientele.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 LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,