Being a group of 10 students fill the bincard (10 point each), RRF (20 Point), Cost

analysis (20 point)

BIN CARD-1
This Bin Card is being used at Haramaya general hospital. Bin Card for Paracetamol 500mg
capsule of 50x10. The new Bin Card is started on 2 Meskerem 2015. The last balance from
the previous Bin Card is 100 pk, which has a batch number of par12 and an Expiry date of
July 2024
 8 Meskerem 2015, Issued 10 pk to the OPD dispensary using Model 22 No.100401
 15 Meskerem 2015, Issued 20 pk to the OPD using Model 22 No.100402
 22 Meskerem 2015, Issued 30 pk to the IPD dispensary using Model 22 No. 100403
 23 Meskerem 2015, Recived 200 pk which has a batch number of param25 and an Expiry
date of July 2023 from EPSA using Model 19 No. 11311
 24 Meskerem 2015, Issued 10 pk to the In Patent Pharmacy using Model 22 No. 100405
 28 Meskerem 2015, Issued 15 pk to the Emergency Pharmacy using Model 22 No. 100406
 28 Meskerem 2015, Issued 10 pk to the gyn/obs using Model 22 No. 100407
 29 Meskerem 2015, Recived 200 pk which has a batch number of param24 and an Expiry
date of May 2024 from OHB using Model 19 No. 11402
 7 Tikimt 2015,Issued 20 pk to the OPD dispensary using Model 22 No. 100408
 12 Tikimt 2015,Issued 10 pk to the OPD dispensary using Model 22 No. 100409
 20 Tikimt 2015,Issued 10 pk to the OPD dispensary using Model 22 No. 1004010
 25 Tikimt 2015, Issued 10 pk to the In Patents using Model 22 No. 1004011
 26 Tikimt 2015, Issued 20 pk to the Emergency Pharmacy using Model 22 No. 1004012
 26 Tikimt 2015, Issued 30 pk to the gyn/obs pk using Model 22 No. 1004013
 29 Tikimt 2015, Stock taking indicated 300 pk in stock. No Known Reason for discrepancy
 BIN CARD-1
 Name of Health Facility:-__________________________
 Product Name ,Strength & Dosage Forms:- _______________________
 Unit Of Issue: ___________
 Maximum Stock Level:__________________ Emergency Order Point:___________
 Average Monthly Consumption (AMC): ____________________

Date Doc.No Received from Quantity Batch. Expiry Remark

(Receiveing)or or Issued to Received Issued Loss/Adj Balance No date
Issueing)


 BIN CARD-2
This Bin Card is being used at Haramaya general hospital. Bin Card for Amoxicillin 500mg
capsule of 10x10. The new Bin Card is started on 1 Meskerem 2015. The last balance from
the previous Bin Card is 300 pk, which has a batch number of amox43 and an Expiry date of
September 2025
 3 Meskerem 2015, Issued 9 pk to the OPD dispensary using Model 22 No.100444
 9 Meskerem 2015, Issued 20 pk to the OPD using Model 22 No.100445
 12 Meskerem 2015, Issued 20 pk to the IPD dispensary using Model 22 No. 100446
 15 Meskerem 2015, Recived 400 pk from EPSA which has a batch number of amVXO1 and
an Expiry date of October 2024 using Model 19 No. 11782
 19 Meskerem 2015, Issued 10 pk to the In Patent Pharmacy using Model 22 No. 100447
 26 Meskerem 2015, Issued 20 pk to the OPD Pharmacy using Model 22 No. 100448
 6Tikimt 2015,Issued 20 pk to the OPD dispensary using Model 22 No. 100450
 11 Tikimt 2015,Issued 20 pk to the OPD dispensary using Model 22 No. 100451
 17 Tikimt 2015,Issued 30 pk to the OPD dispensary using Model 22 No. 100452
 23 Tikimt 2015, Issued 10 pk to the In Patents using Model 22 No. 100453
 26 Tikimt 2015, Issued 10 pk to the Emergency Pharmacy using Model 22 No. 100454
 28 Tikimt 2015, Issued 30 pk to the Pediatic Ward using Model 22 No. 100455
 29 Tikimt 2015, Stock taking indicated 502 pk in stock. No Known Reason for discrepancy
 BIN CARD-2
 Name of Health Facility:-__________________________
 Product Name ,Strength & Dosage Forms:- _______________________
 Unit Of Issue: ___________
 Maximum Stock Level:__________________ Emergency Order Point:___________
 Average Monthly Consumption (AMC): ____________________

Date Doc.No Received from Quantity Batch. Expiry Remark

(Receiveing)or or Issued to Received Issued Loss/Adj Balance No date
Issueing)


 BIN CARD-3
This Bin Card is being used at Haramaya general hospital. Bin Card for metronidazole oral
suspension 125mg/5ml. The new Bin Card is started on 3 Meskerem 2015. The last balance
from the previous Bin Card is 45 bottles, which has a batch number of MZ22005 and an
Expiry date of June 2024
 5 Meskerem 2015, Issued 15 bottles to the Emergency pharmacy using Model 22 No.100444
 9 Meskerem 2015, Issued 10 bottles to the OPD using Model 22 No.100434
 11 Meskerem 2015, Issued 20 bottles to the IPD dispensary using Model 22 No. 100446
 17 Meskerem 2015, Recived 200 bottles from EPSA which has a batch number of mza421
