Managing the Business

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: 

  1. 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?
How much we have sold in each product and region?

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:

  1. Expenses

    1. Grape Production

      1. Vineyard workers

        1. Salaries

        2. Taxes

        3. Insurance

        4. Clothing

      2. Grape Services

        1. Cosechadores

        2. Tractor Services

        3. Transportation (grapes to winery)

        4. Electricity

        5. Irrigation

        6. Limpieza de Cupo

      3. Grape Insumos

        1. Agrochemicals

        2. Guano

    2. Wine Production

      1. Wine Making

      2. Bottling

      3. Transportation (wine to winery wine storage in Mendoza, Winelock)

      4. Wine Insumos

        1. Bottles

        2. Cork

        3. Boxes

        4. Capsules

        5. Wax

        6. Labels

        7. Oak Barrels

        8. Jaula (cage)

      5. Wine Services

        1. Print labels

        2. Labeling

        3. Wine Storage Mendoza, Winelock

        4. Transportation Long Distance, Camionera Mendocina

        5. Wine Storage BsAs and Distribution

        6. Winery Representative: Analysis, Certifications, INV

        7. Customs Broker

        8. Wine Storage Spain, Andeswine

        9. OIA

        10. GS1

        11. NIC

        12. RUT

        13. INTA

        14. BARBAT

    3. MTB* Torrontés

      1. Wine Making Correas

    1. Administration, Financial, Legal, Design

      1. Accountant Fee

      2. Notary Fee

      3. Lawyer Fee

      4. Graphic Designer Fee

      5. MPA Vinos

      6. La Pera Limonera

      7. SMF Consulting

    2. Marketing and Communications

      1. Events, Tasting

      2. Concours

      3. Marketing and Communications Services

      4. Promotional Materials

  2. Sales

    1. Wine Sales

      1. Argentina

      2. Spain

      3. Brasil

      4. Uruguay

      5. U.S.A

Inventory

The Inventory Module should track the following stocks:

  1. Items

    1. Wine

    2. Insumos

    3. Promotional materials

    4. Tools and other assets

  2. Locations

    1. Costaflores Organic Vineyard

    2. Wine Storage Mendoza, Winelock

    3. Wine Storage Buenos Aires, MEM

    4. Warehouse Spain, Andeswine

Valuation

 

Master Data Management

Req ID

P

Definition

Owner

Req ID

P

Definition

Owner

1

1

The system should allow to manage the following master data information:

  • Products: Insumos, services (power, gas, ...) and Wine Bottles

  • Business Partners (Suppliers, Customers and Employees)

  • Document Types

  • Taxes

  • Currency conversion rates

 

1.1

1

The information for products is:

  • Pricing

  • Product categories

  • Accounting information

  • Product Type: Item, Services or Expense

  • Attributes: Lot, Expiration Date and Year of wine production.

  • Other OB optional and additional information

 

 

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):

  • Business Partner category

  • Accounting information

  • Financial information

  • Credit Management

  • Type: Employee, Customer or Supplier

  • Tax Category

  • Other OB optional and additional information

 

1.3

1

Document Types: Openbravo has to allow different document type management for each transaction (either sales or purchase transaction):

  • Purchase Order

  • Goods Receipt

  • Purchase Invoice

  • Sales Order

  • Sales Invoice

  • Goods Shipment

  • Other openbravo standard documents will be created for Payments In and Payments out

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:

  • Goods Shipment

  • Sales Invoice



 

1.4

1

The system will include all the Argentinian mandatory taxes for Costaflores S.A. The most used taxes will be, for Sales:

  • IVA 21%

For Purchase:

  • IVA 21%

  • Percepción (IIBB, IVA, SUS, depending on the supplier)

 

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):

  • 6 bottles of wine mtb 18: 600 pesos

    - 6 tokens mtb 18: -600 pesos

    Logistics services: 100 pesos

    TOTAL: 100 pesos

 

More info about the implicit requirements met by openbravo: http://wiki.openbravo.com/wiki/Master_Data_Management

Sales Management 

Req ID

P

Definition

Owner

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:

  • Customers

  • Products and stocks

  • Orders

  • Payments

  • Invoices

 

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:

  • Return sales order

  • Negative goods shipment

  • Credit Note

 

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:

  1. Sales Order for X "Token product" in the e-commerce site or manually introduced in Openbravo.

  2. Sales Invoice is issued for the customer with the corresponding taxes

When a user wants to burn their tokens:

  1. Sales Order for X wine bottles manually introduced in Openbravo (Phase 2: Integration with Magento and acceptance of MTBs as payment method)

  2. A line for the shipment cost will be added

  3. A discount will be added to the order -X "Token Products" (Phase 2: Crete a process to add this discount and set the applied tokens as burned)

  4. The user will pay only for the shipment service.

  5. Manually create the shipment linked to the Sales Order

  6. Create an invoice linked to the Shipment and Order

 

2.9.3

1

Sales flow for international sales (excluding USA) will be:

  1. Sales Order for X "Token product" in the e-commerce site or manually introduced in Openbravo.

  2. Sales Invoice is issued for the customer with the corresponding taxes (Usually Tax exempt)

When users want to burn their tokens: