COMPANY ADDRESS
SR NO……………..
DATE…………………………………………….
FROM…………………………………… TO………………………………………..
MANAGER/STORE OFFICER GENERAL MANAGER/MANAGING DIRECTOR
SIGN………………………………………
| BRAND DETAILS | STANDARD STOCK | AVERAGE SALES | CURRENT STOCK | DURATION IN STORE | ORDER QTY | UNIT PRICE | UNIT AMOUNT |
| SUB TOTAL | |||||||
| DIRECTOR’S COMMENT………………… | TAX RATE | ||||||
| …………………………………………………… APPROVAL……………………………… | SALES TAX | ||||||
| FREIGHT | |||||||
| …………………………………………….. | OTHER | ||||||
| ORDER TOTAL | |||||||
HOW TO USE THE TABLE
Record the brand details
STANDARD STOCK=sum (6-day brand sales)
6 days
AVERAGE SALES=cumulative monthly sales
Total number of days’ cover
Record the current stock (closing stock) and from date received, determine the duration the stock has taken in the store. Generate your order quantities.
ORDER AMOUNT=ORDER QUANTITY X UNIT/COST PRICE
Add taxes, freight cost and other costs to order amount to get the overall total order amount.
