Exercise $8-11($Algo$)$ Cash Budget Analysis $[$LO$8-8]$

A cash budget, by quarters, is given below for a retail company $(000$ omitted$).$ The company requires a minimum cash balance of $$3,000$ to start each quarter.

Required:

Fill in the missing amounts.

Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.

$\backslash$table$[[,$Quarter $(000$ omitted$),\backslash$table$[[(000$ omitted$)],[$Year$]]],[,1,,2,3,4],[$Cash balance, beginning,$$,8,,,,$c$],[$Add collections from customers,,,,$106,,367],[$Total cash available,,$77,,,,],[$Less disbursements:$],[$Purchase of inventory,,$55,55,,29,],[$Selling and administrative expenses,,,$32,30,,111],[$Equipment purchases,,$7,8,20,,45],[$Dividends$,,2,2,2,2,],[$Total disbursements,,,$97,,,],[$Excess $($deficiency$)$ of cash available over disbursements,,$2),,7,,r^2$