04) Sweet Cakes Ltd are examining their cash requirements for the first six months of 2018. The following information will be used to help them with their decisions Month Credit Sales (6) Cash Sales (6) Credit Purchases () January 7.000 2,000 9.500 February 7,000 2,000 1,000 March 4,000 3,000 1,500 April 5,000 3,000 1,500 May 6,000 4,000 1,500 June 7,000 4,000 6,000 Notes: For credit purchases, one month's credit is taken from the suppliers. For credit sales, two months credit is given to debtors Rent of 800 is due to be received in March Wage costs will amount to 1,600 each month Commission of 10% of total sales is payable in the month of the sale An advertising campaign costing 2,500 will be paid for in January Monthly rent will amount to 1,000 Opening cash balance will amount to 5,000 You are required to prepare a cash budget for the first six months of 2018 (30 marks)