Prepare a cash budget for PT AWOL! (Assuming 1 quarter = 90 days)

Given:

X=6

Y=9

PT AWOL has sales projections (in million rupiahs) for the following four quarters: Q1 | Q2 Q3 Q4 Q1* Sales 410 395 440 500 500*(1+XY%) Account receivables at the beginning of this year were IDR 150 million. PT AWOL has an average collection period of 45 days. PT AWOL purchases from suppliers on each quarter are 40% of the estimated sales of the next quarter, and the average account payable period is 30 days. Salaries, taxes, and other expenses for each quarter are 30% of sales. The dividend is IDR 20 million, paid quarterly. PT AWOL plans a capital expenditure in the second quarter of IDR 150 million. The company has an initial cash balance of Rp. 85 million with a minimum balance of Rp. 85 million. Assume that the company must borrow the funds needed in the short term at an interest rate of 5% per quarter and the interest is paid in the following quarter