LAWN WIZARD INC. (MANUAL SYSTEM WITH STAND-ALONE PC SUPPORT)
Law Wizard Inc. (LWI) is a manufacturer of a range of walk-behind gasoline lawnmowers, which it markets to garden centers and home improvement centers.
LWI employs a batch production process whose inventory management, production planning, and accounting procedures consist of a combination of manual activities supported by stand-alone (non-networked) PC technology. The company is experiencing production delays and cost overruns. Its CEO has hired your firm to review its procedures and make recommendations for improving its operations.
The batch production process is initiated by receipt of individual customer orders, which are grouped together in batches for manufacturing. The production planning and control clerk enters the orders into the digital production schedule from his department PC and prints two hard-copy work orders. He sends one of these to cost accounting and the other to the production department.
The production department supervisor enters the work order into a PC application. The system automatically creates an open work order record and prints the hard-copy move tickets and materials requisitions.
The supervisor distributes the move tickets and two copies of the purchase requisitions to each work center invoked in the production process. Work center employees exchange the material requisitions for assembly parts and other materials needed to complete the batch. If additional parts or materials are needed beyond the standard quantity, the supervisor issues additional material requisitions. As the production is completed in each work center, employees record their labor time for each batch on hard-copy job cards, which they send to cost accounting along with the move ticket. Finally, upon completion of the batch, the supervisor closes the open work order file.
The storekeeping clerk files one copy of the material requisition in the department and updates the raw materials inventory file from the computer in his office. The manager then sends the second copy of the material requisition to cost accounting. At the end of the day, the manager prepares a hard-copy journal voucher and sends it to the general ledger department.
The cost
The general ledger clerk receives the journal vouchers, posts to the appropriate GL accounts, and files the journal vouchers in the department.
Required
- a. Create a system flowchart of the existing system.
- b. What risks exist in the system as it is currently designed?
- c. Describe the changes needed to reduce the risks.
Trending nowThis is a popular solution!
Chapter 7 Solutions
Accounting Information Systems
- Maglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,334,000 based on production of 320,000 handheld consoles and 113,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $ 1,285,500 $ 382,000 $ 1,667,500 Materials 800,000…arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,237,000 based on production of 290,000 handheld consoles and 100,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $ 1,135,250 $ 411,000 $ 1,546,250 Materials 700,000 671,000 1,371,000…arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,125,000 based on production of 310,000 handheld consoles and 110,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $ 1,022,250 $ 384,000 $ 1,406,250 Materials 700,000 712,000 1,412,000…arrow_forward
- Maglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to Investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1.337,000 based on production of 310,.000 handheld consoles and 95,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home $409,000 696,000 Total $1,671,250 1,476,000 Direct labor $1,262,250 780,000 Materials Management has determined that overhead costs are…arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,262,000 based on production of 320,000 handheld consoles and 114,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $1,192,500 $385,000 $1,577,500 Materials 780,000 711,000 1,491,000 Management has determined that…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_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,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_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,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 $2,145,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,451,400 1,038,000 Commercial $ 702,000 749,500 Total $ 2,153,400 1,787,500 Management has determined that overhead costs are caused by three cost drivers. These…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 $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_forwardAsia Aerials (AA) manufactures satellite dishes for receiving satellite television signals. AA supplies the major satellite TV companies that install standard satellite dishes for their customers. The company also manufactures and installs a small number of specialized satellite dishes to individuals or businesses with specific needs resulting from poor reception in their locations. The chief executive officer (CEO) wants to initiate a program of cost reduction at AA. His plan is to use activity-based management (ABM) to allocate costs more accurately and to identify non-value-adding activities. The first department to be analyzed is the customer care department, as it has been believed for some time that the current method of cost allocation is giving unrealistic results for the two product types. At present, the finance director (FD) absorbs the cost of customer care into the product cost on a per-unit basis using the data in table 1. He then tries to correct the problem of…arrow_forwardSouthward Company has implemented a JIT flexible manufacturing system. John Richins, controller of the company, has decided to reduce the accounting requirements given the expectation of lower inventories. For one thing, he has decided to treat direct labor cost as a part of overhead and to discontinue the detailed direct labor accounting of the past. The company has created two manufacturing cells, each capable of producing a family of products: the radiator cell and the water pump cell. The output of both cells is sold to a sister division and to customers who use the radiators and water pumps for repair activity. Product-level overhead costs outside the cells are assigned to each cell using appropriate drivers. Facility-level costs are allocated to each cell on the basis of square footage. The budgeted direct labor and overhead costs are as follows: Radiator Cell Water Pump Cell Direct labor costs $168,400 $108,410 Direct overhead 656,760 395,550 Product…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