[go: up one dir, main page]

0% found this document useful (0 votes)
617 views3 pages

Monthly Product Inventory Template

The document is a monthly product inventory reconciliation form used to track inventory levels of a product stored in a tank. It records the opening physical inventory, additions and removals of product, and closing physical versus book inventory. Any discrepancies between the actual and allowable over/short amounts must be investigated under the company's procedures. Unexplained variances over a certain threshold must be reported immediately.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
617 views3 pages

Monthly Product Inventory Template

The document is a monthly product inventory reconciliation form used to track inventory levels of a product stored in a tank. It records the opening physical inventory, additions and removals of product, and closing physical versus book inventory. Any discrepancies between the actual and allowable over/short amounts must be investigated under the company's procedures. Unexplained variances over a certain threshold must be reported immediately.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 3

PRODUCT INVENTORY MONTHLY RECONCILIATION FORM

tation Address: Month/Year: Product:


Date Stick A B C D E F G H Inches Inches
reading Opening Gross Metered Total Closing Closing Daily Over/Short of of
to the Physical Gallons Non Daily Book Physical Over (+) Cumulative Water Water
1/8" Inventory Loaded Sales Metered Inventory Inventory or Total In In
(N/A if (Prior Sales (A+B+C-D) Short (-) Tank Tank
electronic Day's (F-E) (electronic (manual
tank gauge Closing gauge) stick)
is used) Physical)

1 0 0 0

2 0 0 0 0

3 0 0 0 0

4 0 0 0 0

5 0 0 0 0

6 0 0 0 0

7 0 0 0 0

8 0 0 0 0

9 0 0 0 0

10 0 0 0 0

11 0 0 0 0

12 0 0 0 0

13 0 0 0 0

14 0 0 0 0

15 0 0 0 0

16 0 0 0 0

17 0 0 0 0

18 0 0 0 0

19 0 0 0 0

20 0 0 0 0

21 0 0 0 0

22 0 0 0 0

23 0 0 0 0

24 0 0 0 0

25 0 0 0 0

26 0 0 0 0

27 0 0 0 0

28 0 0 0 0

29 0 0 0 0

30 0 0 0 0

31 0 0 0

Monthly Throughput = 0 Actual Month Total 0


Over/Short

The total allowable over/short for one (1) month = (.01 x Monthly Throughput) + 130 gallons

= 130 ** See reverse for information on


investigating and reporting inventory
discrepancies

SH Reference Book Version 1, 4/00 R E 1-3.2


Reverse Side of Form

Step Monthly Inventory Reconciliation


Calculate the allowable over/short figure, and compare it to the actual over/short
figure. If the actual over/short figure is larger than (+ or -) the allowable over/short
1 figure, complete the following steps:
Immediately notify the Sales Consultant, who will review the subject months inventory
2 records. This notification should be documented below.
Check for math errors and bad stick readings.
*** If an error is corrected in the inventory records and, as a result, the subject
inventory variance is explained and resolved, no further action is required. However, you
must complete the remaining step if:
there was no detectable error in the inventory records,
or
you found an error and corrected it, but the actual over/short amount is still larger
than the allowable over/short amount.

3 Check existing monitoring systems for alarm conditions

Immediately notify the SH&E Compliance Coordinator that you have an unexplained
monthly inventory variance in excess of 1% + 130 gals of sales. This notification should
4 be documented on the lines below.

The SH&E Compliance Coordinator will promptly initiate a same-day investigation of the
reported variance, and take any necessary follow-up actions. The investigation should
5 consider the types of factors listed in the SH&E Release and Reporting Procedures.

Note: For further guidance, refer to the Fuel Inventory Variances Info Sheet (E 1-5) in
the SH&E Reference Book ("Blue Book"). These are Company guidelines. Your state or
local UST agency may enforce additional or more stringent requirements, with which
you are obligated to comply.

Documentation of Notification to the Company and Investigative Steps for


Unexplained Inventory Discrepancies
Document all actions taken to investigate suspected releases and/or unexplained
inventory discrepancies. Write your comments below, including the date and steps
taken to correct the problem.

Date: Action:

Date: Action:

Page 2
Reverse Side of Form

Date: Action:

Page 3

You might also like