Application of Linear Programming Algorithm in the Optimization of Financial Portfolio of Golden Guinea Breweries Plc, Nigeria

Affiliation(s)

^{1}
Department of Computer Science, Imo State University, Owerri, Nigeria.

^{2}
Department of Computer Science, Nnamdi Azikiwe University, Awka, Nigeria.

ABSTRACT

In this study, Simplex Method, a Linear Programming technique was used to create a mathematical model that optimized the financial portfolio of Golden Guinea Breweries Plc, Nigeria. This work was motivated by the observed and anticipated miscalculations which Golden Guinea Breweries was bound to face if appropriate linear programming techniques were not applied in determining the profit level. This study therefore aims at using Simplex Method to create a Mathematical Model that will optimize the production of brewed drinks for Golden Guinea Breweries Plc. The first methodology involved the collection of sample data from the company, analyzed and the relevant coefficients were deployed for the coding of the model. Secondly, the indices collected from the first method were deployed in the software model called PHP simplex, an online software for solving Linear Programming Problem to access the profitability of the organization. The study showed that Linear Programming Model would give a high profit coefficient of N9,190,862,833 when compared with the result obtained from the manual computation which gave a profit coefficient of N7,172,093,375. Also, Bergedoff Lager, Eagle Stout and Bergedoff Malta were found not to contribute to overall profitability of the company and it was therefore recommended that their productions should be discontinued. It also recommends that various quantities of Golden Guinea Lager (1 × 12) and Golden Guinea Lager (1 × 24) should be produced.

In this study, Simplex Method, a Linear Programming technique was used to create a mathematical model that optimized the financial portfolio of Golden Guinea Breweries Plc, Nigeria. This work was motivated by the observed and anticipated miscalculations which Golden Guinea Breweries was bound to face if appropriate linear programming techniques were not applied in determining the profit level. This study therefore aims at using Simplex Method to create a Mathematical Model that will optimize the production of brewed drinks for Golden Guinea Breweries Plc. The first methodology involved the collection of sample data from the company, analyzed and the relevant coefficients were deployed for the coding of the model. Secondly, the indices collected from the first method were deployed in the software model called PHP simplex, an online software for solving Linear Programming Problem to access the profitability of the organization. The study showed that Linear Programming Model would give a high profit coefficient of N9,190,862,833 when compared with the result obtained from the manual computation which gave a profit coefficient of N7,172,093,375. Also, Bergedoff Lager, Eagle Stout and Bergedoff Malta were found not to contribute to overall profitability of the company and it was therefore recommended that their productions should be discontinued. It also recommends that various quantities of Golden Guinea Lager (1 × 12) and Golden Guinea Lager (1 × 24) should be produced.

Received 8 April 2016; accepted 17 June 2016; published 20 June 2016

1. Introduction

Golden Guinea Breweries Plc, Nigeria is a production company that produces drinks (beers and malt) for daily human consumption. Given the method and volume of production and sale, raw materials which are used for the production of these beers and malt are often supplied on credit while suppliers or creditors are paid in later days according to company’s policy. Moreover, other transactions such as repairing of broken down machines and the like are also done on credit. Since these transactions are done as time and need arise, it therefore becomes necessary that a system should be adopted whereby transactions are categorized with the aim of improving the efficiency of payment appropriately. In light of this, an automated information system has been developed with high level of control as regards modification and timely rendering of accurate reports to functional managers for result oriented decision-making.

One of the main issues that management of companies and institutions deals with is permanent optimization and improvement of its main process of production. Given the fact that the solution to one problem can be done in many ways, it is important to find and implement the optimal solution between them. In the view of Taha H. A. [1] , Mathematical Programming is special mathematical approach of selecting the best/optimal from the set of possible alternatives towards solving the problem. It assumes that it is possible to represent the problem as a Mathematical Model that reflects certain production function (more precisely, mathematical function). In this direction, resolution of the problem of optimization converges to determination of the optimal (minimum or maximum, depending on the nature of the model) value of the production function, having in mind all the limitations of the model/environment, represented in the limitation equations.

