No.

Item Unit of Quantity Unit Price Total Price

Measurement
1 Shuttle box hand lo pcs 8

2 Foot-power floor h pcs 8

3 Loom bench pcs 16

4 Vertical warping reepcs 2

5 Yarn spacer frame pcs 2

6 Flat shuttles pcs 48

7 Weft winding wheelpcs 2

8 Cotton spinning whepcs 6

Total
Specifications

· Made of metal and wood materials

· Width 160cm
· With full accessories including reed and flying shuttles
· Made of metal and wood materials
· Width 120cm
· With full accessories including reed
· Enlarged model
· Legs are metal
· Top wood
· Made of metal and wood materials
· Four wings model
· Wings to wings 0.75cm
· With bearings
· Made of wood
· Width 120 cm
· Height 120cm
· With 50 thread wails
· Made of hard wood
· One Bobbin model
· Made of wood
· Legs are metal
· With bearings
· Made of wood
· Legs are metal
· Including speal parts
No. Item Unit of Quantity
Measurement
1 Latche machine pcs 2

Provide and supply wood lath machine 2HP, single

phase, and 220/380v semi automatic long-bed wood-
turning lathe. A top quality, powerful industrial
machine with detached gap bed and 2-speed motor
giving 8 spindle speeds: length 2700mm,width
600mm,height 1400mm.Fitted with rack drive carriage
and compound slide rest for precision pattern making
work. Left-hand end of spindle is threaded to take
faceplates complete with all the necessary accessories
and spares. Made in Italy or similar
2 Surface Planer pcs 2

Provide and supply semi- automatic 220/380V

maximum cutting width:24;maximum cutting height 8-
1/4;maximum depth of cut:1/8;minimum stock
thickness ¼;minimum stock length 8;bed size 31-
1/2;x24-1/8; Cutter head R.P.M 5200;

Rate of feed per minute 17-26F.P.M; Number of cuts

per inch 66-101;Number of cuts per minute 28,800

Cutter head motor: 5.H.P, 220V, 25amps, single phase;

Overall size: 42H X 38W X 33D power transfer double V
belt complete with the necessary accessories and
spares.
3 Edge Planer pcs 2

Provide and supply 220/380V semi automatic cutter

head R.P.M 5200; rate of feed per minute 17-26 F.P.M;
Number of cuts per inch 66-101; Number of cuts per
minute 28,800;Cutter head motor
5.H.P,220V,25amps,single phase; complete with the
necessary accessories and spares. Made in Italy or
similar
4 Bench Jig Saw pcs 2
 Provide and supply automatic single phase 220/380V
2.0KW bench jig saw complete with all the necessary
accessories and spares. Made in Italy or similar
5 Hand Router pcs 2

Provide and supply automatic hand router single phase

220V 500W complete with the necessary accessories
and spares. Made in Italy or similar
6 Circular Saw pcs 2

Provide and supply semi automatic single phase

220/380V 2.0KW complete with the necessary
accessories and spares. Made in Italy or similar
7 Band Saw pcs 2

Provide and supply semi automatic band saw single

phase 1.5 hp,1.1KW.220/380V including all the
necessary accessories and spares. Made in Italy or
similar
8 Hand Drill pcs 4

Provide and supply single phase automatic hand drill

500W, 220V single phase including set of wooden drills.
Made in Italy or similar
9 Hand Saw pcs 4
Provide and supply Flat hand saw made in Sweden type
or similar
10 Drill set pcs 4
Wood1-23 mm diameter Made in Italy or similar
11 Hand Tools
100 cm flexible steel ruler pcs 4
Bench sheet metal cutter 4mm pcs 4
Micrometer 0-25mm pcs 4
Chisel and punch set pcs 4
Bench grinder 200mm Makita or similar pcs 4
Bench grinder 150mm Makita or similar pcs 4
12 Star Up Raw materials M2 12
12 meter cube 5mm Wanza or Kerero
Total
Unit Price Total Price Remarks
SN Name of material Unit Quantity Unit price Total price

1 Wheel with its accessories no 12 1750 21000

2 Clay crasher ‘’ 1 500 1500
3 Clay crincler
24 Engraving and polishing hand toolump sum 24

62048
Remark
 land rent and civil works

s/n Cost item

1 Land rent
Land escaping and
2 innovation
Total

Furniture and equipment

S/n Cost item
Office and display
1
furniture
Computers and it
2
equipment
Total

cost of machinary and equipment

s/n
poetery production line
1 machinary for pottery
2 equipment and hand tools
Total
weaving product line
1 machinary
2 equipment and hand tools
Total
stone and wood craft product line
1 machinary
2 equipment and hand tools
Total
painting and printing productline
1 leaser printing machine
2 equipment and hand tools
Total
Grand total

Material cost
No. Material

3 Wood
4 Cotton
5 Stone
 6 Clay/Sand
other adhesives
Total

salary and benefits

s/n position
1 General manager
2 assistant manager
3 machine operaters
4 crafts men
5 it expert
6 sales person
7 janitary
8 Guards
Total
benefits
Grand total

summary of investment cost

Description Total Cost (Birr)

land rent &civil work 500,000
furniture & office equipment 1,200,000
machinary and equipment 4,170,000
vehicle 1,200,000
Electrical Power supply 150,000
Sub-total 7,220,000
Pre-production cost 250,000
Total Fixed Investment Cost 7,470,000
Working Capital 2,191,287
Total Investment Cost 9,661,287
Percentage

preproduction cost
Description Total Cost (in Birr)
Project management 100,000
Civil work design and consultancy s 150,000
Total 250,000

working capital cost in Birr

