| Literature DB >> 35454724 |
Walter M Warren-Vega1, David E Aguilar-Hernández2,3, Ana I Zárate-Guzmán1, Armando Campos-Rodríguez3, Luis A Romero-Cano1.
Abstract
The interest of consumers to acquire Tequila has caused an increase in its sales. As demand increases, the Tequila industry must obtain its raw material at a constant rate and agave farmers must be prepared to satisfy this supply chain. Because of this, modernization of the strategies used to ensure a planned, scheduled, timely, and predictable production will allow farmers to maintain the current demand for Tequila. This has been evidenced in official historical records from 1999 to 2020 where there is a fluctuation in the price of agave due to supply and demand. Given this scenario, this research shows the development of a multivariable predictive mathematical model that will permit the agave-Tequila production chain to work based on a smart implementation of planned actions to guarantee the agave supply to the Tequila industry. The proposed model has a goodness of fit (R = 0.8676; R¯2 = 0.8609; F(1,20) = 131.01 > F0.01 (1,20) = 8.10) and demonstrates the impact on agave prices is due to several factors: Tequila exports (α = 0.50) > agave plants harvested "jima" (α = 0.44) > dollar exchange (α = 0.43) > Tequila production (α = 0.06) > annual accumulated precipitation (α = 0.05). Nevertheless, the price forecast can be influenced by climate change or economic crises that affect the supply chain. In conclusion, a prediction of agave price stabilization for five years is shown where authorized producers can evaluate future scenarios so that the agave supply chain can be guaranteed for Tequila production, facilitating the decision making regarding its raw material.Entities:
Keywords: Tequila production; agave planification and harvest; guarantee supply chain of agave-Tequila industry; predictive model
Year: 2022 PMID: 35454724 PMCID: PMC9028388 DOI: 10.3390/foods11081138
Source DB: PubMed Journal: Foods ISSN: 2304-8158
Figure 1Supply chain of the agave–Tequila industry.
Summary of models for price prediction of raw materials and products.
| Raw Material or Product | Model | Variables of the Model | References |
|---|---|---|---|
| Cereals | Spatial price prediction | Longitude, latitude, precipitation, month, and access to the market. | [ |
| Corn | Nonlinear autoregressive models: univariate and bivariate neural network | Daily corn cash prices and future corn prices estimation. | [ |
| Multiple linear regression model | Production, import, outports, and consumption of corn. | [ | |
| Cotton | Multifactor seasonal model | Daily futures cotton prices | [ |
| Soybeans | Multifactor seasonal model | Daily futures soybeans prices | [ |
| Quantile repression radial basis function (QR-RBF) neural network model | The output of domestic soybean, the import volume of soybean, the output of global soybean, the demand of domestic soybean, consumer price index, consumer confidence index, money supply, and port distribution price of imported soybean. | [ | |
| Olive oil | Autoregressive fractionally integrated moving average model (ARFIMA) and Fuzzy time series (FTS). | Consumption, import, export, and production. | [ |
| Wheat | Radial basis function model (RBF). | Climatic and meteorological variables | [ |
| Potato | Multivariate linear regression | Average temperature | [ |
| Cocoa bean | Autoregressive integrated moving average (ARIMA) model. | Explanatory variables | [ |
| Tomato | Seasonal ARIMA (SARIMA) | Weekly and monthly tomato market prices | [ |
| Backpropagation neural network (BPNN) | Weekly and monthly tomato market prices | [ | |
| Backpropagation neural network (BPNN) and radial basis function neural network (RBF). | Weekly and monthly tomato market prices | [ | |
| Garlic | ARIMA-SVM hybrid model | Average monthly wholesale price of garlic | [ |
Figure 2Risk analysis of the Tequila supply chain to satisfy the current demand.
Figure 3Historic data of: (a) agave price, (b) harvested “jima” plants, (c) Tequila total liters production, (d) dollar exchange rate, (e) Tequila exports, and (f) annual accumulated precipitation of Jalisco state, Mexico.
Figure 4(a) ○ Historical data of the price of agave, □ predicted data of the predictive mathematical model for agave price, ◊ estimated projection for the next 6 years using the predictive mathematical model; (b) Comparison between the historical data vs. predicted data from the predictive mathematical model proposed.
Parameters of the predictive mathematical model proposed for determining the price of agave based on: number of plants available; production of Tequila; dollar exchange rate; total export of Tequila; annual accumulated precipitation; unmeasurable uncertainties and weight parameters .
| Parameters for the Predictive Mathematical Model | |||||
|---|---|---|---|---|---|
| Βij | j = 1 | j = 2 | j = 3 | j = 4 | j = 5 |
| i = 1 | 103.30 | 495.10 | −4.17 × 104 | 247.70 | −138.00 |
| i = 2 | −0.26 | −4.93 | 3526.00 | −0.33 | −3.49 |
| i = 3 | 2.22 × 10−4 | 0.02 | −133.90 | 2.07 × 10−4 | 0.03 |
| i = 4 | 5.62 × 10−8 | 1.58 × 10−5 | 2.03 | 5.08 × 10−8 | 5.13 × 10−5 |
| Parameter μj | |||||
| −2745.00 | −969.70 | 1.83 × 105 | −6.57 × 104 | 3.15 × 104 | |
| Parameter αj | |||||
| 0.44 | 0.05 | 0.45 | 0.50 | 0.05 | |
Agave price 1999–2020 history statistics and model fitting.
| Year | Real Price | Predicted Price | Residuals | Standardized Residuals |
|---|---|---|---|---|
| 1999 | 1232.96 | 6196.49 | 2321.03 | 1.47 |
| 2000 | 6926.64 | 6667.79 | −1353.10 | −0.86 |
| 2001 | 11,731.55 | 9071.88 | −2447.33 | −1.55 |
| 2002 | 10,039.68 | 9492.86 | −794.54 | −0.50 |
| 2003 | 6310.24 | 7766.85 | 194.76 | 0.12 |
| 2004 | 4277.80 | 6562.61 | 470.28 | 0.30 |
| 2005 | 2295.51 | 4485.90 | −163.19 | −0.10 |
| 2006 | 1681.55 | 4828.56 | 626.48 | 0.40 |
| 2007 | 2121.12 | 5724.58 | 1202.47 | 0.76 |
| 2008 | 1886.75 | 6693.65 | 2342.18 | 1.48 |
| 2009 | 858.19 | 3220.42 | −382.19 | −0.24 |
| 2010 | 979.68 | 4531.76 | 840.70 | 0.53 |
| 2011 | 913.63 | 2678.00 | −964.97 | −0.61 |
| 2012 | 1470.03 | 2809.74 | −1238.33 | −0.78 |
| 2013 | 1754.47 | 3961.62 | −293.54 | −0.19 |
| 2014 | 3447.14 | 3926.71 | −1560.84 | −0.99 |
| 2015 | 3778.54 | 4618.95 | −1109.89 | −0.70 |
| 2016 | 4470.78 | 7810.69 | 1577.86 | 1.00 |
| 2017 | 8518.73 | 8179.13 | −1000.91 | −0.63 |
| 2018 | 13,563.44 | 10,567.02 | −2285.93 | −1.45 |
| 2019 | 16,039.45 | 15,148.60 | 492.93 | 0.31 |
| 2020 | 19,618.31 | 20,787.43 | 3526.09 | 2.23 |
Figure 5Historical data of the opening of international markets for Tequila commercialization.
Tequila sales participation percentage in the international markets from 2020.
| Continent | Countries | Liters of Tequila Exports from 2020 | Participation (%) in the Market |
|---|---|---|---|
| America | 31 | 301,367,647.44 | 89.5 |
| Europe | 32 | 24,662,303.48 | 7.3 |
| Asia | 25 | 6,032,626.59 | 1.8 |
| Africa | 7 | 1,619,565.33 | 0.5 |
| Oceania | 2 | 3,217,762.82 | 1.0 |
| Total | 97 | 336,899,905.66 | 100.0 |
Figure 6Maps corresponding to the region granted by the DOT: (a) geographical location of properties where Agave tequilana Weber blue variety jima was grown in the year 2020; (b) accumulated annual precipitation contour map; (c) altitude contour map with respect to sea level.