Document Flowchart Helpful hints: Please give yourself plenty of time to complete this assignment. First, prepare the flowchart by hand. Then, transfer the flowchart to the computer package. Keep in mind that the creation of the flowchart within a package often takes longer than the design itself. Feed My Starving Children (FMSC) The following is a partial description of the organization’s expenditure transaction process. The full description is provided in Assignment 1. Assignment 3 only requires the following processes to be modeled: An important part of FMSC operations are the warehouse captains who monitor incoming goods. Warehouse captains are located at the receiving dock. Captains are responsible for receiving, inspecting and recording each delivery for correct items, quantity and quality. When a delivery comes in, a captain reviews the goods and manually creates a receiving report. The captain prints a copy of the related purchase order from the purchase order transaction file and compares the receiving report to the purchase order for quantity or item differences. If there is a difference the captain works with the department manager to resolve the discrepancy. When no differences exists, the captain stamps the original receiving report approved and keys the data into the ERP system to update the inventory master file. The general ledger is automatically updated when changes are made to these records. The approved receiving report and the purchase order print out are sent to the accounts payable department. The approved receiving report and purchase order are received in Accounts Payable where a cash disbursement clerk manually creates a check on carbon copy based on the supporting documentation. Vendors allow FMSC to make partial payments by the 20th of each month for all deliveries made during the preceding months. The original check is mailed to the vendor and the carbon copy is sent to Accounting and filed by check number along with the supporting documentation. Accounting scans all carbon copy checks into the ERP system to update the cash master file. Required: • • • Prepare a task-level document flowchart of the process described above using a computer graphics software program. It cannot be hand-drawn. Include your name on the face of the document. Save the document as a PDF file. Upload the PDF file to Blackboard. This assignment requires a solid understanding of the data modeling theory covered in class and Chapter 17. I recommend reviewing that material before beginning this assignment. Feed My Starving Children Feed My Starving Children (FMSC) is a non-profit organization committed to feeding hungry children around the world. Their approach includes the development of a food mixture that is easy and safe to transport, simple to make with only boiling water, and culturally acceptable worldwide. The basic dry food mixture includes rice, high protein soy nuggets, vegetables, vitamins and flavoring. The following describes the company’s expenditure cycle. Description of the Expenditure Cycle The FMSC expenditure cycle begins when a food production manager reviews inventory records. When it is determined that inventory is needed for production of the food mixture, the manager manually prepares a purchase requisition. A carbon copy of the requisition is filed in the production department numerically. The original purchase requisition is forwarded to the purchasing department. After receiving the requisition, a purchase order clerk prepares the purchase order using the ERP system. The purchase order clerk may negotiate price as well as combine requisitions and/or orders to achieve the lowest cost with the highest-rated vendor. Note that vendors permit back-orders. The ERP process accesses the vendor and inventory master files and updates the purchase order transaction file. Three copies of the purchase order are subsequently printed. One copy is sent to the vendor. One copy is filed in the purchasing department numerically along with the purchase requisition. The last copy is forwarded to the accounts payable department and filed in the Accounts Payable Pending temporary file numerically. An important part of FMSC operations are the warehouse captains who monitor incoming goods. Warehouse captains are located at the receiving dock. Captains are responsible for receiving, inspecting and recording each delivery for correct items, quantity and quality. When a delivery comes in, a captain reviews the goods and manually creates a receiving report. The captain prints a copy of the related purchase order from the ERP system and compares the receiving report to the purchase order for quantity or item differences. If there is a difference, the captain works with the department manager to resolve the discrepancy. When no differences exist, the captain stamps the original receiving report approved and keys the data into the ERP system to update the receiving transaction file. The general ledger is automatically updated when changes are made to these records. The approved receiving report and the purchase order print out are sent to the accounts payable department. The approved receiving report and purchase order are received in the accounts payable department where a cash disbursement clerk manually creates a check on carbon copy based on the supporting documentation. Vendors allow FMSC to make partial payments by the 20th of each month for all deliveries made during the preceding months. The original check is mailed to the vendor and the carbon copy is sent to the accounting department and filed by check number along with the supporting documentation. The accounting department scans all carbon copy checks into the ERP system to update the disbursement transaction file. Some vendors allow inventory items to be returned and will work with the warehouse captain to coordinate that process. Required: Conceptual model: Prepare a data model with cardinalities for the operating events, agents, and resources in the expenditure cycle process described above. Use crows feet notation for cardinalities. The data model can be hand-drawn – but neatness is required. (If you use Lucid Chart – use the Flowchart Process symbol for events.) Stock Watcher Company ABC Truck Parts Tasty Juice, Inc. FastChips Memory Internet Celebration Bouncy Balls, Ltd XYZ Steel Ticker abct juce fchp webc bbbb xstl Purchase $ 25,00 $ 7,50 $ 67,00 $ 12,50 $ 18,00 $ 38,00 $ $ $ $ $ $ Last 27,50 7,50 39,50 75,00 19,50 47,00 Date Gain/Loss (%) 4/21/2020 10,0% 4/21/2020 0,0% 4/21/2020 -41,0% 4/21/2020 500,0% 4/21/2020 8,3% 4/21/2020 23,7% Regional Sales Summary Northeast South Midwest West Totals 1st Quarter $ 119.700,00 $ 48.900,00 $ 34.600,00 $ 56.200,00 $ 259.400,00 2nd Quarter $ 125.100,00 $ 52.000,00 $ 32.200,00 $ 49.000,00 $ 258.300,00 3rd Quarter $ 133.400,00 $ 49.600,00 $ 47.000,00 $ 52.000,00 $ 282.000,00 4th Quarter $ 139.500,00 $ 54.500,00 $ 45.900,00 $ 51.300,00 $ 291.200,00 Regional Sales Summary $160.000,00 $140.000,00 $120.000,00 $100.000,00 $80.000,00 $60.000,00 $40.000,00 $20.000,00 $1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ $ $ $ $ Totals 517.700,00 205.000,00 159.700,00 208.500,00 1.090.900,00 Northeast South Midwest West 4th Quarter Aluminum Can Recycling Contest Results 0,02 per can Recycling Can Contest City Arvada Centenntial Lakewood Highlands Ranch Parker Total Minimum Average Maximum Potential Revenue Population Jan Feb Mar Total 15.855 28.951 142.547 2.801.561 1.689.908 10.505 24.567 102.376 2.714.664 1.523.665 4.375.777 24.556 21.777 105.876 2.503.344 1.487.660 4.143.213 12.567 26.719 121.987 1.999.877 1.002.545 3.163.695 47.628 73.063 330.239 7.217.885 4.013.870 11.682.685 10.505 875.155 2.714.664 21.777 828.643 2.503.344 12.567 632.739 1.999.877 $ 87.516 $ 82.864 $ 63.274 Accounting Analytics Document Flowchart and Data Flow Diagram Modeling Exercise The following describes the process to execute a credit sale at Marlo's Furniture Store. Salespeople assist customers in locating and pricing merchandise. A salesperson prepares a sales invoice with an original and three copies. Copy 3 of the sales invoice is filed by the salesperson in a salesperson file. The salesperson walks the customer and the remaining copies of the invoice to the Credit Approval Department where the invoice is checked for mathematical errors by a clerk. The credit manager evaluates the credit standing of the customer, approves or rejects the application based on standard company policy, and marks "credit sale" on the invoice along with the results of the credit evaluation. Invoice copy 2 of a creditapproved sale is given to the customer. The Credit Approval Department keeps the original copy of the invoice in their files (filed numerically) and sends the other copy to shipping. The Shipping Department uses their copy as a guide to pull merchandise and deliver it to the customer’s car at the shipping dock of the store. The customer is asked to sign the invoice copy as evidence of delivery. The delivery person files the invoice copy by date. Required: a. Prepare a document flowchart (DFC) for the process above. b. How would the flowchart change if the sale process at Marlo’s Furniture Store was computerized? c. Prepare a level one data flow diagram (DFD) for this process. d. How would the DFD change if the sale process at Marlo’s Furniture Store was computerized? Marlo’s Furniture Sales Process Level One Data Flow Diagram Salesperson 1.0 Prepare Sales Invoice Sales Info Invoice Customer 2.0 Check for Errors Sales/Shipment Data S In igne vo d ice Reviewed Invoice 4.0 Pull and Deliver Goods 3.0 Evaluate Customer Credit Approved Invoice Customer Credit Customer
Purchase answer to see full attachment