Search This Blog

Friday 6 June 2014

How to make a Stock Control in Excel?


viernes, 6 de junio de 2014

 



Written by Carlos Fernandez Muriano in Excel and tagged Excel, Stock17 May 2014

 For any business, inventory management plays an important role in the graphic business benefits.
Whether a manufacturing unit, trading company or even a retail store, the inventory should be kept well / properly / appropriately for the owner to have a clear idea about the flow of goods within the company.
The inventory is reflected as current assets on the balance sheet of any company, which is equal to the inflow of cash, to be sold.
The Inventory Management
Management or inventory control requires constant vigilance and this can be done more efficiently using the software MS Excel.
The inventory management process involves three main aspects:
• The transfer of control of raw and finished inside and outside the company, products materials respectively.
• The calculation of the buffer stock, in order to keep business running without interruption.
• Keeping track of goods in progress (material passing through the production process), in order to adjust orders accepted.




Control Actions with Excel

 
When the company is small, inventory management is not very complicated. While large companies, the database itself is quite large and computerized inventory management becomes inevitable.
In this establishment, control and management actions need to be made at different locations within a premise or within a single grid.
Microsoft Excel provides the perfect platform for a detailed inventory tracking log that includes all elements as items of property, the cost, the percentage of total sales, cost per unit, the sale price, the percentage of
sales and other important information similar.
Such an inventory will help company managers to track finished goods, raw materials consumption and the amount of buffer stocks to be maintained so that the production process of the company is given without difficulty, at the same time taking care not to have an excess of stock, it will look very bad on fiscal graph of the company.
Careful inventory management precedes the regular and planned course of production, inventory and delivery of finished products.
Create an Action List in Excel
Excel is an easy to use and so powerful at the same time, even a novice only has practical experience with the program can easily adapt this to create a list of actions.
However, the person must have a good understanding of the products, the manufacturing process and supply chain company to create an Excel spreadsheet with all inclusive.


Step 1: Create Columns

 
Record the number of columns to be created in the spreadsheet and make the columns with the appropriate width using the mouse to drag the line between the columns.
Step 2: Set the width of columns
This can be done taking into account the amount of space that each item in the column will occupy. Again the person making the spreadsheet should have a good understanding of the handled goods company.





Step 3: Entering Text

 
Now enter the title of the worksheet and column headers. After introducing them, hit "Wrap Text" and aligns the column header to center alignment.
Part of the header must extend over more than one column, you can do merging cells and pressing the "Wrap Text".
Step 4: Highlight the source
Headings and column title should be in bold selecting these titles and clicking the symbol 'B' in bold and tools found above.
Step 5: Highlight and shading columns
This is to mark important for a quick look possible relevant data columns.

 
Step 6: Formulas

 
This is the main part of the worksheet that helps you get to a calculated from the data array number. Therefore, care must be taken to formulate. In columns as the unit price, the sale price, the percentage of sales, the sales range, the amount of replenishment and balance shares applied formulas and glue the entire length of the column that applies to throughout the sheet.
For example: = minimum order quantity of shares to be used - available quantity.


Now that the columns are ready, you can enter data and calculated corresponding details are available in Excel.


The secret to business success is to maintain the level of actions needed to meet your sales. This can be done by using the Excel spreadsheet and evaluation of the calculated values ​​for a period of time, for a few weeks, so that the owner can reach a conclusion on the percentage of sales and the number of shares
I should have.
- See more at: http://www.egafutura.com/es/wiki/control-stock-excel # sthash.UCwpmjOI.dpuf
Posted by Carlos Fernández Muriano the / s 6:59
Reactions:
Email this ThisBlogThis! Share to TwitterShare to FacebookShare on Pinterest


Tags: Excel, Inventory

Etiquetas: ,

0 comentarios:

Suscribirse a Enviar comentarios [Atom]

No comments:

Post a Comment