DOC PREVIEW
OSU BA 378 - LECTURE NOTES

This preview shows page 1-2-3-18-19-37-38-39 out of 39 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

ProjectSlide 2External EntitiesSlide 4Enter and Validate SubsystemSlide 6Validation ChecksCompute Shipping DateSlide 9Q1Slide 11Slide 12Update Mix InventorySlide 14Q2Slide 16Slide 17Schedule ProductionSlide 19Q3Slide 21Determine Green Bean RequirementSlide 23Determine Bean AvailabilityQ4Select Supplier and Generate PONotesOrder FulfillmentSlide 29Slide 30ProductionReceivingSlide 33Slide 34Slide 35First ProjectFirst Project – cont’dSlide 38To DoProject•Based on fictitious Coffee Roasting Company•Automatic Order Processing System–Process “projected”•Accept order from customer and validate•Update coffee mix inventory•Schedule production of coffee mixes•Update raw materials inventory (green beans)•Generate purchase order–Process “actual”•Order Fulfillment: Fill and ship, generate Bill of Lading•Production: Update inventories after production•Receiving: Update inventories, generate Payment VoucherExternal Entities–Customers•27 restaurants–Some have multiple shipping addresses–Suppliers•5 wholesalers where we purchase raw green beans–Some have multiple warehouses–Freight Carriers•Use three carriers with rates that are negotiated periodically–OE Clerk•Receives order from customer and enters into system–Receiving Clerk•Receives shipment from supplier and enters into systemEnter and Validate SubsystemValidation Checks•The sales order number must be numeric and non-zero•The customer code exists in the customer information file.•The customer shipping code exists in the customer shipping address file.•The delivery date must be at least two days after the order date.•The mix and package codes exists in the mix description file.•The quantity ordered must be numeric, greater than 0 and less than 1000.•The unit price must be numeric, greater than $2.99 and less than $100.00Compute Shipping Date•Look at difference between Order Acceptance and Desired Delivery Date–If 2 days, ship one day before delivery using overnight rate (most expensive)–If 3 days, ship two days before delivery using express rate–If 4 or more, ship three days before delivery using regular rateQ1•Create T-AccountsCreate T-AccountsUpdate Mix Inventory•Check the inventory status on the estimated shipping date–Ensure that a sufficient projected quantity-on-hand exists to fill the order. •If an Inventory Status Record exists for the shipping date, the projected due-out and projected quantity-on-hand are updated. •If an inventory status record does not exist, one is created for the shipping date, and the projected due-out and projected quantity-on-hand are derived. –If the projected quantity-on-hand falls below the minimum inventory level for the specified mix code, a Mix Production Request record is created for the day prior to the shipping date.Q2•Update Mix InventoryUpdate Mix InventoryUpdate Mix Inventory–If the projected quantity-on-hand falls below the minimum inventory level for the specified mix code, a Mix Production Request record is created for the day prior to the shipping date.Schedule Production•Use the Mix Code and Production date to determine if a batch is available in the Production Schedule file–If a batch is not available, then check all dates before the production date, but after the Order Acceptance date, to determine if a production batch is available•If a batch is available, update the Production Schedule file, write a record to the Scheduled Mix Production data file, and update the due-in status in the Mix Inventory file for the production date. –If a batch is still not available, display a message to decline the orderQ3•Schedule ProductionSchedule ProductionDetermine Green Bean Requirement•Each variety is comprised of a mix of green coffee beans.–Contained in Mix-Bean-Proportions fileDetermine Bean Availability•Update inventory file•If at or below reorder point, generate purchase requisitionQ4•Update Bean InventoryUpdate Bean InventorySelect Supplier and Generate PO•Maintain information about purchases from suppliersNotes•Business Rules regarding shipment–Must ship at least one day prior to delivery–Must produce at least one day prior to ship•If only two days between OA and Delivery, must reject order if need production–Requisition for raw material delivery at least one day prior to production•If assume that the Supplier also needs two days between OA and delivery, how many days are needed between our OA and promised delivery date if we do not have sufficient quantity of raw beans on hand?Order Fulfillment•Pick orderPick order–When pick completedWhen pick completed•Generate Bill of LadingGenerate Bill of Lading•Update Mix Inventory File (Actual Out and on-Hand)Update Mix Inventory File (Actual Out and on-Hand)–If cannot fill order, generate backorder for deficient If cannot fill order, generate backorder for deficient amount and ship what is availableamount and ship what is available•Generate Backorder Notice for customerGenerate Backorder Notice for customerProduction•After production batch:After production batch:–Update Actual In and QOH for Mix, Actual Out and Update Actual In and QOH for Mix, Actual Out and QOH for BeanQOH for Bean–If there is not sufficient quantity of a coffee bean to If there is not sufficient quantity of a coffee bean to produce a batch, then juggle production schedule produce a batch, then juggle production schedule and mark the “skipped” batch as “Expedite”and mark the “skipped” batch as “Expedite”Receiving•Fill out Receiving ReportFill out Receiving Report–Look up corresponding Purchase OrderLook up corresponding Purchase Order•Derive shipment numberDerive shipment number•If quantity ordered = quantity received, generate Payment If quantity ordered = quantity received, generate Payment VoucherVoucher–Update Actual In and QOH Inventory for BeanUpdate Actual In and QOH Inventory for Bean•Check for “Expedited” batches requiring this BeanCheck for “Expedited” batches requiring this Bean•If sufficient quantity of all required Beans available, If sufficient quantity of all required Beans available, generate Expedite Production Noticegenerate Expedite Production Notice–Trigger Production, and then check for backorders Trigger Production, and then check for backorders and trigger order fulfillmentand trigger order fulfillmentFirst Project•Team Project•Design a normalized relational database for


View Full Document

OSU BA 378 - LECTURE NOTES

Download LECTURE NOTES
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view LECTURE NOTES and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view LECTURE NOTES 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?