At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December $31$ to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:

Cash balance, September $1($from a summer job$)$ $$9,450$

Purchase season football tickets in September

$140$

Additional entertainment for each month

$220$

Pay fall semester tuition in September

$4,900$

Pay rent at the beginning of each month

$530$

Pay for food each month

$480$

Pay apartment deposit on September $2($to be returned December $15)$

$530$

Part$-$time job earnings each month $($net of taxes$)$

$1,050$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign.