A Ltd. is preparing its cash budget for the period. Sales are expected to be ` 1,00,000 in April 2015, `2,00,000 in May 2015, ` 3,00,000 in June 2015 and ` 1,00,000 in July 2015. Half of all sales are cash sales, and the other half are on credit. Experience indicates that 70% of the credit sales will be collected in the month following the sale, 20% the month after that, and, 10% in the third month after the sale. Calculate the budgeted collection for the month of July 2015.