Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:

Requirement 1:
(a)	A sales budget, by month and in total. (Omit the "$" sign in your response.)

	April		May		June		Quarter
Budgeted sales in units
Selling price per unit	$		$		$		$
Total sales	$		$		$		$

(b)	A schedule of expected cash collections from sales, by month and in total. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

	April		May		June		Quarter
February sales	$		$		$		$
March sales
April sales
May sales
June sales
Total cash collections	$		$		$		$

(c)	A merchandise purchases budget in units and in dollars. (Omit the "$" sign in your response.)

	April		May		June		Quarter
Required unit purchases
Required dollar purchases	$		$		$		$

(d)	A schedule of expected cash disbursements for merchandise purchases, by month and in total. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

	April		May		June		Quarter
Accounts payable	$		$		$		$
April purchases
May purchases
June purchases
Total cash payments	$		$		$		$

Requirement 2:

A cash budget. Show the budget by month and in total. (Leave no cells blank - be certain to enter "0" wherever required. Deficiencies, repayments and interest should be preceded by a minus sign when appropriate. Total financing should be preceded by a minus sign when it consist of repayments and interest. Omit the "$" sign in your response.)

Earrings Unlimited Cash Budget For the Three Months Ending June 30
	April		May		June		Quarter
Total cash available	$		$		$		$
Less disbursements:
Total disbursements
Excess (deficiency) of receipts over disbursements
Financing:
Total financing
Cash balance, ending	$		$		$		$

Requirement 3:

A budgeted income statement for the three-month period ending June 30. Use the contribution approach. (Input the amount as positive value. Omit the "$" sign in your response.)

Earrings Unlimited Budgeted Income Statement For the Three Months Ended June 30
			$
Variable expenses:
	$
Contribution margin
Fixed expenses:
:
			$

Requirement 4:

A budgeted balance sheet as of June 30. (Omit the "$" sign in your response.)

Earrings Unlimited Budgeted Balance Sheet June 30
Assets			Liabilities and Stockholders' Equity
	$			$
Total assets	$		Total liabilities and Stockholders' equity	$