Firstly: System Objectives

1. Basic Data Preservation:

   • Store fundamental data for the system, including details of materials used in production, their specifications, maximum and minimum limits, order quantities, and the quantity to be requested in each purchase order for each item.

2. Transaction Tracking:

   • Monitor various movements related to each item (addition, transfers, returns, returned goods).

   • Update inventory balances with each movement.

   • Calculate the moving average price for each item.

3. Allocation of Expenses:

   • Distribute consumed items to cost centers.

   • Allocate to the benefiting units.

4. Personal Asset Recording:

   • Record personal assets.

   • Monitor, determine, and specify the value of personal assets.

Secondly: System Outputs

1. Inventory Balance Reports:

   • Detailed inventory balance report for each item and an overall inventory balance report.

2. Order Limit Report:

   • Report indicating the order limit for each item.

3. Minimum Limit Report (Critical Stock):

   • Report indicating the minimum limit for each item.

4. Idle Inventory Report:

   • Report on idle inventory.

5. Item Groups Report:

   • Report on item groups.

6. Cost Report:

   • Report detailing costs for various transactions (transfer, issue, return, damaged, or direct addition).

7. Item Movement Card:

   • Report detailing item movements (addition, deletion, transfer, settlement).

8. Inventory Items Inventory Report:

   • Report on inventory items.

9. External Movement Tracking:

   • Report on external transactions (total and detailed).

10. Total Inward and Outward Report:

    • Report on the total inward and outward movements.

11. External Entities Report:

    • Report on external entities with which transactions are conducted.

Warehouse and Spare Parts System Application