Part I : completed
The
salesperson
receives
a hardcopy customer
order from
the customer. The salesperson enters the customer order into the salesperson’s mobile device using the Sales Order Program which retrieves information from the Customer Master file, enters data into the Sales Order Transaction file, and updates the information in the Customer Master file. The salesperson forwards the hardcopy of the customer order to the sales manager.
The sales manager
receives the hardcopy of the customer order from the salesperson. The sales manager views the salesperson’s order entered into the Sales Order Program by retrieving data from the Customer Master File and the Sales Order Transaction file. The sales manager then manually compares the hardcopy of the customer order with the sales order on the computer screen and approves the hardcopy with a signature. The sales manager then files the signed hardcopy in the Approved Customer Orders file cabinet by customer number. The sales manager prints a picking ticket for each sales order by using the Sales Order Program and retrieving information from the Sales Order Transaction file. The sales manager sends the picking ticket to the warehouse clerk.
Part II
The warehouse clerk
receives the picking ticket from the sales manager. The warehouse clerk manually gathers the items listed on the picking ticket (NOTE: use the input/output parallelogram symbol to represent the items). The warehouse clerk enters the items picked into a mobile device using the Order Processing Program which retrieves information from the Customer Master file and the Sales Order Transaction file and enters data into the Orders Processed Transaction file. The warehouse clerk brings the picking ticket and items to the shipping clerk.
The shipping clerk
receives the picking ticket and items from the warehouse clerk. The shipping clerk enters the items received into a mobile device using the Shipping Program which retrieves information from the Customer Master file and the Sales Order Transaction file and enters data into the Shipments Transaction file. The shipping clerk files the picking ticket in the Completed Picking Tickets file by date. The shipping clerk prints a packing slip using the Shipping Program which retrieves data from the Customer Master file, Sales Order Transaction file, and Shipments Transaction file. The shipping clerk sends the packing slip and items to the customer.
Instructions:
Create one file in Excel with two worksheets (use a new, blank file).
Create a Table of Entities and Activities on the first worksheet.
Create a Document Flowchart on the second worksheet.
Assignment #2 builds from Assignment #1.
Assignment #1 – the Narrative represents the 1st half of the process.
Assignment #2 – the Narrative includes the 1st and 2nd halves of the process.
The grade for #2 will include the Table and Flowchart from #1.
Attachments:
Assignment.doc