MRP Mobile Inventory System

1
2
3
4
5
7
I developed a mobile app that takes bill of material and the gross requirements of the end item along with the stock, scheduled receipt, arrival on week, lead time and lot sizing rule information of the subcomponents to create MRP records for all parts and components. This project has been developed using the sqlite database.
  • For advanced mobile version of the project Link
  • For console version of the project Link
  • For the mobile version of the project with SharedPreferences Link

System Operation

There are 6 buttons in the main activity of application. These are “INVENTORY”, “ITEM TREE”, “ORDER ITEM”, “ADD ITEM”, “UPDATE ITEM” and “CLEAR DATABASE” buttons.

“INVENTORY” button

When the button is pressed, the inventory page opens and you can see the current stock status.

The data are recorded in the system as tables with the sqlite database.

“ITEM TREE” button

When the button is pressed, the item tree page opens. According to the products you add, an automatic tree is created and printed on the screen.

“ORDER ITEM” button

When the button is pressed, the ordering page opens. Order is made by following the steps below.

  1. User enters the id of the item he wants to order in the “Item id” section.
  2. The user writes down how many pieces he wants for the weeks he wants to order.
  3. The user presses the “order item” button.
  4. If the selected item exists in the system, the item entered as input is assigned as the current item. If there are no items in the system, the 1st stage will be returned.
  5. Calculations for the entered item are returned.
  6. Calculations are printed on the screen in tabular form.
  7. Sub-item test is made for the current item, if there are subitems, calculations are made for the subitems and printed on the screen.

“ADD ITEM” button

When the button is pressed, the product adding page opens and when you fill in the required fields, the product is added.

The value in the spinner indicates which product is the main product of the product to be added

“UPDATE ITEM” button

When the button is pressed, the product updating page opens and when you fill in the required fields, the product is updated.

Required fields are automatically filled according to the value you choose in the spinner