EGY_HEGS_2012_V1.0 DDI_EGY_2014_CDMSE_v01_M Economic Research Forum 2014 Nesstar Publisher Economic Research Forum Version 2.0 - This is identical to ERF Version 1.0 downloaded from http://erfdataportal.com/index.php/catalog/89 on 6/9/2016. ID fields edited Study on the Constraints Facing the Development of Micro and Small Enterprises, 2014 CDMSE 2014 EGY_2014_CDMSE_v01_M Economic Research Forum (c) 2016, Economic Research Forum Nesstar Publisher Economic Research Forum (ERF) - 21 Al-Sad Al-Aaly St., Dokki, Giza, Egypt Other Enterprise Survey Version 1.0: A version of the raw data prepared for dissemination The Economic Research Forum has collected this dataset and releases it for dissemination in both SPSS and STATA formats. Egypt, Arab Rep. The survey was implemented in the Gharbeya and Bani Suef governorates. Micro and Small Enterprises Sample survey data [ssd] Economic Research Forum Face-to-face [f2f] One questionnaire form, in both Arabic and English, consisting of 12 Parts was designed to collect the survey data. Data is not weighted Economic Research Forum Licensed datasets, accessible under conditions. The Economic Research Forum has granted the researcher access to relevant data following exhaustive efforts to protect the confidentiality of individual data. The researcher is solely responsible for any analysis or conclusions drawn from available data. ERF data on MSEs.NSDstat 0 199 Nesstar 200801 Project basic information Demographic information of the project owner Project description Sources of project financing Technical support for the project Project labor Project expenditures Marketing Project revenues Constraints facing the project Other information on the owner/employer and his/her opinions Future expectations Project ID 0 0 Governorate 0 0 Project sector 0 0 1 Commercial 2 Industrial 3 Agriculture 4 Services Formality status 0 0 1 Formal 2 Informal Project life (in years) 0 0 Owner's gender 0 0 1 Male 2 Female Owner's age 0 0 Owner's marital status 0 0 1 Single 2 Married 3 Widowed 4 Divorced Owner's education status 0 0 1 Illiterate 2 Read and Write 3 Less than intermediate 4 Intermediate 5 Above intermediate 6 University & above Ever worked outside Egypt 0 0 1 Yes 2 No Project workplace 0 0 1 Own home 2 Another home 3 Flat or office 4 Shop 5 Workshop or factory 6 Kiosk 7 Hut 8 Shop-window 9 Street vendor Year project started 0 0 Periodicity of work 0 0 1 All year 2 Seasonal Project ownership 0 0 1 Individual 2 Partnership This is the only workplace for the project 0 0 1 Yes 2 No Number of branches 0 0 Nature of workplace 0 0 1 Branch 2 Headquarter 3 Sales point 4 Intermediary production place Project has an activity practice license 0 0 1 Yes 2 No Project has a commercial/industrial register 0 0 1 Yes 2 No Project keeps regular accounting books 0 0 1 Yes 2 No Project is registered at Taxes authorities 0 0 1 Yes 2 No Q208/209=No; License/register cost is too high for the project 0 0 1 Yes 2 No Q208/209=No; Project has just started and will be registered upon success 0 0 1 Yes 2 No Q208/209=No; Too long licensing process which might delay starting the project 0 0 1 Yes 2 No Q208/209=No; Too many procedures/approvals from different authorities 0 0 1 Yes 2 No Q208/209=No; Other reasons 0 0 1 Yes 2 No To encourage licensing; Temporary tax exemption 0 0 1 Yes 2 No To encourage licensing; Temporary insurance exemption 0 0 1 Yes 2 No To encourage licensing; Reduce employer and employee share in social insurance 0 0 1 Yes 2 No To encourage licensing; Facilitate financing from banks 0 0 1 Yes 2 No To encourage licensing; Share big projects to reduce production and market costs 0 0 1 Yes 2 No To encourage licensing; Other facilities 0 0 1 Yes 2 No Value of initial capital (in LE) 0 0 Value of current capital (in LE) 0 0 Financing sources: Self-financed 0 0 1 Primary source 2 Secondary source Financing sources: RoSCA-financed 0 0 1 Primary source 2 Secondary source Financing sources: Formal loan finance 0 0 1 Primary source 2 Secondary source Other financing sources 0 0 1 Primary source 2 Secondary source Self-financed: From personal/family savings 0 0 1 Yes 2 No Self-financed: From family heritage 0 0 1 Yes 2 No Self-financed: From selling assets 0 0 1 Yes 2 No Self-financed: From savings from work outside the country 0 0 1 Yes 2 No RoSCA-financed; Association with relatives, neighbors or friends 0 0 1 Yes, currently 2 Yes, previously RoSCA-financed; Amount paid (in LE) 0 0 RoSCA-financed; Payment periodicity 0 0 1 Monthly 2 Weekly 3 Daily RoSCA-financed; Number of persons engaged 0 0 RoSCA-financed; When engaged: Month 0 0 RoSCA-financed; When engaged: Year 0 0 RoSCA-financed; Last time, how did you use the money? 0 0 1 Don't have it yet 2 Save it all 3 Personal shopping 4 Shopping for family 5 Invest in private business 6 Spending on business and family 7 Others RoSCA-financed; Next time, how will you use the money? 0 0 1 Don't have it yet 2 Save it all 3 Personal shopping 4 Shopping for family 5 Invest in private business 6 Spending on business and family 7 Others Loan/advance finance; Source 0 0 1 Bank 2 SFD 3 Credit company 4 NGO 5 Relatives and friends 6 Business partners 7 Money lender 8 Others Loan/advance finance; Source; Reason for choosing this source 0 0 Loan/advance finance; Month when acquired 0 0 Loan/advance finance; Year when acquired 0 0 Loan/advance finance; Month when first used 0 0 Loan/advance finance; Year when first used 0 0 Loan/advance finance; Value (in LE) 0 0 Loan/advance finance; Duration in months 0 0 Loan/advance finance; Duration in years 0 0 Loan/advance finance; Month when ending 0 0 Loan/advance finance; Year when ending 0 0 Formal loan finance; Interest rate (%) 0 0 Formal loan finance; Level of interest 0 0 1 Suitable 2 High 3 Too high Formal loan finance; Payment method 0 0 1 Suitable 2 Not suitable Formal loan finance; Grace period 0 0 1 Suitable 2 Not suitable Formal loan finance; Acquisition procedures 0 0 1 Simple 2 Normal 3 Difficult Formal loan finance; Field in which it is used 0 0 1 Start business 2 Expansion 3 Operating expenses 4 Others Formal loan finance; Payment status 0 0 1 Fully paid 2 Pay regularly 3 Do not pay regularly 4 Tripped Formal loan finance; Reason for payment irregularities 0 0 1 High installment 2 Expensive raw material & supplies 3 High wages 4 High stock & low demand 5 Others Formal loan finance; Getting it was easier before 2011 0 0 1 Yes 2 No 3 New firm Capital increased since launch (value added) 0 0 1 Yes 2 No Type of value-added 0 0 Value of value-added 0 0 Source of value-added 0 0 Needs financial support 0 0 1 Yes 2 No Value of support needed (in LE) 0 0 Got any type of financial awareness or banking training 0 0 1 Yes 2 No Seminar/Training title 0 0 Seminar/Training sponsor 0 0 Should provide training to the employees 0 0 1 Yes 2 No Nature of training required (1) 0 0 Nature of training required (2) 0 0 Nature of training required (3) 0 0 Product was improved during operation 0 0 1 Yes 2 No Describe improvements 0 0 Project materials are available in local unit (village/shiakha) 0 0 1 Yes 2 No Location where materials are available 0 0 1 At the district 2 At the governorate 3 Outside the governorate Production method was developed after operation 0 0 1 Yes 2 No Type of development 0 0 Disruption happen during operation 0 0 1 Yes 2 No 3 NA Reason for disruptions 0 0 Daily working hours at startup 0 0 Daily working hours at survey time 0 0 Reason for decreasing/increasing working hours below/above legal limit 0 0 Employer works in the project 0 0 1 Yes 2 No Number of employees (including the employer) 0 0 Number of male employees 0 0 Number of female employees 0 0 Number of Egyptian employees 0 0 Number of employees from other nationalities 0 0 Number of illiterate employees 0 0 Number of employees who can read & write 0 0 Number of employees who acquired an education certificate 0 0 Number of employees changed compared to 2011 0 0 1 Yes 2 No Type of change (increased/decreased) 0 0 1 Increased 2 Decreased Level of increase/decrease 0 0 Project includes waged workers from outside the HH 0 0 1 Yes 2 No Number of waged workers from outside the HH 0 0 Wages increased since launch 0 0 1 Yes 2 No Type of wages increase 0 0 1 Annually 2 According to production 3 According to marketing Employees benefit from employment contracts 0 0 1 Yes, all 2 Yes, but not all 3 No one Employees benefit from social insurance 0 0 1 Yes, all 2 Yes, but not all 3 No one Employees benefit from medical insurance 0 0 1 Yes, all 2 Yes, but not all 3 No one Employees benefit from paid sick leaves 0 0 1 Yes, all 2 Yes, but not all 3 No one Employees benefit from paid annual leaves 0 0 1 Yes, all 2 Yes, but not all 3 No one Employees benefit from maternity leaves 0 0 1 Yes, all 2 Yes, but not all 3 No one No contract/insurance; Lack of commitment to work 0 0 1 Yes 2 No No contract/insurance; High turnover once employees get training 0 0 1 Yes 2 No No contract/insurance; Financial burden on the project 0 0 1 Yes 2 No No contract/insurance; Refused by workers to avoid salary reduction 0 0 1 Yes 2 No No contract/insurance; Amounts insured are less than actual amounts 0 0 1 Yes 2 No No contract/insurance; Other reasons 0 0 1 Yes 2 No To provide contract/insurance; Temporary tax exemption 0 0 1 Yes 2 No To provide contract/insurance; Temporary insurance fees exemption 0 0 1 Yes 2 No To provide contract/insurance; Reduce employer/employee share in insurance 0 0 1 Yes 2 No To provide contract/insurance; Other facilities 0 0 1 Yes 2 No Project spending on total salaries during the month preceding the survey 0 0 Project spending on raw materials 0 0 Project spending on machines spare parts 0 0 Project spending on land, warehouses, building and premises rentals 0 0 Project spending on machines and vehicles rentals , 0 0 Project spending on machines and vehicles maintenance 0 0 Project spending on electricity 0 0 Project spending on water 0 0 Project spending on taxes 0 0 Other project spending 0 0 Main customer for project product/service 0 0 1 Consumers/individuals 2 Private sector units 3 Public sector units 4 Government 5 Wholesalers and retailers 6 Exporters or foreigners 7 Other Developing marketing strategy for the product 0 0 1 Yes 2 No Type of development for marketing strategy 0 0 1 Selection 2 Packaging 3 Storage 4 Others Marketing outlets for the product 0 0 1 Business portal 2 Permanent markets 3 Temporary markets 4 Exhibitions 5 Projects outlets Developed/improved marketing methods 0 0 1 Yes 2 No Nature of development/improvement 0 0 Project achieved net profit 0 0 1 Yes 2 No Value of net profit (in LE) 0 0 Profit used in savings 0 0 1 Yes 2 No Profit used in increasing project capital 0 0 1 Yes 2 No Profit used in buying raw materials and production supplies 0 0 1 Yes 2 No Net profit changed compared to previous year 0 0 1 Increased 2 Decreased 3 Did not change Percentage change in net profit compared to previous year 0 0 Net profit changed compared to before 2011 0 0 1 Increased 2 Decreased 3 Did not change Percentage change in net profit compared to before 2011 0 0 Constraints: Financial issues 0 0 1 Yes 2 No Constraints: Administrative issues 0 0 1 Yes 2 No Constraints: Market demands 0 0 1 Yes 2 No Constraints: Product quality/project management 0 0 1 Yes 2 No Constraints: Technical competency for trained maintenance workers 0 0 1 Yes 2 No Constraints: Lack of production supplies 0 0 1 Yes 2 No Constraints: Lack of info on raw materials/products markets and project services 0 0 1 Yes 2 No Constraints: Severe competition between similar projects 0 0 1 Yes 2 No Constraints: Difficulty of participation in exhibitions and public markets 0 0 1 Yes 2 No Constraints: Lack of permanent marketing outlets 0 0 1 Yes 2 No Constraints: Lack of technical support for marketing operations abroad 0 0 1 Yes 2 No Constraints: Low purchasing power in project area 0 0 1 Yes 2 No Constraints: Legal issues 0 0 1 Yes 2 No Constraints: Training on foreign languages to deal with customers 0 0 1 Yes 2 No Constraints: Access to utilities 0 0 1 Yes 2 No Other constraints 0 0 1 Yes 2 No Member in professional syndicate 0 0 1 Yes 2 No Member in cooperative association 0 0 1 Yes 2 No Member in trade union 0 0 1 Yes 2 No Member in business men association 0 0 1 Yes 2 No Member in other entities 0 0 1 Yes 2 No Does not have any memberships 0 0 1 Yes 2 No Ever invited to attend seminars/workshops/conferences/meetings on MSEs awareness 0 0 1 Yes 2 No Think about getting a membership in any of the entities 0 0 1 Yes 2 No Society encourages and assists MSEs 0 0 1 Yes 2 No Barriers for private projects: Losses/incapable of paying loans 0 0 1 Yes 2 No Barriers for private projects: Lack of required capital 0 0 1 Yes 2 No Barriers for private projects: Lack of social/security coverage 0 0 1 Yes 2 No Barriers for private projects: Lack of qualifications to make the project works 0 0 1 Yes 2 No Barriers for private projects: Fulfil licensing process and legal conditions 0 0 1 Yes 2 No Barriers for private projects: Might face damages being a woman 0 0 1 Yes 2 No Barriers for private projects: People's perception in case of failure 0 0 1 Yes 2 No Barriers for private projects: Incapable to control work power 0 0 1 Yes 2 No Barriers for private projects: Facing corruption 0 0 1 Yes 2 No Barriers for private projects: Severe competition in the field 0 0 1 Yes 2 No Barriers for private projects: Customer may not need my products 0 0 1 Yes 2 No Other barriers for private projects 0 0 1 Yes 2 No Intention for expansion 0 0 1 Yes 2 No Expansion area: Number of workers 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Project area 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Products 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Assets 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Use of advanced technology 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Revenues 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Local sales 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: Exports 0 0 1 Increased 2 Decreased 3 Did not change Expansion area: New products 0 0 1 Increased 2 Decreased 3 Did not change Financing source for expansion 0 0 1 Private savings 2 Assets liquidation 3 Formal loan 4 Informal loan 5 Others