Question

Sitcom Technology Case

Case Study: Cost Concept and Cost Sheet

Sitcom Technology was founded by two IIT graduates Rehan and Nixit in the year 2016 with the objective of providing IT solutions to various companies. They launched their FinTech start-up after getting funded Rs 25,00,000 by Business Ventures, one of the FinTech Angel investors. This was in the form of a loan at a 12% rate of interest.

Rehan utilized his unused two bedrooms flat in Bannerghatta, Karnataka worth Rs 60,00,000 for the office. Although he could get Rs 20,000 per month as rent for the same in the market, he rented it out to his start-up at Rs 15,000 per month and also decided to waive off the security deposit of Rs 100,0000 (going rate).

The other assets bought for their enterprise were four computers and a server (Rs. 200,000), two printers come scanner (Rs 18,000), two cordless phones & four mobiles (Rs 62,000), modem for wifi and other internet accessories (Rs 6000)and office furniture (Rs 1,70,000). After purchasing the furniture, they realized that Rs 20,000 invested in panel doors couldn’t be used. There was no return or refund for that. With no other option in hand, they sold these doors as scrap for Rs 8,000. Besides these purchases, they also invested Rs 40,000 in annual licenses for a lot of software.

Nixit picked up two of his juniors as Programmer and Visualizer come graphic designer after negotiating heavily on their hourly remuneration of 1,000 per hour on a freelancing basis. Depending on the number of hours invested in the development of a particular software/ERP/IT Solution, they were paid. In the month of April 2019, Sitcom Technology paid them Rs 84,000 for 42 hours of work put in by each one of them.

In addition to these two, a telephone operator and a data entry staff were also hired at Rs 13,000 and Rs 17,000 per month respectively. The monthly expenses of Sitcom Technology in April 2019 were:

Expenses	Amount(Rs.)
Salaries	30,000
Rent	15,000
Wages(peon)	10,000
Electricity	5,000
Telephone and internet charges	12,000
Office stationery	4,000
Trade Magazines	500
Conveyances	8,000
Advertising charges	1,000
Tours and travel	16,000
Snacks	6,000
Miscellaneous	5,000

In April 2019, Sitcom Technology received two big project orders from a leading private bank and one small programming work outsourced by a major IT company in Electronic City. The work was completed in the same month with all four of them putting in a lot of hours. The revenue generated from these three projects was Rs 4,10,000.

Question: Prepare the cost sheet for April 2019 and calculate the profit generated assuming the depreciation on fixed assets to be 10%.

NOTE- could you please provide me the solution ASAP.

Answer 1

Cost Sheet for April 2019
Sr NO	Particulars	Amount
A	Gross Revenue For April 2019	4,10,000.00
B	Cost for April 2019 ( 1 to 17)	2,29,466.67
1	Salaries	30,000.00
2	Rent	15,000.00
3	Wages(peon)	10,000.00
4	Electricity	5,000.00
5	Telephone and internet charges	12,000.00
6	Office stationery	4,000.00
7	Trade Magazines	500.00
8	Conveyances	8,000.00
9	Advertising charges	1,000.00
10	Tours and travel	16,000.00
11	Snacks	6,000.00
12	Miscellaneous	5,000.00
13	Charges Paid to developers	84,000.00
14	Deprication on Fixed Assets for April 2019	3,633.33
15	Interest on fund for April 2019	25,000.00
16	Loss on sale of Furniture (apprtioned for April 2019)	1,000.00
17	Cost of Annual software licence charges for april 2019	3,333.33
C	Profit (A-B)	1,80,533.33

Working Notes.

Calulation of Depriciation
Particulars	Amount
Computer and server	2,00,000.00
Printer and Scanner	18,000.00
cordless phones and mobiles	62,000.00
Modem and Wifi and internet accessories	6,000.00
Furniture	1,50,000.00
Total Cost of Fixed Assets	4,36,000.00
Rate of Depreciation	10%
Depreciation for year	43,600.00
Depreciation for April 2019	3,633.33

Calulation of Interest on Fund
Loan Taken	25,00,000.00
Rate Of Interest	12%
Interest for Year	3,00,000.00
Interest on fund for April 2019	25,000.00