1 / 60

Physical Inventory Prep & Inventory Weekend

Physical Inventory Prep & Inventory Weekend. FFF Branches – January 2009. Overall FFF PI Process. PI will be the weekend of January 23 rd – 25 th . FBV’s will be at specified locations to assist with the PI Process day of inventory.

hada
Download Presentation

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 – January 2009

  2. Overall FFF PI Process • PI will be the weekend of January 23rd – 25th. • FBV’s will be at specified locations to assist with the PI Process day of inventory. • FBV’s to provide Trilogie Guidance with Reports and how the Trilogie process works. • FBV’s should not “Run” the PI. • FBV’s should not be counting inventory. • FBV’s should coordinate with the branch when to arrive. • Arrive prior to when the counts begin. • Completion of the J-1 Schedule is required prior to the FBV leaving for the weekend. • E-mail to Dave Hill when complete.

  3. High-Level Timeline • On-goingClean up your files • January 1th thru 21stVerify “Staging Locations” Yard Counts for Approved Locations – Dave Hill • January 21stCreate PI File, Print Count Sheets • January 23rd and 24thCount, Enter, Recount, Enter • January 25thUpdate On-Hand Balances • January 26th Conduct Business & Make Corrections

  4. 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

  5. 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)

  6. 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)

  7. Specials on Hand Rpt • 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: • July 31, 2008

  8. Early 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 ===================================================================================================================================

  9. 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

  10. Inventory Prep: Ongoing • Purchasing: • Review open Purchasing Transactions • Clean Open Purchase Order Report (4,10,1,1) • January 16th 2009 • Ensure Receivings, Debits, Dist/Pipe RFCs are current

  11. The Week of January 12th • 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

  12. The Week of January 19th • 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 20th, 2009 • Maintain this ticket throughout inventory, delete from system after inventory when DRR is approved and official ticket created by system

  13. The Week of January 19th • Finish all aisle location changes, loadprod, status changing, product exchanges, etc. • These must be done before you create your Stock & Temp PI file (most locations do this Tues/Wed of inventory week)

  14. Prepare layout of warehouse and yard, devise teams, schedule tasks Organize warehouse, pipe yard, office and file areas The Week of January 19th Count Sheets R1 Bill & Ted

  15. January 19th & 20th • Contact customers and expedite shipments • Staged Products by writer Rpt 4,10,1,20,1,3, BCM-PROM-7

  16. January 19th & 20th • 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 Saturday closing - counters • Work the Unbilled Interbranch Transfer Report (1,3,3,10)

  17. Wednesday, January 21st • 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)

  18. Wednesday, January 21st • 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:

  19. Wednesday, January 21st • 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>):

  20. Thursday, January 22nd • 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)

  21. Friday, January 23rd • Reminder: Automated Night-End will NOT run. • Close all warehouses by 5:00 pm 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.

  22. Physical Inventory: • First counts

  23. Friday, January 23rd • 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 webcast (i.e.: Friday instead of Saturday; Saturday instead of Sunday) – it’s the sequence that matters!

  24. Friday, January 23rd - Morning • Fabrication Work In Process • WE DON’T WANT ANY W.I.P.!!! Bill it out! • 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. • Assign Staging Location of FAB in LOC for all pulled material.

  25. Friday, January 23rd… • 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.

  26. 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______ ********************************

  27. 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:

  28. 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

  29. 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:

  30. Friday, January 23rd… • 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)

  31. Friday, January 23rd… • 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

  32. Friday, January 23rd… • 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.

  33. Friday, January 23rd… • 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.

  34. Friday, January 23rd… • 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)

  35. Friday, January 23rd… • 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

  36. 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 - $75.00 / 15% (PIM,11)

  37. 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>):

  38. Physical Inventory • Recounts

  39. Saturday, January 24th…. • ‘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.

  40. 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 _____________ ********************************

  41. 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 _____________ ******************************

  42. Saturday, January 24th • 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

  43. 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 ____________ ********************************

  44. 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 _________ ********************************

  45. 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____ ********************************

  46. 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___ ********************************

  47. Inventory Weekend: Saturday Final Count Entry (PIM,3) • P# and PE# toggle between the Regular and Exception-based views. • Initially the far-right hand column will be all zeros – don’t panic. System will assume you want to keep the First Count unless you tell it otherwise. • For Final Count Entry, ENTER THE NUMBER YOU WANT (not a +/- to First Count!) • Counts will move to the right (cumulative count column) - after you enter the desired number, if you need to make corrections, then (and only then) use + and -. 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 23 REF# ITEM# COUNT2 DESCRIPTION TOTAL 20 PSHCOAU __11__________ 6 PVC SWR HUB CO ADPT 0 21 PSSCAPP ______________ 4 PVC SWR SW CAP 0 22 PSSCAPU __12__________ 6 PVC SWR SW CAP 0 27 PDWV9P ______________ 4 PVC DWV 90 ELL 0 28 PDWV9U ______________ 6 PVC DWV 90 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:

  48. Saturday 24th… • Run Final Counts Complete (PIM,7)

  49. Physical Inventory: • After counts are final; reports

  50. Inventory Weekend: Saturday • Run the Final Count Difference Report (PIM,10,4) • Report will be requested in Exception Based mode sorted by Countsheet • Review for needed corrections to final counts • Only reprint Final Count Difference detail if significant changes were made • Use this to complete audit workbook tab Schedule J-1 . P H Y S I C A L I N V E N T O R Y BRANCH NUMBER 466 FINAL COUNT DIFFERENCE REPORT PI.DIFF.RPT EXCEPTION BASED VERSION LOCATION B01 Page 2 REF# ITEM# UM COUNT PI-COST PI-EXT OHB-STG CNT-DIFF EXT-DIFF 21 PSSCAPP 4 PVC SWR SW CAP EA 8 1.26 10.08 5 3 3.78 This Report includes Specials

More Related