Description MDC in months
Capacity Utilization
Direct Cost 4
Indirect Cost 3
Finished Good Stock 0.5
Cash on hand 0.7
Working Capital

source of financing

Sr. Description
No
1 Building & Construction
2 Machinery & Equipment
3 Vehicles
4 Generator
5 Consumable & Spare-parts
6 Office furniture & equipment
7 Electrical Power Supply
8 Working Capital
9 Pre-operating interest
10 Pre-operating costs
Total Cost
Debt/ Equity Ratio

sales revenues

Project Year Capacity Utilization

1 70%
2 85%
3 90%
4 100%
5 & thereafter 100%

projected income sta

year 1
sales revenue 11,200,000.00
cost of goods sold 1,116,500.00
material cot 1,116,500.00
Total direct cost 1,116,500.00
salary and benefits 2,130,000.00
Rent 500,000.00
utilty 150,000.00

adminstrative and other expenses 560,000.00

marketing and sales 2,240,000.00
Total in direct cost 5,580,000.00
Total cost of Goods sold 6,696,500.00
EBITD 4,503,500.00
Intrest expense 734,257.85
Depreciaton 1,074,000.00
EBT 2,695,242.15
Tax expense 808,572.65
Net profit 1,886,669.51
cash flow statem
year 0

viablity of the project

Measure of Change Profitability

Decrease in sales by 10% Before tax IRR

After tax IRR
Increase in operating cost by 10% Before tax IRR
After tax IRR
Increase in investment cost by 10 Before tax IRR
After tax IRR
works

Annually estimated cost in birr

200,000.00

300,000.00
500,000.00

ment
Estimated cost in Birr

700,000.00

500,000.00
240000
1,200,000.00

quipment

n line

350,000
ine

670,000
oduct line

1150000
oductline

2000000
4,170,000 834000

Material cost
Qty Price (Birr)
Local Foreign Total
2ton 250,000 250,000
1 ton 180,000 180,000
0.25 ton 750,000 750,000
 1 ton 15000 15,000
lumpsum 400,000 25.07836990596 400,000
1,595,000 1,595,000

12
salary and benefits
no monthly salary
1 8,000.00 96000
1 6000 72000
3 6000 216000
14.00 5000 840000
2 6000 144000
3 5000 180000
2 3500 84000
2 3000 72000
28 $ 1,704,000.00
25% $ 426,000.00
$ 2,130,000.00

mmary of investment cost

source
% Share % equity % loan
5.2 5
12 12%
43 43.00%
12 12%
1.6 1.6

2.6 2.6

23 15 7%
100 7729029.963899 734257.84657
24% 76%

preproduction cost

working capital cost in Birr

 Year 1 Year 2 Year 3 Year 4 Year 5
70% 85% 90% 100% 100%
279,125 338,938 358,875 398,750 398,750
497,000 603,500 639,000 710,000 710,000
566,065 687,365 727,798 808,664 808,664
849,097 1,031,047 1,091,697 1,212,996 1,212,996
2,191,287 2,660,849 2,817,370 3,130,411 3,130,411

source of financing

Total Investment (Birr)

Total Cost Equity Bank Loan
126,588,627 126,588,627 -
69,279,268 - 69,279,268
12,443,442 - 12,443,442
4,317,500 - 4,317,500
12,051,301 12,051,301
426,340 - 426,340
5,261,850 - 5,261,850
202,678,451 - 202,678,451
5,557,500 5,557,500 -
1,270,000 1,270,000 -
439,874,278 133,416,127 306,458,152
100% 30% 70%

sales revenues
20000 800
Revenues (Birr) finished stock cash on hand
11,200,000 40433.2129963899 566064.9819495 849097.4729242
13,600,000 49097.4729241877 687364.6209386 1031046.931408
14,400,000 51985.559566787 727797.833935 1091696.750903
16,000,000 57761.7328519856 808664.2599278 1212996.3898917
16,000,000 57761.7328519856 808664.2599278 1212996.3898917

projected income statement

year 2 year 3 year 4 year 5
13,600,000 14,400,000 16,000,000 16,000,000
1355750 1435500 1595000 1595000
1,355,750.00 1,435,500.00 1,595,000.00 1,595,000.00
1,355,750.00 1,435,500.00 1,595,000.00 1,595,000.00
$ 2,130,000.00 $ 2,130,000.00 $ 2,130,000.00 $ 2,130,000.00
500,000.00 500,000.00 500,000.00 500,000.00
 150,000.00 150,000.00 150,000.00 150,000.00

680,000.00 720,000.00 800,000.00 800,000.00

2,720,000.00 2,880,000.00 3,200,000.00 3,200,000.00
6,180,000.00 6,380,000.00 6,780,000.00 6,780,000.00
7,535,750.00 7,815,500.00 8,375,000.00 8,375,000.00
6,064,250.00 6,584,500.00 7,625,000.00 7,625,000.00
734,257.85 734,257.85 734,257.85 734,257.85
1,074,000.00 1,074,000.00 1,074,000.00 1,074,000.00
4,255,992.15 4,776,242.15 5,816,742.15 5,816,742.15
1,276,797.65 1,432,872.65 1,745,022.65 1,745,022.65
2,979,194.51 3,343,369.51 4,071,719.51 4,071,719.51
cash flow statement
year1 year2 year 3 year4 year 5

IRR

35%
22%
40%
28%
47%
36%
Year Number

2020 518,000 259000 $ 233,100,000.00

2019 812,000
2018 849,000
2017 933,000
2016 871,000
2015 864,000
2014 770,000
Total 5,617,000
Average 802428.57 401214.3 $ 3,610,928,571.43