Value of stock loss is calculated from actual retail price and variance based on actual shots sold. (Actual Purchase Cost (AP) - Actual Spending Allowance (AC)) / 1 - Growth Profit % (GP) / Growth Profit % (GP) + (Actual Purchase Cost (AP) - Actual Spending Allowance (AC) Net Revenue Surplus is the amount you are left with after taxes and other obligations. Actual Net revenue is more than the Actual Net Revenue. Please note that this is exclusive of sales tax. Since we are managing stock taking on per week basis, Monthly Net Revenue is the sum of Actual Net Revenue every week. How to calculate Monthly Net Revenue (NR), Net Revenue Surplus, and Value of Stock Loss? If you do not require to perform inventory counts with monthly frequency, you can use this very spreadsheet for other periodic inventory counts and analyses. Uses the same very principals as pro version, except that if you have more than one delivery per month, you would need to add cumulative quantities of the stock into the Purchases column. The modified version of the Beverage Stocktake template, suitable for performing monthly inventory counts instead of doing so weekly.
Unlocked - so that you can customize it just a little more.You can also see the entire overview of your beverage stock on one page at any point of time in a month. You will have accurate stock take figures every week. This template gives you the exact variance by key lines of beverage inventory.
This is a very simple and easy to use template hence training of your team members on "How to take the stock?" can be done easily. We recommend taking the stock at the same time/same day. Once everything is recorded, you are ready for recording the opening stock and tracking stock movement, week by week.
This template gives you the flexibility of establishing the correct measure of your stockline by defining the "Unit". You can record the Unit of Measure, volumes and sizes for all type of alcoholic and non-alcoholic drinks.Īfter this, create inventory list which includes entering the beverage name, package details, single unit volume, unit of measure, cost per bottle, per shot and retail price per shot and per bottle. Begin with setting up your company, this template allows you to set country specific tax rate, currency.
0 kommentar(er)
