Manage Bean Inventory Subsystem Figure 6. The Production Requirements record is passed to the Update Bean Inventory and Determine Requirements module. A Bean-Supplier file is used to track purchases of coffee beans from various suppliers, including base cost and volume discounts available. The Select Supplier module will select the Supplier with the lowest cost, given the total volume of purchases, for each coffee bean and create a Purchase Requisition record. Each Purchase Order Record is assigned a sequential number, and contains the internal code for the supplier, the internal code for the supplier shipping warehouse, the date the PO is generated, and the promised delivery date.
Product information includes the coffee bean ordered, the unit cost, and the quantity ordered.
At this time, the actual carrier and freight rate will be determined based on the availability of carriers. If there is not a sufficient amount of a mix variety to fill an order, then a backorder record will be created for the deficient amount. If there are not sufficient quantities of each raw coffee bean to complete a production batch, then the production manager may alter the production schedule and run a future production batch. An internally generated, sequential number is assigned to each Receiving Report. The module will check for previous Receiving Reports for the selected Purchase Order.