Scribd
Upload
33 views

Compile File

This document outlines operating expenses for a business including: 1) Warehouse space and partitions for storage and production areas. 2) Machinery and equipment such as mixers, packing machines, and washing machines. 3) Electricity, water, and raw material connections and supplies. 4) Packaging materials including various sized plastic bottles and containers. 5) Shipping, trucking, office supplies, and miscellaneous expenses. 6) A business plan and budget totaling 396,621.50.

Uploaded by

kingjam dimacaling2019
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
33 views

Compile File

This document outlines operating expenses for a business including: 1) Warehouse space and partitions for storage and production areas. 2) Machinery and equipment such as mixers, packing machines, and washing machines. 3) Electricity, water, and raw material connections and supplies. 4) Packaging materials including various sized plastic bottles and containers. 5) Shipping, trucking, office supplies, and miscellaneous expenses. 6) A business plan and budget totaling 396,621.50.

Uploaded by

kingjam dimacaling2019
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 42

OPERATING EXPENSES

ITEM DESCRIPTION
A. WARE HOUSE
1 ware house (existing)
2 office partition
3 room partition for finished product
B. MACHINERIES AND EQUIPMENT
1 detergent powder mixer
2 detergent liquid mixer
3 packing machine
4 washing machine 8kg ( converted into mixer)
5 drums
C. ELECTRICITY CONNECTION
D. WATER CONNECTION
E. RAW MATERIALS
1 Fabcon softener beads/flakes
2 SLES
3 EDTA (Ethylenediamine Tetraacetic Acid)
4 CDEA (COCO DIETANOLAMIDE)
5 SODA ASH
6 SODIUM SULPHATE
7 CFAS
8 SCENT (ariel)
9 SCENT (nature fresh)
10 SCENT (downy special)
11 SCENT (LAVANDER)
12 SPARKLE (GREEN)
13 SPARKLE (BLUE)
14 SPARKLE (RED)
16 LINEAR ALKYL BENZENE ACID (LABS)
17 COLORANT(green)
18 COLORANT(yellow)
19 COLORANT(blue)
20 COLORANT(pink)
21 ESSENCE(kalamansi)
22 ESSENCE(lemon)
23 SODIUM CHLORIDE(technical grade)(Industrial Salt)
24 SODIUM BENSOATE(preservative)
25 LIQUID CARNAUBA WAX
26 STPP-Anti-stain
27 BENZALKONIUM CHLORIDE(antibac)
28 fixative
29 ethyl alcohol
F. PACKAGING
1 plastic container 4 liters (round)
2 plastic container 2 liters (round)
3 plastic container 4 liters (square)
4 plastic container 2 liters (square)
5 pet plastic bottle w/ cap (1 liter)
6 pet plastic bottle w/ cap (500ml)
7 pet plastic bottle w/ cap (350 ml)
8 pet plastic bottle w/ cap (1 liter)

9 pet plastic bottle w/ SPORTS cap (500ml)

10 PAPER STICKER FOR LABELING


G. SHIPPING AND TRUCKING
H. OFFICE SUPPLIES
1 computer set
2 epson printer (colored)
3 others
I. MISCELLANEOUS

J. BUSINESS PLAN / IDEA


QTY UNIT PRICE AMOUNT
107,500.00
1 lot 100,000.00 100,000.00
1 lot 5,000.00 5,000.00
1 lot 2,500.00 2,500.00
43,500.00
1 pc. 15,000.00 15,000.00
1 pc. 8,000.00 8,000.00
1 pc. 13,500.00 13,500.00
1 pc. 2,500.00 2,500.00
3 pc. 1,500.00 4,500.00
1 lot 5,000.00 5,000.00
1 lot 2,500.00 5,000.00
130,065.00
50 kg 357.00 17,850.00
340 kg 80.00 27,200.00
1 liters 259.00 259.00
25 liters 216.00 5,400.00
650 kgs 30.00 19,500.00
200 kgs 14.70 2,940.00
150 kgs 255.00 38,250.00
1.5 liters 2,650.00 3,975.00
1.5 liters 2,650.00 3,975.00
1.5 liters 2,650.00 3,975.00
1.5 liters 2,650.00 3,975.00
5 kg 66.00 330.00
5 kg 66.00 330.00
5 kg 66.00 330.00
30 liters 0.00
1 liters 0.00
1 liters 0.00
1.5 liters 0.00
1 liters 0.00
1 liters 0.00
1 liters 0.00
30 kg 0.00
2 kg 0.00
6 liters 296.00 1,776.00
50 grams 0.00
1 liters 0.00
1 liters 0.00
5 liters 0.00
27,500.00
50 pcs. 55.00 2,750.00
50 pcs. 35.00 1,750.00
50 pcs. 55.00 2,750.00
50 pcs. 35.00 1,750.00
300 pcs. 6.00 1,800.00
300 pcs. 5.00 1,500.00
3000 pcs. 4.00 12,000.00
100 pcs. 12.00 1,200.00