The development of the automated system went through stages like system analysis, design and implementation of the results.

1.1. Related Work

Linear programming has been widely applied in Breweries, as most managerial problems involve resource allocation. For example, management decision problems such as production planning, capital budgeting, personnel allocation, advertising and promotion planning are concerned with the achievement of a given objective (profit maximization or cost minimization) subject to limited resources (money, material, labor, time, etc.).

Linear programming, sometimes known as linear optimization, is the problem of maximizing or minimizing a linear function over a convex polyhedron specified by linear and non-negativity constraints. Simplistically, Sultan A. [2] , states that Linear Programming is the optimization of an outcome based on some set of constraints using a linear mathematical model. According to Symorg [3] , Linear programming is implemented in the Wolfram Language as Linear Programming [c, m, b], which finds a vector which minimizes the quantity subject to the constraints and for. According to Wikipedia [4] , linear programming is a technique for the optimization of a linear objective function, subject to linear equality and linear inequality constraints. It’s feasible region is a convex polytope, which is a set defined as the intersection of finitely many half spaces, each of which is defined by a linear inequality. Its objective function is a real-valued affine function defined on this polyhedron. A linear programming algorithm finds a point in the polyhedron where this function has the smallest (or largest) value if such a point exists. Linear programming is the best known and one of the most widely used techniques of management science. It is a mathematical technique for determining the best allocation of a firm’s limited resources. In his own contribution, Wagner H.M. [5] , is of the view that Linear programming involves the description of a real world decision situation as a mathematical model that consists of a linear objective function and linear resource constraints. According to Iwuagwu C.C. [6] , Linear Programming is also special technique for determining the optimum combination of scarce resources in the attainment of some objectives of economic or other nature. Iwuagwu contends that it is a method for solving problems in which an objective function must be maximized or minimized when considering certain constraints. Iwuagwu further stated that Linear programming follows the following steps to transform life problem in industries into linear programming solution as shown below:

Firstly, it determines the quality to be optimized (minimized and or maximized) and expresses it as a mathematical function called criterion function or objective function.

Secondly, it identifies all stipulated requirements, restrictions and limitations and expresses them mathematically.

Thirdly, it expresses any hidden conditions; such conditions are not stipulated explicitly in the problem but are apparent from the physical situation being modeled.

There must be a well defined objective function such as profit, cost or revenue functions.

There must be different alternative courses of action for linear programming to be applied.

Linearity in linear programming is a mathematical term used to describe systems of simultaneous equations of the first degree which satisfy the objective function and constraints.

The resources which must be limited in supply are finite and economically quantifiable [6] .

Furthermore, Iwuagwu [6] , is of the opinion that the following steps should be adopted in formulating a linear programming model:

Identification of the decision variables.

Identification of the objective function which may be profit, revenue or cost functions and expressing it as an equation.

Identification of the constraints and expressing them in the form of inequalities. The constraints should express the usage of available resources.

Write the standard Linear programming model.

In their contributions, Andersen E.D. and Anderson K.D. [7] , contend that the simplex algorithm, invented by George Dantzig in 1947, is one of the earliest and best known optimization algorithms. The algorithm solves the linear programming problem

such that

The algorithm moves along the edges of the polyhedron defined by the constraints, from one vertex to another, while decreasing the value of the objective function, , at each step. They contend that the simplex algorithm has two phases:

Phase 1―Compute an initial basic feasible point. Here, the algorithm finds an initial basic feasible solution by solving an auxiliary piecewise linear programming problem. The objective function of the auxiliary problem is the linear penalty function

where is defined by

P(x) measures how much a point x violates the lower and upper bound conditions. The auxiliary problem is

Phase 2. Compute the optimal solution to the original problem. Here, the algorithm applies the simplex algorithm, starting at the initial point from phase 1, to solve the original problem. At each iteration, the algorithm tests the optimality condition and stops if the current solution is optimal.

Robert et al. [8] , is of the view that Karmarkar’s algorithm is rather complicated as shown below:

Algorithm Affine-Scaling

