INVENTORY
MANAGEMENT
SYSTEM
SYNOPSIS
By Nayeem, Nethra, Asawari
TABLE OF CONTENTS
Introduction
Objective
Problem Statement
Project Module
Data Flow Diagram
Project Scope
Conclusion
INTRODUCTION
An inventory can be defined as a stock of
goods help for the purpose of sales or further
production. It is also used to meet future
demands of the public. Goods can be kept in
the following forms:
i) Raw Materials
ii) Unfinished Goods
iii) Finished Goods
iv) Spare Parts & Tools
Inventory Management on the other hand
is the branch of business management
concerned with planning and controlling of
stock. It is the process of storing, ordering and
selling of goods and services. One of the most
critical aspects of inventory management is
managing the flow of raw materials from the
time of procurement till they turn into finished
goods.
The different types of Inventories are:
i) Raw Materials – Basic inputs that are
transformed into finished goods
through the manufacturing process.
ii) Work-in-progress – Semi-
manufactured products that need more
working on before they transform into
finished goods.
iii) Finished Goods – Goods that are
ready to be sold.
Reasons to hold Inventory:
i) Meet Customer Demands – The
market is full of unexpected changes
and it requires businesses to be quick
to follow the new trends and provide
for the new public demand.
ii) Price Related – Goods can be sold at
a higher price when the demand for a
certain product is high.
iii) Manage Risk – The stock held can be
used to cover up any losses or
potential threats to the business.
OBJECTIVE
The objective of this project is to build an
application to:
Provide functions to manage goods in
the business more efficiently
Reduce time and cost to control and
manage inventory
Increased accuracy and reliability
Increased data consistency and
security
PROBLEM STATEMENT
For any business, the most important
department that must be well managed in
order to run daily activities smoothly is
Inventory Management. But many businesses
lack a good computerized system and hence
it results in deficiency of:
Management of Data with Consistency
Quick Access to Data
Quick Search Engines
Security of Data
Inability to analyze data
PROJECT MODULE
Stock Module – This module helps
you to add, modify and delete product
data.
Sales Module – This module is used
to manage information about the products
sold.
Purchase Module – This module is
used to manage purchase records of the
customers.
Report Module – This module is used
to generate sale bills, purchase bills and
visualize data by plotting charts.
DATA FLOW DIAGRAM
ADMIN LOGIN
fail
LOGIN CHECK
success
MENU
SALE PURCHASE STOCK CUSTOMER
ADD UPDATE SEARCH DELETE
PROJECT SCOPE
Managing the stocks and inventory of a
business can be very tricky work. To do this
task more effectively, establishment of
inventory database and control is required.
This is provided by our application which has
the following scope:
Ensures effective inventory control
Easy to Use
User Friendly Interface
High Security Level
Can be modified to the person’s liking
Manage daily sales and track records
easily
CONCLUSION
This inventory management system is a
simple application suitable for small
organizations. It consists of all the basic
elements which are needed for effective
managing of inventory and stock.
We strongly believe that the implementation
of this system will surely benefit so and so
organization.
CODE
unit_price={}
description={}
stock={}
try:
details = open("[Link]","r")
no_items = int(([Link]()).rstrip("\n"))
for i in range(0,no_items):
line = ([Link]()).rstrip("\n")
x1,x2 = [Link]("#")
x1=int(x1)
x2=float(x2)
unit_price.update({x1: x2})
for i in range(0,no_items):
line = ([Link]()).rstrip("\n")
x1,x2 = [Link]("#")
x1=int(x1)
[Link]({x1: x2})
for i in range(0,no_items):
line = ([Link]()).rstrip("\n")
x1,x2 = [Link]("#")
x1=int(x1)
x2=int(x2)
[Link]({x1: x2})
except:
print("Stock empty")
cart=[]
c="y"
print("Welcome to Inventory Management System of NAN Makeup!")
print()
print("A-Add an item")
print("R-Remove an item")
print("E-Edit specifics of an item")
print("L-List all items")
print("I-Inquire about a item")
print("P-Purchase")
print("C-Checkout")
print("S-Show all items purchased")
print("Q-Quit")
print("remove-Remove an item from the cart")
print("help-See all commands again")
print()
total_cost=0
flag=0
while(c!= "q" or c!= "Q"):
c= input("What would you like to do? ")
if(c=="q" or c=="Q"):
break
elif(c=="A" or c=="a"):
p_no = int(input("Enter item number: "))
p_pr = float(input("Enter item price: "))
p_desc = input("Enter item description: ")
p_stock = int(input("Enter item stock: "))
m=0
for i in range(0,len(unit_price)):
if(p_no in unit_price):
p_no+=1
m=1
if(m==1):
print()
print("That item number already exists :(, changing value to ",p_no)
unit_price.update({p_no: p_pr})
[Link]({p_no: p_desc})
if(p_stock > -1):
[Link]({p_no: p_stock})
else:
p_stock = 0
[Link]({p_no: p_stock})
print("The stock of an item cannot be negative, the stock has been set to 0.")
print()
print("Item number: ",p_no," Description: ",[Link](p_no)," Price: ",unit_price.get(p_no),"
Stock: ",[Link](p_no))
print("Item was added successfully!")
print()
elif(c=="E" or c=="e"):
print()
p_no = int(input("Enter item number: "))
if(p_no in unit_price):
p_pr = float(input("Enter item price: "))
p_desc = input("Enter item description: ")
p_stock = int(input("Enter item stock: "))
unit_price.update({p_no: p_pr})
[Link]({p_no: p_desc})
[Link]({p_no: p_stock})
else:
print("That item does not exist, to add an item use a")
print()
elif(c=="R" or c=="r"):
print()
p_no = int(input("Enter item number: "))
if(p_no in unit_price):
are_you_sure = input("Are you sure you want to remove that item(y/n)? ")
if(are_you_sure=="y" or are_you_sure=="Y"):
unit_price.pop(p_no)
[Link](p_no)
[Link](p_no)
print("Item successfully removed!")
print()
else:
print("Sorry, we don't have such an item!")
print()
elif(c=="L" or c=="l"):
print()
print("Item and their prices: ",unit_price)
print("Descriptions: ",description)
print("Stock left of Item: ",stock)
print()
elif(c=="I" or c=="i"):
print()
p_no=int(input("Enter Item Number: "))
if(p_no in unit_price):
print()
print("Item number: ",p_no," Description: ",[Link](p_no)," Price: ",unit_price.get(p_no),"
Stock: ",[Link](p_no))
if([Link](p_no)<3 and [Link](p_no)!=0):
print("Only ",[Link](p_no)," remaining! Hurry!")
print()
else:
print("Sorry we don't have such an item!")
print()
elif(c=="P" or c=="p"):
print()
p_no = int(input("Enter Item number: "))
if(p_no in unit_price):
if(flag==1):
flag=0
stock_current = [Link](p_no)
if(stock_current>0):
stock_current = [Link](p_no)
stock[p_no] = stock_current-1
item_price = unit_price.get(p_no)
total_cost = total_cost+item_price
print([Link](p_no),"added to cart: ","$",item_price)
[Link](p_no)
else:
print("Sorry! We don't have that item in stock!")
else:
print("Sorry! We don't have such an item!")
print()
elif(c=="C" or c=="c"):
print()
print("You bought the following items: ",cart)
print("Total: ","$",round(total_cost,2))
tax= round(0.12*total_cost,2)
print("Tax is 12%: ","$",tax)
total = round(total_cost+tax,2)
print("After Tax: ","$",total)
total_cost=0
flag=1
print()
print("You can still purchase items after check out, your cart has been reset. To quit press q")
print()
elif(c=="help"):
print()
print("Help Centre")
print("A-Add an item")
print("R-Remove an item")
print("E-Edit specifics of an item")
print("L-List all items")
print("I-Inquire about a item")
print("P-Purchase")
print("C-Checkout")
print("S-Show all items purchased")
print("remove-Remove an item from the cart")
print("help-See all commands again")
print("If you have any other questions or concerns please contact the manager.")
print()
elif(c=="remove" or c=="Remove"):#To remove an item from the cart
print()
are_you_sure = input("Are you sure you want to remove an item from the cart(y/n)? ")
if(are_you_sure=="y"):
p_no = int(input("Enter item number to remove from cart: "))
if(p_no in cart):
stock_current = [Link](p_no)
stock[p_no] = stock_current+1
item_price = unit_price.get(p_no)
total_cost = total_cost-item_price
j=0
for i in range(0,len(cart)):
if(i==p_no):
j=i
[Link](j)
print([Link](p_no),"removed from cart: ")
print()
else:
print()
print("That item is not in your cart!")
print()
elif(c=="s" or c=="S"):
print()
print(cart)
print()
else:
print()
print("ERROR! Contact manager for help!")
print()
if(total_cost>0 and flag==0):
print()
print("You bought: ",cart)
print("Total: ","$",round(total_cost,2))
tax= round(0.12*total_cost,2)
print("Tax is 12%: ","$",tax)
total = round(total_cost+tax,2)
print("After Tax: ","$",total)
print("Thank you for using Inventory Management System")
try:
details = open("[Link]","w")
no_items=len(unit_price)
[Link](str(no_items)+"\n")
for i in range(0,no_items):
[Link](str(i+1)+"#"+str(unit_price[i+1])+"\n")
for i in range(0,no_items):
[Link](str(i+1)+"#"+description[i+1]+"\n")
for i in range(0,no_items):
[Link](str(i+1)+"#"+str(stock[i+1])+"\n")
except:
print("Stock saved")
PRODUCTS
GRAPHS
i) Line Graph of NAN Makeup sales during 4 weeks:
CODE
import pandas as pd
import [Link] as plt
df=pd.read_csv(r"C:\Users\Administrator\Desktop\nan
[Link]")
[Link](kind='line',x='Days',color=['green','blue','yellow
','red'],marker='*',markersize=10,linewidth=3,linestyle
='--')
[Link]('NAN Sales Report')
[Link]('Days')
[Link]('Sales in Rs')
[Link]()
CSV FILE
OUTPUT
ii) Bar Graph of the current stock held by NAN
Makeup: