Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As an auditor and systems data flow specialist, you interviewed McCloud client personnel and gathered the following information about the client. McCloud Company produces and

As an auditor and systems data flow specialist, you interviewed McCloud client personnel and gathered the following information about the client. McCloud Company produces and sells fleece-lined suede leather jackets. Have been in business for almost 40 years. McCloud Companys products are well-known for their durability and no-nonsense fashion consciousness. Strictly an online order business, the company handles sales orders exclusively through a company website over the Internet. There is currently no complete set of formal documentation of the processing of sales orders and shipping of goods. The procedures related to these processes, as reported to you, are as follows: McCloud Companys customers enter their order information via the Internet. Orders are automatically recorded in a sales order transaction file by McClouds Sales Module (SD) of the ERP system. The Sales Module automatically generates and sends an email of the sales order to the customer. A sales order is also automatically generated by the system and a hard copy is printed out in the customer service department. A customer service clerk files this copy by customer name and then by date in an open sales order file. The SD/ERP system uses sales data from table [which table you inquire, covered in Unit2] to automatically create a picking ticket form that is displayed (on screen/monitor) in the warehouse. Warehouse personnel use the picking ticket information to pick ordered items from shelves, noting on the displayed picking ticket how many units of each item has been pulled. As the warehouse personnel are entering quantity pulled, they also scan the barcode of the items pulled to update the inventory file in the warehouse database [type of file, completed in Unit 2]. The process of pulling items is completed by the warehouse personnel entering their employee pin-numbers on screen and printing a copy of picking ticket. Warehouse personnel then complete an online work order requesting production of all inventory items for which there is a shortage. The work order form is initialed on-screen by the production manager by entering the pin number. As production work order is completed, it is forwarded by the ERP system to shipping department. The copy of picking ticket (goods pulled) is also sent to the shipping department [internal control issue raised, class discussion]. In the shipping department, the quality manager/shipping clerk inspects assembled product(s), package product(s), and access data from the Production Planning/Quality Management Modules of the ERP system (for this exercise simplification purposes, preceding two modules are combined as one). The PP/QM of the ERP system records the data in respective packing slip and bill of lading transaction files. The ERP system automatically prints a three-part packing slip and a three-part bill of lading. The copies of the packing slip are used and distributed by the shipping clerk as follows: Part one (original) is placed with the goods to be sent to the customer. Part two is sent to customer service. Part three is filed alphabetically by customer name and by date in the shipped orders file. The copies of the bill of lading are distributed as follows: Part one (original) is placed with part one of the packing slip above and the goods pulled. These items are given to the carrier to be delivered to the customer. Part two is given to the carrier too. This copy is to be retained by the carrier for their own company records. 2 Part three is signed by carriers agent and filed with part three of the packing slip above. After the carrier picks up the goods, the shipping clerk initials the picking ticket and forwards it to the accounts receivable clerk in the accounting department for billing. Upon receiving part two of the packing slip, the customer service clerk uses the packing slip to pull the matching sales order filed earlier in the open sales order file. The customer service clerk enters data from the matched documents for updating the sales order in the sales order transaction file in the ERP system as being shipped. The ERP system automatically generates and sends an email to the customer that the shipment is on its way and an invoice is generated automatically by the system. The customer service clerk then files the matched documents by customer name and then by date in the closed sales order file and forward a copy of the invoice to supervisor in customer service for approval and releasing the invoice to the customer. Required: 1) Draw a system flowchart (FROM SCRATCH) in good form and using standard symbols and flowcharting design techniques for McCloud Companys processing of sales orders and shipping of goods (option to skip the production function details and link to it using off-page connectorseparate page and process). Include your name at the top of the flowchart you create. This flowchart should be done using flowcharting software Visio which is available for students through Office 365 (Excel can be used, but Word is not recommended). Please, note that there are few steps and/or documents which are not adequately reported or properly utilized in the above process, and you are required to correct that inadequacy (internal control issue, class discussion). Integration of multiple forms into one is also an assumption that is not applicable for this exercise. Checklist: Have you included all documents (reports) used and generated by the system? Have you included all files (master and transaction files) used and updated? Make sure you reflect the logical sequence of activities. Make sure you represent the sequence and direction of data flow. Make sure you use the flowcharts symbols to help the user know when and where each activity starts and ends, and who is in charge of carrying out each activity. Utilize on-page and off-page connectors whenever possible. The flowchart should not include redundant activities and should reflect internal control concepts and objectives

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health And Safety Environment And Quality Audits A Risk Based Approach

Authors: Stephen Asbury

4th Edition

1032427574, 978-1032427577

More Books

Students also viewed these Accounting questions