NOTE: This is a simplified version of a process for the purpose of illustrating flowcharting techniques.
NARRATIVE
The Chief Operating Officer receives the Annual Budget from the Accountant then approves the Annual Budget. The Chief Operating Officer then sends the Annual Budget to the Factory Supervisor.
The Factory Supervisor prepares the Master Production Schedule using the Production Program which retrieves data from the Inventory Master and Sales Transaction files and adds a new record to the Production Schedule Transaction file. The Factory Supervisor prints two copies of the Master Production Schedule using the Production Program which reads data from the Production Schedule Transaction file.
Copy 1 of the Master Production Schedule is sent to the Chief Operating Officer. Copy 2 is filed in the Master Production Schedule file cabinet by date. The Factory Supervisor then prepares three copies of a Production Order using the Production Program which views the Production Schedule Transaction file data and creates a new record in the Production Order Transaction file. Copy 1 is sent to the Factory Worker.
Copy 2 is sent to the Chief Operating Officer. The Chief Operating Officer compares the information on the Production Order with the information on the Master Production Schedule. The Factory Worker prepares a Materials Requisition using the Production Program which updates the Production Order Transaction file and enters new data into the Materials Requisition Transaction file. Two copies of the Materials Requisition are printed using the Production Program which retrieves data from the Materials Requisition Transaction file.
Copy 1 is sent to the Warehouse Clerk. The Warehouse Clerk checks for materials in stock using the Inventory Program which reads the Inventory Master file. The Warehouse Clerk then gathers the Materials listed on the Materials Requisition and sends the Materials to the Factory Worker.
The Warehouse Clerk also creates a Purchase Requisition for more materials using the Inventory Program which updates the Inventory Master file and adds data to the Purchase Requisition Transaction file. The Purchase Requisition is sent to the Purchasing Department, and the Materials Requisition is filed in the Fulfilled Requisitions file cabinet by requisition number.
After receiving the Materials from the Warehouse Clerk, the Factory Worker files the Materials Requisition in the Materials Requisitions file cabinet by requisition number. The Factory Worker uses the Production Order and Materials to assemble the Product then sends the Product to the Factory Supervisor and files the Production Order in the Completed Production file cabinet by product name then by date.
The Factory Supervisor signs off on Copy 3 of the Production Order and files it in the Completed Production file cabinet by product name then by date.
INSTRUCTIONS:
Create one file in Excel with two worksheets (use a new, blank file). Name the first worksheet "Table" and create a Table of Entities and Activities.
Name the second worksheet "Flowchart" and create a Document Flowchart. Use the parallelogram symbol to represent physical goods.