Question

Here is a portion of Joshua Sanders' budget record for a recent month. Fill in the blanks in columns 5 and 6. Use minus sign to enter negative numbers. If an amount is zero, enter "0".

	Amount	Amount	Beginning	Monthly Surplus	Cumulative Surplus
Item	Budgeted	Spent	Balance	(Deficit)	(Deficit)
(1)	(2)	(3)	(4)	(5)	(6)
Rent	$600	$640	-$10	$	$
Utilities	190	205	15
Food	540	540	4
Auto	90	95	10
Recreation and entertainment	115	130	0

Answer 1

Monthly SUrplus/ Deficit = Budgeted Amount - Amount Spent

Cumulative Surplus = Begining Balance + Monthly Surplus / Deficit

Item	Budget	Spent	Beginning Bal	Monthly Surplus/ Deficit	Cumulative Surplus/ Deficit
Rent	$ 600.00	$ 640.00	$        -10.00	$                             -40.00	$                                  -50.00
Utilities	$ 190.00	$ 205.00	$          15.00	$                             -15.00	$                                          -
Food	$ 540.00	$ 540.00	$            4.00	$                                     -	$                                      4.00
Auto	$   90.00	$   95.00	$          10.00	$                               -5.00	$                                      5.00
Recreation & entertainment	$ 115.00	$ 130.00	$                 -	$                             -15.00	$                                  -15.00