Producing Beer, Wine, CNY

BRAVO software solution (ERP-VN) applied at enterprises in the field of BEER, WINE, Beverage is a total management solution.

Software overview

Special problem

Software solutions

Application efficiency

Typical customers

I. SOFTWARE OVERVIEW

BRAVO (ERP-VN) software solution applied at enterprises in the field of BEER, WINE, BEVERAGE PRODUCTION is a total management solution, supporting leaders in the management of all resources of the enterprise (human – financial – material) as well as effective assistants for departments from Sales, Purchasing, Accounting to Production Management , Administration – Human Resources… in order to share information effectively through the standard workflow process when surveying and designing software according to the characteristics of the Beer, Wine, Beverage industry. .

Parts use together on a software system in a closed process, allowing data linkage and inheritance between parts (the output data of this part is input data of another department) to serve the management and support business operations for each department quickly and accurately in order to maximize production and business efficiency.

II. READING PROBLEM OF BEER, WINE, Beverage MANUFACTURERS

1. Overview of specific characteristics of beer, wine and beverage production enterprises

a. General

Food and Beverage (Beer – Wine – NGK) industry in Vietnam has been around for a long time but develops faster in over the past decade, on the basis of:

– The State’s policy of renovation and opening-up.

– Rapid economic growth, needs and living standards of population improved.

– International tourism and FDI increased sharply.

b. Achievement

– Many new production facilities were built with modern equipment and technology.

– Producing a wide range of high quality products.

– Having made great contributions to the State budget.

– Step by step meeting meet consumer needs.

c. Opportunities and challenges

– The beverage industry has been invested heavily and has had a good growth rate in recent years.

– Vietnam’s consumption power is getting stronger and stronger. Large market, young and dynamic population structure. Consumers, especially young people, are quite sensitive, receptive and knowledgeable about brands.

– Vietnam is one of the fastest growing economies in Asia in recent years. Recently.

– The increasingly fierce competitive pressure in the NGK industry is the driving force for a dynamic market and stimulates development.

– Increasingly competitive increased through Vietnam’s accession to WTO (2007), becoming a member of ASEAN AEC (2015), TPP was signed.

– Market barriers and trade restrictions were eliminated. phased out, better access to capital and foreign markets.

– Large domestic market, low labor costs, and strong equitization of SOEs.

– The tourism industry is well developed and the opportunities for export market development are increasing.

2. Scope and operating procedures for software systems

Operating steps:

(1) Sales Department receives orders from customers and coordinates with the Factory to conduct production to keep up with the agreed delivery schedule.

( 2) Factory proposes raw materials, receives materials from warehouse, conducts warehousing after production is completed and production statistics: raw materials, semi-finished products, finished products, man-hours, efficiency, productivity…

(3) Purchasing department purchases and stores goods to meet demand at individual parts, optimal inventory needs, and production needs.

(4A,B) Sales of salespeople and the production output of workers at the Factory are gathered at the Administration – Human Resources Department to calculate salary.

(5A,B,C,D)

strong> Data from departments is shared and inherited at the Finance – Accounting Department to perform the management of revenue, liabilities, expenses…

3. Describe some specific business processes

BUSINESS DEPARTMENT

– Management, store customer information

– Track sales price list by item, applicable unit (member company, customer) and time of application

– Make sales orders, sales orders to transfer to the Warehouse Department for shipment , Items, Quantity

– Manage sales policies applicable to units and distributors

– Track sales and payments

Purchase Department

– Manage and store supplier information

– Manage domestic and imported purchases materials, chemicals, oil, ink…

– Make a detailed purchase plan for each material

– Search, evaluate and choose a home offer

– Margin tracking to open L/C for purchase >- Track delivery progress and liabilities

– Manage expiry dates of shipments

– The calculation program provides a report of material needs to support users make timely and reasonable purchasing decisions.

WAREHOUSE PARTS

– Manage supplies and finished products by code, according to warehouse

– Manage batch details, expiry date of each material, finished product

– Manage finished product packaging:

Export warehouse, import warehouse
According to the order notice
Vehicle code, license plate

– Manage the deposit of bottles or of customers send and handle damaged cases

PRODUCTION PARTS

– The data is separated by stages at the extraction workshop, workshop and rotate according to the production process.

– Make a detailed, weekly production plan (production machine, production shift…)

– Statistics on the quantity of semi-finished and finished products in the period

– Tracks the loss of production materials.

SHIPPING DEPARTMENT

– Inheriting sales order information from the Sales Department

– Building a price list for self-delivered or outsourced vehicles

– Manage goods delivered according to orders: Vehicle number, Driver, Goods name, Quantity…

– Check status and coordinate delivery vehicles, identify and process in the following forms:

