Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A grocery chain, CariMart, has decided to streamline their processes by introducing a new supply chain management information system (SCMIS) using a Just-In-Time strategy. This

A grocery chain, CariMart, has decided to streamline their processes by introducing a new

supply chain management information system (SCMIS) using a Just-In-Time strategy. This will

ensure that produce are delivered to the customer in peak condition, the shelves are never empty,

and food wastage and warehouse inventory costs are reduced.

All products sold by CariMart are approved by Management. Any new items or items to be

removed are reported to sales department, who informs store managers. The report is also

received by the warehouse manager, who enters the new item or edits the items information

directly into SCMIS. This information is stored in the Product File with Universal Product Code

(UPC), Name, Description, Warehouse Location, Store Location, and Unit Price. If a new item is

entered, then a new record is also created in the Inventory Database. The SCMIS then sends an

automatic update to the Point-of-Sale System.

When a customer buys products in the store, a cashier enters the sales information into the Point-

of-Sale System, which sends an update to the SCMIS. The SCMIS then updates the Inventory

Database. The Inventory Database records the quantity of product within the warehouse and

store at any given time with Inventory ID, Reorder Level, Quantity in Stock, Quantity in

Reorder, and Status. If the Quantity in Stock is below or equal to the Reorder Level, an

automatic notification is sent to the SCMIS.

The warehouse clerk receives the reorder notification and queries the Product File and Supplier

List. The Supplier List logs Supplier ID, Company Name, Contact Name, Phone Number, Email,

and Address. The warehouse clerk then creates a new record in the Purchase Order Database,

Compiled by Rehanna Lutchman

MGMT3011 Management Information Systems II Semester 1, 2019-2020

which stores Purchase Order Number, Date, Quantity, and Status. The warehouse manager

reviews the purchase order and updates the status. Once the purchase order for the product is

approved, the purchase order is emailed to the Supplier, and the SCMIS sends an automatic

notification to the Accounting Information System.

When the Supplier delivers the order, the warehouse clerk enters the delivery information

directly into the SCMIS, which updates the Inventory Database. The warehouse manager then

checks for any discrepancies with all deliveries made and updates the Inventory Status to

indicate that the quantity recorded for the delivered products are correct. If the inventory status is

verified, the SCMIS automatically sends a delivery confirmation to the Accounting Information

System so that payment for the supplier could be arranged for that order.

REquirement

Course Project Part A: Create a Context Diagram for CariMart from the perspective of the SCMIS.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions