Virtual Business Systems
Production control and Financial Forecasting for Your Company
|
Virtual Business Systems Production control and Financial Forecasting for Your Company |
|
The VIRTUAL Winery is actually two programs - a production component and a financial component. The Production component forecasts sales, cost of sales and inventory movement in dollars, gallons and cases. Information from the production component is transferred to the financial component. The financial component includes the capital budget, headcount and payroll calculations, departmental operations, profit and loss, cash flow, balance sheets and summery financial information. List Features included with Production component: · All costs, sales and barrel usage are computed monthly for up to 2,000 "products" for 10 years (120 months). A product represents a wine type for a single vintage year- e.g. 2005 Chardonnay. Graphs are generated showing monthly results for the first 60 months. · Sophisticated workbook navigation system. Data entry, report printing, processing and system functions are selected from a menu system. · Complete flexibility in entering product data. The seasonal sales percentages, sales channel allocation, sales prices, cost components, and blends can be “Fine Tuned” for each product. It is easy to replicate data for similar products, link data from other workbooks, or use Excel formulas to compute annual percentage changes, etc. · Scenario management - the model database can be saved, recalled or Emailed for review and/or modification. A description is entered for each scenario so that file can be easily identified for recall. Scenario files are maintained on a separate data directory on your network drive. · Product data can also be entered into an Excel Product Template then automatically posted to a scenario file for up to 15 years (5 inventory vintages and 10 production vintages) · Products can be a blended from 9 sources - 3 vineyard, 3 grape purchase and/or 3 bulk purchases. · “Free-run” juice or juice left with the leeds in a post fermentation gravity feeding process (often totaling as much as 20% of the crush) is now included in the costing calculations. · Simplified wine calendar to identify crop, cellar, bulk wine purchases, bottle aging and sales periods. · An Audit Cube is included with the Verification Summary which allows the user to “drill down” on the forecast results by product and line item. This saves time when investigating model anomalies (e.g. Which product contributed to a large increase in bottled goods inventories?) · The 120 month production forecast from the VW Monthly Production Program can be transferred to the VW Monthly Financial module; or, it can be easily copied to your winery’s forecasting model. When transferred to the VW Monthly Financial module, the production forecast is adjusted for your winery’s FYE and annual totals are computed. The user can elect to show monthly or only annual totals for each fiscal year at the time the data is transferred.
Financial Component Sales and Inventory data is transferred from the Production component to the Financial component (see flow chart below). The VWfinancial.xls workbook includes the capital budget, head count & payroll data, financing information and cash flow computations. This information is used to generate complete financial statements including Operations, Cash Flow and Balance Sheets for the 10 year forecast period. The user can determine which years to show monthly data, and which years to show only annual totals (e.g. first five years monthly and next five years annual). The financial component is an Excel workbook and can be easily customized to match the clients financial structure. The system also includes an automated budgeting system that can forecasts costs for 120 months based on up to 35 parameters such as total sales, bottling payroll, percentage of another line item, gallons in production etc.
The Next Step Review the documentation. If you think that this sort of planning needs to be implemented at your winery, download the program, install it on your computer and review the slide show ( Presentation1.ppt ). Also, feel free to contact me (415-905-0347) for a quick demonstration. One of these days I'll develop a video and post it to the site, but for now we will do it the "old fashion way". Download the VIRTUAL Winery V3 The VIRTUAL Winery is actually two programs - a production component and a financial component. The Production component forecasts sales, cost of sales and inventory movement in dollars, gallons and cases. Information from the production component is transferred to the financial component. The financial component includes the capital budget, headcount and payroll calculations, departmental operations, profit and loss, cash flow, balance sheets and summery financial information. List Features included with Production component: · All costs, sales and barrel usage are computed monthly for up to 2,000 "products" for 10 years (120 months). A product represents a wine type for a single vintage year- e.g. 2005 Chardonnay. Graphs are generated showing monthly results for the first 60 months. · Sophisticated workbook navigation system. Data entry, report printing, processing and system functions are selected from a menu system. · Complete flexibility in entering product data. The seasonal sales percentages, sales channel allocation, sales prices, cost components, and blends can be “Fine Tuned” for each product. It is easy to replicate data for similar products, link data from other workbooks, or use Excel formulas to compute annual percentage changes, etc. · Scenario management - the model database can be saved, recalled or Emailed for review and/or modification. A description is entered for each scenario so that file can be easily identified for recall. Scenario files are maintained on a separate data directory on your network drive. · Product data can also be entered into an Excel Product Template then automatically posted to a scenario file for up to 15 years (5 inventory vintages and 10 production vintages) · Products can be a blended from 9 sources - 3 vineyard, 3 grape purchase and/or 3 bulk purchases. · “Free-run” juice or juice left with the leeds in a post fermentation gravity feeding process (often totaling as much as 20% of the crush) is now included in the costing calculations. · Simplified wine calendar to identify crop, cellar, bulk wine purchases, bottle aging and sales periods. · An Audit Cube is included with the Verification Summary which allows the user to “drill down” on the forecast results by product and line item. This saves time when investigating model anomalies (e.g. Which product contributed to a large increase in bottled goods inventories?) · The 120 month production forecast from the VW Monthly Production Program can be transferred to the VW Monthly Financial module; or, it can be easily copied to your winery’s forecasting model. When transferred to the VW Monthly Financial module, the production forecast is adjusted for your winery’s FYE and annual totals are computed. The user can elect to show monthly or only annual totals for each fiscal year at the time the data is transferred.
Financial Component Sales and Inventory data is transferred from the Production component to the Financial component (see flow chart below). The VWfinancial.xls workbook includes the capital budget, head count & payroll data and cash flow computations. This information is used to generate complete financial statements including Operations, Cash Flow and Balance Sheets for the 10 year forecast period. The user can determine which years to show monthly data, and which years to show only annual totals (e.g. first five years monthly and next five years annual). The financial component is an Excel workbook and can be easily customized to match the clients financial structure. The system also includes an automated budgeting system that can forecasts costs for 120 months based on up to 35 parameters such as total sales, bottling payroll, percentage of another line item, gallons in production etc.
The Next Step Review the documentation. If you think that this sort of planning needs to be implemented at your winery, download the program, install it on your computer then contact me (415-905-0347) for a quick demonstration. One of these days I develop a video and post it to the site, but for now we will do it the "old fashion way". |
Copyright Virtual Business Systems, LLC 2005 The Future and Reality - Let Us HELP YOU Close the Gap |
