Especially need a detailed answer to the third question, thank you very much.
UVW Ltd has 5 chain stores, all of which sell CDs. At the beginning of June (20X1), the company's overdraft was $4,200,000 and the bank requested that it be cancelled before the end of November. Therefore, the directors recently decided to review their plans for the next six months. Currently, UWW is repaying $600,000 in monthly instalments. The interest element accounts for 20% of each period. The following plans were prepared for the business some months earlier: May June July August Sept Oct Nov $'000 $'000 $'000 $'000 $'000 $'000 $'000 Sales revenue 18,000 23,000 32,000 25,000 14.000 12.000 11,000 Purchases 13,500 18,000 14,200 9,400 7,500 6,600 5,700 Administration expenses 5,200 5,500 5,600 5,300 4,800 4,600 4,500 Selling expenses 2,200 2,400 2,800 2,600 2,100 1,900 1,800 Taxation payment 2,200 Finance payments 600 600 600 600 600 600 600 Shop refurbishment 1,400 1,800 600 Notes: 1) The inventories level at 1 June was $11,200,000. 2) Suppliers allow one month's credit. 3) The gross profit margin is 40 per cent. 4) Receive all cash from sales in the month of sales. However, 50% of customers pay by credit card. The fee charged by the credit card company to UVW Ltd is 3% of the value of the sales revenue. These expenses are in addition to the above sales expenses. The credit card company pays UVW Ltd in the month of sale. 5) Administration expenses are paid when incurred. This item includes a charge of $1,500,000 each month in respect of depreciation. 6) Selling expenses are payable in the following month. Required (working to the nearest $1,000): a) Compute the inventories levels at the end of each month for the six months to 30 November. b) Prepare a cash budget for the six months ending 30 November 20X1 which shows the cash balance at the end of each month. c) Prepare a budgeted income statement for the whole of the six-month period ending 30 November 20X1. (A monthly breakdown of profit is not required.)