Concept explainers
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 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 DURAPLAST’s small data processing department. If the customer has done business with DURAPLAST 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 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
DURAPLAST has hired you to review its sales order procedures for internal control compliance and to make recommendations for changes.
You are required to:
- Create a data flow diagram of the current system.
- Create a system flowchart of the existing system.
- Analyze the internal control weaknesses in the system.
- 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!
Step by stepSolved in 4 steps with 2 images
- Lamothe Kitchen and Bath makes products for the home, which it sells through major retailers and remodeling (do-it-yourself, or DIY) outlets. One product that has had varying success is a ceiling fan for the kitchen. The fan comes in three sizes (36-Inch, 44-Inch, and 54-Inch), which are designed for various kitchen sizes and cooling requirements. The chief financial officer (CFO) at Lamothe has been looking at the segmented income statement for the fan and is concerned about the results for the 36-inch model. Revenues Variable costs Fixed costs allocated to products Operating profit (loss) 36 Inch $ 376,000 233,600 149, 230 $ (6,830) 44 Inch $ 578,600 287,680 227,464 $ 63,456 54 Inch $ 356,400 165,500 140, 806 $ 50,094 If the 36-Inch model is dropped, the revenue associated with it would be lost and the related variable costs saved. In addition, the company's total fixed costs would be reduced by 25 percent. Required: a. Prepare a differential cost schedule to support your…arrow_forwardWatko Entertainment Systems (WES) buys audio and video components for assembling home entertainment systems from two suppliers, Bacon Electronics and Hessel Audio and Video. The components are delivered in cartons. If the cartons are delivered late, the installation for the customer is delayed. Delayed installations lead to contractual penalties that call for WES to reimburse a portion of the purchase price to the customer. During the past quarter, the purchasing and delivery data for the two suppliers showed the following: Bacon 5,000 $ 192 40 30% Bacon Hessel Hessel 3,000 $ 208 Total purchases (cartons) Average purchase price (per carton) Number of deliveries Percentage of cartons delivered late. The Accounting Department recorded $265,200 as the cost of late deliveries to customers. Effective Cost Per Carton Total 8,000 $ 198 20 15% Required: Assume that the average quality, measured by the percentage of late deliveries, and prices from the two companies will continue as in the…arrow_forwardLamothe Kitchen and Bath makes products for the home, which it sells through major retailers and remodeling (do-it-yourself, or DIY) outlets. One product that has had varying success is a ceiling fan for the kitchen. The fan comes in three sizes (36-Inch, 44-Inch, and 54-Inch), which are designed for various kitchen sizes and cooling requirements. The chief financial officer (CFO) at Lamothe has been looking at the segmented income statement for the fan and is concerned about the results for the 36-inch model. Revenues Variable costs Fixed costs allocated to products Operating profit (loss) 36 Inch $ 372,200 231,600 147,230 $ (6,630) If the 36-Inch model is dropped, the revenue associated with it would be lost and the related variable costs saved. In addition, the company's total fixed costs would be reduced by 25 percent. Required A Required B Required: a. Prepare a differential cost schedule to support your recommendation. b. Should Lamothe Kitchen and Bath should drop the 36-Inch…arrow_forward
- Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products - they manage relationships with the bicycle shops to enable them to better meet consumers' needs. The company's sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 450 bicycle shops. To do so, however, the company would have to hire more salespeople. Each salesperson earns $30,000 plus 3 percent commission on all sales annually. Another alternative is to use the services of sales agents instead of its own sales force. Sales agents would be paid 6 percent of sales. Each sales call lasts approximately 3 hours, and each sales rep has approximately 675 hours per year to devote to customers. Wheels needs 6 salespeople if it has 450 bicycle shop accounts that need to be called…arrow_forwardSuppose that Stillwater Designs has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors are buying the same product. Stillwater Designs provides the following information about customer-related activities and costs for the most recent quarter: JITDistributors Non-JITDistributors Sales orders 1,000 100 Sales calls 70 70 Service calls 350 175 Average order size 650 6,500 Manufacturing cost/unit $125 $125 Customer costs: Processing sales orders $3,380,000 Selling goods 1,120,000 Servicing goods 1,050,000 Total $5,550,000 Required: 1. Calculate the total revenues per distributor category, and assign the customer costs to each distributor type by using revenues as the allocation base. Selling price for one unit is $150. Round calculations to the nearest dollar. JIT…arrow_forwardStark and Company is a manufacturer that sells robots predominantly in the Asian market. Times have been tough for the auto industry and Stark and Company is no different. The company is under tremendous pressure to turn a profit. Several years ago, as analysts were predicting a large downturn in the robot industry, Stark decided to purchase a smaller niche robot maker in the hopes of capturing a different segment of the consumer market and to better learn the manufacturing processes of other robot makers. Starks still operates as two separate divisions, Classic and New Age, with each division manager employing a different manufacturing philosophy. The Classic manager is concerned with low input costs and quantity in production in addition to brand recognition and robot power. The New Age manager is concerned with quality and innovation in manufacturing, fuel-efficient and environmentally friendly robots. SAC continued to suffer losses even with the addition of the New Age division.…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education