Standard Costing with Wine Stages

A wine stage can represent workflow states such as when wine is being produced, maturing, or ready for bottling/bulk sale. In vintrace, you can define wine stages by vintage and use a date range to determine the standard cost rate to use.

Because wine stages have settings that are program-specific, you can add and edit them by editing the relevant program from the Winery Setup window (Setup Options > Work-flow > Programs). Be sure to select the Wine Stages tab in the Update Program/Brand window.

The fields in the Wine Stages tab are described below:

• Stage Name — A name for the stage.
• Vintage — The production year of the wine that the wine stage rule applies to.
• Std Cost — The standard cost for the wine stage/period.
• Recovery Amt — The standard cost recovery rate. This allows you to see the wine’s value change as it moves from one stage to another.
• From/To — The date range the wine stage is applicable for.
• Sequence — This determines the order of the wine stages for the vintage.
• Final — Indicates if the wine is dispatched, or bottled. The amount that leaves the facility should apply the standard cost rates up until this wine stage.

You can replace the existing wine stages with wine stages from another program/brand. To do this, click the  beside the Copy From field to search for the program that you want to copy the stages from. 

You can view the standard costs for wines in your system by running the Standard Cost Activity Report. 

If you have the Advanced Bulk Wine Purchasing option enabled, you can specify the wine stage of a bulk wine you’re purchasing. Contact our support team to have this option enabled.

If the bulk wine you’re purchasing is recorded at a different wine stage than the one it should be based on, you can run the Bulk Stock Fiscal Receipt Report. This report compares the wine’s standard cost on the date it was received to the standard cost for the wine stage that it was purchased.

Standard Cost Activity Report

You can view the standard costs for wines in your system by running the Standard Cost Activity Report. This report lets you apply filters (e.g., on one or more programs) and generates a spreadsheet of a wine’s effective costs at different stages.

You can take a snapshot of each wine’s volume for the date range by setting the report’s Trial/Final filter to Final. The next time you run the report, it compares the opening balance to the last report’s closing balance. It also details any volume changes that may have occurred due to backdated work orders.

To run the Standard Cost Activity Report:

1. Click  Reports in the sidebar.
2. Select Bulk Wine.
3. Scroll down to the Standard Cost Activity Report.

4. Specify the filters for the report.
5. Click Generate or Email.

Bulk Stock Fiscal Receipt Report

The Bulk Stock Fiscal Receipt Report compares the wine’s standard cost on the date it was received to the standard cost for the wine stage that it was purchased.

To run the Bulk Stock Fiscal Receipt Report:

1. Click  Reports in the sidebar.
2. Select Inventory.
3. Scroll down to the Bulk Stock Fiscal Receipt Report.

4. Specify the filters for the report.
5. Click Generate or Email.