and an Expiry date of May, 2024 using Model 19 No. 11782
 19 Meskerem 2015, Issued 10 bottles to the In Patent Pharmacy using Model 22 No. 100447
 26 Meskerem 2015, Issued 20 bottles to the OPD Pharmacy using Model 22 No. 100448
 26 Meskerem 2015, 2 bottles with batch number of mza421 and an Expiry date of May, 2024
were broken
 6 Tikimt 2015,Issued 10 bottles to the OPD dispensary using Model 22 No. 100450
 11 Tikimt 2015,Issued 20 bottles to the pediatric ward dispensary using Model 22 No.
100472
 15 Tikimt 2015, 10 bottles with batch number of metr788 and an Expiry date of October 2023
were returned from Awaday health center
 17 Tikimt 2015,Issued 5 bottles to the Emergency pharmacy dispensary using Model 22 No.
100452
 23 Tikimt 2015, Issued 30 bottles to the In Patents Pharmacy using Model 22 No. 100453
 26 Tikimt 2015, Issued 10 bottles to the Emergency Pharmacy using Model 22 No. 100453
 26 Tikimt 2015, Issued 30 bottles to the Pediatic Ward using Model 22 No. 100454
 28 Tikimt 2015, Stock taking indicated 98 bottles in stock. No Known Reason for
discrepancy
 BIN CARD-3
 Name of Health Facility:-__________________________
 Product Name ,Strength & Dosage Forms:- _______________________
 Unit Of Issue: ___________
 Maximum Stock Level:__________________ Emergency Order Point:___________
 Average Monthly Consumption (AMC): ____________________

Date Doc.No Received from Quantity Batch. Expiry Remark

(Receiveing)or or Issued to Received Issued Loss/Adj Balance No date
Issueing)


 BIN CARD-4
You are working currently Haramaya general hospital. As if you need to update Bin
card of oxytocin 10 IU .you have 700 ampoules of oxytocin 10IU with batch number
A321 and expiry date 8/2025 from the previous bin card on meskerem1, 2015. Update
the Bin card based on the following transaction

 on meskerem 1, 2015 the store man issued 200 amp of oxytocin to the emergency
pharmacy
 on meskerem 6, 2015 the store man issued 300 amp of oxytocin to in patient
pharmacy
 on meskerem 12, 2015 the store man issued 200 amp of oxytocin to in to the
emergency pharmacy
 on meskerem 16, 2015 the store man received 1000 amp of oxytocin with batch
number A432 and expiry date of 7/2023 from EPSA
 On meskerem 22, 2015 the store man transfer to 100 ampoules of oxytocin to sabian
health center
 on meskerem 29, 2015 the store man issued 250 amp of oxytocin to in patient
pharmacy
 on tikimt 7, 2015 the store man issued 350 amp of oxytocin to emergency pharmacy
 on tikimt 15, 2015 The store man received 800 amp of oxytocin with batch number
A678 and expiry date of 5/2024 from EPSA
 on tikimt 22, 2015 the store man issued 400 amp of oxytocin to in patient pharmacy
 On tikimt 25, 2015 the store man found 100 ampoules of oxytocin with batch number
A321 expiry date of 8/2025 to be damage
 on tikimt 28 ,2015 the store man issued 300 amp of oxytocin to in patient Pharmacy
 On tikimt 30, 2015 physical inventory was conducted and 460 ampoules of oxytocin
were found the reason for discrepancy unknown
 BIN CARD-4
 Name of Health Facility:-__________________________
 Product Name ,Strength & Dosage Forms:- _______________________
 Unit Of Issue: ___________
 Maximum Stock Level:__________________ Emergency Order Point:___________
 Average Monthly Consumption (AMC): ____________________

Date Doc.No Received from Quantity Batch. Expiry Remark

(Receiveing)or or Issued to Received Issued Loss/Adj Balance No date
Issueing)


 Report and Requisition Form (RRF)

Name of Health Facility: ________________________________

Report Period: From___________________________ To ____________________

S. PRDUCT NAME Unit Beginnin Quantity Losses/ Ending Calculated Day Maximum Quantity Quantity
N of g Received Adjuste balance consumptio out of stock quantity needed to ordered
o issue balance d n stock reach max
A B C D E=A+B+/- F G=120*E/(60- H=G-D I
C-D F)
1

s.n Product name VEN Unit

o group cost
1 Paracetamol 500mg capsule 50x10 N 400
2 Amoxicillin 500mg capsule of 10x10 E 400
3  metronidazole oral suspension 125mg/5ml E 75
4  oxytocin 10 IU V 220

COAST ANALYSIS WORKSHEET FOR RRF

 S. Product name Unit VEN Original request ADJUSTED REQUEST
no of group Quantity Unit Total Quantity Unit Total price
issue needed to price price ordered price
reach max
A B C(A×B) D E F=(D×E)

TOTA PRICE
TOTA PRICE

DRUG BUDGET = 800,000