Master Budget with Supporting Schedules (2 of 5)

Master Budget with Supporting Schedules (2 of 5)

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	$		$		$		$

Is this the question you were looking for? If so, place your order here to get started!