The JMD Corporation sales for the second year of 2015 are as follows:
July RM550,000 November RM1,200,000
August RM440,000 December RM 800,000
September RM760,000 January 2016 RM 600,000
October RM1,000,000 February 2016 RM 900,000
a) 20% of sales are for cash, another 40% is collected in the month following sales, and 40% is collected in the second month following sales.
b) JMD Berhad purchases raw materials equaling to 50% of sales and is made two months in advance of sales. The supplier is paid one month after the purchase.
c) Furthermore, a company pays RM4,000 per month for rent, and RM12,000 per month for other expenditures.
d) Allowance for staff in September is RM500. This amount will be increased by 20% for each following month.
e) Dividend of RM50,000 will be received in December, interest of short term loan of RM2,000 will be paid starting in November.
f) Tax deposits of RM60,000 are made each quarter, beginning in October.
g) Purchase of new equipment for new operating factory amounting to RM400,000 in November and December.
h) The company's cash balance on September 30 was RM12,000 with a minimum balance of RM50,000 and an increase of up to RM120,000 starting in November.
i) Any short term financing needed to maintain the minimum cash balance should be paid off the month after the financing month with an annual interest rate of 10% per annum.
Prepare a cash budget for JMD Corporation for the fourth quarter of 2015.