Kampüs Gida Company wants to incorporate more information technology into its organization, particularly its shipping de

[answerhappygod]

Kampus Gida Company Wants To Incorporate More Information Technology Into Its Organization Particularly Its Shipping De 1 (82.76 KiB) Viewed 37 times

Kampus Gida Company Wants To Incorporate More Information Technology Into Its Organization Particularly Its Shipping De 2 (64.17 KiB) Viewed 37 times

Kampus Gida Company Wants To Incorporate More Information Technology Into Its Organization Particularly Its Shipping De 3 (71.64 KiB) Viewed 37 times

Kampus Gida Company Wants To Incorporate More Information Technology Into Its Organization Particularly Its Shipping De 4 (87.76 KiB) Viewed 37 times

Kampus Gida Company Wants To Incorporate More Information Technology Into Its Organization Particularly Its Shipping De 5 (81.51 KiB) Viewed 37 times

Kampüs Gida Company wants to incorporate more information technology into its organization, particularly its shipping department. The sales department has already implemented a database for order entry functions, and the production planning department has an information system for tracking inventory, including finished goods. The shipping department currently uses information from these sources while doing its daily tasks. The shipping supervisor has asked END409 student(s) to study the activities in the department and to recommend an information system design to support the operation. What follows is a description of the tasks performed by the shipping clerk and support personnel during a typical day. At the beginning of each day, the sales department prints a report and sends it to the shipping department. This report, called the "Open Orders Report", is a list of orders taken by sales that have not been closed out. Orders are not closed out until the final shipment has been made against the order. An example of a typical open report is shown in Table 1. Open orders are listed in the ascending order of their promised delivery date. Kampüs Gida Company, A.Ş Order Customer ID Number 03564 03565 03580 03566 03564 03567 3950 1000 1050 873 3950 1200 Name/Ship To Bilkent University Universiteler 06800 Çankaya, Ankara Ankara Teknik University Atatürk Blvd. 06560 Etimesgut, Ankara TOBB ETÜ Söğützu Cd. No:43 Çankaya, Ankara ODTU Universiteler 06800 Çankaya, Ankara Bilkent University Universiteler 06800 Çankaya, Ankara Hacettepe University Sahhaye 06450 Çankaya, Ankara PO Number Product ID 58900 03-100 20300 03-222 58900 4999 I 243 430 350 235 350 440 243 333 380 430 905 Label Macaroni & Cheese Turkey Soup Beef Ravioli in Sauce Chili w/Beans Beef Ravioli in Sauce Comed Beef Hash Macaroni & Cheese Chicken Noodle Soup Fish Chowder Turkey Soup Beef Stew Open Orders Report, 11/01/19 QTY (Cases) Price Extension 800 27.00 600 30.00 300 45.00 1000 40.00 500 45.00 700 32.00 1000 27.00 3000 22.00 400 30.00 500 30.00 600 50.00 21,600 TL 18,000 TL 13,500 TL 40,000 TL 22,500 TL 22,400 TL 27,000 TL 66,000 TL 12,000 TL 15,000 TL 30,000 TL Deliver By 10/29/19 11/01/19 11/01/19 11/01/19 11/01/19 11/01/19 11/02/19 11/02/19 11/03/19 11/03/19 11/03/19
Table 1: Open Orders Report Kampüs Gida plans its production in two ways: produce to order and produce to inventory. In the first case, production is scheduled for a specific order. In the second case, production is done in the absence of a specific order. The second case occurs because a specific order is small, and it is desirable to have longer production run before changing over to another product. Changeovers require that the machinery is thoroughly cleaned before the next product can be made, thus incurring a significant cost. The excess production is placed in inventory and is available for shipment the next time a customer orders the product. Also, sometimes production runs of the most popular food products are made to inventory during periods of slack demand. The shipping clerk receives a report (printout) of the finished goods inventory from the production planning department, showing the location of the finished goods inventory by inventory lot. The report is ordered by material ID in the ascending order. The clerk examines each of the open orders and determines whether there exists a matching product inventory lot. If the match occurs, a shipment can be made. A typical finished product inventory report is shown in Table 2. After identifying an inventory lot that can be shipped, the shipping clerk dispatches the forklift truck operator to the warehouse to fetch items to be shipped. He does this by giving verbal instructions to the driver concerning the lot number and location of the product. The driver collects the items and brings the on pallets to the shipping dock. He informs the shipping clerk that the pallets have been retrieved and gets his next assignment.
Finished Product Inventory Report, 11/01/19 Material ID Description Lot No. On Hand 235 243 333 350 380 430 * Chile w/ Beans 03567 Macaroni & Beans 05565 Chicken Noodle Soup Beef Ravioli in Sauce Fish Chowder Turkey Soup Warehouse Transfer Report, 11/01/19 Order Number From Location 03564 5-1-1-8 5-4-2-4 5-4-2-2 5-1-1-6 5-5-1-1 5-1-1-6 13180 13210 12920 13010 13220 13400 12840 13006 13285 13401 13080 5-3-2-10 5-3-1-6 Product Macaroni & Cheese Fish Chowder Turkey Soup Beef Stew area 500 5 2000 5 400 5 1000 5 1000 S 1000 5 100 5 600 5 Turkey Soup Beef Ravioli in Sauce Location 1 isle tier 2 3 3 600 5 1 600 S 1000 S 13080 12840 13006 1 2 1 1 4 2 4 1 1 6 17 Table 2: Finished Product Inventory Report It is the responsibility of the shipping clerk to keep a daily record of everything that is transferred out of the warehouse for shipping and to indicate on the record the customer order against which it is shipped. The warehouse transfer report, shown in Table 3, is used for that purpose. The shipping clerk completes this record when pallets are brought to the loading dock. This document is transferred at the end of the day to the sales department where it is used as the source of information to close out sales orders. I 1 2 I 2 2 1 1 bin 2 1 10 8 4 3 1 10 6 425 Location No. QTY (Cases) 12920 400 13010 400 13401 400 13080 500 12604 600 500 100 400
Table 3: Warehouse Transfer Report After completing an entry on the warehouse transfer report, the shipping clerk directs his personnel to load the cases of product to a truck. As cases are being loaded, he fills out another important report maintained by the shipping clerk, the shipping summary report. This report is kept daily and held in a file in the shipping department. It describes the quantity of cases that are shipped, the customers to whom they are shipped, and the truck number on which they are shipped. Kampüs Gida maintains its own fleet of trucks, which is managed by company's transportation department. The shipping department is only responsible for tracking the shipment to the truck on which it is dispatched. The transportation department is responsible for tracking deliveries to the final customer. A typical shipping summary report is shown in Table 4. Shipping Number 03550 03551 03552 Customer Bilkent Univ. Hacettepe Univ. Ankara Teknik Univ. TOBB ETÜ City & Province PO Number No. of Cases Weight (kg) Truck No. Çankaya, Ankara Cankaya, Ankara Etimesgut, Ankara Çankaya, Ankara 58900 4999 03-100 20300 Table 4: Shipping Summary, 11/01/19 I 1200 1100 1900 1200 6000 5500 9500 6000 3 3 4 2 For each customer shipment on a truck, the shipping clerk prepares a bill of laden for the truck driver after the cases of product are loaded on the truck. Most of the information for the bill of laden is taken off the shipping summary and open orders reports. A copy of the bill of laden is sent to the transportation department at this time, and the other copies are given to the truck driver. No copies are kept in shipping. This bill of laden is presented to the customer when the driver arrives at the customer's receiving location. A signed copy of the bill of laden in turned in to the transportation department when the driver returns from a delivery. The transportation department matches this copy to the one sent by the shipping department and choses out the delivery in its records. A typical bill of laden is shown in Table 5.
To: Date Shipped: Truck Number: B/L No.: Code 350 440 Received by: TOBB ETÜ Söğütözü Cd. No:43 Çankaya, Ankara Driver: 11/01/19 2 03552 Quantity 500 cases 700 cases Total Weight BILL OF LADEN Weight 2500 kg 3500 kg 6000 kg I From: Kampüs Gida Çiftlik Cd. No: 6 Yenimahalle, Ankara Description Beef Ravioli in Sauce Corned Beef Hash Date: License Number: Table 5: Bill of Laden Reference PO 20300 PO 20300