The following data are available in a manufacturing company for a half-yearly period:

Fixed expenses:

Rs. (lakhs)

Rs. (lakhs)

Wages & salaries

8.4

Rent, rates & taxes

5.6

Depreciation

7.0

Sundry administration expenses

8.9

29.9

Semi-variable expenses:

(at 50% of capacity)

  1. Equipment of original value of Rs. 1.63 lakhs with accumulated depreciation of 0.84 lakhs to be sold.
  2. The increase in working capital is as follows:
    1. Inventory Rs. 5.2 lakhs
    2. Debtors Rs. 2.8 lakhs
  3. Dividends of Rs. 15 lakhs to be paid.
  4. Term-loan instalment due during the year – Rs. 3 lakhs.
  5. Following is the budgeted P&L A/c for the next year

(Rs. in lakhs)

Sales

155.44

Less: Cost of sales (includes depreciation of Rs. 10.37 lakhs)

101.24

Less: Administration & selling costs

30.68

Less: Interest

1.25

Add: Gain on sale of:

Equipments

0.11

Investments

2.70

Gross income

25.08

Tax

12.19

Net income

12.89

Prepare a cash budget from the above and assess the surplus or deficit.