HR Materials Master

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Total Joiners till date 1112 Total Joiners till date

Min Joiners in a Month 95 Min Joiners in a Month

Max Joiners in a Month 142 Max Joiners in a Month

Average Number of Joiners 112 Average Number of Joiners


HR Materials Airtel HR Materials

Onboarding Requirement per Unit Cost/Month Onboarding


Access Card 150 128 19200 Access Card
Holder 150 4 600 Holder
Lanyard 150 19.75 2963 Lanyard
Blank ID Card 150 5.9 885 Blank ID Card
Ribbon 2 2900 5800 Ribbon
Joining Booklet 150 15 2250 Joining Booklet
Flat Files 150 19.5 2925 Flat Files
Letter Heads (4x1) 600 1.18 708 Letter Heads (4x1)
A4 Sheets- Rims 2 150 300 A4 Sheets- Rims
Big Envelope 150 3.41 512 Big Envelope

Permanent Markers 2 15 30 Permanent Markers

Total 36172 Total

ER Requirement per Unit Cost/Month ER


Letter Heads 250 1.18 295 Letter Heads
A4 Sheets- Rim 1 150 150 A4 Sheets- Rim
Small Envelopes 200 1.73 346 Small Envelopes
Labels- Sheets 13 5 65 Labels- Sheets

Markers 5 18 90 Markers

Total 946 Total

Current Inventory Levels Process wise Breakup

Airtel BFSI

Access Card 15 15 0
Holder 100 50 50
Lanyard 20 (150 Loan from NTP) -96 -34
Blank ID Card 1000 500 500

Ribbon 6 3 3

Joining Booklet 1921 887 1034

Flat Files 100 50 50

Letter Heads (4x1) 2000 2000 0

A4 Sheets- Rims 10 10 0

Big Envelope 1600 800 800

Permanent Markers 3 2 1

Small Envelopes 0 0 0

Labels- Sheets 1000 500 500


Markers 10 10 0

Stapler Pins 2 2 0

Glue Stick 8 8 0

Blue Pens 50 50 0

Pencils 50 50 0

Eraser 5 5 0

Sharpener 5 5 0
386
27
70
39
BFSI

Requirement per Unit Cost/Month


70 128 8960
70 4 280
70 19.75 1383
70 5.9 413
1 2900 2900
70 15 1050
70 19.5 1365
280 1.18 330
1 150 150
70 3.41 239

1 15 15

17085

Requirement per Unit Cost/Month


100 1.18 118
0 150 0
100 1.73 173
7 5 35

3 18 54

380

Inventory Levels

Approved but Pending for Delivery Process wise Breakup

Airtel BFSI

Access Card 200 0


Holder 100 0
Lanyard 125 0
Blank ID Card 75 0

Ribbon 1 0

Joining Booklet 0 0

Flat Files 100 0

Letter Heads (4x1) 1500 0

A4 Sheets- Rims 0 0

Big Envelope 100

Permanent Markers 0 0

Small Envelopes 125 0

Labels- Sheets 0 0
Markers 0 0

Stapler Pins 0 0

Glue Stick 0 0

Blue Pens 0 0

Pencils 0 0

Eraser 0 0

Sharpener 0 0
Inventory for Next month Process wise Breakup

Airtel BFSI

Access Card 215 0


Holder 150 50
Lanyard 29 -34
Blank ID Card 575 500

Ribbon 4 3

Joining Booklet 887 1034

Flat Files 150 50

Letter Heads (4x1) 3500 0

A4 Sheets- Rims 10 0

Big Envelope 900 800

Permanent Markers 2 1

Small Envelopes 125 0

Labels- Sheets 500 500


Markers 10 0

Stapler Pins 2 0

Glue Stick 8 0

Blue Pens 50 0

Pencils 50 0

Eraser 5 0

Sharpener 5 0

You might also like