The ShireLodge provides a residential convention service in England's Yorkshire Dales. The lodge's general manager is...

  

Transcribed Image Text:

The ShireLodge provides a residential convention service in England's Yorkshire Dales. The lodge's general manager is concerned about cash flow in the next few months particularly as insurance will soon be due for payment. The following revenue and expense estimates have been developed for the first four months of 2023, Convention sales revenue Fixed costs: Salaries Ground maintenance Insurance January 10.000 4.000 500 420 February 12.000 4.000 500 420 March 13.000 4.000 500 420 It has been estimated that sales in December 2022 will be £8,000. Previous cash collections indicate that 10 per cent of all ales are collected in the month prior to the sale as a deposit. Then, 50 per cent of all sales are collected in the month of the sale, and 40 per cent of sales are collected in the month following the sale. Variable costs are 15 per cent of revenue. Ninety per cent of variable costs are paid in April 14.000 4.000 500 420 Quiz nav 1 2 Finish att Time left Convention sales revenue Fixed costs: Salaries Ground maintenance Insurance 10.000 4.000 500 420 12.000 4.000 500 420 13.000 4.000 500 420 It has been estimated that sales in December 2022 will be £8,000. Previous cash collections indicate that 10 per cent of all ales are collected in the month prior to the sale as a deposit. Then, 50 per cent of all sales are collected in the month of the sale, and 40 per cent of sales are collected in the month following the sale. Variable costs are 15 per cent of revenue. Ninety per cent of variable costs are paid in the month of the sale to which they relate, and the remainder 10 per cent are paid in the month prior to the sale (purchase of some food and other items in preparation for conventions). Salary and ground maintenance fixed cost are paid for as they are incurred. Insurance is paid for twice year, in January and July. It is estimated that on 1st January 2023 the lodge will have £4.200 in its bank account, Prepare a cash budget showing receipts, payments, and opening and closing cash balances for each of the first three months of 2023. April 14,000 4.000 500 420 Time left 0:51: The ShireLodge provides a residential convention service in England's Yorkshire Dales. The lodge's general manager is concerned about cash flow in the next few months particularly as insurance will soon be due for payment. The following revenue and expense estimates have been developed for the first four months of 2023, Convention sales revenue Fixed costs: Salaries Ground maintenance Insurance January 10.000 4.000 500 420 February 12.000 4.000 500 420 March 13.000 4.000 500 420 It has been estimated that sales in December 2022 will be £8,000. Previous cash collections indicate that 10 per cent of all ales are collected in the month prior to the sale as a deposit. Then, 50 per cent of all sales are collected in the month of the sale, and 40 per cent of sales are collected in the month following the sale. Variable costs are 15 per cent of revenue. Ninety per cent of variable costs are paid in April 14.000 4.000 500 420 Quiz nav 1 2 Finish att Time left Convention sales revenue Fixed costs: Salaries Ground maintenance Insurance 10.000 4.000 500 420 12.000 4.000 500 420 13.000 4.000 500 420 It has been estimated that sales in December 2022 will be £8,000. Previous cash collections indicate that 10 per cent of all ales are collected in the month prior to the sale as a deposit. Then, 50 per cent of all sales are collected in the month of the sale, and 40 per cent of sales are collected in the month following the sale. Variable costs are 15 per cent of revenue. Ninety per cent of variable costs are paid in the month of the sale to which they relate, and the remainder 10 per cent are paid in the month prior to the sale (purchase of some food and other items in preparation for conventions). Salary and ground maintenance fixed cost are paid for as they are incurred. Insurance is paid for twice year, in January and July. It is estimated that on 1st January 2023 the lodge will have £4.200 in its bank account, Prepare a cash budget showing receipts, payments, and opening and closing cash balances for each of the first three months of 2023. April 14,000 4.000 500 420 Time left 0:51:

Answer rating: 100% (QA)

Based on the information provided we are asked to prepare a cash budget showing receipts payments and opening and closing cash balances for each of th... View the full answer