Bricks & Cement Pvt. Ltd. is a building supplies company offering a wide range of materials like bricks, cement, and aggregates to both trade…

Bricks & Cement Pvt. Ltd. is a building supplies company offering a wide range of materials like bricks, cement, and aggregates to both trade professionals and private customers. The company focuses on providing high-quality products and reliable service for all type of construction projects. The management provides the following budgeted data for each of the six months in the first half of the year: Particulars April (₹) May (₹) June (₹) July (₹) August (₹) September (₹) Credit sales 22,50,000 22,50,000 22,50,000 23,40,000 23,40,000 25,20,000 Cash sales 5,40,000 5,40,000 5,85,000 6,75,000 7,20,000 8,10,000 Credit purchases 15,30,000 16,20,000 16,20,000 18,00,000 18,00,000 18,00,000 Other operating costs (excluding depreciation) 8,10,000 8,10,000 8,10,000 10,98,000 11,07,000 11,07,000 Following table shows the distribution of payments received against credit sales: Value of credit sales Payment received 80% One month after sale 10% Two months after sale 8% Three months after sale Balance Written off as a bad debt However, credit purchases are paid in the following manner: Value of credit purchases Payment made 75% One month after purchase Balance Two months after purchase Any remaining operational costs, including overheads, utilities, and day-to-day expenses, are paid in the month they are incurred. This ensures that all routine expenses are settled promptly without delay, maintaining smooth financial operations throughout the period. During the month of July, the company has also placed an order for four pallet jacks that will cost around - 2,25,000 each, the payment of which is divided into four equal instalments following the month of purchase. The cash balance at the beginning of 2nd quarter is projected to be - 1,35,000. You are required to PREPARE a cash budget for each of the three months of 2nd Quarter.