Hello and welcome to our new video
In this video we are going to know
that if you manufacture any product
then how excel
helps in making our inventory
So let's understand this thing
So first of all I open excel
and you will see data here
Here you will see
biscuits packages and their names
like for example Gudde
Monaco, Parle-G
Mario
or 50-50
like this
4-5 biscuits names are given
and their production happens
some manufacturer
so you will notice one thing
over the years
biscuits packets
their quantity
earlier biscuits packets were
20 in 5 rs
then 16, then 14, then 12
but the price
was only 5 rs
this thing is called in economy
so
what we are going to understand here
that
how to make inventory
of biscuit manufacturer
and how to make inventory
from excel
this is not only about biscuits
if you manufacture
for example tube light
or toffee
then you can easily
make inventory of that product
so here you can see
date is given
here
production
here number of biscuits
in one packet
number of packets manufactured
and last
remaining biscuits
it is telling
20 march 2023
how much production of biscuits
number of biscuits
here it is written 1 lakh
you can take any biscuit brand
you can assume
after that we have to find
number of biscuits in one packet
number of packets
manufactured
there are two things
first is how much production of biscuits
second is when we put biscuits
in packet
it can be any number
14, 16, 12
on that basis
we have to tell
number of packets manufactured in one day
it can be
1 lakh biscuits in one day
if you put in packets
it can be 10, 11, 4
8 biscuits
it can be
hypothetical number
suppose
in one packet
18 biscuits
now it is 14
so I write
14
and I drag it down
now I
take example
suppose
what is happening
good day company
how much production
of biscuits
1 lakh
number of biscuits
14
21 march
90,000
22 march
95,000
23 march
1,10,000
24 march
99,000
25 march
1,05,001
26 march
91,678
this much production
is happening on daily basis
you can prepare inventory
on daily basis
you can do it on weekly basis
what we are seeing here
number of biscuits
14
now we have to find
number of packets manufactured
this is
very easy way
divide
production
14
you can see
I put sign
select
production
14
select
now if I enter
you will notice
all values
or packets
are in decimals
now you go to shop
and ask for 1 biscuit
or 2 biscuits
or 3 biscuits
you don't ask
4.5 biscuits
of mario
or packets
or
2.5 packets
of mario biscuits
he will not give
so what we have to do
number is difficult
if we divide it directly
so formula is
quotient
so I remove it
ok
so what you have to do
you have to put equal sign
then you have to write
you can see here
double click
numerator and denominator
if you don't know
what is numerator and denominator
I will tell you
in math
4 divided by 5
numerator
and denominator
fraction
4 divided by 5
7 divided by 6
numerator
7 divided by 6
denominator
now we have to
divide it
and write
now think
what is coming
production
number of production
in one day
in numerator
1 lakh
comma
denominator
we have to put
14
now what we
select it
and enter
now you notice
7142
no other value
in decimal place
lets drag
and see
double click
formula
will apply
Now we know that on 20th of this month
100,000 biscuits were produced
and we put 14 biscuits in each packet
so how many number of packets were made here
7142
you can see here that on 22nd of this month
we produced 95000 biscuits
and number of biscuits in one packet is 14
and here we know that 6,7,8,5
number of packets were manufactured
so you can ask the shopkeeper to give 4 packets
or 5 packets in decimals
so we know that we produced these biscuits from
quotients. Now one thing you should remember
that the values of dot and decimal
where did those biscuits go?
so we are going to produce those biscuits in remaining
biscuits
so it happens that suppose in machine
we produce 100,000 biscuits or 90,000 biscuits
but it is possible that in the end of the day
2 or 4 biscuits will be left
so it happens everywhere
so this is what we will try to find out from remaining
biscuits
so what we have to do is, there is a formula to find
remaining
to find remaining things
there is a formula called mode
quotient and mode are two things, from quotient we get
exact number
and from remaining
from mode we get exact number of biscuits
so we will get exact number of biscuits
so for mode you have to put equal sign
and write mod
so you have to double click it
now it is asking you to tell number and divisor
from which you want to divide
we said that number is from production
now it is asking how many biscuits are there in a packet
so I have put 14
after that I have entered
so it has told me that on 20th
when 100,000 biscuits were produced
and you have packed 14 biscuits in a packet
so number of packets manufactured on 20th
was 7142
and remaining biscuits were 12
here we put 2 biscuits
and write 2 and press enter
now packet is increased to 7143
and how many biscuits are left here? 0
so I will check remaining
how many biscuits are left?
here 90,000 biscuits were produced
so how many biscuits are left? 8, 10, 2, 6
1, 6, 9, 10, 7, 1
I hope you have understood this video
whatever we have done in this
inventory is also prepared in the same way
that how much production was done, how much was done in date
now it is not that you have to take out for biscuits
you are doing anything
you are making a whiteboard, you are making a bottle
if you have to prepare inventory of anything
you can use excel
you can apply on any other product
I hope everything is clear
if you still have any doubt
you can play this video again I will meet you in the next
video
till then keep practicing