Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Statement 1 Customer seeks to build a state of the art web application for their manufacturing unit The goal is to build an integrated

image text in transcribedimage text in transcribedimage text in transcribed

Problem Statement 1 Customer seeks to build a state of the art web application for their manufacturing unit The goal is to build an integrated manufacturing application system. The initial focus will be on Material Purchase and Goods receipt domain Customer must be able to Order items, check available stock, Add Pre- Approved suppliers, Maintain alternative items which can be ordered if suppliers can't supply the required item, delivery schedule and delivery location, cost of item, discounts and so on. When the deliveries are made by the supplier, a robust quality inspection process is carried out for each item. only quality approved items are accepted into material stock. The delivered items which are rejected in quality are to be picked up by the supplier Once an item is accepted into stock, the availability is communicated to the indenting shop floor person. This time it takes from indenting an item to the time it is actually available for use is a critical success factor for the organization. Let us call it the lead time. It is a vital objective of the business to minimize this lead time. Reliable "Just In Time (JIT) inventory" is the most economical but it is hard to accomplish Innovative ideas from service providers are expected Here are a few requirements 1) Administrator, users, managers 2) Items, Requesting shop floors, alternates 3) Suppliers, Deliveries, Quality processes, Lead time tracking etc 4) Search, Home page etc 5) Email notifications Some expected relationships A Material request indent (MI) is initiated by one and only 1 requestor MI has 1 or more items Each MI Item has one or more deliveries A Purchase order (PO) covers one or more Mi (partially or fully) PO has 1 or more items Each PO Item has one or more Scheduled deliveries

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

Oracle 10g Database Administrator Implementation And Administration

Authors: Gavin Powell, Carol McCullough Dieter

2nd Edition

1418836656, 9781418836658

More Books

Students also viewed these Databases questions

Question

What environmental factors influenced achievement?

Answered: 1 week ago

Question

We will be opening our new facility sometime this spring.

Answered: 1 week ago