Outsourced car : Put down the invoice and arrange it yourself
Customers transport themselves
Company car: Segmentation by district/district empty enter bets or borrow shells.

FINANCE – ACCOUNTING DEPARTMENT

– Make and track revenue and expense plans

– Cash management/bank deposits

– Management accounts payable/receivable

– Inventory accounting

– Management of fixed assets and tools

– Calculation into the production of beer, beverage, alcohol, wine: Specific plan for multiple stages of cost aggregation by each product

– General accounting

– Report Financial and Tax Reporting according to current regulations

administrative department – HUMAN RESOURCES

– Manage personnel records of sales team, marketing:

Resume information
Employment contract
Decisions on reward and discipline

– Declare the formula to calculate the actual salary according to each position level: Sales Manager, Sales, Marketing Manager, Marketing.

III. BRAVO SOFTWARE SOLUTION^® AT BEER, WINE, Beverage MANUFACTURERS

1. Software installation model

BRAVO (ERP-VN) solution can support 02 different software installation models: installation model centralized data model (Online – online connection) and distributed data model (Offline – periodic synchronization). However, based on experience, enterprises operating in the field of beer, wine and beverage production are often dispersed in many locations (offices, processing plants, packaging factories, etc.) ), the function that works in each place is also different. BRAVO builds a data system that needs to ensure optimal data flow in accordance with the organizational structure of the enterprise, strictly control it so that the business process can operate correctly and conveniently, therefore, BRAVO will implement the centralized data installation model (Online).

– On the server (Server) will be installed the BRAVO Software including Software Program and Database.

– The data will be partitioned into basic units: Head Office, Factory, Subsidiaries. The software supports to make separate financial statements and tax reports for each unit.

– The function of adjusting the exclusion of internal accounts and merging data helps administrators to view the consolidated financial statements of the whole company.

FACTORY. /Subsidiary/ STORAGE

– The computers that are allowed to access the software (the Client) will be declared (machine name, user ID) and installed the Software program for users to access and input data online to the respective service provider on the server via a high-speed network connection.

– List of common uses for both system.

– There is no limit to the number of clients in the LAN system of these locations.

Users will be managed and decentralized in detail according to each role. user roles in relevant departments. Each user user/user group user or department will have its own layout design (interface) suitable for the management of each user or department. The software solution BRAVO^®7 allows to connect remote locations through the Internet line system with basic requirements for transmission (common ADSL network). Data stored centrally on the Server will be backed up periodically or continuously through the software’s automatic backup mechanism.

Recommendation: In order to ensure stability and data safety when operating the software, Bravo recommends equipping an additional 01 backup server (backup server) for two main tasks: replacing the main operating server. operating the system and backing up the software’s data. On the main server and the backup server integrate equivalent physical hard drives and are configured according to hard drive Raid solutions: Raid 0, Raid 1, Raid 10).

2. Solutions for cross-department use

BRAVO software solutions are designed and used for all parts of a beer and wine production business. , Beverage. Therefore, for users’ convenience in operating the software and ensuring security between departments, BRAVO will design specific “layouts” for each department or even each user location. . Each “layout” will stipulate the interface, features, operations, data, and reports appropriate to the user’s location. “Layout” is the interface layer that the user will manipulate with the features and data system of the software. The database layer between “layouts” will be used on one database to ensure that data between departments is linked and inherited together.

One the main layouts include:

At Headquarters:

– Layout Administrator

– Layout of the Board of Directors of the Company

– Layout of the Sales Department

– Layput of the Purchasing Department goods

– Warehouse Layput

– Shipping Department Layout

– Finance – Accounting Department Layout

– Chief Accountant

– Human Resource Management Layout

– Timekeeping Layout – Payroll calculation

At Factory:

– Layout of Factory Board of Directors

– Production Moderation Layout

– Chief Layout ca Production

– Factory Warehouse Layout

– Quality Management Layout

– Factory Accounting Layout

In Warehouse: Warehouse Layout

3. Some business processes on BRAVO software solutions applicable to Beer, Wine, Beverage manufacturers

a. Sales business process

(1) Make a sales price list (with a date to apply the price list)

When there is a change in the price policy, the user creates a new price list. The program supports inheriting goods information from the old price list for quick data entry, supports calculating new prices based on % of current prices and evaluating profit margins.

(2) Make sales orders and sales orders after finalizing the quantity and unit price with customers to send to the Warehouse Department for shipment

The process of creating vouchers is approved through the statuses for confirmation between management levels.

(3) Sales invoices (also delivery notes for delivery). goods)

The Warehouse Department will inherit the sales order to complete and form the delivery note. The Accounting Department will inherit the sales order to add accounting information and issue invoices to customers. The program supports strict decentralization to each information on the ticket for each user object (For example, the Warehouse Department can only see Quantity information, cannot see Unit Price information).