100 pcs. 8.00 800.00

10 pack 120.00 1,200.00


1 lot 10,000.00 12,000.00
15,000.00
1 set 12,000.00 8,000.00
1 pc. 5,500.00 5,500.00
1 lot 1,500.00 1,500.00
1 lot 15,000.00 15,000.00

sub total 360,565.00

5% of sub total 36,056.50


TOTAL 396,621.50

A 316,621.50

B 50,000.00

C 30,000.00

396,621.50
RAW MATERIALS/SHIPPING/TRUCKING PROFIT %
169,565.00 32.42

Jam actual needed


150,565.00
STOCK PROFIT

224,540.00 54,975.00
LESS:
LABOR (2 person) 9,000.00
ELECTRICITY/month 600.00
WATER/month 1,500.00
TRANSFO(300/day) 9,000.00
MISSILANEOUS 5,000.00

NET Profit /month 29,875.00


2x month 59,750.00

3x month 89,625.00
RAW MATERIALS

ON

ID
ID

R
DE
PO
QU

U
BC

IQ
OW
AM
LI

FA

L
SH

T.
P
SH

DE
T.
DI

DE
CA
ITEM DESCRIPTION 500L 500L 500L 1000kg 500L TOTAL QTY. QTY. UNIT PRICE AMOUNT
1 Fabcon softener beads/flakes 50 50 50 kg
2 SLES 75 75 75 225 250 kg
3 EDTA (Ethylenediamine Tetraacetic Acid) 0.58 0.58 1 liters
4 CDEA (COCO DIETANOLAMIDE) 7.5 7.5 7.5 22.5 25 liters
5 SODA ASH 650 650 650 kgs
6 SODIUM SULPHATE 200 200 200 kgs
7 CFAS 150 150 150 kgs
8 SCENT (ariel) 1.5 0.5 2 2 liters
9 SCENT (nature fresh) 0.5 0.5 1.5 0.5 3 3 liters
10 SCENT (downy special) 0.5 1.5 0.5 2.5 3 liters
11 SCENT (LAVANDER) 0.5 1.5 0.5 2.5 3 liters
12 SPARKLE (GREEN) 5 5 5 kg
13 SPARKLE (BLUE) 5 5 5 kg
14 SPARKLE (RED) 5 5 5 kg
15 SODIUM HYDROXIDE/CAUSTIC SODA(PEARL/FLAKES)
16 LINEAR ALKYL BENZENE ACID (LABS) 7.5 7.5 7.5 22.5 30 liters
17 COLORANT(green) 0.5 0.5 1 liters
18 COLORANT(yellow) 0.5 0.5 1 liters
19 COLORANT(blue) 1 0.5 1.5 1.5 liters
20 COLORANT(pink) 1 1 1 liters
21 ESSENCE(kalamansi) 0.5 0.5 1 liters
22 ESSENCE(lemon) 0.5 0.5 1 liters
23 SODIUM CHLORIDE(technical grade)(Industrial Salt) 7.5 7.5 7.5 22.5 30 kg
24 SODIUM BENSOATE(preservative) 0.25 0.25 0.5 0.25 1.25 2 kg
25 LIQUID CARNAUBA WAX 5.5 5.5 6 liters
26 STPP-Anti-stain 30 30 50 grams
27 BENZALKONIUM CHLORIDE(antibac) 0.5 0.5 1 1 liters
28 fixative 1 1 1 liters
29 ethyl alcohol 5 5 5 liters

TOTAL
OPENING STOCK
NO. ITEMS
1 DISHWASHING LIQUID
2

8 CAR SHAMPOO
9

10

11 LIQUID DETERGENT
12

13

14

15 FABRIC CONDITIONER
16

17

18

19 DETERGENT POWDER
STOCK BA

OPENING STOCK
TYPE QTY. UNIT PRICE
plastic container 4 liters (round) 20 201.00

plastic container 2 liters (round) 20 133.00

pet plastic bottle w/ cap (1 liter) 100 51.00

pet plastic bottle w/ cap (500ml) 200 33.00

pet plastic bottle w/ cap (350 ml) 600 22.00

pet plastic bottle w/ SPORTS cap (1 liter) 50 62.00

pet plastic bottle w/ SPORTS cap (500ml) 100 38.00

plastic container 4 liters (square) 80 233.00

