Middleboro Township plans to order supplies every quarter of the year. It expects to receive the supplies in the quarter after they are ordered. It expects to use them the quarter after that and to pay for them the quarter after that. For example, if it orders supplies in the first quarter of the year, it will receive them in the second quarter, use them in the third quarter, and pay for them in the fourth quarter. The township pays salaries in the quarter that the employees work. The township earns its income tax revenues in equal amounts throughout the year. However, it receives substantially more cash in April, when tax returns are filed. It plans to borrow $35,000 on a 20-year, 5 percent annual interest note on the first day of the fourth quarter. Interest will be paid once each year at the end of the third quarter. Interest is paid only on outstanding debtthat which has not yet been repaid. The town prepares its operating budget following the unique rules of modified accrual accounting used by governments. Under these rules expenses are recognized when the town receives goods or services and becomes legally obligated to pay for them. It does not matter if they have been used or not. Also, cash inflows or proceeds from long-term loans are treated as if they were revenues. Using the information from the table below, prepare an operating budget and a cash budget for Middleboro Township for the fourth quarter only. Assume the town has $300,000 in cash when the fourth quarter starts.

\begin{tabular}{|l|l|l|l|l|l|} \hline & Jan.-March & April-June & July-Sept. & Oct.-Dec. & Total \\ \hline Supply Orders & $300,000 & $360,000 & $390,000 & $330,000 & $1,380,000 \\ \hline Salaries & 600,000 & 750,000 & 825,000 & 720,000 & 2,895,000 \\ \hline Income Tax Cash Receipts & 600,000 & 600,000 & 1,200,000 & 600,000 & 3,000,000 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{} & \multicolumn{2}{c|}{ Middleboro Township } \\ \hline & & Operating Budget \\ \hline & Revenues & & & \\ \hline & Income Tax & & & \\ \hline & Loan & & & \\ \hline & Total Revenue & & & \\ \hline & & & & \\ \hline & Expenditures & & & \\ \hline & Salaries & & & \\ \hline & Interest & & & \\ \hline & Supplies & & & \\ \hline & Total Expenditures & & & \\ \hline & & & & \\ \hline & Surplus/(Deficit) & & \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{3}{|c|}{ Middleboro Township } \\ \hline \multicolumn{3}{|c|}{ Cash Budget } \\ \hline & Beginning Cash & & & \\ \hline & Tax Receipts & & & \\ \hline & Loan Receipt & & & \\ \hline & Cash Available & & & \\ \hline & Salaries & & & \\ \hline & Supplies & & & \\ \hline & Ending Cash & & & \\ \hline & & & & \\ \hline \end{tabular} Note that oberating budget and cash budget results are not the same. because of timing differences of when \begin{tabular}{|l|l|l|l|l|l|} \hline & Jan.-March & April-June & July-Sept. & Oct.-Dec. & Total \\ \hline Supply Orders & $300,000 & $360,000 & $390,000 & $330,000 & $1,380,000 \\ \hline Salaries & 600,000 & 750,000 & 825,000 & 720,000 & 2,895,000 \\ \hline Income Tax Cash Receipts & 600,000 & 600,000 & 1,200,000 & 600,000 & 3,000,000 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{} & \multicolumn{2}{c|}{ Middleboro Township } \\ \hline & & Operating Budget \\ \hline & Revenues & & & \\ \hline & Income Tax & & & \\ \hline & Loan & & & \\ \hline & Total Revenue & & & \\ \hline & & & & \\ \hline & Expenditures & & & \\ \hline & Salaries & & & \\ \hline & Interest & & & \\ \hline & Supplies & & & \\ \hline & Total Expenditures & & & \\ \hline & & & & \\ \hline & Surplus/(Deficit) & & \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{3}{|c|}{ Middleboro Township } \\ \hline \multicolumn{3}{|c|}{ Cash Budget } \\ \hline & Beginning Cash & & & \\ \hline & Tax Receipts & & & \\ \hline & Loan Receipt & & & \\ \hline & Cash Available & & & \\ \hline & Salaries & & & \\ \hline & Supplies & & & \\ \hline & Ending Cash & & & \\ \hline & & & & \\ \hline \end{tabular} Note that oberating budget and cash budget results are not the same. because of timing differences of when