 |  |  |
|---|
| | |
|---|
INNOVATION / QUALITY CONTROL AND MANAGEMENT
Specs:
I'm going to comment on how the cost control system works for an SME that wants to control its costs and profit margins in this inflationary context, in this case determining the profit margins and with the composition of the products it informs you how the current margins as the costs of the inputs vary, it is quite simple and it is done in Excel
The program is composed of a single Excel file
Analysis Costs.
Specifically, the operation is as follows:
All recipes are loaded.
The prices of all raw materials are charged.
Recipes are updated and valued at today's prices of raw materials (Current Price List)
Then, when the prices of the raw materials vary, the prices must be modified, this will generate that in the CURRENT ANALYSIS_COMPOSITION tab the costs vary, when compared with the PREVIOUS ANALYSIS_COMPOSITION costs, it will inform you what was the % that varied the cost of your product and how much in $
Depending on the composition of the products, for example, when the price of flour varies, some products that are more sensitive to this raw material will vary by a greater % in cost than others that do not have or have little flour.
It works in the following way:
 Detalle de todos los productos |  Lista de Precios Productos |  Visualizador Datos Lista de Precios |
|---|---|---|
 Listado de Productos y SubProductos |  Cotizados Ofertas |  Recetas de cada uno de los productos valorizadas a los precios de la materia prima actuales. |
 Comparativa Costos Actuales y Anterior ( % de Variacion y Dif $) |  Costos Actuales |  Lista de Precios de Materia Prima Actual y Anterior (% Variacion X Item) |
 Recetas de los productos para imprimir. |  Impacto de cada una de las Materias Primas en el Precio |  Centro de costos no asociaciados a la Materia Prima |
Price List Products
The costs are on the tab where the sale price and profit margins are found automatically and compare them with the current Price List, and inform how much must be increased the list on each of the items to recover the desired profit margin that was lost due to the increase in cost.
This file will automatically import the current and previous costs, according to the Profit Margin, determine a sale price, which will be compared with the current List and inform if we are above or below the required profit margin and in what % ,
In fairness it will tell us if we are earning what we want to earn or if we are earning less than we want to earn, and inform us what is the % of increase or what % of reduction of the price list we have to make to obtain the Profit Margin required for each of the products, by means of a 3-color traffic light it will tell us:
Yellow Negative Value, "The product can be lowered by X%, and the required margin will be obtained"
Orange Positive Value, "The product must be increased by X%, and the required margin will be obtained" (Between 0-3%)
Green Positive Value, "The product must be increased by X%, and the required margin will be obtained" (Between 3-5%)
Red Positive Value, "The product must be increased by X%, and the required margin will be obtained" (Mayoy 5%)
White: The sale price should not change, the product delivers the required margin.
Then from here the new Price List will be generated, granting the % required or a lower %, this will generate a price increase not granted, for which the next price list will have an X % to increase pending + the % increase that derives from the changes in the prices of the Raw Material.
At the same time, a "Cushion" can be included, that is, a fixed increase % to amortize inflation, on the cost, when you do not want to change the Price List, it would be like an envelope cost_cc781905-5cde-3194-bb3b- 136bad5cf58d_to mutiny the raises and avoid constantly changing the list
Price List: This is where the Product Price List model can be found to print, Send by Mail or Post on our social networks, it automatically captures the new list prices and generates the information ( This page is blank since it must be generated following the graphic designs of each of the clients, but the realization of this flap is included within the package)
Model Discounts x Line: This Tab takes all the information from the Product Price List, and presents it in such a way that it can be used to analyze sales proposals for large customers, just by loading the codes and quantities, different types of discounts are simulated and the spreadsheet informs with colors if the operation that is going to be carried out with the loaded discounts is acceptable or not, taking the required profit margins and how they are after of applying the discounts for the operation, informing when $ was going to be earned with the list prices and when they end up being earned after the discounts, detailing what the bonus was in $ for the client, this report when pressing a Button is saved in PDF format within the PC for consultation and verification of prices in order to correctly invoice the offers accepted by the client.