Rasmussen University Assessing Systems What Is the Current System and Recommended System Paper

User Generated

yvy_qrivy_69_692002

Business Finance

Rasmussen University

Description

BeGood Baking Supply is a small bakery supply company formed as a closely held corporation. The company supplies raw baking materials, paper goods, and equipment to restaurants and bakeries in three states in the upper mid-west. Most of its business, however, is located in a large metropolitan area. BeGood wants to increase its presence in the region and serve five states. In fact, the owners of BeGood would like 75% of their business to come from throughout the region rather than the current metropolitan area. In order to do this, the owners understand they must diversify offerings and lines of business.

Currently, BeGood has a phone center where customer orders are taken; these orders are then sent to shipping where the order is filled in its large warehouse and shipped within four days. BeGood outsources its shipping to a local trucking company. Once the order ships all paperwork goes to the accounting department where it is entered into the accounting system. BeGood still uses the same accounting system it has used since the inception of the company. All aging of receivables and other analysis is done using Excel spreadsheets. Purchasing and tracking of inventory are done solely by the warehouse manager. Invoices for inventory purchasing are sent to the accounting department when goods are received.

The owners at BeGood are wondering how they can utilize an online presence and further automate its systems in order to facilitate its growth and diversify its business. The owners may also like to expand into the retail business.

You have been hired as a full-time staff accountant at BeGood Baking Supply and have been given the task of evaluating and recommending a viable accounting information system for the accounting and financial data of BeGood in order to facilitate expansion and diversification. As you begin your research, you realize that many departments are involved in the information system, and communication is key.

BeGood has grown over the years but the AIS has not kept up with that growth, and you believe there may be some internal control issues. Since cost of goods sold is the largest expense of the company, you decide to take a look at inventory control, ordering and receiving first. You have an "uneasy feeling" about the warehouse supervisor, Harold. The Receiving department consists of three employees, including Harold. The two receiving employees unload vendor trucks and stock the goods received. If goods are shorted on an order or defective goods are received, it is brought to light when filling customer orders or when customers complain about product received. After receiving, employees unload trucks and restock goods. The vendor invoice is held in a folder on Harold's desk. Once per week, Harold takes the invoices to accounting for payment.

Requirements

As part of your analysis of the ordering and receiving process, prepare documentation of the following items and the research you find that would ultimately become part of a final presentation of a viable AIS system for management. NOTE: You will not be creating this presentation. These elements of research and documentation are part of the process that would lead up to that final presentation of information.

Documents Required:

  1. A system flowchart of the ordering and receiving process described above
  2. A chart listing the control weaknesses in the current system, along with the fraud that could occur with the weakness, and a solution to the weakness
  3. A system flowchart of a new recommended system addressing each of the control weaknesses identified in the chart

Unformatted Attachment Preview

