Below is an extract from the transcript of your interview with Mr. Jackson Brown.

Systems Analyst: On a scale of 1 to 10, how would you rate LLCHs customer service?

Brown: Id give us a six.

Systems Analyst: OK. In your view, what needs to happen for the rating to go up?

Brown: Jensen needs to figure out his inventory. The primary complaint my team hears from customers is delayed jobs. Whether its service or new installs, it seems our Techs never have all the parts they need, so jobs get delayed. How are we supposed to have happy customers when it takes us weeks to complete a job?

Systems Analyst: Thats a good question. It sounds like I need to talk with Chris.

Brown: Please do. Theres got to be a better way.

The dialogue below is an extract from the transcript of your interview with Mr. Chris Jensen.

Systems Analyst: How many employees are in the Parts Department and what are they responsible for?

Jensen: Four, including me. We are responsible for managing the companys inventory, which includes Parts and Supplies. Parts are items sold to customers (i.e., they are included as line items on customer invoices). Supplies are items used by LLCH Techs to complete jobs, but are not included on customer invoices (e.g., tools, tape, connectors, etc.).

Systems Analyst: Got it. Id like to walk through your inventory management process to better understand the flow of things. Can you explain the process of how and when parts leave inventory?

Jensen: Sure. Each time Dispatch assigns a Work Order to a Technician, we receive a copy of the Work Order. From this, we create a Pick List.

Systems Analyst: Pick List?

Jensen: Yes, its a list of all the parts needed to complete the Work Order.

Systems Analyst. OK. What is done with the Pick List?

Jensen: We use it to pull (or pick) the right parts from inventory. Once parts are picked, we package them up, along with a packing slip, and update the inventory file. We then notify the Technician the parts are ready for pickup. If its a big enough job, the parts are delivered to the job site.

Systems Analyst: What happens when you dont have the required parts in stock?

Jensen: That happens sometimes. Unfortunately, it usually causes job delays. We try to have enough parts in stock, but sometimes we get it wrong. Each day I run a report from the inventory file that shows part totals. We have established minimum and maximum inventory levels, so if the total for a particular part is less than its minimum level, we place an order to the Supplier. Once the part comes in, along with an Invoice from the Supplier, we add the parts back to inventory and update the file. Of course, any outstanding Work Orders are filled, and the Technician is notified.

Using the information and transcript above, model the inventory management system. Your objective is to show the movement of data between external entities, processes and data stores within the inventory system. Include the necessary amount of detail to achieve this. If you discover that the information or transcript is incomplete, make up reasonable explanations to complete the story. Upload these extra explanations, along with your diagram(s), to BlueLine in PDF format.