plastic container 2 liters (square) 50 135.00

pet plastic bottle w/ cap (1 liter) 80 54.00

plastic container 4 liters (round) 50 241.00

plastic container 2 liters (round) 50 138.00

pet plastic bottle w/ cap (1 liter) 100 56.00

pet plastic bottle w/ cap (500ml) 200 33.00

plastic container 4 liters (round) 50 233.00

plastic container 2 liters (round) 50 135.00

pet plastic bottle w/ cap (1 liter) 100 54.00

pet plastic bottle w/ cap (500ml) 200 32.00

1 kg/bag 1000 95.00

224,540.00
15.00

3,368,100.00
STOCK BALANCE SHEET

STOCK IN STOCK OUT


DATE QTY. UNIT PRICE DATE
STOCK OUT BALANCE STOCK
QTY. UNIT PRICE NO. QTY. UNIT PRICE
1

10

11

12

13

14

15

16

17

18

19
500

30

15000
RAW MATERIALS
ITEM DESCRIPTION
1 Fabcon softener beads/flakes
2 SLES
3 EDTA (Ethylenediamine Tetraacetic Acid)
4 CDEA (COCO DIETANOLAMIDE)
5 SODA ASH
6 SODIUM SULPHATE
7 CFAS
8 SCENT (ariel)
9 SCENT (nature fresh)
10 SCENT (downy special)
11 SCENT (LAVANDER)
12 SPARKLE (GREEN)
13 SPARKLE (BLUE)
14 SPARKLE (RED)
15 SODIUM HYDROXIDE/CAUSTIC SODA(PEARL/FLAKES)
16 LINEAR ALKYL BENZENE ACID (LABS)
17 COLORANT(green)
18 COLORANT(yellow)
19 COLORANT(blue)
20 COLORANT(pink)
21 ESSENCE(kalamansi)
22 ESSENCE(lemon)
23 SODIUM CHLORIDE(technical grade)(Industrial Salt)
24 SODIUM BENSOATE(preservative)
25 LIQUID CARNAUBA WAX
26 STPP-Anti-stain
27 BENZALKONIUM CHLORIDE(antibac)
28 fixative
29 ethyl alcohol

PACKAGING
ITEM DESCRIPTION
1 plastic container 4 liters (round)
2 plastic container 2 liters (round)
3 plastic container 4 liters (square)
4 plastic container 2 liters (square)
5 pet plastic bottle w/ cap (1 liter)
6 pet plastic bottle w/ cap (500ml)
7 pet plastic bottle w/ cap (350 ml)
8 pet plastic bottle w/ cap (1 liter)
9 pet plastic bottle w/ SPORTS cap (500ml)
ERIALS
MUST ORDER
NOW
UNIT QTY.
25 kg 50
125 kg 250
0.5 liters 1
12.5 liters 25
325 kgs 650
100 kgs 200
75 kgs 150
1 liters 2
1.5 liters 3
1.5 liters 3
1.5 liters 3
2.5 kg 5
2.5 kg 5
2.5 kg 5
0
15 liters 30
0.5 liters 1
0.5 liters 1
0.75 liters 1.5
0.5 liters 1
0.5 liters 1
0.5 liters 1
15 kg 30
1 kg 2
3 liters 6
25 grams 50
0.5 liters 1
0.5 liters 1
2.5 liters 5

GING
MUST ORDER
NOW
UNIT QTY. 30-Dec 30-Dec 30-Dec
25 PCS. 50
25 PCS. 50
25 PCS. 50
25 PCS. 50
150 PCS. 300
150 PCS. 300
1500 PCS. 3000
50 PCS. 100
50 PCS. 100
30-Dec 30-Dec 30-Dec 30-Dec 30-Dec 30-Dec
30-Dec 30-Dec 30-Dec 30-Dec 30-Dec
RESELLER A

NO. ITEMS
1 DISHWASHING LIQUID
2
3
4
5
6
7
8 CAR SHAMPOO
9
10
11 LIQUID DETERGENT
12
13
14
15 FABRIC CONDITIONER
16
17
18
19 DETERGENT POWDER
UNIT PRICE
TYPE DATE
plastic container 4 liters (round) 201.00
plastic container 2 liters (round) 133.00
pet plastic bottle w/ cap (1 liter) 51.00
pet plastic bottle w/ cap (500ml) 33.00
pet plastic bottle w/ cap (350 ml) 22.00
pet plastic bottle w/ SPORTS cap (1 liter) 62.00
pet plastic bottle w/ SPORTS cap (500ml) 38.00
plastic container 4 liters (square) 233.00
plastic container 2 liters (square) 135.00

