​

​

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:

​

1. All recipes are loaded.

2. The prices of all raw materials are charged.

3. Recipes are updated and valued at today's prices of raw materials (Current Price List)

4. 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 $

5. 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:

​

​

​

​

​

​