Number of items Price

Products
Hand Painted Items
Sarees
1) Cotton Sarees 2 1,300
2) Silk Sarees 2 800
Dupattas 5 400
Blouse 3 500
Kurtas 5 600
Purses 3 400
Cushions 5 300
Toran 5 300

Thread, Mirror work or wool work Items

Dupattas 3 500
Bags 3 300
Purses 3 200
Table Cloth 5 400
Blouse 3 500
Shall 3 700

Modern Thread Work Items

Earings 10 100
Necklace Set 10 300
Bangles Set 10 200

Total
 Material Cost Total Revenue
Cost of Cloth Cost of Paint Total Material Cost

600 100 700 2600

400 100 500 1600
100 100 200 2000
250 100 350 1500
300 100 400 3000
200 50 250 1200
100 50 150 1500
100 50 150 1500

Cost of cloth Cost of Mirror work

100 100 200 1500
100 50 150 900
50 50 100 600
100 100 200 2000
200 100 300 1500
400 100 500 2100

Cost of threads & Mirrors ( Material Cost)

30 1000
100 3000
50 2000

4330 29500
 production
Total Cost Profit in Month Employees

1400 1200 20 3
1000 600
1000 1000 30 1
1050 450 15 1
2000 1000 40 1
750 450 20 1
750 750 10
750 750 1 1

600 900 15 2
450 450 10
300 300 10 1
1000 1000 10
900 600 5 1
1500 600 10 1

300 700 20 1
1000 2000 10 1
500 1500 20 1

15250 14250 246 16

Department Working In No. of Employees Rate
Hand Painted Items 8 5000
Mirror & Threading work 5 5000
Morden Iteam Workers 3 2000

Purchase department for

the raw materials 2 3000
Warehouse associates 1 4000
packaging 2 2000
Client support Officer 2 3000
Support staff 1 3000
Accountant 1 10,000

Total 25 37000
Total Pay
40000
25000
6000

6000
4000
4000
6000
3000
10000

104000
Cash Flow Statement

Operating Activities
Cash inflows from sales 3,680,000
Cash outflows for materials 1,660,000
Cash outflows for labor 1,248,000
Cash outflows for operating expenses 711,000 3,619,000
Net Cash from Operating Activities 61,000

Investing Activities
Purchase of Computers 60,000
Purchase of equipment (Furniture) 120,000
Investment in website development 30,000
Net Cash from Investing Activities 210,000

Financing Activities
Loan repayments …
Owner's investment 2,000,000
Owner's withdrawals ….
Net Cash from Financing Activities

Net Change in Cash

Opening Cash Balance ….
Closing Cash Balance 30,000 (Net profit I have assumed
 5,680,000

(Net profit I have assumed)

Advertising Budget for Hastkala Handmade Estimated Amount
Products (Year 20XX) (in Rs)

Social Media Ads (Facebook, Instagram) 5,ooo

Google Ads (PPC) 5,000
Website SEO and Content Marketing 10,000

Total Advertising Expenses 20,000

Free Produtcs for the Influencer
Capital (Invested) 2,000,000
Rent 15,000
Legal 15,000
Transportation/supplies 5,000
Advertising 20,000
Salaries to Staff 104,000
Packaging 5,000
Electricity charges 8,000
Telephone Charges 5,000

Web Developer (Expenses) 30,000

Total 2,207,000
Financial Statement in Rupees
Revenue:
Gross Sales 3,680,000

1. Total Revenues 3,680,000

Cost of Goods Sold:

Purchases (Raw
1,660,000
Material)

2. Gross Profit 2,020,000

Expenses:
Advertising 240,000
Rent 180,000
Professional/Legal
15,000
Fees(onetime payment)

Transportation/ Supplies 60,000

Salaries 1,248,000

Web Developer Charges

30,000
(One time payment)

Electricity charges 96,000

Telephone charges 60,000
Packaging 60,000

3. Total Expenses 1,989,000

Net
Operating Income

Net Income (Profit)

31,000
(2-3)
 Aug-23 Sep-23 Oct-23 Nov-23
Gross Sales

1. Total Revenues
145,000 300,000 450,000 520,000

Cost of Goods Sold:

Purchases (Raw Material)

80,000 175,000 200,000 290,000

2. Gross Profit
65,000 125,000 250,000 230,000

Expenses:
Advertising 20,000 20,000 20,000 20,000
Rent 15,000 15,000 15,000 15,000
Transportation/ Supplies 5,000 5,000 5,000 5,000
Salaries 104,000 104,000 104,000 104,000
Electricity charges 8,000 8,000 8,000 8,000
Telephone charges 5,000 5,000 5,000 5,000
Packaging 5,000 5,000 5,000 5,000

3. Total Expenses 162,000 162,000 162,000 162,000

4. Profit (2-3) -97,000 -37,000 88,000 68,000

Dec-23 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23

250,000 300,000 250,000 350,000 300,000 270,000 275,000 270,000

105,000 135,000 100,000 140,000 120,000 105,000 105,000 105,000

145,000 165,000 150,000 210,000 180,000 165,000 170,000 165,000

20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000

15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000
5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
104,000 104,000 104,000 104,000 104,000 104,000 104,000 104,000
8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000
5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000

162,000 162,000 162,000 162,000 162,000 162,000 162,000 162,000

-17,000 3,000 -12,000 48,000 18,000 3,000 8,000 3,000

Yearly Total

3,680,000

1,660,000

2,020,000

240,000
180,000
60,000
1,248,000
96,000
60,000
60,000

1,944,000

76,000
Financial Statement in Rupees
Revenue:

Gross Sales 3,680,000 year 1

1. Total Revenues 3,680,000

Cost of Goods Sold:

Purchases (Raw
1,660,000
Material)

2. Gross Profit 2,020,000

Expenses:

Advertising 240,000
Rent 180,000
Professional/Legal
15,000
Fees(onetime payment)
Transportation/ Supplies 60,000
Salaries 1,248,000
Web Developer Charges
30,000
(Onetime payment)

Electricity charges 96,000

Telephone charges 60,000

Packaging 60,000

3. Total Expenses 1,989,000

Net Income (Profit)

31,000
(2-3)
year 2 year 3

4,048,000 6,000,000

1,800,000 2,000,000

2,248,000 4,000,000

240,000 240,000
180,000 180,000

60,000 70,000
1,248,000 1,248,000

30,000 30,000

120,000 180,000

70,000 1,000,000

70,000 90,000

2,018,000 3,038,000

230,000 962,000