1 / 66

Physical Inventory Prep & Inventory Weekend

Physical Inventory Prep & Inventory Weekend. FFF Branches – June 2010. Purpose of Inventory. Count our Money $$ 3 ways we count our money Accounts Receivable (A/R) Cash In Bank Inventory. Drug & Alcohol Policy.

emmly
Télécharger la présentation

Physical Inventory Prep & Inventory Weekend

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Physical Inventory Prep & Inventory Weekend FFF Branches – June 2010

  2. Purpose of Inventory • Count our Money $$ • 3 ways we count our money • Accounts Receivable (A/R) • Cash In Bank • Inventory

  3. Drug & Alcohol Policy All associates are required to comply with our current set of Drug & Alcohol policies at all times. As stated in the guidelines: No associate may possess, use, or be under the influence of any illegal substance or alcohol while on company time or property.

  4. Keep in mind…. • You own your inventory • Get everyone involved • Teach someone else at your location how to run your inventory • Four goals • Safety of your associates is key • Get accurate inventory counts • To determine how much we have in inventory assets • Get your people out at a decent hour

  5. High-Level Timeline • On-goingClean up your files • June 18th & 23rd Suspend shipping IBTs • June 14th thru 24thVerify “Staging Locations” • June 23rdCreate PI File, Print Count Sheets • June 25th and 26thCount, Enter, Recount, Enter • June 26th and 27thUpdate On-Hand Balances • June 28thConduct Business & Make Corrections

  6. Inventory Prep: Ongoing • Aisle Locations correct and loaded • Aisle Location Rpt (4,10,1,11,2), • Products w/ NO Aisle Location Rpt (4,10,1,11,1) • BCM – PYHF like “STAGE” but shows bogus “regular” aisle locations. • Locations can be fixed via 4-8-15 or PFMW • Bins labeled

  7. Inventory Prep: Ongoing • Statuses Correct in system • Temp & Sp Rpt (4,10,1,6), BCM-STOHR & DRST • Sp/Temp with OHB > On Order Qty Rpt (12,3,1,6,8) • Clean up Negative Item Report • Manage your Average Cost • PO Preview, Invoice Preview, Op Sum: Invoice vs. Avg Cost Exception (12,2,2,3&4), • Products whose Average Cost = 0 (Crystal/Dee)

  8. Inventory Prep: Ongoing • Clean up your Staging Location files: • Specials w/ On-Hand > Committed (4,10,1,20,5) • Sp & Temp Committed - No Staging Loc (4,10,1,20,2) • Staging Location Rpt for Stock Products (4,10,1,20,1,1,S) • Listing of Staging Locations (BCM-STAGE) • Staging Location Reports (4,10,1,20,1) • Use LOC to make changes • Material may need to be committed to the order before it can be entered into LOC (IAM, 6)

  9. Specials on Hand Report • Used to give you a heads up on specials that have been in your warehouse too long with no activity. • Menu: 4-10-23 or 1-9-7 • You will not get credit for items that show a status of NQ on the report if those items remain in your inventory at inventory time. • For specials to be valued: the Last Rec Date or Last Sale Date must have been AFTER: • Jan 31, 2009

  10. Warning Specials on Hand =================================================================================================================================== NVSP.ONHAND.RPT ANYBRANCH PAGE 1 APR 13 2004 17:01:16 Specials on Hand =================================================================================================================================== WH# Alt.Code OHB Avg.Cost Avg.Cost Ext. MasterCst LastRecPO# LstRctDt LstSleDt CmmtQty Cmmt Ord# ST ----- ------------------- ------- ------------ ------------- ------------ -------------- -------- -------- ------- ------------ -- 000 G300CF 7 3.34 23.38 3.34 T141-10914-1 12/22/03 12/23/03 SP 000 B300TJJH 1 9.67 9.67 7.68 T141-16795-2 03/23/04 03/22/04 0 SP 000 BBSDUF 9 7.75 69.75 7.75 T141-16084-3 03/11/04 03/29/04 9 857376-2 SP 000 VL020075GE0 3 4.96 14.88 4.96 CM049924 0 NQ 000CB166135516 6 603.42 3,620.52 603.42 T141-3598-3 10/03/03 11/13/03 6 679447-4 + SP 000CB166135520 9 1,257.12 11,314.08 1,257.12 9 679447-4 + NQ 000CB166135524 1 1,993.41 1,993.41 1,993.41 1 679447-4 NQ 000SVSHP1510 100 3,495.24 3,495.24 3,425.56 T141-3612-1 09/26/03 100 800258 SP 000SV415 7 211.98 1,483.86 211.66 R141-10928-1 03/19/03 7 578547-2 NQ 000SV2U 2 13.06 26.12 11.49 T141-19215-1 04/09/04 2 872006-1 SP 000SVY1515U 2 423.29 846.58 419.46 T141-3612-1 09/26/03 2 800258 SP 000SVR1512 1 116.95 116.95 121.78 1 578547-2 NQ 000SVPTX 1 148.01 148.01 146.74 1 718033-2 NQ 000SVCOSP 3 10.71 32.13 10.88 T141-7454-1 11/13/03 3 813919 SP 000SP-AUT181284K6S 1 356.72 356.72 0.00 R141-10633-3 04/23/03 04/24/03 1 708627 NQ 000SP-AWEP42SPICEMP 2 11.20 22.40 0.00 2 722850 NQ 000SP-B19321-WN 25 3.15 78.75 0.00 T141-17955-1 04/09/04 25 CS113030-1 SP 000SP-B19322-WN 12 3.78 45.36 0.00 T141-17955-1 04/09/04 12 CS113030-1 SP 000SP-B207426 1 18.23 18.23 0.00 R141-9835-1 03/05/03 NQ 000SP-ZZN550NLM 3 76.67 230.01 0.00 T141-16590-1 03/11/04 3 858457 SP -------------- 542,432.81 ===================================================================================================================================

  11. Inventory Prep: Ongoing • Dispose of Non-Stock/Defective/No-Value • Use “No Value Follow-Up” (4,10,1,8) & “D Ranked Items” (4,10,1,15) reports to identify material • Schedule inspections, Secure RGAs, Return on debit to Vendors • Stay current on DC - DRRs • DRI status of A/Approved and O/Open need to be processed & shipped! • SPIFFS (Create a List 2,10,1 and set up Spiff 2,1,16) • Sell to other branches (Create a select list (2-10-1) then BCM-DCHK) • Sell over counter sale • Give to Best Customer/Prospect • Scrap it

  12. Inventory Prep: Ongoing • Purchasing: • Review open Purchasing Transactions • Clean Open PO Report (BCM  OPEN) • Ensure Receivings, Debits, Dist/Pipe RFCs are current

  13. Interbranch Transfers… • Suspension of interbranch transfers will commence as follows: • Parcel orders (UPS, FedEx, etc) as of Friday 6/18 • Shuttle/Truck orders as of Wednesday 6/23 • Do not confuse interbranch transfers (IBT) with shipments to other FEI (logons) branches. The computer ships to other FEI branches just as it ships to regular customers.

  14. The Week of June 21st • Managers will be the only associate opened to PI programs. • Meet with key management associates to discuss inventory prep progress and plans. • Notify customers about inventory closing

  15. The Week of June 21st • For the items you are waiting to return to the DC (because it’s not your day to submit/don’t meet minimum): • Create a BOD order to the DC for the items, commit the items and assign a Staging Location • By June 24th, 2009 • Maintain this ticket throughout inventory, delete from system after inventory when DRR is approved and official ticket created by system

  16. The Week of June 21st • Finish all aisle location changes, loadprod, status changing, product exchanges, etc. • These must be done before you create your Stock & Temp PI file (on June 23rd)

  17. Prepare layout of warehouse and yard, devise teams, schedule tasks Organize warehouse, pipe yard, office and file areas The Week of June 21st Count Sheets R1 Bill & Ted

  18. June 21st & 22nd • Contact customers and expedite shipments • Staged Products by writer Rpt 4,10,1,20,1,3, BCM-PROM-7

  19. June 21st & 22nd • Continue to work on inventory prep, material returns to the vendor, and various clean-up (purchasing/accounting). • Post a sign on doors notifying customers of Early Friday (11:00am) closing - counters • Work the Unbilled Interbranch Transfer Report (1,3,3,10)

  20. Wednesday, June 23rd • By end of day: • CREATE your PI File for Stock and Temp Products (PIM,1 or 4,8,9,1) • Print Count Sheets for Stock and Temp Products (PIM,10,1,1): • Exception-Based, print only ONE set (First Count Sheets) • Print the Inventory Back-up Report (PIM,10,2)

  21. Wednesday, June 23rd • Create Physical Inventory File for Stock and Temporary Products (PIM, 1) P H Y S I C A L I N V E N T O R Y =============================================================================== Create Physical Inventory File Sort By File A/Aisle Break-On Whse # Created? L/Line Char Page 1 of 1 ------------------------------------------------------------------------------- 466 A 3 =============================================================================== #/Whse #, ABORT, E/END:

  22. Wednesday, June 23rd • Print the “appropriate” number of Count Sheets (PIM,10,1,1): • Exception-Based, print only ONE set (First Count Sheets) • You will be prompted to print the Exception-Based First and Second Recount Sheets at the same time you request the Exception-Based First Count Difference Report. P H Y S I C A L I N V E N T O R Y ================================================================================ PRINT COUNT SHEETS Enter Branch Numbers Separated By Commas, A/ALL, E/END :466 Enter The Number Of Count Sheets You Want To Print Or E/END :1 Enter Message For Count Sheet 1 (2 Lines, 30 Char Each) FIRST COUNT SHEET Message 1 OK? (N/<RTN>):

  23. Thursday, June 24th • Continue to work on inventory prep, material returns to the vendor, and various clean-up (purchasing/accounting). • If you pre-counted Staged Products last weekend, optionally, selectively audit newly arrived Specials and Temp products • Use the “Specials and Temp Received” Report (4,10,1,20,3)

  24. Friday, June 25th • Reminder: Automated Night-End will NOT run. • Close all warehouses by 11:00 am and hold inventory meeting to review schedule and procedures. • Precounting and/or bin slipping may be completed prior to closing, but utilizing the count sheets is not allowed.

  25. Physical Inventory: • First counts

  26. Friday, June 25th • There are two streams of work going on this weekend: • Count Related • Counting the bins, recording the counts, entering the counts, etc. • Transaction Related • Getting all the billing, receivings, etc. completed • Note: some locations will complete the following steps sooner that we’ll show in this presentation (i.e.: Friday instead of Saturday; Saturday instead of Sunday) – it’s the sequence that matters!

  27. Friday, June 25th - Morning Fabrication (WIP) “Work In Progress” • Identify all Fab Orders which have been pulled first thing in the morning. • Verify that all material has been pulled and in the Fab Area – This means count! • If not all material has been pulled, determine what will be needed the remainder of the day/weekend and bring to the FAB Area.

  28. Friday, June 25th - Morning Fabrication (WIP) “Work In Progress” Continued… • Assign Staging Location of fabrication using jump word LOC (4-18) for all pulled material. • IMPORTANT NOTE: It is important to note that a product cannot be placed into a staging location until it has been committed.

  29. Friday, June 25th… • Begin first counts for Stock and Temporary Products: • Slip all bins • Transfer completed bins into First Count Sheets • Use Supplemental Sheets for items not on Count Sheets • For sheets with completed counts, manually hash total. • For sheets that have been hash totaled, enter into the system. • Work the Supplemental sheets (determine product codes) and turn in for count entry.

  30. P H Y S I C A L I N V E N T O R Y C O U N T S H E E T S PI.PRTCNT.SHEET WHSE 466 - SORTED BY PRIMARY LOCATION - B01 Page 2 REF# ITEM# COUNT COUNT COUNT DESCRIPTION UM LOC ALT.LOC 18 PDWVCOPP _____________ _____________ _____________ 4 PVC DWV CO PLUG EA B01A01 19 PSHCOAP _____________ _____________ _____________ 4 PVC SWR HUB CO ADPT EA B01A02 20 PSHCOAU _____________ _____________ _____________ 6 PVC SWR HUB CO ADPT EA B01A03 21 PSSCAPP ____8________ _____________ _____________ 4 PVC SWR SW CAP EA B01A04 22 PSSCAPU ___16________ _____________ _____________ 6 PVC SWR SW CAP EA B01A05 23 PSSCAPX ___1________ _____________ _____________ 8 PVC SWR SW CAP EA B01A06 24 PSSCU _____________ _____________ _____________ 6 PVC SWR SW COUP EA B01A07 25 PDWVFAP ____1_____ _____________ _____________ 4 PVC DWV FEM ADPT EA B01A08 26 PDWVFAU _____________ _____________ _____________ 6 PVC DWV FEM ADPT EA B01A09 27 PDWV9P ____3________ _____________ _____________ 4 PVC DWV 90 ELL EA B01A11 28 PDWV9U ___1________ _____________ _____________ 6 PVC SWR 90 ELL EA B01B01 29 PSS4U _____________ _____________ _____________ 6 PVC SWR SW 45 ELL EA B01B02 30 PSSS4U ____________ _____________ _____________ 6 PVC SWR SW ST 45 ELL EA B01B03 ******************************** HASH TOTAL ___30_______ * FIRST COUNT SHEET * * * INPUT BY ___TLS______ ********************************

  31. H/Hash each page to indicate entry is correct As you leave the page you are on, the counts will move to the right (cumulative count column) After you enter the desired number, if you need to make a correction, then (and only then) use + and – PE#/Excpt Page to toggle to Exception based entry Inventory Weekend: Friday First Count Entry (PIM, 3) P H Y S I C A L I N V E N T O R Y Branch Number 466 Entry and Maintenance Location: B01 Page 2 of 81 Hash Total 30 REF# ITEM# COUNT1 DESCRIPTION TOTAL 18 PDWVCOPP 100,50________ 4 PVC DWV CO PLUG 0 19 PSHCOAP 100 50________ 4 PVC SWR HUB CO ADPT 0 20 PSHCOAU 100+50________ 6 PVC SWR HUB CO ADPT 0 21 PSSCAPP ______________ 4 PVC SWR SW CAP 8 22 PSSCAPU ______________ 6 PVC SWR SW CAP 16 23 PSSCAPX ______________ 8 PVC SWR SW CAP 1 24 PSSCU ______________ 6 PVC SWR SW COUP 0 25 PDWVFAP ______________ 4 PVC DWV FEM ADPT 1 26 PDWVFAU ______________ 6 PVC DWV FEM ADPT 0 27 PDWV9P ______________ 4 PVC DWV 90 ELL 3 28 PDWV9U ______________ 6 PVC DWV 90 ELL 1 29 PSS4U ______________ 6 PVC SWR SW 45 ELL 0 30 PSSS4U ______________ 6 PVC SWR SW ST 45 ELL 0 REF#, A/Alt, AL/Alt Loc, H/Hash, I/Item, L/Loc, P#/Page, PA#/Alt Page, PE#/Excpt Page, PI, PRINT, M/More, E/END:

  32. Note: some of these products may be Specials. You will not be able to enter a count for Specials until AFTER the addendum file has been created (AFTER Freeze On-hand Balances has been completed for the last warehouse). Inventory Count Supplement Sheet

  33. Supplemental Count Entry P H Y S I C A L I N V E N T O R Y Branch Number 466 Entry and Maintenance Location: Page 1 of 537 Hash Total REF# ITEM# COUNT1 DESCRIPTION TOTAL 1 DBSPA106BH ______________ 1-1/4 BLK PE A106B 40 SMLS SRL PIP 0 2 DBSPA106BU ______________ 6 BLK PE A106B 40 SMLS SRL PIPE 0 3 DBSPA106B80U ______________ 6 BLK PE A106B 80 SMLS SRL PIPE 0 4 DBPPEA53BK ______________ 2 BLK PE A53B S40 ERW SRL PIPE 0 5 DGPPEA53BU ______________ 6 GALV PE A53B S40 ERW SRL PIPE 0 REF#, A/Alt, AL/Alt Loc, H/Hash, I/Item, L/Loc, M/More, E/END: Whse 466 PI Item Code Entry Screen Page 1 of 1 Alt Code/ Location/ Ref# Description Alt loc. Count Total ------ ---------------------------------- --------- ------------ ------ 1. P80SCU 3 3 6 PVC SCH80 SXS COUP 2. K30653 5 5 ANTI - SYPHON FLOAT VLV 3. BNH10 6 6 1-1/4X10 BLK STL NIP 4. OPTIONS: #/Line#, P#/Page#, A/Add, E/END, PI/Product Inquiry:

  34. Friday, June 25th… • Complete transactions affecting inventory: • Invoices: customer invoices need to be invoiced and corrected • Credit Memos: need to be processed to the stage that inventory is affected • Cash Sales, Cash Sale Refunds • Balance the cash box and make a deposit • Interbranch Transfers: invoiced if shipped • Stock Receipts Entry completed • APC and ICPD discrepancies handled (work the ones that affect On-Hand Balances) • Debit Memos pick completed if they affect inventory • Inventory Adjustments made • Create, edit, & release a final Inventory Allocation batch (IAM, 4)

  35. Friday, June 25th… • Run Invoicing and Purchasing Complete (PIM,5) • Each location within the Branch may be ‘completed’ individually, but all whses MUST be ‘completed’ before any one whse can proceed on to the next step - Freeze On-Hand Balances

  36. Friday, June 25th … • Run Freeze On-hand Balances (PIM, 4) • Each location within the Branch may be ‘frozen’ individually, but all whses MUST be ‘frozen’ before any one whse can proceed on to the next step - Run First Count Difference Report. • Note: a satellite that has completed its counts and indicated Invoicing & Purchasing Complete and Frozen its On-Hand Balances can pre-request its First Count Difference Report – the system will “sleep” it until the last warehouse in that account finishes running Freeze On-hand Balances – then the report will print.

  37. Friday, June 25th… • The “Freeze On-Hand Balances” Function: • Freezing can take between 30 minutes to 1 hour. The PI system will be LOCKED DOWN during this time! • You are NOT able to obtain the PI version of Staging Location Count Sheets UNTIL the Freeze On-Hand Balance function.

  38. Friday, June 25th… • The “Freeze On-Hand Balances” Function: • Freezes On-Hands for later use in comparing versus actual counts • Some pricing files built • Creates an “Addendum” file that consists of: • Stock, Temp and Special Products that have been Committed & Staged • Specials whose On-Hand Balance Qty > Committed Qty • Specials on ‘Open’ Transactions (On Open Stock PO, SO, Xfer, RFC) • Provides an Option to Print the PI version of the Staging Location Report (use if haven’t pre-counted the Staging Location)

  39. Friday, June 25th… • Count Related: • Complete First Counts for Stock & Temps • Hash Count Sheets, Enter in PI Entry, Verify Hash • Enter Supplemental Sheets in PI Entry • Verify all Sheets are accounted for • All Staging Locations should have been pre-counted • This includes normal Staging Locations and FAB Locations

  40. Either Friday or Saturday . . . • Get EVERYONE out of the PI Count Entry screens and back to the Main Menu. • Run First Counts Complete (PIM,6) • Set Variance Ranges - $50.00 /.10% (PIM,11)

  41. Either Friday or Saturday . . . • Print the First Count Difference Report (PIM,10,3). Option to Print EITHER: • ‘Exception-Based’ Version (See Example below) P H Y S I C A L I N V E N T O R Y ================================================================================ FIRST COUNT DIFFERENCE/EXCEPTION REPORT Enter Branch Numbers separated by commas, A/ALL, E/END : 466 Print Exception Based Version of Report? (Y/N/E) : Y Page break (Y/N)? : Y Print first re-count sheets (Exceptions ONLY)? (Y/N/E) : Y # of copies : 2 Page break (Y/N)? : Y Enter Message (2 Lines, 30 Char Each): RECOUNT SHEET Message OK? (N/<RTN>):

  42. Physical Inventory • Recounts

  43. Saturday, June 26th…. • ‘Exception-Based’ version Recounts will be used: • All items must be recounted. • Only Items that meet the predetermined exception criteria will show up. • Staging Location Recount Sheets • Do not send these out for recounts. • Transfer over on hand balances to the Recount column.

  44. Exception-Based Re-Count sheets • Send these out for recounts. • If product is found in different places – write the number separately (110,5 not 115). P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 EXCEPTION-BASED RE-COUNT SHEETS LOCATION B01 Page 2 REF# ITEM# COUNT COUNT COUNT DESCRIPTION UM LOC ALT.LOC 20 PSHCOAU ___11_____ __________ __________ 6 PVC SWR HUB CO ADPT EA B01A03 21 PSSCAPP ___8_____ __________ __________ 4 PVC SWR SW CAP EA B01A04 22 PSSCAPU ___0_____ __________ __________ 6 PVC SWR SW CAP EA B01A05 27 PDWV9P ____3_____ __________ __________ 4 PVC DWV 90 ELL EA B01A11 28 PDWV9U ____1_____ __________ __________ 6 PVC DWV 90 ELL EA B01B01 ******************************** HASH TOTAL _____________ * FIRST RE-COUNT SHEET * * * INPUT BY _____________ ********************************

  45. Other Re-Count Sheets P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 EXCEPTION-BASED FIRST RE-COUNT SHEETSSp's W/OHB > Froz Stg Qty LOC PI.PRTFINAL.SHEET Page 95 of 100 REF# ITEM# COUNT COUNT COUNT DESCRIPTION UM 1854 DBPPEA53B12 __21______ __________ __________ 12 BLK PE A53B STD ERW SR C ******************************* HASH TOTAL _______ * FIRST RE-COUNT SHEET * * * INPUT BY _______ ******************************* P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 EXCPETION-BASED FIRST RE-COUNT SHEETAdditional Specials PI.PRTFINAL.SHEET Page 100 of 100 REF# ITEM# COUNT COUNT COUNT DESCRIPTION UM 1939 SP-VALVE77 __0_______ __________ __________VALVE77 EA ****************************** HASH TOTAL _____________ * FIRST RE-COUNT SHEET * * * INPUT BY _____________ ******************************

  46. Saturday, June 26th • Completed recount sheets in “in” box • Enter recounts to the First Count Difference report • Send items for 2nd (etc.) recount as needed • Determine Final Counts • Once FCD page is done, calculate Hash total • Enter counts into PI Count Entry as the Desired count • Verify all sheets are accounted for

  47. First Count Difference Exception Rpt • This is your Control Guide - Do not send out to the warehouse! • Notice the number of counts entered on the far-right • The ‘Cost-Diff’ column is based on the old PI Cost figure (lower of Master Average Cost and Branch Cost) P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTION LOCATION B01 PI.PRTFINAL.SHEET Page 2 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 20 PSHCOAU _____ 6 PVC SWR HUB CO ADPT EA ______ ______ 0 11 -11 -52.58 11,-11 21 PSSCAPP _____ 4 PVC SWR SW CAP EA ______ ______ 8 5 3 1.26 5,3 22 PSSCAPU _____ 6 PVC SWR SW CAP EA ______ ______ 16 12 4 6.12 12,4 27 PDWV9P _____ 4 PVC DWV 90 ELL EA ______ ______ 3 0 3 5.67 3 28 PDWV9U _____ 6 PVC DWV 90 ELL EA ______ ______ 1 0 1 10.42 1 ******************************** HASH TOTAL ____________ * FIRST COUNT DIFF RPT * * * INPUT BY ____________ ********************************

  48. Other Sections of First Count Diff Rpt P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTIONSp's W/OHB > Froz Stg Qty LOC PI.PRTFINAL.SHEET Page 95 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 1854 DBPPEA53B12 _____ 12 BLK PE A53B STD ERW C ______ ______ 0 21 -21 -60.05 ******************************** HASH TOTAL _________ * FIRST COUNT DIFFERENCE RPT * * * INPUT BY __________ ******************************** P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTIONAdditional Specials PI.PRTFINAL.SHEET Page 100 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 1939 SP-VALVE77 _____ VALVE77 EA ____ ______ 0 1 -1 -50.00 ******************************** HASH TOTAL ______________ * FIRST COUNT DIFFERENCE RPT * * * INPUT BY _________ ********************************

  49. Working the First Count Diff Rpt • Post the numbers from the Re-Count Sheet back • Your goal: to get two counts that agree – ie: Recount to First Count or Recount to OHB-STG. This may require additional re-counts (hence 2nd Re-count sheets). Highlight what to count & send out. • Only write a number in the FINAL column if the number that you want is different than the 1st-CNT • If 1st-Count > 0 and you want the FINAL Count to be zero, must enter 0 in the FINAL column • When sheet is complete, hash (total of “final” column) and enter (initial). P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTION LOCATION B01 PI.PRTFINAL.SHEET Page 2 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 20 PSHCOAU _11__ 6 PVC SWR HUB CO ADPT EA _11___ ______ 0 11 -11 -52.58 11,-11 21 PSSCAPP _√___ 4 PVC SWR SW CAP EA _8____ ______ 8 5 3 1.26 5,3 22 PSSCAPU _12__ 6 PVC SWR SW CAP EA _0____ _12___ 16 12 4 6.12 12,4 27 PDWV9P _√___ 4 PVC DWV 90 ELL EA _3____ ______ 3 0 3 5.67 3 28 PDWV9U _√___ 6 PVC DWV 90 ELL EA _1____ ______ 1 0 1 10.42 1 ******************************** HASH TOTAL __23________ * FIRST COUNT DIFF RPT * * * INPUT BY ___TLS____ ********************************

  50. Completing the Other Sections of the First Count Diff Rpt P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTIONSp's W/OHB > Froz Stg Qty LOC PI.PRTFINAL.SHEET Page 95 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 1854 DBPPEA53B12 __21__ 12 BLK PE A53B STD ERW C __21__ ______ 0 21 -21 -60.05 ******************************** HASH TOTAL ___21_____ * FIRST COUNT DIFFERENCE RPT * * * INPUT BY ___TLS____ ******************************** P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FIRST COUNT DIFFERENCE EXCEPTIONAdditional Specials PI.PRTFINAL.SHEET Page 100 of 100 REF# ITEM# FINAL DESCRIPTION UM RCNT-1 RCNT-2 1ST-CNT OHB-STG CNT-DIFF COST-DIFF FIRST-COUNTS 1939 SP-VALVE77 _√___ VALVE77 EA _0____ ______ 0 1 -1 -50.00 ******************************** HASH TOTAL ____√____ * FIRST COUNT DIFFERENCE RPT * * * INPUT BY ___TLS___ ********************************

More Related