Ideal Manufacturing Co. has prepared the following forecasts. From this information prepare a cash budget for three months ended 31 December.

Notes (i) The anticipated cash balance at 1 October will be £5,000 overdrawn.
(ii) 80 per cent of debtors pay at the end of the month following sales; 10 per cent pay at the end of two months and the remainder after three months.
(iii) 50 per cent of raw materials are purchased from one supplier who allows 2 per cent cash discount for payment in same month.
T he remainder are paid in the month following.
(iv) Fuel and power costs are accumulated and paid at the end of every quarter beginning 1 April.
(v) All other suppliers of goods and services allow one month's credit.
(vi) Included in sundry expenses is a standing charge for depreciation of £1,000 per month.
(vii) Wages are paid one week in arrears. August and November are five-week months, the remainder are four weeks. Salaries are paid monthly at the end of the period to which they refer.
(viii) New plant costing £50,000 will be paid for in December.

Transcribed Image Text:

Purchases Month Sales Raw Fuel and Other Wages Salaries Direct Sundry materials power expenses expenses July 29,800 14,400 1,305 Aug. 24,600 13,800 1,050 Sept. 27,000 14,400 2,050 3,124 2,010 426 1,876 1,860 2,800 1,830 414 1,828 780 2,020 3,128 1,950 432 1,952 Oct. 32,400 13,500 840 2,250 2,860 1,805 405 1,810 Nov. 36,000 12,600 1,020 2,400 3,550 2,280 378 1,822 Dec. 40,500 15,900 1,035 2,700 3,520 2,430 480 1,960