Bittu and Chintu were partners in a firm sharing profits and losses in the ratio of 4 : 3. Their Balance Sheet as at 31st March, 2024 was as follows:
Liabilities | Amount (₹) | Assets | Amount (₹) |
Capitals: | Fixed Assets | 15,40,000 | |
Bittu | 8,00,000 | Stock | 3,50,000 |
Chintu | 6,00,000 | Debtors | 1,40,000 |
General Reserve | 2,10,000 | Bank | 70,000 |
Creditors | 4,90,000 | ||
Total | 21,00,000 | Total | 21,00,000 |
On 1st April, 2024, Diya was admitted in the firm for 1⁄7 share in the profits on the following terms:
Prepare Revaluation Account and Partners’ Capital Accounts.
Particulars | Amount (₹) | Particulars | Amount (₹) |
To Fixed Assets (Decrease) | 1,40,000 | By Creditors (Saving) | 70,000 |
By Loss transferred: | |||
Bittu’s Capital A/c | 40,000 | ||
Chintu’s Capital A/c | 30,000 | ||
Total | 1,40,000 | Total | 1,40,000 |
Loss on Revaluation = ₹ 70,000 distributed in 4 : 3 ratio
Bittu’s share = ₹ 70,000 × 4/7 = ₹ 40,000
Chintu’s share = ₹ 70,000 × 3/7 = ₹ 30,000
Adjustment for General Reserve:
Bittu’s share = ₹ 2,10,000 × 4/7 = ₹ 1,20,000
Chintu’s share = ₹ 2,10,000 × 3/7 = ₹ 90,000
Adjustment for goodwill premium brought by Diya:
Diya brings ₹ 5,60,000
Divided in sacrificing ratio = old ratio – new ratio
Old ratio = 4 : 3
New ratio = 3 : 3 : 1
Sacrifice of Bittu = 4/7 – 3/7 = 1/7
Sacrifice of Chintu = 3/7 – 3/7 = 0
Thus entire premium goes to Bittu = ₹ 5,60,000
Capital of Diya = 1/7 of firm’s total capital = 1/7 × ₹ 21,00,000 = ₹ 3,00,000
Total brought in by Diya = ₹ 3,00,000 + ₹ 5,60,000 = ₹ 8,60,000
Revaluation loss ₹ 70,000 distributed and goodwill adjusted. Diya’s capital and premium recorded.
Rupal, Shanu and Trisha were partners in a firm sharing profits and losses in the ratio of 4:3:1. Their Balance Sheet as at 31st March, 2024 was as follows:
(i) Trisha's share of profit was entirely taken by Shanu.
(ii) Fixed assets were found to be undervalued by Rs 2,40,000.
(iii) Stock was revalued at Rs 2,00,000.
(iv) Goodwill of the firm was valued at Rs 8,00,000 on Trisha's retirement.
(v) The total capital of the new firm was fixed at Rs 16,00,000 which was adjusted according to the new profit sharing ratio of the partners. For this necessary cash was paid off or brought in by the partners as the case may be.
Prepare Revaluation Account and Partners' Capital Accounts.
Consider the DataFrame Doctor shown below:
Write suitable Python statements for the following:
(i) To print the last three rows of the DataFrame Doctor.
(ii) To display the names of all doctors.
(iii) To add a new column 'Discount' with value of 200 for all doctors.
(iv) To display rows with index 2 and 3.
(v) To delete the column 'Department'.
XYZ Technologies, Hyderabad is a company that deals with data science and AI projects. They have different divisions: ADMIN, SALES, PRODUCTION and SERVICE. The layout of the Hyderabad branch is:
The management wants to connect all the devisions as well as the computers of each devision (ADMIN, SALES, PRODUCTION and SERVICE.
Based on the above specifications, answer the following questions:
(i) Suggest the topology and draw the most suitable cable layout for connecting all the divisions in the Hyderabad office.
(ii) XYZ Technologies is having its head office in the USA. Out of LAN, MAN and WAN, which kind of network will be created to connect Hyderabad office with USA Office? Justify your answer.
(iii) Suggest the division for the placement of server. Explain the reason for your selection.
(iv) Suggest the placement of Switch/Hub with justification.
(v) Where will a repeater be placed in the suggested network layout? Justify your answer.
Ashutosh, who is a manager, has created a database to manage employee records. The database includes a table named EMPLOYEE whose attribute names are mentioned below:
EID : Stores the unique ID for each employee.
EMP_NAME : Stores the name of the employee.
DEPT : Stores the department of the employee.
SALARY : Stores the salary of the employee.
JOIN_DATE : Stores the employee’s joining date.
Write the output of the following SQL Queries:
(i) SELECT SUBSTRING(EMP_NAME, 1, 5) FROM EMPLOYEE WHERE DEPT = 'ENGINEERING';
(ii) SELECT EMP_NAME FROM EMPLOYEE WHERE MONTH(JOIN_DATE) = 8;
(iii) SELECT EMP_NAME FROM EMPLOYEE WHERE SALARY>60000;
(iv) SELECT COUNT(DEPT) FROM EMPLOYEE;
An educational institution is maintaining a database for storing the details of courses being offered. The database includes a table COURSE with the following attributes:
C_ID : Stores the unique ID for each course.
C_NAME : Stores the course’s name.
INSTRUCTOR : Stores the name of the course instructor.
DURATION : Stores the duration of the course in hours.
Write SQL queries for the following:
(i) To add a new record with following specifications:
C_ID : C106
C_NAME : Introduction to AI
INSTRUCTOR : Ms. Preeti
DURATION : 55
(ii) To display the longest duration among all courses.
(iii) To count total number of courses run by the institution.
(iv) To display the instructors’ name in lower case.