29 information supplied by Mahesh Stores. Balance Sheet as on 31 March, 2011 Liabilities Amount Assets Amount Proprietors Capital Outstanding Liabilities 20.500 50.500 26.000 1.00.000 Cash 17,000 Stock in trade Sundry Debtors Furniture 25.000 Less : Depreciation 5.000 1.17,000 20.000 1,17,000 Sales (Rs.) Salaries (Rs.) 3,000 3.500 Expected for April May June July August September 30,000 52.000 50,000 75,000 90.000 35.000 3,500 4,000 4,000 3,000 Other Expenses - Rent Rs. 1000 pm. Sales Commission - 1% of sales Misc. Exp. Rs. 500 pm. Sales - 80% on Credit and 20% on cash Out of the Credit sales - 70% collected after one month and remaining in next month. Gross margin is 70% purchases equal to requirement of next months sales are made for which payment is against delivery. Debtor on 31" March, 2011 included Rs.20,000 for February and remaining for January Cash on Hand should be Rs. 10000 at all times. The deficiency to be met by short term loans. Prepare Cash Budget for April to August 2011 and ascertain the borrowing to be made from time to time