Input: A, b, c, , stopping criterion,.

do while stopping criterion not satisfied

if then

return unbounded

end if

end do

“←” is a shorthand for “changes to”. For instance, “largest←item” means that the value of largest changes to the value of item.

“return” terminates the algorithm and outputs the value that follows.

From Wikipedia [9] , the free encyclopedia in mathematical optimization, Dantzig’s simplex algorithm (or Simplex Method) is a popular algorithm for linear programming. The journal of Computing in Science and Engineering [10] , listed it as one of the top 10 algorithms of the twentieth century.

1.2. Statement of Problem

In recent times, Golden Guinea Breweries has been faced with low profitability as a result of miscalculations, probably at the managerial level. This has no doubt generated numerous problems in the company. Some of these problems include delay in payment of salaries and wages, inadequate provision of motivational benefits in the work place, laissez-faire attitude to work by the employees and reduced productivity, etc. As a result of the forgoing problems, there is unhappiness in the minds of staff, frustration, insecurity, high staff turn-over, high recruitment and training rates, low profit potential of the organization. Staff who are not well remunerated feel unsatisfied with the organization and this creates tension and anxiety within them. Tension and anxiety result to aggressiveness over companies polices. These problems also lead to frustration among workers, conflicts of roles, confusion and complaints, etc. Job insecurity results when worker’s expectations are not met. This leads to an employee leaving the organization at any slightest chances in search of better job. Those who stay would have laissez-faire attitudes in doing their jobs. Therefore, a study that scientifically investigates and provides ways of optimizing the financial portfolio of Golden Guinea is highly imperative.

1.3. Objective of Study

This study aims at using Simplex Method, one of the Linear Programming Techniques to create a Mathematical Model that will optimize the profit of the production of Brewed drinks for Golden Guinea Breweries Plc.

2. Methodology

The various data we are primarily concerned with are the following:

1) Cost of production.

2) Total sales incomes.

3) Raw materials and their cost per annum.

4) The price of a unit (one carton) of the products.

Also, Listed below is the summary of the products of the company;

1) Golden Guinea (1 × 12) lager, G.G (1 × 12).

2) Golden Guinea (1 × 12) lager, G.G (1 × 24).

3) Bergerdoff lager (BDF).

4) Eagle stout (E/S).

5) Bergerdoff malta (B/M).

Research Procedure

According to Anyanwu A. [11] , the research procedure centers mainly on the data collection and simplification. As earlier stated, data collection for this study was through interview method which yielded data through verbal interaction and questionnaire distributed among members and staff of the organization under study. The company has four major departments: Production, Purchasing, Accounting and Finance and Marketing departments. The production process involves the transformation of raw material through various stages both manual and machine oriented to get the finished products. The data collected include:

The products of the company.

The total cost of production for each product.

The prices of a unit (one carton) of the product.

The sales income for each product.

The total sales revenue for each product.

The raw materials for each product.

The total cost of raw material.

The machines used at different stages.

The Model

According to Ekwonwune E.N., [12] a Linear Programming Model is of the form:

Minimize or Maximize

Subject to:

The annual cost of raw material per unit of production can be gotten by dividing the total cost of raw materials per annum by the total quantity produced as shown in Table 1.

Objective Function

The research problem bothers on how to optimize the production system. We define the profit contribution of a unit of each of the product and aim at getting the quantity of each product that will maximize the profit from the system.

We define the quantities of the five products that will maximize profit to the decision variables. Hence we have the following:

X_{1} = The quantity of Golden Guinea Lager (1 × 12) in cartons.

X_{2} = The quantity of Golden Guinea Lager (1 × 24) in cartons.

X_{3} = The quantity of Bergedoff Lager in cartons.

X_{4} = The quantity of Eagle stout in cartons.

X_{5} = The quantity of Bergedoff Malta in cartons.

Hence, the Objective function then transforms to:

Raw Material Constrains

In this study, the cost of raw materials constitutes the major constraints. This is because the system operates in an open market; that is, there is a ready market for as much as they can produce. Also since the machines used run a long lifecycle, they work as long as they remain on and as such have no maximum capacity.

