Easy List | easy-excel

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:

Entrance Menu

Ingreso con Usuario y Contraseña	Menu	Control Ingreso
Selector de Listas	Lista Seleccionada	Seleccion x DNI
Info Cargada	Lista Seleccionada	Selección x Nombre
Info Cargada	Listado para Ingresos	Confirmacion accion

Create and Modify List Menu

Using this module, the staff responsible for compiling lists will be able to create or rename new lists from the App as needed.

Lists are defined by 2 Parameters, "Name" and "Date"

Depending on the case, you can rename an existing list, changing the two parameters that define it, Name and Date. If the date field is left blank, the List will take the general parameter of all lists for the "Date" data, which is called "General List Date" and can also be updated.

Cambio de Nombre y Fecha de la Lista	Cambio de Nombre y Fecha de la Lista	Cambio de Nombre y Fecha de la Lista
Modificación Fecha General

Mark and Delete Guests

Using this module, the staff responsible for creating the lists will be able to add or remove guests individually and delete all guests from a Selected List.