Back-dating Inventory Worksheet
MONTH: |
LOCATION: |
CATEGORY |
A. Retail on date inventory taken |
B. Retail sales since EOM |
C. Add A and B. |
D. Retail-to-cost multiplier |
E. Multiply C by D. |
F. Enter purchases since EOM |
G. Subtract F from E. This is the back-dated inventory. |
CIGARETTES |
|
|
|
85% |
|
|
|
BEER |
|
|
|
75% |
|
|
|
VENDING |
|
|
|
60% |
|