days.
May June July August September October November December January
Collections and purchases worksheet
Sales (gross) $180,000 $180,000 $360,000 $540,000 $720,000 $360,000 $360,000 $90,000 $180,000
Collections
During month of sale 18,000 18,000 36,000 54,000 72,000 36,000 36,000 9,000
During 1st month after sale 135,000 135,000 270,000 405,000 540,000 270,000 270,000
Cash gain or loss for month
Collections $198,000 $351,000 $531,000 $657,000 $414,000 $333,000
Payments for labor and raw materials 90,000 126,000 882,000 306,000 234,000 162,000
General and administrative salaries 27,000 27,000 27,000 27,000 27,000 27,000
Design studio payment 180,000
Total payments $128,700 $164,700 $983,700 $524,700 $272,700 $263,700
Loan requirement or cash surplus
Cash at start of month $132,000 $201,300 $387,600 ($65,100) $67,200 $208,500
Cumulative cash $201,300 $387,600 ($65,100) $67,200 $208,500 $277,800
b. The cash budget indicates that Helen will have surplus funds available during July, August,
c. In a situation such as this, where inflows and outflows are not synchronized during the