: Master Budget Preparation
The following is selected information relating to the operations of Ramblewood Plc a wholesale distributer.
Current Assets as at 31 March
Cash 8 000
Accounts receivable 20 000
Inventory 36 000
Plant and Equipment net 120 000
Accounts Payable 21 750
Capital Stock 150 000
Retained earnings 12 250

a.) Gross profit is 25% of sales
b.) Actual and budgeted sales data:
March (actual) 50 000
April 60 000
May 72 000
June 90 000
July 48 000
c.) Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. The account receivables at March 31 are a result of March credit sales.
d.) At the end of each month, inventory is to be on hand equal to 80% of the following months sales needs, stated at cost.
e.) One half of a month’s inventory purchases are paid for in the following month. The accounts payable at March 31 are a result of March purchases of inventory.
f.) Monthly expenses are as follows: salaries and wages, 12% of sales; rent, $2500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets).
g.) Equipment costing $1 500 will be purchase in for cash in April.
h.) The company must maintain a minimum balance of$4 000. An open line of credit is available at a local bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of a month; borrowing must be in multiple of $1 000. The annual interest rate i s12%. Interest is paid only at the time of repayment of principal.

Required: Using the data above prepare:
1.) Schedule of expected cash collection [4 marks]
2.) Inventory purchase budget [10 marks]
3.) Schedule of expected cash disbursements – purchases [6 marks]
4.) Schedule of expected cash disbursements- Operating expenses [6 marks]
5.) The cash budget for the three months- April ,May and June [16 marks]
6.) Income statement for the three months ended June 30. [18 marks]
7.) Balance Sheet as of the June 30 [15 marks]

[Total 75 marks