This file contains one suggested data flow diagram solution and one suggested flowchart solution for the Gilbert Glass Manual scenario posted in the IM341 Blackboard site Fall 2013. The examples should be used to supplement (rather than replace) learning acquired by reading and studying the required pdf and class slides and by participating in class discussion. Students should create solutions to the scenarios, then use the following sample “solutions” to review their work. Important note: Students who do not create the solutions first (but choose only to review the “solutions”) typically do not perform as well on class assessments.Gilbert Glass FlowchartManual Processes page 1Sales DeptCustomerCustomer OrderCheck credit and prepare sales orderCustomer credit recordsCustomer OrderApproved SO 1Approved SO 2Approved SO 3Approved SO 4FaxD1Warehousing Dept1Approved SO 3Approved SO 4Update inventoryInventory RecordsApproved SO 3Approved SO 4Packing SlipDD= DateDept = DepartmentPage 2Page 3SO = Sales OrderApproved SO 3Approved SO 4Packing SlipPrepare shipment, prepare packing slipOrderApproved?Customer OrderRejectionLetterYesNoCustomerRecord phone order on paperPhonePhone or fax?Gilbert Glass FlowchartManual Processes page 2Shipping DeptPage 1Approved SO 4Packing SlipPrepare bills of lading and shipping noticesApproved SO 4Shipping Notice 2Shipping Notice 1Bill of Lading 1Packing SlipDCustomerMail RoomCustomerRemittance AdviceCustomer CheckLog and Sort checks by companySorted Remittance AdviceSorted Customer CheckPage 3D= DateRemittance ListDPage 1 Page 2Gilbert Glass FlowchartManual Processes page3Billing DeptApproved SO 2Create invoice with remit. advice Sales JournalPrice DataApproved SO 2Remittance Advice 1Sales Invoice 1NCustomerUpdate accounting filesA/R subledgerCash Receipts JournalRemittance AdviceCustomer CheckD = DateRemit = remittanceAR = Accounts ReceivableN= NameDBankKeep for 2 months then discardCashierSales Invoice 2UpdateaccountingfilesInventorySubsidiarySales Invoice 2AccountsReceivableSubsidiary11Sorted Remittance AdviceSorted Customer CheckCustomerCustomer OrderPaymentBankDeposit (of Customer Checks)ShipmentdataInvoiceGilbert Glass Manual Case – Context Diagram0Process Order to CashTransactionsOrder Rejection1.0ReceiveCustomerOrdersCustomer2.0Record Picking andShipmentsCustomer(Records)Sales OrderTransactionsShippingTransactions3.0Bill Customers4.0ReceiveCustomerPaymentsBilling Transaction dataBankCashReceiptsJournalRemittance TransactiondataOrder recordPicking/Packing data (approved orders)ShipmentrecordInvoiceCustomerOrderCredit dataBilling recordPaymentrecordDepositRemittancerecordPaymentrecordPaymentInventory(Records)Pulled InventoryData that accompanies shipment (Shipping notice, bill of lading, packing slip)Confirmation of Approved OrdersSales JournalRevenue($) dataPriceListAccountsReceivableSub LedgerReceivable Update ($)InventorySold ($)InventorySub LedgerPricesGilbert Glass Manual Case – Level 0 DFDPickingTransactionsPicked OrdersRejectionNoticeRemittance
View Full Document
Unlocking...