The cost of raw materials and the production in general constitute the constraint in production. The cost of raw materials for a unit of production as shown in Table 2 is expressed thus:

Sorghum:

Sugar:

Enzymes:

Hops:

Brewing sundries:

Bottling and washing machine:

_{ }

Table 1. Total and unit costs of production and profit contribution.

Source: [12] .

Table 2. Total cost of material (millions).

Source: [12] .

Total cost of production results from material, personnel and miscellaneous costs as shown below:

………………………1

Table 3 shows that Total production cost gives sum of Cost of materials, personnel and miscellaneous costs. It also shows that Total Profit is given as:

……………………………………………………..2

The Total Cost of Production Constraint

Since the other expenses also contribute to the total cost of production of each of the production, the total cost of production hence constitutes the constraint,

The Complete Model

Having defined the criterion function, decision variable and constraints, our model is given as shown below thus;

Subject to:

3. Analysis

The various data obtained are used in the PHP Simplex. The steps taken in using the Simplex Method to solve our model are shown below:

The leaving variable is P_{8} and entering P_{4}.

The indices collected from the section of the complete model were deployed in the PHP simplex. A close look shows that the initial tableau is shown in Table 4 while the final tableau is shown in Table 5. One also observes that the overall profit from the final tableau is the optimal solution given by N9, 190, 862, 855.

Show results as fractions

The optimal solution value is Z = 9190.862855157. X_{1} = 0.20031389501087. X_{2} = 44743546061916. X_{3} = 0. X_{4} = 0. X_{5} = 0.

The optimal solution value is Z = 9,190,862,855. X_{1} = 200,313. X_{2} = 447,435,460. X_{3} = 0. X_{4} = 0. X_{5} = 0.

4. Discussion

From the above result, it is clear that the profit, N7, 172,093,575 obtained from Table 3 is different from that, N9,190,862,855 obtained using the Simplex Software as shown in Table 5. One of the reasons that account for low profitability in the manual methods is that not every variable is put into consideration in the process of computation. Also the optimal solution using Linear Programming Model rejects three variables X_{3}, X_{4} and X_{5} respectively but their consideration in the manual method resulted to considerable loss in market value.

The various quantities of the cartons of each of the products of the company that should be produced per annum for the optimal profit obtained in section 3.0 are such that:

1) 200,312 of Golden Guinea Lager (1 × 12) will be produced.

2) 447, 435,460 cartons of Golden Guinea lager (1 × 24) will be produced.

3) No quantity of Bergedoff Lager will be produced.

4) No quantity of Eagle stout will be produced.

5) No quantity of Bergedoff Malta will be produced.

From the result above, it will be observed that three products whose production should be stopped for the optimal system are X_{3} = Golden Guinea (1 × 12), X_{4 }= Bergedoff Lager and X_{5} = Bergedoff Malta with the least unit profits contributions. Also from our model, it is obvious that surplus amounts will result which is brought about by the reduction in the cost of production and this helps to boost the profits.

5. Conclusions and Recommendation

The result of this study has shown that an overall annual profit of the company is N9, 190,862,855. The objective of this study was to be able to plan production for the company for a period of one year in order to maximize profit. The system model hence is able to:

1) Maximize profit, 2) Allocate raw materials, and 3) Deduce an optimal cost of production. 4) All excesses from cost of raw materials and other expenditure that were cut down generally affected the cost of production and an optimal amount was reached.

Table 3. The total sales revenue, total cost of production and total profit contribution.

Source: [12] .

Table 4. The initial tableau.

Table 5.The final tableau.intermediate operation (Show/hide details).

Following the result of this study, the following recommendations are hence given to Golden Guinea Breweries Plc:

The quantities of the two products that should be increased for an optimal profit are: 200,312 cartons of Golden Guinea (1 × 12) Lager and 447,436,460 cartons of Golden Guinea (1 × 24) Lager beer.

No production of Bergedoff lager beers, Eagle Stout and Bergedof Malta. Production should concentrate on the products that yield a high amount of profit.

