Answer:
a) Statement showing Cash Budget
Particulars October$ November$ December$ Total
$
Monthly take 4,900.00 4,900.00 4,900.00 14,700.00
home pay
Housing at 30% 1,470.00 1,470.00 1,470.00 4,410.00
Utilities at 5% 245.00 245.00 245.00 735.00
Food at 10% 490.00 490.00 490.00 1,470.00
Transportation 343.00 343.00 343.00 1,029.00
at 7%
Medical at 0.5% 24.50 24.50 24.50 73.50
Clothing at 3% 147.00 147.00 - 294.00
for Oct and Nov
Clothing for Dec - - 440.00 440.00
Property Taxes - 563.50 - 563.50
at 11.5% for Nov
Appliances at 1% 49.00 49.00 49.00 147.00
Personal Care 98.00 98.00 98.00 294.00
at 2%
Entertainment 294.00 294.00 - 588.00
at 6% for Oct and Nov
Entertainment - - 1,500.00 1,500.00
for Dec
Savings at 7.5% 367.50 367.50 367.50 1,102.50
Other 5% 245.00 245.00 245.00 735.00
Excess Cash 220.50 220.50 220.50 661.50
at 4.5%
Remaining Cash 906.50 343.00 -592.50 657.00
b) Yes- In December there is a deficit of $592.50
c) Cumulative surplus is of $657 by end of Dec 2013
