Computer Aided System for Manufacturing Industries Economic Production Status Determination ()
1. Introduction
In the development literature, industrialization has been accepted as the major driving force of the modern economy. In most modern economies, industrial sector serves as the vehicle for the production of goods and services, the generation of employment and the enhancement of incomes. Hence, [1] [2] [3] [4] described industry and in particular the manufacturing sub-sector, as the heart of the economy.
In the light of the above, Nigeria has employed several strategies which were aimed at enhancing the productivity of the sector in order to bring about economic growth and development. For instance, the country adopted the import substitution industrialization strategy during the First National Development Plan (1962-1968) which aimed at reducing the volume of imports of finished goods and encouraging foreign exchange savings by producing locally some of the imported consumer goods, Central bank of Nigeria [5] . The country consolidated her import substitution industrialization strategy during Second National Development Plan period (1970-74) which actually fell within oil boom era. At this time, manufacturing activities were so organized to depend on imported inputs because of the weak technological base of the economy. However, as a result of the collapse of the world oil market in the early 1980s, there was a severe reduction in the earnings from oil exports. Consequently, the import-dependent industrial structure that had emerged became unsustainable owing to the paucity of earnings from oil exports which could not adequately pay for the huge import bills, Central Bank of Nigeria [5] . Various policy measures were adopted to ameliorate the above situation, such as the stabilization measures of 1982, the restrictive monetary policy and stringent exchange control measures of 1984, all proved abortive. This led to the introduction of the Structural Adjustment Program (SAP) in 1986 Central bank of Nigeria [5] . One of the main reasons for the introduction of SAP was to reduce the high dependence of the economy on crude oil as the major foreign earner, by promoting non-oil exports, particularly manufactured goods. But the contribution of the manufacturing sub-sector to GDP has declined steadily, due to a number of factors Central bank of Nigeria [5] . As a result, government introduced many other economic policies. Despite these efforts of the government, the performance of the manufacturing sectors is still not clear. The study therefore seeks to develop a software model that will determine the economic productivity performance of manufacturing industries for sustainable economic development.
2. Literature Review
There are many definitions attached to productivity by many authors like: [6] - [14] . In industrial engineering, productivity is generally defined as the relation of output (i.e. produced goods) to input (i.e. consumed resources) in the manufacturing transformation process. However, there are numerous variations on this basic ratio which is often too wide, a definition to be useful in practice. Examining the term from different perspectives, [11] summarize a number of these variations found in different literatures. The basic content seems to be the same in many definitions of productivity. However, within the similar definitions, there are three broad categorizations which are: the technological engineering and economics concepts used in its [15] [16] [17] .
Although the definition of productivity appears straight forward, for three major reasons it is difficult to deal with [18] ; [19] and [20] . According to [21] , the overall performance of a company is comprised of at least seven criteria: effectiveness, efficiency, quality, productivity, quality of work life, innovations, and profitability. Productivity is thus a key success factor for all companies. [22] [23] [24] and [25] has stated that organizations must be able to continuously increase their productivity in order to stay profitable.
Productivity combines the concepts of effectiveness and efficiency, where effectiveness is the degree to which end results are achieved to the required standard [26] [27] and [28] . Growth is a function of total factor productivity (TFP), which is the aggregation of partial productivities [29] [30] and [31] .
Conceptually, output embodies both quality and quantity and this creates sometimes confusion that the productivity measure is unfounded in the sense that they do not take quality into consideration. Such arguments may be true in case of very simple productivity ratios. In those ratios, the quality of the output or input is often ignored. But, when the output is measured in deflated net sales, for example, the quality of the products or services is included in the function. However, quantifying quality changes in productivity measurement is always a measurement problem, not a conceptual problem. At the conceptual level quality of the output and the input are very much included in the productivity ratio.
3. Methodology
The following are the methods used to achieve the objectives in this research which are: ascertain the required parameters for the model development, mathematical models used for the required computation of each parameter, development of algorithm and its software for implementing the mathematical models ascertained, application of the models and the developed software named (PPE-INDICES 2016).
3.1. Identification of Required parameters for the model Development
The following parameters for strategic decision taken were identified in this research for required model development:
1) Quantity produced in year: This is the total unit or quantity of product produced in either the base year or current year. It is an output function.
2) Price per Unit for product: This function is used to convert the output in to monetary form. It is the cost of each unit of the product.
3) Labour input time: This is an input function that describes the time input of labour to produce the given output quantity of the product.
4) Cost per hour of labour: This is the amount paid per hour for the labour used to produce the given quantity of product.
5) Period of time: This is the time under consideration which could be either a base year or a current year. The base year is the period used as a comparison time to determine the economic productivity of a current year relative to the base year.
6) Factor Productivity Index (FPI): This defined as the ratio of the value of current level output to base level output, divided by the ratio of the value of current-period inputs to base level inputs. The productivity change ratio measures the technical efficiency of firms.
7) Price recovery index: This defined as the ratio of the value of outputs at current period prices to the value at base level prices, divided by the value of inputs at current period prices to the value at base level prices. The price recovery ratio helps measure the abilities of firms to be price or allocative efficient.
8) Cost Effectiveness index: This is the ratio the value change of input to the value change of total output.
3.2. Case-Study History
Data used for this study were extracted from accounting/inventory departments of Olam Cocoa Processing Company Akure. Olam is a leading global integrated supply chain manager and processor of agricultural products and food ingredients. Agricultural products processed by Olam include Cocoa, Cashew, Sesame and Cotton. It also has a cashew processing plant at Ogbondoroko, a suburb of Ilorin, Kwara state. According to the statement, working closely with the group, Olam’s corporate responsibility and sustainability team had delivered farm management training and GPS mapped 5000 hectares of farmland. “In so doing, Olam equipped Nigerian cocoa farmers with accurate information about the size of their farms”, it added. The company also distributed higher yielding planting materials and successfully prepared the farmers for Rainforest Alliance audits in 2012 and 2013 which made the N26 million premium payments possible [32] .
The company is located besides Ondo State Cooperative building, Akure-Owo express road. The Company has over 50 workers both skilled and unskilled.
3.3. Nomenclature for Model Development
1) Q1 = Quantity produced in year 1
2) Q2 = Quantity produced in year 2
3) P1 = price per units for product in year 1
4) P2 = price per units for product in year 2
5) I1 = Labour (input) time in year 1
6) I2 = Labour (input) time in year 2
7) C1 = Cost per hour of Labour (input) time in year 1
8) C2 = Cost per hour of Labour (input) time in year 2
9) T1 = Period of time in year 1
10) T2 = Period of time in year 2
3.4. Development of Algorithm for Implementing the Mathematical Mode
3.5. Software Development
This software was developed using the java application, and intended to determine the production status of manufacturing industries regardless of the product type. Once the data is extracted in this manner, the cumbersomeness of manual calculation is eliminated by the use of this software and the production status is determined in matter of a second. This makes this software a handy to for manager and business owners.
3.6. Software Requirement
Below are conditions that must be met or processed by a system to satisfy the specification for this software.
1) Microsoft window 98 or above (Operating System Platform)
2) Browser
3) Java Compiler (JDK 1.5 above)
3.7. Hardware Requirement
The hardware requirements are:
1) System with minimum of Pentium II motherboard
2) Minimum of 5 gigabyte of Hard disk drive
3) A good VGA or SVGA monitor
4) Printer.
3.8. Software Interface
The software interface designed for the determination of economic productivity of a firm of product is as shown in figure 1. Loading this option and keying in the appropriate data will perform the desired computation and generate the result in no time at all. This interface is designed to display input data such as quantity produced, price per unit, labour time, labour time 2, Time of production, cost per hour of labour and cost 2 per hour of labour and when these data is inputted it yields an output displayed as factor productivity price recovery index cost effectiveness index and then a decision which is either increase in productivity, decrease in productivity or a static productivity.
3.9. Application of Developed Software
For the purpose of application of the developed software, the necessary data was collected from Olam Cocoa Processing Company Akure.
3.10. Data Collected For Model Application
The data for applying the APC model was obtained from the accounting/ inventory departments of Olam Cocoa Processing Company Akure (2013/2014) fiscal year. This data made it possible to calculate the deflated values, change ratios, performance ratios and performance contributions. Quantities; prices and/or values of both input and output were obtained. The period selected was 2013 to 2016 fiscal year.
3.11. Application of Developed Software (PPE-INDICES 2016)
The software interface designed for the determination of economic productivity of a firm of product is as shown in Figures 2-4. When the data in Table 1 to Table 3 is inputted into the software appropriately, it generate results as shown in the interfaces Figure 4. The result interface is designed to include inputted date, Factor productivity index, and price recovery index and cost effectiveness index.
This interface accepts all required data from Table 2 for the 2014/2015 fiscal year. Here, 2015 is compared to 2014 as the base year and the software
![]()
![]()
Table 1. Extracted from accounting/inventory departments of Olam Cocoa Processing Company Akure (2013/2014) fiscal year.
![]()
![]()
Table 2. Extracted from accounting/inventory departments of Olam Cocoa Processing Company Akure (2014/2015) fiscal year.
![]()
![]()
Table 3. Extracted from accounting/inventory departments of Olam Cocoa Processing Company Akure (2015/2016) fiscal year.
![]()
Figure 2. Interface for software application to Table 2 data.
![]()
Figure 3. Interface for software application to Table 3 data.
(PPE-INDICES 2016) was able to indicate an increase in productivity bases in the data inputted.
This interface accepts all required data from Table 3 for the 2013/2014 fiscal year. Here, 2016 is compared to 2015 as the base year and the software (PPE-INDEX 2016) was able to indicate a decrease in productivity bases in the data inputted.
3.12. Developed Software (PPE-INDICES 2016) Cost
The cost implication for PPE-INDICES, 2016 development is as shown in Table 4.
From the above cost implication for (PPE-INDICES 2016), a unit cost for the software disk is N100,000.00. Similar software like the SANDVIK CORAMANT-PAYBACK CALCULATOR cost $10. By using (PPE-INDICES 2016) the establishment would have added a 50% economic value.
3.13. Maintenance of Software (PPE-INDICES 2016) Developed
For the preservation of this software, it is important to:
1) Keep it away from direct sun light.
2) Keep it away from dust.
3) Store in a dry environment.
4) Avoid exposure to magnetic fields.
5) Avoid using on virus infested system.
4. Result and Discussion
Results identifies APC model as a suitable model for making strategic decision required for measuring the productivity in manufacturing industries in that it can make use of both financial and non-financial data as input data. The algorithm now was used to develop software (PPE- INDICES 2016) with the capability of calculating the economic productivity of any manufacturing firm. Case study data was used to run PPE-INDICES 2016 and the results gotten were as desired.
The software was able to compute the three performance measuring indicators which are the factor productivity index, price recovery index and cost effectiveness index for the various period under consideration. The results are displayed on a printable software interface as shown in figure 2 to figure 4 in chapter three.
PPE-INDICES 2016 was verified by comparison of manual application result of the model and the results from PPE-INDICES 2016 and were tabulated in Table results 1, 2 and 3 respectively. From the table it is concluded that PPE-INDICES 2016 is not only accurate, but also convenient and can produce the desired result in no time at all. These features make PPE-INDICES 2016 a
![]()
Table 4. Development of software cost.
![]()
Figure 4. Productivity performance graph.
recommended handy tool for managers and any other performance decision maker in the manufacturing industry.
Table 5 to Table 7 show the results of the manual and software application of the model. The deviation of the software application from manual application authenticates the accuracy of the software.
Discussion
From the result as determined with the software, it is easy to see the performance of the company within the selected period. The result for (2013/2014), with 2013 as base year shows that CEI = FPI × PRI i.e. 1.87 = 1.24 × 1.51. This index indicates also that sales revenue is increasing faster than the cost and that the product price increase is more significant than productivity. So there is low productivity.
The indices for (2014/2015) CEI = FPI × PRI i.e. 1.55 = 1.29 × 1.20 indices also indicates that sales revenue is increasing faster than the cost and that the productivity is more significant than the product price increase So there is increase in productivity. The indices for (2015/2016) which is CEI = FPI × PRI i.e. 1.39 = 1.23 × 1.13 also indicate that sales revenue is increasing faster than the cost and that the productivity is more significant than the product price increase so there is increase in productivity (Table 8).
The graph shows the performance indicators for the various years compared. From the graph it can be seen that period 2013/2014 recorded a low productivity level that is FPI
PRI, these shows increase an productivity of the company.
![]()
Table 5. 2013/2014 Manual/Software results.
![]()
Table 6. 2014/2015 Manual/Software results.
![]()
Table 7. 2015/2016 Manual/Software results.
![]()
Table 8. Tabulation of performance indices.
5. Conclusions
The impetus for this study arose from the review of the literature on importance of productivity measurement in the manufacturing industries. This literature review revealed that productivity can be measured by a profit-linked model, and this model can be set up and computed using this software. American Productivity Center (APC) Model was found to be the most suitable; it allows for measure of both non-financial (indexes) and financial (Naira) during computation. The non-financial and financial measurement allows both line manager and financial manager to use the model for measuring productivity and profitability in the company.
The computation with the model software makes it possible for the manager to get further insight on the performance of the firm in no time at all.
In addition, the literature revealed productivity which is regarded as value addition and quality, which is value enhancement, is the main determinant of competitiveness. To remain competitive, companies need to integrate and synergize both productivity and quality.
Based on the review of literature, the main objectives of this study were formulated as follows: to identify the strategic decision required for measuring the productivity in manufacturing industries, identify and adopting a suitable model for measuring economic productivity in manufacturing industries, develop an algorithm and software that will calculate the economic productivity of any manufacturing industry based on the mathematical relations of the identified model, and then validate the software (PPE IDICES 2016).
In accordance with the aforementioned objectives, a literature study APC model was set up and productivity, price recovery and profitability were computed with the software.
This study could be classified as being successful because a suitable productivity measurement was computed and contribution of profitability were decomposed to productivity and price recover to determine the economic productivity of Olam cocoa processing company Akure.
From the discussion, the result indicates that Olam cocoa processing company Akure experienced a low productivity in 2014 compared to 2013 as the base year. Subsequently, 2015 and 2016 were better years for her as productivity improved.