4-Jan-23
pet plastic bottle w/ cap (1 liter) 54.00
plastic container 4 liters (round) 241.00
plastic container 2 liters (round) 138.00
pet plastic bottle w/ cap (1 liter) 56.00
pet plastic bottle w/ cap (500ml) 33.00
plastic container 4 liters (round) 233.00
plastic container 2 liters (round) 135.00
pet plastic bottle w/ cap (1 liter) 54.00
pet plastic bottle w/ cap (500ml) 32.00
1 kg/bag 95.00

CASH
BALANCE
BALANCE
QTY. AMOUNT DATE QTY. AMOUNT DATE
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

PHp 0.00 PHp 0.00


CASH OLD BALANCE 0.00 OLD BALANCE
BALANCE 0.00 TOTAL 0.00 TOTAL
CASH CASH
BALANCE 0.00 BALANCE 0.00 BALANCE
QTY. AMOUNT DATE QTY. AMOUNT DATE
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

PHp 0.00 PHp 0.00


OLD BALANCE 0.00 OLD BALANCE 0.00 OLD BALANCE
TOTAL 0.00 TOTAL 0.00 TOTAL
CASH CASH CASH
BALANCE 0.00 BALANCE 0.00 BALANCE
QTY. AMOUNT
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

PHp 0.00
OLD BALANCE 0.00
TOTAL 0.00
CASH
BALANCE 0.00
RESELLER
No. Name JAN FEB MAR
1 JAM 15,000.00
2 PHAIE 23,000.00
3 KING 215,430.00
4 QUEENIE
5 MAYA
6 22K 23,566.00
7 A
8 B
9 C
10 D

JAN
250,000.00

215,430.00
200,000.00

150,000.00

100,000.00

50,000.00

23,000.00 23,566.00
15,000.00
0.00
JAM PHAIE KING QUEENIE MAYA 22K A B C
MONTHLY SALES
APR MAY JUN JUY AUG

JAM
16,000.00

15,000.00
14,000.00

12,000.00

10,000.00

8,000.00

6,000.00

4,000.00

2,000.00

A B C D 0.00
JAN FEB MAR APR MAY JUN JUY
SEPT OCT NOV DEC

JAM

APR MAY JUN JUY AUG SEPT OCT NOV DEC


CALCULATION
STARTING CAPITAL Php 396,621.50

INVESTOR INVESTMENT Php

A. ENGR. JAMALODIN DIMACALING 292,621.50


B. 100,000.00
C. 30,000.00
Total %

ENGR. JAMALODIN DIMACALING


YEAR: 2023
MONTH NET PROFIT PHp
JANUARY 22,041.33
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER

INVESTOR B
YEAR: 2023
MONTH NET PROFIT PHp
JANUARY 6,025.90
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER

INVESTOR C
YEAR: 2023
MONTH NET PROFIT PHp
JANUARY 1,807.77
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
Net Profit
monthly 2x month 3x month
% weight 29,875.00 59,750.00 89,625.00
73.78 22,041.33 44,082.67 66,124.00

20.17 6,025.90 12,051.79 18,077.69

6.05 1,807.77 3,615.54 5,423.31


100.00 29,875.00 59,750.00 89,625.00

NET PROFIT PHp


25,000.00

22,041.33
20,000.00

15,000.00

10,000.00

5,000.00

0.00
Y RY L
AR CH RI AY NE LY ST BE
R E R
BE
R
BE
R
U A AR AP M JU JU GU OB
N RU M AU EM T EM E M
JA FE
B PT OC V
DE
C
SE NO

NET PROFIT PHp


7,000.00

6,000.00
6,025.90
5,000.00

4,000.00

3,000.00

2,000.00
7,000.00

6,000.00
6,025.90
5,000.00

4,000.00

3,000.00

2,000.00

1,000.00

0.00
RY RY L
CH RI AY NE LY ST BE
R E R
BE
R
BE
R
A A AR AP M JU JU GU OB
NU RU M AU E M T E M EM
J A
FE
B PT OC OV DE
C
SE N

NET PROFIT PHp


2,000.00
1,800.00
1,807.77
1,600.00
1,400.00
1,200.00
1,000.00
800.00
600.00
400.00
200.00
0.00
RY RY L
CH RI AY NE LY ST BE
R
BE
R
BE
R
BE
R
A A AR AP M JU JU GU
NU RU M AU EM CTO EM E M
JA FE
B PT O V
DE
C
SE NO
R R R
OB
E BE BE
CT
V EM CE M
NO DE
R R R
OB
E BE BE
E M EM
C
N OV DE

R R R
BE BE BE
V EM CE M
NO DE

You might also like