Problem
Preparation of cash budget. Sam and Suzy Sizeman need to preparee 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 5.4% of monthly take-home pay). The information here can be used to create their fourth-quarter budget for this year.
1) Prepare a quarterly cash budget for Sam and Suzy covering the months October through December.
2) Are there individual months that incur a deficit?
3) What is the cumulative cash surplus or deficit by the end of December?