Airex PLC is the owner and operator of a hotel chain. The directors have decided to invest in a new hotel which will require a capital outlay of 1 million The furniture, fixtures and fittings will be installed by the suppliers Bracknell Ltd at a cost of 9% of the purchase price. Bracknell intends to commence the instalment work on 1st May 2017 and has contracted to have the job finished by 31 July 2017. Airex PLC will pay 25% of the capital costs on commencement of the installation work and the balance in three equal instalments payable monthly commencing June 16th The furniture, fixtures and fittings installation fees are to be paid in three equal instalments at the end of May, June and July. Bracknell has agreed to a 10% refund of the installation fees one month after completion of the job (i.e. in August 2017) if all costs are paid to them on time. The company has forecast sales for the new hotel for May to August 2017 of 250,000; 350,000; 250,000 and 300,000 respectively. Sales are all on credit terms to trade customers who take, on average, two months credit. Airex experiences bad debts at an average rate of 5% of sales. Labour costs are at the rate of 40% of sales and are paid in the month sales are made. Other operational expenses for the company should run at a stable 150,000 per month payable in the month incurred. Airex PLC is planning to finance all its requirements with a bank overdraft! The agreed limit for the new project is 700,000. Required: Prepare a cash budget for the company for the four months, May to (a) August 2017 assuming the installation is completed on time and that it qualifies for the refund from Bracknell