Use the preceding information to fill in the missing amounts in the following cash budget.

Use the preceding information to fill in the missing amounts in the following cash budget. Capel Company Cash Budget For the Six Months Ended December 31, Year 1 m OnS August September October November December May June July Credit sales $1,140 $1,176 $1,200 $1,212 $1,236 $1,260 $1,296 $1,320 Credit purchases 660 680 693 713 667 726 August September October November December July Cash receipts Collections from this month's sales 294 297 303 309 318 323 Collections from previous month's sales 780 788 803 819 842 764 Collections from sales two months previously 114 118 120 121 124 126 Total cash receipts $1,172 $1,195 $1,211 $1,233 $1,261 $1,291 Cash disbursements Payments for credit purchases 660 667 680 693 713 726 Wages and salaries 180 182 185 189 194 198 Rent 48 48 48 48 48 48 Other expenses 60 61 62 63 65 66 Taxes 70 73 Payment for plant construction 1,200 Total cash disbursements $958 1,018 $2,175 $1,066 $1,020 $1,038 Net cash flow (Receipts disbursements $154 $237 $964 $167 $241 $253 Beginning cash balance 217 371 608 356 189 52 Ending cash balance $371 $608 $356 $189 $52 $305 Target (minimum) cash balance 200 200 200 200 200 200 Surplus (shortfall) cash $171 $408 $556 $389 $148 $105 Use the information provided in the budget to complete the following sentences