chapter 4 status of e-business application...
TRANSCRIPT
70
CHAPTER 4
STATUS OF E-BUSINESS APPLICATION SYSTEM AND
ENABLERS IN SCM OF MSMEs
4.1 PREAMBLE
This chapter deals with analysis of data gathered through
questionnaire survey to bring out
• The profile of MSMEs
• Status of e-business application system
• E-business enablers in SCM of MSMEs
• Status of SC enablers
• Status of factors available to support SCM
The profile of the MSMEs was established in terms of number of
years experience of the firm in business and the category to which each one of
them belong. The status of e-business application systems, e-business
enablers and SC enablers to support MSMEs was analyzed using Friedman
test. Factors that support the SCM include bench marking of SCM activities
with that of the best in class of organization, emphasis of company strategy in
SCM, emphasis of top management in SCM, emphasis on SCM infrastructure
and attributes are measured by applying Friedman test.
71
To test the generic hypothesis formulated a Chi square test was
applied. It is an important non-parametric test, which does not require rigid
assumption about the type of population. This test was employed to find the
significance of association between the following : usage of e-supply chain
systems and MSMEs, between the success of managing SCM and the e-
business systems in use, between the benefits of usage of e-supply chain
components and MSMEs. Multiple regression analysis was used to measure
the influence of top management in SCM, emphasis on bench marking of
SCM activities with that of the best in class of organizations and the influence
of SC enablers on benefits of using the enablers in MSMEs.
4.2 PROFILE OF MSMEs
4.2.1 Categorization and Experience of MSMEs
According to the published reports of Government of India there
were 1.56 million micro, small and medium enterprises in 2011-12.
Categorywise distribution of the MSMEs is given below in Table 4.1.
Table 4.1 Percentage analysis of nature of MSMEs
Type of MSME
Percentage as per the MSMEs report 2011-12
Percentage of firms as per survey for research
Micro 94.94 87.79
Small 4.89 9.92
Medium 0.17 2.29
For the survey, though 400 firms were targeted and approached,
finally the response for the schedule could be obtained from 131 firms (which
forms 32%), the distribution of category-wise MSMEs respondents is also
given in the Table 4.1. Comparison of the distributions of actual number of
72
firms and the distribution of firms responded to the questionnaire schedule,
they do not closely agree. The reason for the mismatch in both the column
value is due to the fact that one is an all India figure (population figure)
comprises of manufacturing and service MSMEs, while the MSMEs covered
in the sample survey are mainly manufacturing ones and belong to
geographically small area compared to the other. If the sample size is more
and cover a wider area, the mismatch will get reduced.
To assess the experience of firms responded from the data gathered,
the number of years of existence has been grouped as indicated in Table 4.2.
Table 4.2 Analysis of years existence of firms in business
Years of experience No of firms Percentage of firms
Less than 5 years 31 23.7
5 - 10 years 50 38.2
10-15 years 25 19.1
more than 15 years 25 19.1
Total 131 100.0
From Table 4.2 it may be seen that 38.2% firms have experience
between 5-10 years followed by 19.1% respondents between 10-15 years and
the remaining 19.1% respondents having more than 15 years of experience.
Thus, as high as 76% of firms surveyed have more than 5 years of experience,
while the average life of the MSMEs surveyed is around 9 years. Five years
can be considered as a reasonable span of life of firms especially MSMEs, by
which time, it should be possible for them to achieve stabilization and be in a
position to adopt ICT tools to improve their business prospects.
73
4.2.2 Success of Managing the Supply Chain of MSMEs
To assess the level of success of managing the supply chain of
MSMEs, a percentage distribution analysis was made. The Table 4.3 gives the
details.
Table 4.3 Percentage analysis of success of managing the supply chain
in MSMEs
Level of Success No of firms Percentage of firms
Not successful 2 1.5
Somewhat successful 49 37.4
Successful 61 46.6
Very successful 19 14.5
Total 131 100.0
From the Table 4.3 it is evident that, 61.1 % of the firms are either
successful or very successful in managing the SCM, while 37.5% of firms are
somewhat successful in managing SCM. The percentage of firms not
successful is hardly 1.5%. Obviously this indicates that firms with good
infrastructure and good education background of the owner are managing
their supply chain successfully. The firms, that are somewhat successful in
managing the supply chain, are in the process of adoption and implementation
of the e-business tools for the success of SCM.
4.2.3 Status of the e-business Systems in MSMEs
As high as 12 e-business systems were considered in the analysis to
ascertain the percentage of firms using which type of package or none. The
status established based on the survey is given in Table 4.4.
75
This analysis indicate that 67.9% of the MSMEs are using MRP
either standard or custom made package. Comparatively lesser percentage,
54.9% of the MSMEs are using MRPII either standard or custom made
package because of its vast application.
Usage of ERP package by MSMEs appear significant from
Table 4.4. It is to be noted that as high as 72.5% of the MSMEs are using
ERP either in the standard form or custom made due to its availability at
lesser cost. Totally 57.2% of MSMEs are only using either standard or custom
made package of Warehouse Management System (WMS).
From the point of view of MSMEs, maintaining of proper
relationships both with the customer and supplier are equally important. The
survey reveals that 52.7% and 61.1% of MSMEs are using CRM and SRM
packages respectively either standard or custom made. The use of custom-
made packages is more prevalent than the use of standard package.
From Table 4.4, it is evident that the usage of JIT and APS packages
are not significant. Only 30.5% of firms use JIT supply aiding package and
37.5% use APS package . The MSMEs may have to look in to this aspect
seriously.
The usage of RFID package by MSMEs is very low 11.5% only.
Similarly only 40.5% of them use DSS systems either standard or custom-
made form. Further, it may be noted that 35.8% of the MSMEs use EDI
either standard or custom made package while 51.9% of the MSMEs are
using barcode.
This analysis reveal that the usage of APS, IT, DSS, RFID, EDI and
Bar coding is not quite high as more the 50% of firms do not use any of these
softwares.
76
4.2.4 Association between the e-business Systems Available and
Category of MSMEs
Chi-square test was used to find the association between e-business
systems available and the category of MSMEs. A Cross tabulation was
prepared to test whether there is a significant difference between observed
frequency distribution and a theoretical frequency distribution. In this
manner, the fitness of the distributions between two groups of variables can
be found out. Through this test, the dependency between MSMEs and the
usage of e- business systems can be established. The null hypothesis
formulated is,
H0: E-business systems currently available in MSMEs depend on the
category of MSMEs ( Micro, small and Medium Enterprises)
The Pearson Chi-square value and the significance value is given in
Table 4.5 between each category of MSMEs and e-business systems.
From the Table 4.5, it is evident that the P value is less than 0.05
only in respect of two e-business systems viz., ERP and WMS and the
category of MSMEs, hence the null hypothesis is rejected at 5 percent level of
significance. Thus, there is statistical evidence to confirm the association
between Enterprise Resources Planning (ERP), Warehouse Management
System (WMS) and category of MSMEs. This may be due the size of the
firm having direct influence with use of WMS and ERP for the whole
industry. All the rest of the components don’t have any association with the
category of industry. But, irrespective of the category, all of them use e-
business systems.
77
Table 4.5 The Pearson Chi-square values for association between the
e-business systems currently available in MSMEs and
category of MSMEs
Sl.NoBetween MSME category and e-
business system
Pearson
Chi-Square
Asymp. Sig.
(2-sided)
1 Material Requirement Planning (MRP) 2.645 0.619
2 Manufacturing Resources Planning(MRPII
3.037 0.552
3 Enterprise Resources Planning (ERP) 11.144 0.025*
4 Warehouse Management System (WMS) 15.872 0.003**
5 Supply Chain Management module (SCM)
5.748 0. .219
6 Customer Relationship Management (CRM)
7.633 0.106
7 Supplier Relationship Management (SRM)
8.079 0.089
8 Advanced Planning System (APS) 5.094 0.278
9 Just in time (JIT) 8.011 0. .091
10 E-business 1.790 0.774
11 Decision support / expert System 2.178 0.703
12 Radio frequency Identification(RFID) 2.357 0.670
13 Electronic data interchange (EDI) 4.592 0.332
14 Bar coding 5.382 0 .250
** denotes significance at 1% level * denotes significance at 5% level
78
4.2.5 Association between Success in Managing SCM and e-business
System Currently Available
As discussed in the previous section, Chi-square test was employed
to find the association between the success in managing the SCM in MSMEs
and the e-business system currently available. The null hypothesis formed for
this purpose is,
H0: Success in managing the SCM in MSMEs depends on the e-
business system
Table 4.6 Chi-square value for association between SCM components
and success in managing SCM
Sl.NoSuccess in managing SCM vs
e-business system
PearsonChi-
Square
Asymp. Sig.
(2-sided)1 Material Requirement Planning (MRP) 14.994 0.020*2 Manufacturing Resources Planning
(MRPII) 12.845 0.0456*
3 Enterprise Resources Planning (ERP) Successful in Managing (SCM) 17.170 0.008**
4 Warehouse Management System (WMS) 12.876 0.0450*5 Customer Relationship Management
(CRM) 13.151 0.0407*
6 Supplier Relationship Management (SRM) 10.716 0.098
7 Advanced Planning System (APS) 7.788 0.2548 Just in time (JIT) 17.898 0.006**9 Decision support (DSS) 4.761 0.57510 Radio frequency Identification (RFID) 13.975 0.030*11 Electronic data interchange (EDI) 18.699 0.0048**12 Bar coding (BC) 18.094 0.006*
** denotes significance at 1% level * denotes significance at 5% level
79
From the Table 4.6, it is evident that the P value is less than 0.05 in
respect of all the e-business systems except SRM and DSS and hence the null
hypothesis rejected at 5 percent level of significance in respect of these.
Therefore, it is concluded that there is a statistical evidence for an association
between successful in managing SCM and the following e-business systems
Material Requirement Planning (MRP)
Manufacturing Resources Planning (MRPII)
Enterprise Resources Planning (ERP)
Customer Relationship Management (CRM)
Warehouse Management System (WMS)
Just in time (JIT)
Radio frequency Identification (RFID)
Electronic data interchange (EDI).
4.3 E-BUSINESS ENABLERS AND MSMEs
4.3.1 Status of e-business Enablers in MSMEs
To analyze the status of e-business enablers in MSMEs, the
distribution of firms in percentage that are currently using, planned to use,
under consideration and will never use was made. The Table 4.7 provide the
details.
80
Table 4.7 Percentage analysis of status of e-business enablers with
respect to SCM
Sl. No
e-business enablers
Count&%
Never Considering Planned Currently using Total
1 e-procurement Count 13 59 23 36 131% 9.92 45.04 17.56 27.48 100.00
2 E-auctions for procurement
Count 23 47 29 32 131% 17.56 35.88 22.14 24.43 100.00
3 Retail e-payments
Count 14 40 18 59 131% 10.69 30.53 13.74 45.04 100.00
4 Retail transfer e-payments
Count 10 42 23 56 131% 7.63 32.06 17.56 42.75 100.00
5 Certifications for security of payments
Count 7 34 41 49 131% 5.34 25.95 31.30 37.40 100.00
6 Wholesalers e-payments
Count 17 36 28 50 131% 12.98 27.48 21.37 38.17 100.00
7 Electronic signature
Count 28 36 30 37 131% 21.37 27.48 22.90 28.24 100.00
8 Electronic ID Count 15 47 20 49 131% 11.45 35.88 15.27 37.40 100.00
9 Electronic document management
Count 11 36 41 43 131% 8.40 27.48 31.30 32.82 100.00
10 Collaborative tools for e-business
Count 27 35 25 44 131% 20.61 26.72 19.08 33.59 100.00
11 Internet Count 0 0 2 7 122 131% 0.0 1.52 5.34 93.12 100.00
12 Order processing
Count 1 9 29 92 131% 0.76 6.87 22.14 70.23 100.00
13 Follow up Count 1 10 34 86 131% 0.76 7.63 25.95 65.65 100.00
14 Onlinemarketing
Count 9 24 32 66 131% 6.87 18.32 24.43 50.38 100.00
Total Count 176 457 380 821 1834% 9.60 24.92 20.72 44.77 100.00
81
From Table 4.7, it is evident that 27.5% of firms are using the
e- business enabler e-procurement currently while 24.4% of the firms resort to
e- business enabler e-auctions for procurement. The number of firms planning
to use the e-business enabler e-auctions for procurement form 22.1%.
The analysis reveal that 42.7% of firms are using the e- business
enabler retail e-payments currently; 37.4% for certifications for security of
payments and 31.3% of the firms are planning to use retail transfer
certifications for security of payments.
Only 37.4% of the firms are found using the e-business enabler
wholesalers e-payments, while 28.2% use the electronic signature and 22.9%
of the firms are planning to use the e-business enabler electronic signature.
Evidence also indicate that currently 37.4% of the firms are using
e-business enabler electronic ID; 32.8% of the firms use electronic document
management; the remaining 31.3% of the firms are planning to use electronic
document management.
Analysis reveal that currently 33.6% of the firms are using
collaborative tools for e-business currently. The number of firms found using
the e-business enabler internet currently account for 93.12%, while 5.34% of
the firms are planning to use internet.
From Table 4.7, it may be seen that currently 70.2% of the firms are
using enabler order processing; 22.1% of the firms are planning to use for
order processing and 6.9% of the firms are only aware of the benefits of
order processing and not using.
It may be seen from Table 4.7, 65.6% of the firms are adopting
follow up currently; 50.4% of the firms use for online marketing and 24.4%
of the firms are planning to use it.
82
4.3.2 Status of SC Enablers in MSMEs
The Friedman test is normally applied to data with repeated-
measures designs or matched-subjects designs. With repeated-measures
designs, each item is a case in the data file and has scores on ‘k’ variables.
From the rating score obtained on each of the “k” occasions, one can
determine whether there are significant difference in the rating of items based
on the mean rank, standard deviation and Chi-square values.
Table 4.8 Mean rank and standard deviation towards the status of SC
enablers
Sl.No SC enabler MeanRank
Std. Deviation
1 Close partnership with customers 3.25 0.8822 Close partnership with suppliers 3.18 0.9273 Holding safety stock 2.88 1.0154 Many suppliers 2.77 1.042
5Strategic Planning in Procurement and Distribution 2.73 0.991
6 JIT supply 2.66 1.0517 Third Party Logistics(3PL) 2.6 1.0588 Sub contracting 2.56 1.0779 Few suppliers 2.51 0.995
10 E-procurement 2.5 1.12611 Vertical Integration 2.47 1.01812 Supply chain benchmarking 2.4 0.98213 Use of external consultants 2.31 1.08214 Electronic data interchange (EDI) 2.28 1.03215 Out sourcing 2.23 1.147
Range of mean rank : (1- 1.75) Not appropriate ; (1.76 – 2.5) Improve;
(2.51 – 3.25) -Start implementing; (3.26 – 4) Satisfied already
83
To assess the status of supply chain enabler in MSMEs the
Friedman test was employed to arrive at the mean rank and standard
deviation. The range of mean rank values to identify the status of SC enablers
was calculated based on the average value as interval width. In this case the
minimum rank value is 1, the maximum rank is 4 and the interval width is
0.75. Totally four class intervals adopted, since a four point rating scale was
used. The standard deviation values can be used to supplement the inference
of mean rank values.
From Table 4.8, it is clear that the following SC enablers of MSMEs
have mean rank between 2.51 to 3.25. Obviously they have started to
implement them
close partnership with customers
close partnership with suppliers
holding safety stock
many suppliers
strategic Planning in Procurement and Distribution
JIT supply
third Party Logistics(3PL)
sub contracting
few suppliers
The enablers mentioned below have secured mean rank between
1.76 to 2.5 and hence, they should improve their position.
e-procurement
vertical Integration
supply chain benchmarking
84
use of external consultants
electronic data interchange (EDI)
out sourcing
4.3.3 Benefits of SC Enablers
To find out the benefits of SC enabler in MSMEs, the Friedman test
was applied to establish the mean rank and standard deviation. The range of
mean rank values to identify the benefits of SC enablers was calculated based
on the average value as interval width.
Table 4.9 Mean rank and standard deviation towards benefits SC
enablers
Sl.No SC enablers Number Mean
RankStd.
Deviation1 Increased coordination with
customers 131 3.49 0.807
2Increased coordination with suppliers 131 3.36 0.929
3 Increased sales 131 3.26 0.764 Better quantity of information 131 3.21 0.9015 Flexibility in operation 131 3.17 0.938
6Reduced lead-time in manufacturing 131 3.13 1.091
7 Better operational efficiency 131 3.13 0.7988 Better quality of information 131 3.12 0.9379 Cost saving in manufacturing 131 3.08 0.942
10Increased coordination between departments 131 3.06 1.072
11 Improved Forecasting 131 3.05 0.8812 More accurate costing 131 2.98 0.88113 Improved Resource planning 131 2.95 0.97114 Reduced inventory Level 131 2.92 0.92
Range of mean rank : (1-1.8) - Not at all; (1.9-2.7) - Little;
(2.8-3.5) - Average; (3.6-4.2) – Greatly (4.2-5) - A lot
85
In this case the minimum rank value is 1, the maximum rank is 5
and the interval width is 0.8. Totally five class interval adopted since a five
point rating scale was used.
It is clear that all the benefits of SC enablers in MSMEs listed in the
above table have mean rank between 2.8 to 3.5. Obviously all the above
factors influence the MSMEs at an average level.
4.3.4 Association between SC enablers and the Category of MSMEs
As discussed in the section 4.2.4, the Chi-square test was used to
find the association between the SC enablers and the category of MSMEs.
The null hypothesis formed for this purpose was,
H0: Benefits gained by using SC enablers depends on the category of
MSMEs
Table 4.10 Chi-square value for association between category of
industry and SC enablers
Sl:No Between MSME category and SC enabler
PearsonChi-Square
Asymp. Sig. (2-sided)
1 Better quality of information 24.826 0.002**
2 Better quantity of information 19.848 0.011*
3 Flexibility in operation 20.078 0.010*
4 Reduced lead-time in manufacturing 10.988 0.202
5 Cost saving in manufacturing 18.718 0.016*
6 Improved Forecasting 4.732 0.579
7 Improved Resource planning 15.532 0.049*
86
Table 4.10 (Continued)
Sl:No Between MSME category and SC enabler
PearsonChi-Square
Asymp. Sig. (2-sided)
8 Better operational efficiency 5.321 0.503
9 Reduced inventory Level 16.424 0.037*
10 More accurate costing 19.846 0. 276
11 Increased coordination between departments 7.352 0.499
12 Increased coordination with suppliers 15.993 0.043*
13 Increased coordination with customers 16.862 0.032*
14 Increased sales 5.359 0.719
From Table 4.10, it is evident that the P value is less than 0.05 in
respect of 8 items and hence the null hypothesis was rejected at 5 percent
level of significance. Thus, there is statistical evidence establishing
association between category of MSMEs and the following SC enablers.
better quality of information
better quantity of information
flexibility in operation
cost saving in manufacturing
improved resource planning
reduced inventory level
increased coordination with suppliers
increased coordination with customers.
87
The remaining six SC enablers out of the 14 considered do not have
any significant association with the category of MSMEs.
4.3.5 Establishment of Relationship between Benefits and SC
Enablers
In order to establish relationship between the benefit accrued and
SC enabler, a multiple regression analysis was adopted. Here, the benefits
accrued are the dependent variable while the SC enablers are the predictor or
independent variables. A stepwise regression approach was used by adding
variable one at a time and checking its contribution and the variable that
contributes to the model was retained. All other variables in the model are re-
tested to see if they are still contributing to the success of the model. If they
no longer contribute significantly they are removed. Thus, this method
ensures that the smallest possible sets of predictor variables that contributes
are included in the model.
Multicollinearity occurs when independent or predictor variables are
highly correlated with each other. It is difficult to establish with reliable
estimates of their individual regression coefficient using beta weight (Garson,
2008). To avoid occurrence of multicollinearity, tolerance indicator of more
than 0.1 and variation inflation factors (VIF) not greater than 10 (Ooi et al
2007) were used. The threshold value of condition index is 15-30, with 30 as
the most commonly used value.
Of the 15 supply chain (SC) enablers used in the stepwise multiple
regression, only two enablers found contributing to the benefits. The
dependent and independent variables finally established are,
88
Dependent variable : Benefits of using SC enablers (Y)
Independent variables : i)Strategic planning in procurement and
distribution (X1)
: ii) Close Partnership with customers (X2)
Table 4.11 gives the value of coefficients, correlation coefficient
(R), R2 and adjusted R2 along with F value and P-values for each model
considered. The -coefficient, t-value, collinearity statistics and conditional
index are given for each model considered in Table 4.12.
Table 4.11 Model fit coefficient value for the analysis between benefits
and SC enablers in MSMEs
Model R R SquareAdjusted R
SquareF value P value
1 0.401 0.160 0.154 24.653 <0.001**
2 0.517 0.267 0.256 23.308 <0.001** ** denotes significance at 1% level
Table 4.12 coefficient, t value and significance value for the analysis
between benefits of using the SC enablers and availability of
SC enablers in MSMEs
Model Variable
Unstandardized Coefficients
Standard.Coeff. t -
valueSig.
Collinearity Statistics Condition
IndexBeta Std.Error Beta Tol. VIF
1 (Constant) 33.890 2.142 - 15.82 <0.001** - - 1.000(X1) 3.661 0.737 0.401 4.965 <0.001** 1.000 1.000 5.712
2 (Constant) 24.084 3.034 - 7.937 <0.001** - - 1.000(X1) 3.207 0.700 0.351 4.585 <0.001** 0.977 1.023 5.896(X2 ) 3.389 0.786 0.330 4.313 <0.001** 0.977 1.023 9.507
** denotes significance at 1% level
89
From Table 4.11, it is evident that for model-1, the multiple
correlation coefficient (R value) is 0.401 which indicates the degree of
relationship between the strategic planning in procurement and distribution
with the benefits of using e-SCM components. It shows a positive relationship
between the dependent variable and the independent variable viz., strategic
planning in procurement and distribution.
For the model 2 a second variable namely close partnership with
customers (X2) was added. It may noted that the multiple correlation
coefficient now increased to 0.517. This implies that close partnership with
customers also contribute to the benefits of using e-SCM components. From
the final model with two independent variables the value of R square is 0.267
which explain that 26.7% of the variation in benefits of using e-SCM
components is on account of these two independent variables. The R square
value is also significant at 1% level. The multiple regression equation
developed is
Y = 24.087 + 3.207 X1 +0.786 X2
The -coefficient of X1 is 3.207, which represents the partial
positive effect of strategic planning in procurement and distribution (X1) on
benefits of using e-SCM components(Y), holding the variable close
partnership with customers(X2) constant and this coefficient value is
significant at 1% level.
Similarly, the -coefficient of X2 is 0.786 and represents the partial
positive effect of close partnership with customers(X2) on benefits of using
e-SCM components (Y), holding the variable strategic planning in
procurement and distribution (X1) constant and this coefficient is significant
90
at 1% level. Also it may be noted from table 4.12 that, all the condition index
values are less than 30 and the VIF value is less than 10 indicating no
multicollinearity in this analysis.
Each sub factors of the dependent variable was measured with a five
point rating scale viz., 1-Not at all; 2- Little; 3-Average; 4-Greatly; 5-A lot.
Totally fifteen sub factors used for the independent variable. While
constructing the multiple regression model the rating values of all the sub
factors were summed up. Hence, for establishing the value of the dependent
variable in this model, the range of rating scale values adopted is; 1-15 not at
all; 16-30 little; 31-45 average; 46-60 greatly and 61-75 a lot.
4.4 SUPPORTS FOR SUPPLY CHAIN MANAGEMENT OF
MSMEs
4.4.1 Emphasis of Company Strategy in SC
To assess the support for SCM based on emphasis of company
strategy in MSMEs, the Friedman test was applied to find the mean rank and
standard deviation. The range of mean rank values to identify emphasis of
company strategy was calculated based on the average value as interval
width. In this case the minimum and maximum are 1 and 5 rank value
respectively and the interval width is 0.8. The number of class intervals
adopted was five, since a five point rating scale was used. The mean rank and
standard deviation for the items considered is given in Table 4.13.
91
Table 4.13 The mean rank and standard deviation towards emphasis of
company strategy in SCM
Sl.No
Emphasis of company strategy in SCM Number
MeanRank
Std. Deviation
1 On offering products with the best quality and yet with a minimum price
131 3.24 0.851
2 On reducing the lead time in the supply chain 131 3.16 0.83
3 On producing innovative and technologically superior products 131 3.13 0.872
4 On ensuring the product are readily available on the shelf in the market
131 3.1 0.858
5 On offering returns management solutions 131 3.09 0.818
Range of mean rank: (1-1.8) - Not at all; (1.9 -2.7) - Little;
(2.8-3.5) -Average; (3.6-4.2) - Greatly; (4.2 – 5) - A lot.
From Table 4.14, it is clear that the following company strategy of
MSMEs have mean rank between 2.8 to 3.5. This indicates that the MSMEs
are averagely influenced by,
offering products with the best quality and yet with a
minimum price
on reducing the lead time in the supply chain
on producing innovative and technologically superior products
on ensuring the product are readily available on the shelf in
the market
on offering returns management solutions.
92
4.4.2 Emphasis of Top Management in SCM
In order to establish the support for SCM based on emphasis of top
management in MSMEs the Friedman test was applied to find the mean rank
and standard deviation. The range of mean rank values to identify emphasis
of top management was calculated taking the average value as interval width.
In this case the minimum rank value is 1, the maximum rank is 5 and the
interval width is 0.8. A total of five class intervals were adopted since a five
point rating scale was used. Table 4.14 gives the details of mean values and
standard deviation.
Table 4.14 Mean rank and standard deviation towards emphasis of top
management in SCM
Sl.No Emphasis on top management factors Number
MeanRank
Std. Deviation
1 Has a very clear customer and shareholders focus 131 3.34 0.83
2 Ensures a good internal communication and dialogue process
131 3.34 0.73
3 Supports the acquisition and implementation of appropriate information system across departments and across the supply chain
131 3.23 0.837
4 Commits adequate resources for effective SCM 131 3.21 0.765
5 Ensures performance measures are aligned with the SCM Strategy 131 3.1 0.812
Range of mean rank : (1-1.8) - Not at all; (1.9 -2.7) - Little;
(2.8-3.5) – Average (3.6-4.2) - Greatly; (4.2-5) - A lot.
93
All the factors taken in consideration for the emphasis of top
management in SCM have mean rank between 2.8 to 3.5. On the basis of this
it can be considered that the MSMEs are influenced averagely by these five
factors viz., clear customer and shareholders focus, ensuring a good internal
communication, support the acquisition and implementation of appropriate
information system across departments and supply chain, commitment of
adequate resources for effective SCM and ensuring performance measures
that are aligned with the SCM strategy.
4.4.3 Importance of SCM Attributes
As in the previous case, to find out the support for SCM based on
SCM attributes in MSMEs the Friedman test was applied to establish the
mean rank and standard deviation. The range of mean rank values to identify
emphasis of top management was calculated based on the average value as
interval width. The minimum and maximum rank value are 1 and 5
respectively with interval width as 0.8. Totally five class intervals were
adopted since a five point rating scale was used. The result of the Friedman
test is given in Table 4.15.
From Table 4.15, it is obvious that only two SCM attributes of
MSMEs viz., team work and reduced inventory level have mean rank
between 3.6 to 4.2 indicating that they influence the MSMEs greatly. The
attributes listed below have secured the mean rank between 2.8 to 3.5 and
hence, their level of influence is only average in MSMEs .
94
Table 4. 15 Mean rank and standard deviation towards importance of
SCM attributes
Sl.No
SCM attributes NMeanRank
Std. Deviation
1 Team Work 131 3.99 0.9572 Reduced inventory level 131 3.56 0.8953 Response time 131 3.44 0.8784 Strategic sourcing 131 3.39 0.8735 Use of SCM applications software 131 3.3 0.9426 Vendor managed inventory 131 3.25 0.7687 Information sharing with the supplier 131 3.21 0.8688 JIT Supply 131 3.15 0.9629 Electronic Data Interchange (EDI) 131 3.11 0.96310 Supply Chain Benchmarking 131 3.05 0.52412 Third Party Logistics 131 3.05 0.85813 E-procurement 131 3.02 0.80814 Subcontracting 131 2.95 0.727
Range of mean rank : (1-1.8) - Not at all; (1.9 -2.7) - Little;
(2.8-3.5) - Average; (3.6-4.2) - Greatly; (4.2-5) - A lot.
response time
strategic sourcing and
vendor managed inventory.
information sharing with the supplier
JIT Supply
electronic Data Interchange (EDI)
supply Chain Benchmarking
Third Party Logistics (3PL)
E-procurement
subcontracting
95
4.4.4 Emphasis on e-business Infrastructure Requirement
The emphasis on e-business infrastructure requirement to support
MSMEs was found out through mean rank and standard deviation by
applying the Friedman test results. The range of mean rank values were
calculated taking on the average value as interval width. In this case also the
minimum rank value is 1, with the maximum rank as 5 and the interval width
is 0.8. A total of five class interval were adopted since a five point rating
scale was used. The results are reported in Table 4.16.
Table 4.16 Mean rank and standard deviation towards emphasis of e-
business infrastructure requirement
Sl.No
e-business infrastructures NumberMean
RankStd.
Deviation
1 Various departments, offices and branches are electronically linked for better coordination
131 2.88 1.116
2 Trading partners have access to the organization’s real Time dynamic information through secure extranet sites
131 2.66 0.991
3 The information system is periodically reviewed and technologically updated to respond to ever increasing requirements
131 2.79 0.977
4 Information systems are regularly updated with accurate and timely information
131 2.93 0.954
Range of mean rank : (1-1.8) - Not at all; (1.9 -2.7) - Little;
(2.8-3.5) - Average; (3.6-4.2) - Greatly; (4.2-5) - A lot.
96
From Table 4.16, it is noted that the following two e-business
infrastructures of MSMEs have mean rank between 2.8 to 3.5 stressing the
fact that MSMEs are influenced averagely by these two viz.,
regular updation of information systems with accurate and
timely information
linking of various departments, offices and branches
electronically for better coordination.
The other two factors namely periodic review of the information
system and technological updation to respond to ever increasing
requirements, and accessibility by trading partners to organizations real time
dynamic information through secure extranet sites have mean values
marginally less than average.
4.4.5 Bench Marking of SCM Activities
The support for SCM based on Bench marking of SCM activities in
MSMEs was tested using the Friedman test to find the mean rank and
standard deviation. The range of mean rank values to identify bench marking
of SCM activities was calculated based on the average value as interval
width. In this case, the minimum rank value is 1, the maximum rank is 5 and
the interval width is 0.8. Totally five class intervals were adopted since a five
point rating scale was used. The results are given in Table 4.17.
97
Table 4.17 Mean rank and standard deviation towards bench marking
of SCM activities
Sl.No Bench marks of SCM NumberMeanRank
Std. Deviation
1 Manufacturing 131 3.7 0.909
2 Customer focus 131 3.64 0.886
3 Performance metrics 131 3.63 0.862
4 Employee training and management
131 3.6 0.966
5 Managing information 131 3.58 0.96
6 Trading partner management 131 3.48 0.807
7 Returns management 131 3.4 0.942
8 Inventory management 131 3.37 0.879
9 Supply chain design 131 3.31 0.895
Range of mean rank : (1-1.8) - Not at all; (1.9 -2.7) - Little;
(2.8-3.5) - Average; (3.6-4.2) – Greatly (4.2-5) - A lot.
It may be seen from Table 4.17 that the first four items have mean
rank between 3.6 to 4.2. Thus, the MSMEs are influenced greatly by
manufacturing operations, customer focus, performance metrics, employee
training and managing information. The remaining five items 5, 6, 7, 8 and 9
have secured the mean rank between 2.8 to 3.5 and hence the influence of
them on the MSMEs is only average. The items include trading partner
management, returns management, inventory management and supply chain
design.
98
4.4.6 Association between Benchmarking of SCM Activities and the
Support by Top Management of MSMEs
A stepwise multiple regression analysis approach was adopted, to
establish the relationship between Benchmarking of SCM activities and the
support by top management of MSMEs. Out of 5 top management support
factors, after completing stepwise multiple regressions, it was found that all
the five factors contribute to the SCM bench marking. The dependent
variable and the independent or predictor variables considered, coefficient of
correlation (R), coefficient of determination (R2), F value and P-value are
given below:
Dependent variable : SCM Benchmarking (Y)
Independent variables : i) Commits adequate resources (X1)
ii) Has a very clear customer and shareholders focus (X2)
iii) Ensures a good internal communication and dialogue process (X3)
iv) Supports the acquisition and implementation of appropriate information system (X4)
v) Ensures performance measures are aligned with the SCM Strategy(X5)
R value : 0. 604
R Square value : 0.365
F value : 14.366
P value : <0.001**
The value of -coefficient, t-value, significance value, collinearity
statistics and condition index are detailed in Table 4.18.
99
Table 4.18 -coefficient, t value and significance value for the analysis
between the benchmarking of SCM activities and top
management of MSMEs
Model
Variable
Unstandardized
Coefficients
Standardized
Coefficients
t-valu
eSig.
Collinearity Statistics Conditi
on Index
BetaStd. Erro
rBeta Toleran
ce VIF
1 (Constant)
14.986
2.407 - 6.226
<0.001**
- - 1.000
(X1) 0.728 0.754 0.094 0.965
0.337 0.534 1.872
10.648
(X2) 0.460 0.616 0.064 0.746
0.457 0.681 1.469
12.389
(X3) 1.114 0.796 0.137 1.399
0.164 0.527 1.898
14.678
(X4) 2.948 0.619 0.417 4.764
<0.001**
0.662 1.510
16.154
(X5) 0.867 0.627 0.119 1.383
0.169 0.686 1.457
17.922
It may noted that the multiple correlation coefficient is 0.604 and
this coefficient measures the degree of relationship of all the five independent
variables with SCM bench marks. From the model with five independent
variables the value of R square is 0.365 which implies that 36.5% of the
variation in SCM benchmarks due to the five independent variables. The R
square value is significant at 1 % level. Based on the analysis, the multiple
regression equation of model arrived at is,
Y = 14.986+ 0.728 X1 + 0.460 X2 + 1.114 X3 + 2.948 X4 + 0.867 X5
The coefficient of X1 is 0.728 which indicates the partial positive
effect of committing adequate resources (X1) on SCM benchmarking (Y),
holding the other four variables viz., X2, X3, X4 and X5 constant. This
100
coefficient value is not significant at 1% level, so its contribution need not be
considered as valid in this model.
For the variable X2 the -coefficient value is 0.460 which gives the
partial positive effect of having a very clear customer and shareholders focus
(X2) on SCM bench marking (Y) holding X1 , X3 , X4 and X5 constant and this
coefficient value is also not significant at 1% level, so its contribution may
not be valid in this model.
The -coefficient of X3 is 1.114 representing the partial positive
effect of ensuring a good internal communication and dialogue process (X3)
on SCM benchmarking (Y) holding X1 , X2 , X4 and X5 constant. This
coefficient value is not significant at 1% level. so its contribution may not be
valid in this model.
The value of -coefficient for X4 is 2.948 indicating the partial
positive effect of supporting the acquisition and implementation of
appropriate information system (X4) on SCM benchmarking (Y) holding X1 ,
X2 , X3, X5 constant and this coefficient value is significant at 1% level..
Likewise, the -coefficient of X5 is 0.864 which represents the
partial positive effect of ensuring performance measures aligned with the
SCM strategy(X5) on SCM bench marking (Y) holding X1, X2, X3 and X4
constant. This coefficient value is also not significant at 1% level, so its
contribution may not be valid in this model.
It may also be noted that from table 4.18 that all the condition index
values are less than 30 and the VIF value also less than 10. This implies that
there is no multicollinearity in the predicator or independent variable.
101
Each sub factors of dependent variable was measured with the five
point rating scale viz., 1-Not at all; 2 - Little; 3 - Average; 4 - Greatly; 5 - A
lot. Totally nine sub factors used for the independent variable. While
constructing the multiple regressions model the rating values of all the sub
factors are summed up. Hence for assigning value to the dependent variable
in this model, the range of rating scale values adopted are; 1-9 not at all;
10-18 little; 19-27 average; 28-36 greatly and 37-45 a lot.