Prepare a cash flow budget for SACCL for the next four months.

Sales for SACCL were as follows in the last four months of 2005:
April 2005 Rs 2,60,000 May 2005 3,00,000 June 2005 3,80,000 July 2005 5,00,000 The sales manager has made the following sales projections for the second four months of 2004 as:
August 2005 Rs 5,30,000 September 2005 6,70,000 October 2005 8,40,000 November 2005 10,00,000 All the sales of SACCL are made on credit, 75% of accounts receivable are collected in the month of the sale, 20% the month after the sale and the remainder in the third month of the sale.
All the purchases are paid within the month of purchase. It can be assumed that all goods are manufactured in the month of the purchase and the factory wages and direct factory expenses are paid in the month in which the goods are manufactured. Cost of goods sold (COGS) are forecast to be about 75% of the sales.
Selling and administrative expenses are projected as:
August 2005 Rs 1,25,000 September 2005 1,40,000 October 2005 1,50,000 November 2005 1,60,000 SACCL expects to make the tax payment of Rs 1,65,000 in October 2005. As on 31 July 2004, SACCL had a cash balance of Rs 87,000 and an inventory of finished goods of Rs 1,15,000. The company wishes to maintain a minimum cash balance of Rs 85,000 at its bank and a minimum inventory of finished goods of Rs 1,15,000.