their fourth$-$quarter budget for this year.

a$.$ Prepare a quarterly cash budget for Sam and Suzy covering the months October through December.

b$.$ Are there individual months that incur a deficit?

c$.$ What is the cumulative cash surplus or deficit by the end of December?

a$.$ Complete the October cash budget below: $($Round to the nearest dollar.$)$

Sam and Suzy Sizeman

Personal Budget

for the Period October$-$December

Data table

$($Click on the icon here $$ in order to copy the contents of the data table below

into a spreadsheet.$)$

Income

Monthly take$-$home pay

Expenses

Housing

Utilities

Food

Transportation

Medical$/$dental

Clothing for October & November

Clothing for December

Property taxes $($November only$)$

Appliances

Personal Care

Entertainment for October & November

Entertainment for December

Savings

Other

Excess in cash

$$4,929$

$30\mathrm{.}2\%$

$4\mathrm{.}7\%$

$9\mathrm{.}6\%$

$6\mathrm{.}8\%$

$0\mathrm{.}5\%$

$2\mathrm{.}9\%$

$$434$

$11\mathrm{.}3\%$

$1\mathrm{.}1\%$

$2\mathrm{.}1\%$

$6\mathrm{.}2\%$

$$1,504$

$7\mathrm{.}2\%$

$5\mathrm{.}4\%$

$4\mathrm{.}2\%$Preparation of cash budget.$$Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of the year to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to identify the percentage of their income that they pay for most of for their cash outflows. These percentages are based on their$$ take$-$home pay$($e$.$g$.,$ monthly utilities normally run $4\mathrm{.}7\%$ of monthly$$ take$-$home pay$).$ The information here$$LOADING$...$ can be used to create their$$ fourth$-$quarter budget for this year.

a$.$ Prepare a quarterly cash budget for Sam and Suzy covering the months October through December.

b$.$ Are there individual months that incur a$$ deficit?

c$.$ What is the cumulative cash surplus or deficit by the end of$$ December?