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