Transactional Flowchart: Guidelines and Examples A Transactional Flowchart depicts all the activities in a process, from beginning to end. You can use a Transactional Flowchart to: • • • • Provide a pictorial representation of each activity in a process Show the sequence of tasks for each activity Show the flow of inputs and outputs for each task in a process Analyze the relationship of tasks involved in each activity This guide provides basic instructions for creating a transactional flowchart, and includes an example of an office supplies process and process map. Benefits Include: • • • Good tool to use for documenting processes/procedures Simple to prepare and update Most common type of flowchart Instructions for creating a transactional flowchart: 1. Arrange interviews or group discussions with people who work in the area analyzed. Find out exactly what each person does in the process: Ö What he/she receives; Ö What he/she does with what is received; and Ö What he/she sends on to the next person. 2. For a group setting, determine who will act as the facilitator and who will act as a recorder (drawing the flowchart). Ö An auditor should act as the facilitator. Ö The recorder could be any team member; however, an auditor would be would be the best choice. 3. Select the flowchart symbols you plan to use. (See Process Mapping Guidelines: Flowcharting). Ö Many facilitators use only boxes and diamonds to draw a flowchart; the decisions as to how many symbols to use will normally come down to individual preference. Ö If the auditee or client requests formal flowcharts as a deliverable, an approach using more precise flowchart symbols may be appropriate. 4. Create a flowchart. Ö Automated flowcharting products are good tools to use to create the flowchart. Ö The process should flow to the right, using arrows to connect the boxes which represent tasks, inputs, and outputs. Ö Start by placing the first activity on the left. 5. Use the following questions to analyze flowcharts and look for opportunities to streamline flows: Ö Does paper travel around excessively? Ö Is the process flow overly complicated? Ö Do too many people touch a particular document? Ö Are all reports actually used? Is all distribution necessary? Ö Is there any excessive or unnecessary filing or copying? Ö Are there a large number of decisions that need to be made throughout the process? 6. During the flowcharting process, try to gather the following information: Ö Where exceptions, bottlenecks, and delays occur in the process. Ö How often exceptions occur (twice a day, once a week). Ö Duration of any delays (minutes, hours, days). Ö For all decision diamonds, each "yes" or "no" arrow should have the percentage of time each arrow occurs (arrows should add up to 100%). Ö Number of people involved at each step of the process. Ö Volume of data (number of items processed in a day, week, or month). This information will help the team identify improvement opportunities. Office Supplies - Process Overview Following is a narrative example of a company's office supply ordering process, together with a process map illustrating the flowcharting techniques that can be used to capture this process. Office Supplies Process Narrative The customer service supply room at EC company provides office supplies for all departments within the company. Orders for supplies come from the different company departments within EC. They can either use the Office Supply Catalog to initiate an order or order directly from the supply room personnel. In either case, the supply room processes the P.O. The purchasing process for office supplies is handled primarily by the supply room personnel themselves. The process description and flowchart are limited to activities performed by the supply room, receiving, and the vendor. No attempt is made to discuss interfaces with accounts payable, vendor invoicing, or inventory adjustments. JNB, Inc. is the primary vendor for office supplies for the company. Orders are customarily delivered to EC company on JNB's trucks. Freight charges are deductible if paid within 30 days of invoice date. The EC company has been using Office Solutions as the primary vendor the past several years, although the contract is bid annually. Office Supplies Process Narratives Office Supplies The office supply function for the customer services supply room is responsible for providing office supplies for EC company personnel. Walk-up Request Low-value, high-usage items such as paper, pens, pencils, and post-it notes are stored behind the front counter for walk-up customers. These items are always kept full based on a visual inspection and are replenished as necessary when stock levels are low. Office Supply Orders Orders for supplies come from the different user departments. They can either use the Office Supply catalog to order, or order directly from the supply room personnel. Office supply orders are initiated by a 2-part Supply Requisition Form filled out by the user. The form includes the person ordering, charge #, quantity, part description, stock number, quantity issued, and item price. One copy is retained by the ordering department; the other copy is used to enter P.O. information into the JNB Order System. The supply room personnel log onto the system after entering their password. Orders are batched as received each day and transmitted to JNB via modem by 4:00 PM. JNB confirms receipt and notifies the supply room of any error transmissions so that they can be corrected and re-transmitted by the end of the day. Orders which cannot be transmitted are phoned or faxed to JNB. Orders are received, pulled, packaged, and delivered to the company the next day by JNB. Orders are delivered to EC's receiving dock 5 and brought to the supply room where they are put away in specific stock locations. The supply room personnel reconcile all deliveries received with purchase orders. Items received that were not ordered or over shipments, are sent back to the shipping dock and picked up by JNB the next day. JNB issues a credit voucher to the Office Supplies account. Delivered supplies are put away in specific supply room stocking locations. Physical Inventory Physical inventory is taken weekly and amounts are compared to the safety stock levels report to determine replenishment needs. Orders are initiated by office supply personnel to replenish inventory that has fallen below safety stock levels. Safety stock levels are compared to actual usage and updated twice a year. Office Supply Room Security Supply office hours are 6AM-9PM Mon-Thur, 6AM-7PM Fri, 7AM-5PM Sat-Sun. The office supply door is separately locked. One supervisor and 2 full-time staff have access to the stock room keys. The outside hall doors are locked after hours and monitored by security personnel. Vendor Pricing and Negotiation The vendor contract for office supplies is bid and re-negotiated yearly. Prices are set for a year in the vendor office supply catalog. Transactional Flowchart Example ASSESSING SYSTEMS 1 1. The flowchart of receiving orders In this flowchart, once a client placed an order, it is received at the phone center. After it is received, it is sent to the shipping where it is worked upon by the warehouse attendants. Once it is ready to be dispatched, it is shipped in four days, BeGood Company being in partnership with a trucking company, the goods are taken to the client’s premises. Current System The order took at the phone center Order sent to shipping Accounting system Paper work entered into the Accounting system Goods supplied Outsourced to a local trucking company Shipping in four days Invoices for inventory Accounting department ASSESSING SYSTEMS 2 2. The chart below contains the control weaknesses that were identified in the company, the fraud that have cause to the company's systems and their possible solution. It is evident that with this weaknesses performance of the company would go down and result in losses. However, with these weaknesses having been highlighted earlier, the risk of making losses and incurring excessive expense will be controlled. Control weakness The fraud that may occur Solution to the weakness Poor records Poor record leads to inaccurate data to the system thus giving a wrong data. Incorrect filling of invoices Once the invoice is wrongly filled, the error will be transferred to the entire system thus result in the wrong output. Once the warehouse workers are of doubt, then the work will not be done effectively and in whatever they do will be of no trust. This may cause the delay of the work or the work not done according, thus delivering goods with complications. And cash schemes. Ensure the records are updated correctly before being transferred to the accounting system The invoices should be correctly and carefully filled and overlooked to ascertain it is correct. Doubtful supervisors Assets misappropriation It is advisable to encourage the workers to be trustworthy with their work or else to that to face the consequence of their deeds. There must be a thorough checking of the receipts, check tamped cheque and bill schemes. ASSESSING SYSTEMS 3 3. The new system recommended address the challenges identified in the company includes swapping of the management of different departments and also recruitment of new staff and worker so that the operations in the entire company may run well and utilize the profit. This goes a long way as we're planning to expand our services and make the better for our former clients as well as the new ones. Also, in this new system, there will be few steps in delivering the goods to the cost of transportation as seen in the chart on the next page. ASSESSING SYSTEMS 4 Recommended System Order made through the order system using cedit card or ACH Complete purchase requisition procedure Submit Approved? No Amend order to fulfill requirements Submit verified purchase requisition form to accounting department Valid credit card? Send receipt to customer via e-mail Transaction started in order system No Funds available method Transaction made through order system Transaction updated in ledger Shipping made Enter new payment Submit order and ensure quality assurance Reconciliation of entries done on monthly basis Accounts receivable Tracking inventory This is a great first effort! Practical Flowcharting_for_Auditors.docx Flowchart Example.pdf There are issues with the symbols and the "flow" of the process. For instance, the flowchart shows that a "paperwork" was entered into the "accounting system". There are specific symbols that show "documents" and "data entry", and "computer disks". Also, there are special symbols to show the beginning of a process. file cabinets, decision making. ending a process, etc.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello, find attached. i have worked on the flowcharts only. check them and let me know if you would prefer more editing. goodbye.

Running head: ASSESSING SYSTEMS

1

Assessing Systems

Name:
Institution:
Date

2

ASSESSING SYSTEMS
Assessing Systems
1. Current System
In the current flowchart, the client places an order through a phone call to the
phone center. The warehouse attendants work on the order at the shipping. In four days,
the order is shipped, and then a shipped company is contracted to deliver the order to the
clients.

The order is made at
the phone centre

Order sent to
shipping
Document
Accounting
system

Goods Supplied

Outsourced to a
local trucking
company

Shipping in four
days

Invoices for
Inventory...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags