Final ROI Sheet

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Investment 5300000 63600000

ROI 19.64%
Type Price Total(1 QuaRefrigerator(one month expense)
Capital expenses
Refrigerator parts price Single door 9200
Microwave Owen part price Single door 5380
Assembly labor charges Single door 1000
Others Single door 1000 16580 1958000
Refrigerator parts price Double door 14150
Microwave Owen part price Double door 5380
Assembly labor charges Double door 1200
Others Double door 1200 21930
Extra expense increase one rSingle door 3000 19580 2741250

Production
Type Period(1 day) Period(months) Yearly
Single door 4 100
Double door 5 125
Operational Expenses
total area Rate per sqTotal
Plant rent (20 Rs per Sq feet) 11200 20 15000
Total 180000
Salary
Qty Salary

Service person 3 10000 30000


Marketing person 2 15000 30000
Technician 2 5000 10000

Total 70000 840000

Marketing budget expenses

social media Ad 10000


Market research 20000
Video Ad 20000
50000
Total 600000
Other expenses
Electricity 30000
WIFI 4000
Miscellaneous exp 16000
Intereset 7% 9275 11130
Total 61130 733560
Distribution Expenses
Transportation 50000
Packaging and unpackaging 50000
Storage 50000
Total 150000 1800000

Total Expense 8852810


ROI Calculation

Refrigerator(yearly expense)
Components
Functional Parts
Part name Type Price
Compressor Single door 4000
Over load protector Single door 350
Thermo state Single door 450
Touch Temp. Panel Single door 900
Total 5700
Body Part
Freezer door Single door 350
Ice cube trays Single door 120
Chiller tray Single door 550
Bottle tray Single door 250
Egg trays Single door 180
Vegetable trays Single door 850
Fridge vegetable Single door 300
Partition Iron meshes Single door 120
Drain water sink try Single door 30
Drain water tub Single door 180
Heat condenser Single door 450
Door switch Single door 50
Fridge light Single door 70
Total Single door 3500
Functional Parts
Freezer fan motor Double door 1000
Thermal Bi Metal Double door 650
Heater Double door 750
Temperature sensor Double door 250
Timer Double door 800
Compressor Double door 4500
Total 7950
Body Part
Freezer chamber(old) Double door 1200
Cool condenser Double door 1600
Fan motor, Fan blade Double door 650
Heater Double door 550
FF timer 3+1 Double door 650
Biometal, fuse Double door 450
Fridge Compressor Relay sDouble door 350
Door switch Double door 100
Fridge light and light holdDouble door 100
Thermostat Double door 550
Total Double door 6200
ROI Calculation

Total Investment 5300000 63600000


Owners Fund 3710000 44520000 Single door selling price
Borrowed fund 1590000 19080000 selling price to retailers
selling price to end customer
Profit Profit in single Refrigerator
Profit in a month for single door

Double door cost


selling price to retailers
selling price to end customer
Profit in single Refrigerator
Profit in a month for Double door

Total profit in month

Roi calculation
ROI CALCULATION

Gross profit: -
Expenses: - 8852810/-
Investment: - 5300000/-
ROI = [ (Gross profit – Expenses)/Investm
= [ (9894000– 8852810/-)/5300000/-]*
= [1041190/53,00,000] *100
= 19.64%
Monthly Yearly
19580 1958000
21500+ tax
24999+tax
1920
192000
Total sale 4699250
21930 2741250
26990+ Tax
26999 +Tax
5060
632500.00

824500.00 9894000

9894000/-

it – Expenses)/Investment] *100
8852810/-)/5300000/-]*100
00,000] *100
Body Parts Type Price
Microwave Owen part price Single door 5380
Assembly labor charges Single door 1000
Others Single door 1000
Compressor Single door 4000
Over load protector Single door 350
Thermo state Single door 450
Touch Temp. Panel Single door 900
Freezer door Single door 350
Ice cube trays Single door 120
Chiller tray Single door 550
Bottle tray Single door 250
Egg trays Single door 180
Vegetable trays Single door 850
Fridge vegetable Single door 300
Partition Iron meshes Single door 120
Drain water sink try Single door 30
Drain water tub Single door 180
Heat condenser Single door 450
Door switch Single door 50
Fridge light Single door 70
Total 16580
Body Parts Type Price
Microwave Owen part price Double door 5380
Assembly labor charges Double door 1200
Others Double door 1200
Freezer fan motor Double door 1000 21930
Thermal Bi Metal Double door 650 #REF!
Heater Double door 750
Temperature sensor Double door 250
Timer Double door 800
Compressor Double door 4500
Freezer chamber(old) Double door 1200
Cool condenser Double door 1600
Fan motor, Fan blade Double door 650
Heater Double door 550
FF timer 3+1 Double door 650
Biometal, fuse Double door 450
Fridge Compressor Relay set Double door 350
Door switch Double door 100
Fridge light and light holder Double door 100
Thermostat Double door 550
Total 21930
LG Freezer door – 350/- 350 Freezer door
Ic Icee cube trays – 120/ 120 Ice cube trays
LG Chiller tray – 550/- 550 Chiller tray
LG Bottle tray – 250 250 Bottle tray
LG Egg trays – 180/- 180 Egg trays
LG Vegetable trays – 850 850 Vegetable trays
LG Fridge vege300/- 300 Fridge vegetable
Pa rtition Iron meshes – 120/- 120 Partition Iron meshes

Dr

ain water sink try- 30/ 30 Drain water sink try


LG Drain water tub – 180 180 Drain water tub
He at condenser – 450/- 450 Heat condenser
LG Fridge Commodel – 5500/-
Do or switch – 60/- 50 Door switch
Fr idge light /- 70 Fridge light

3500
0

0
224000
0

224000
0
224000

You might also like