(4) Track sales performance through the reporting system:

Performance tracking report sales orders
Available inventory report
Sales analysis report, sales analysis of sales over time
Report report receivables according to orders, customers, payment due dates
….

b. Purchase business process

(1) Make a purchase plan monthly/quarterly/yearly, detailing each item supplies/goods

(2) Each department that needs to buy supplies/goods will make a purchase request and the Purchasing Department aggregated goods into a total purchase proposal.

The program helps to calculate the quantity to be purchased based on the data of the instantaneous inventory quantity, the quantity that has been purchased. unfinished purchase request, unfinished order quantity, minimum inventory quantity. The voter records the exact purchase quantity depending on the actual situation, and the user decentralization program is allowed to adjust the actual purchase quantity according to the specified margin compared to the quantity to be purchased.

(3) Make supplier quotation

The program helps to inherit goods data from the purchase proposal for fast data entry and reduce errors. Users record information of suppliers such as Quantity, Unit Price, Discount, Service, Warranty period… to make a comparison table or minutes/price browser sheet.

(4) Making purchase contract/ purchase order according to the quantity and price approved by the Board of Directors on the minutes/ report

The program supports the inheritance of goods data from the supplier’s quotation to quickly enter data and reduce errors.

(5) Make purchase order (also known as purchase order) goods receipt)

The program helps to inherit goods data from purchase orders to quickly enter data and reduce errors.

(6) Track purchase through the reporting system:

Reporting of material needs li>
Price comparison reports between suppliers
Reports to track purchase order fulfillment
Reports of payables under contracts, suppliers offer, payment term
….

c. Delivery process

(1) Prepare a shipping price list including company cars, outsourced vehicles

When there is a change in the price policy, the user creates a new price list. The program supports the inheritance of goods information from the old price list for fast data entry.

(2) Check the vehicle condition and coordinate the delivery vehicle according to the route. , district, district (for company vehicles). Make a delivery note to track delivery status

Some tracking information includes Vehicle Code, License Plate, Delivery Driver, Route, Order sales, Item, Quantity.

(3) Check the GPS to manage the vehicle to the right location and check the empty link to re-enter the inventory

(4) Follow up the repair service performance through the reporting system:

Delivery Report
Empty Status Report
….

V. EFFECTIVE APPLICATION OF BRAVO SOFTWARE SOLUTIONS IN BEER, WINE, Beverage PRODUCING BUSINESSES

1. Administrative efficiency

The parts used on a software system follow a closed process, allowing the linkage and inheritance of data between departments (data the output of one part is the input of another part). Software to support operations during operation helps the system have a clear process and work is properly allocated to each department.

Fast and accurate data import and export. Accurate: Simple interface, easy to use, software capable of data reverse and multidimensional data retrieval.
Each department can self-manage its operating mechanism. , seeing gaps and being able to fix them in a timely manner helps the Board of Directors to be proactive and avoid risks in the process of operation (control the inventory after finishing the order by product code and each contract). dong).
Flexible decentralization: Decentralization for each user, each department.
Allows management of the business chain model in the form of a basic unit. Based on the same software version.
Software system has an open and flexible design, making it easy to expand the scope of management and design new features.</ li>
2. Effective for each user

IV. EFFICIENCY OF BRAVO SOFTWARE APPLICATION

– Always have accurate and immediate information on technical norms to help optimally support the process of trading and negotiating prices with customers.

– The identification of names. and specifications for products in the whole system to ensure the accuracy in transactions of selling, exporting and importing goods in the whole system.

– Minimize the paperwork involved in the procurement process in the business.

– Strengthen control of purchasing quality, purchase price through approval processes on the software.

– Support for more diverse, more immediate Purchasing Management Reports.

– Be proactive in managing and operating the import and export of NPLs, materials and finished products.

– Minimize data entry time (can inherit data from other operational departments such as: orders from Sales Department, …) and improve the efficiency of warehouse value.

– Get raw materials inventory reports at any time any point according to each product code, each contract, PO.

– Always know statistics about factors related to the production process quickly and accurately, maximum support for the process of moderation and production monitoring.

- Timely, accurate and detailed statistics of materials used, semi-finished products, and finished products obtained, providing information for relevant departments to grasp promptly.

– Minimizing re-entering of data arising in departments and improving the control role of accountants.

– Controlling incurred costs and revenue well through the mechanism of instant data linkage throughout the system, thereby helping businesses have a general, timely, complete and accurate financial perspective.

– Support Support professional tasks requiring high accuracy such as calculating capital cost, calculating product cost, accounting employee salary.

– Assist in analyzing and synthesizing production results. trading the whole system according to each contract, each product code.