Brian is hoping to expand the business by opening a new Hotel Snowflake at a strategic tourist location in Snowdonia due to open on 1st January 2023. However, this will need to be a viable project therefore Brian has decided to complete a business plan which includes a six-month cash budget, the preparation of which has fallen to you. The following information has been made available: - After careful market research the following forecast has been drawn up for sales and purchases: - Fixtures and fittings will be purchased on 1st January for 21,500 which will have to be paid for at the end of the month. Depreciation is 1,500 a year. - Wages: 5,350 per month. - Other costs incurred in the running of the business (excluding purchases \& depreciation) will be 14,550 per month, payable in the month following the month in which the costs are incurred. - The rent of the hotel will be 55,500 per annum, payable in monthly instalments at the start of each month. - 29% of the sales are expected to be for cash, the remaining on credit. The credit terms are one month after sales. - Purchases will be supplied on one month's credit (i.e., purchases in March will have to be paid for by the end of April). - Brian intends to inject 15,500 as capital into the business on the 1 January. Required: Prepare a monthly cash budget for the six months for Hotel Snowflakes from January to June 2023