To maintain this optimal production level, there is a reduction in the cost of production, which helps boost the profit margin. This surplus amount should be plugged back into production in order to achieve a higher production level.

More awareness should be created for better appreciation of the products by the public. This will make for proper pricing of the products especially as regards the three products: Bergedoff Lager Beer, Eagle Stout and Bergedoff Malta respectively.

Since machines run a long life cycle, their maintenance and servicing should be ensured so that they don’t break down unexpectedly and affect production.

Cite this paper

Ekwonwune, E. and Edebatu, D. (2016) Application of Linear Programming Algorithm in the Optimization of Financial Portfolio of Golden Guinea Breweries Plc, Nigeria.*Open Journal of Modelling and Simulation*, **4**, 93-101. doi: 10.4236/ojmsi.2016.43008.

Ekwonwune, E. and Edebatu, D. (2016) Application of Linear Programming Algorithm in the Optimization of Financial Portfolio of Golden Guinea Breweries Plc, Nigeria.

References

[1] Taha, H.A. (2007) Operational Research Introduction. Pearson Education, Inc., Upper Saddle River.

[2] Sultan, A. (1993) Linear Programming: An Introduction with Applications. Academic Press, San Diego.

[3] Symorg (2014) Effectiveness Determination of Higher Education Using Linear Programming.

[4] https://en.wikipedia.org/wiki/Linear_Programming

[5] Wagner, H.M. (1975) Principles of Operation Research. Prentice Hall Inc., Englewood Cliff.

[6] Iwuagwu, C.C. (2000) Quantitative Methods for Business Application. Name Ventures Ltd., Owerri.

[7] Anderson, E.D. and Anderson, K.D. (1995) Presolving in Linear Programming. Math Programming.

[8] Robert, J.V., et al. (1986) The Modification of Karmarkar’s Linear Programming Algorithm. Algorithmica, 1, 395-407. http://dx.doi.org/10.1007/BF01840454

[9] https://en.wikipedia.org/wiki/Simplex_algorithm

[10] Computing in Science and Engineering Volume 2, No. 1, 2000 html Version.

http://www.computer.org.csdl/mags/cs/2000/01/c1022.html

[11] Anyanwu, A. (1994) Data Collection and Analysis. Avan Global Publication, Owerri.

[12] Ekwonwune, E.N. (2000) The Design and Development of a Linear Programming Model as a Tool for Decision Making Support in a Production Firm. An Unpublished M.Sc Thesis, Ekpoma University, Ekpoma.

[1] Taha, H.A. (2007) Operational Research Introduction. Pearson Education, Inc., Upper Saddle River.

[2] Sultan, A. (1993) Linear Programming: An Introduction with Applications. Academic Press, San Diego.

[3] Symorg (2014) Effectiveness Determination of Higher Education Using Linear Programming.

[4] https://en.wikipedia.org/wiki/Linear_Programming

[5] Wagner, H.M. (1975) Principles of Operation Research. Prentice Hall Inc., Englewood Cliff.

[6] Iwuagwu, C.C. (2000) Quantitative Methods for Business Application. Name Ventures Ltd., Owerri.

[7] Anderson, E.D. and Anderson, K.D. (1995) Presolving in Linear Programming. Math Programming.

[8] Robert, J.V., et al. (1986) The Modification of Karmarkar’s Linear Programming Algorithm. Algorithmica, 1, 395-407. http://dx.doi.org/10.1007/BF01840454

[9] https://en.wikipedia.org/wiki/Simplex_algorithm

[10] Computing in Science and Engineering Volume 2, No. 1, 2000 html Version.

http://www.computer.org.csdl/mags/cs/2000/01/c1022.html

[11] Anyanwu, A. (1994) Data Collection and Analysis. Avan Global Publication, Owerri.

[12] Ekwonwune, E.N. (2000) The Design and Development of a Linear Programming Model as a Tool for Decision Making Support in a Production Firm. An Unpublished M.Sc Thesis, Ekpoma University, Ekpoma.