Managing the Business
How much does it cost to make and sell a bottle of wine? How much is earned or lost?
In this section we implement an online open-source Enterprise Resource Planning (ERP) platform.
Essentially, we want to build an online platform where anyone can view:
How much money are we earning from selling wine, winecoins, and other services? How much money do we spend to produce our wine?
What is our inventory?
What is the current valuation of the company?
This section defines the functional and systemic requirements for an online, open-source ERP (enterprise resource planning) platform to cover the following modules:
Accounting
Inventory
How much money are we earning from selling wine, winecoins, and other services?
Where are we selling?
How is this managed in different currencies?
What are consumers paying for our wine in shops (not buying winecoins)?
How much money do we spend on:
Grape Production: Farmers, chemicals, tractors, irrigation, taxes, fuel, harvesters; .
Wine Production: Wine making, bottles, corks, capsules, boxes, labels;
Logistics: Moving bottles from A-to-B, cold storage;
Administration: Accounting: day-to-day management, legal expenses;
Marketing and Communications: Maintaining our presence online, and telling the story;
Financial Costs.
How much does it cost for us to produce a bottle of wine (for each vintage), considering:
Production cost
Cost changes over time (recurring costs of cold storage)
Effects of inflation and currency value fluctuations over time
What is our inventory?
Wine in bottles, at different storage locations
Wine (litres) in the winery
Fungible materials: boxes, labels, capsules, corks
Chemicals
Tools
What is the current valuation of the company?
Stock valuation
Asset valuation
We can begin by defining the types of reports that we would like to share with the world, and work backwards from there:
Custom Reports
Req ID | P | Definition | Owner | Notes |
3.1.1 | 1 | The site visitor should be able to access a report which summarizes our sales figures: What we are selling (winecoins, wine, other items)? Where are we selling? | Mr. Sinatra |
|
3.1.2 | 1 | Present visitors with a detailed expense report broken down into the following categories: | Mr. Sinatra |
|
3.1.3 | 1 | Production cost | Mr. Sinatra |
|
3.1.4 | 1 | Inventory | Mr. Sinatra |
|
3.1.5 | 1 | Company evaluation | Mr. Sinatra |
|
Accounting
The accounting platform should track the following ledger items:
Expenses
Grape Production
Vineyard workers
Salaries
Taxes
Insurance
Clothing
Grape Services
Cosechadores
Tractor Services
Transportation (grapes to winery)
Electricity
Irrigation
Limpieza de Cupo
Grape Insumos
Agrochemicals
Guano
Wine Production
Wine Making
Bottling
Transportation (wine to winery wine storage in Mendoza, Winelock)
Wine Insumos
Bottles
Cork
Boxes
Capsules
Wax
Labels
Oak Barrels
Jaula (cage)
Wine Services
Print labels
Labeling
Wine Storage Mendoza, Winelock
Transportation Long Distance, Camionera Mendocina
Wine Storage BsAs and Distribution
Winery Representative: Analysis, Certifications, INV
Customs Broker
Wine Storage Spain, Andeswine
OIA
GS1
NIC
RUT
INTA
BARBAT
MTB* Torrontés
Wine Making Correas
Administration, Financial, Legal, Design
Accountant Fee
Notary Fee
Lawyer Fee
Graphic Designer Fee
MPA Vinos
La Pera Limonera
SMF Consulting
Marketing and Communications
Events, Tasting
Concours
Marketing and Communications Services
Promotional Materials
Sales
Wine Sales
Argentina
Spain
Brasil
Uruguay
U.S.A
Inventory
The Inventory Module should track the following stocks:
Items
Wine
Insumos
Promotional materials
Tools and other assets
Locations
Costaflores Organic Vineyard
Wine Storage Mendoza, Winelock
Wine Storage Buenos Aires, MEM
Warehouse Spain, Andeswine
Valuation
Master Data Management
Req ID | P | Definition | Owner |
|---|---|---|---|
1 | 1 | The system should allow to manage the following master data information:
|
|
1.1 | 1 | The information for products is:
|
|
1.1.1 | 1 | Pricing: Price List Management: the system has to provide mechanisms to easily update prices based on price list schemes and also allow manual modifications. |
|
1.2 | 1 | The information for Business Partners (Customers, Suppliers and Employees):
|
|
1.3 | 1 | Document Types: Openbravo has to allow different document type management for each transaction (either sales or purchase transaction):
Every document type will have the standard printing design offered by Openbravo or Argentina Localization module. Only the following document types will be customizable if needed:
|
|
1.4 | 1 | The system will include all the Argentinian mandatory taxes for Costaflores S.A. The most used taxes will be, for Sales:
For Purchase:
|
|
1.4.1 | 1 | Taxes will be automatically calculated by the system for every transaction |
|
1.5 | 1 | Openbravo supports manually management of currency conversion rate between all the currencies |
|
1.5.1 | 2 | Automatically get the conversion rate from a web service (ApiLAYER) |
|
1.6 | 1 | The price of the tokens by default will be 1 but in each sales order it will vary depending on the value of the token at the moment |
|
1.7 | 1 | The price of the wine bottle will be fixed and a token will be rewarded, that is, burning a token implies a bottle price of 0, thus leaving an invoice with the following lines (example with 6 units):
|
|
More info about the implicit requirements met by openbravo: http://wiki.openbravo.com/wiki/Master_Data_Management
Sales Management
Req ID | P | Definition | Owner |
|---|---|---|---|
2 | 1 | The system has to cover the whole sales process from order to cash |
|
2.1 | 1 | The system has the ability register quotations and to transform quotations into sales orders |
|
2.2 | 1 | The system has to have the ability to ship the sold goods to the customer |
|
2.3 | 1 | The system has to allow the user to bill for the goods shipment or the sales order partially or totally. The user can decide when to create the invoice manually if it is not downloaded from the e-commerce |
|
2.4 | 1 | The system has to be integrated with Magento commerce |
|
2.4.1 | 1 | The system has to allow the integration, at least, for the following entities:
|
|
2.4.2 | 1 | Openbravo will be synchronized with Magento based on background processes scheduled in the right order. |
|
2.5 | 1 | Sales invoice has to be sent to AFIP using the official webservices |
|
2.6 | 1 | The system has to meet all the official requirements set by AFIP (Argentinian authorities) |
|
2.7 | 1 | The system allows to manage payments manually or automatically depending on the payment method and if the sales order comes from magento |
|
2.8 | 1 | The system will allow returns from customers that will follow the opposite flow of a natural sales and will generate the following documents:
|
|
2.9 | 1 | The System has to allow sales in several currencies and cryptocurrencies (BTC, ETH, MTB18, MTB 19, etc.) |
|
2.9.1 | 1 | Tokens will be sold as explained in the following flows: |
|
2.9.2 | 1 | The sales flow for national (Argetina) sales will be:
When a user wants to burn their tokens:
|
|
2.9.3 | 1 | Sales flow for international sales (excluding USA) will be:
When users want to burn their tokens: |