Uncle's Caps, Inc, a merchandising company, has provided the following budgeted amounts for the next budget period

Beginning cash balance $30,400
Cash collections 683,000
Payments for:
Purchases of merchandise inventory 349,400
Selling and administrative expenses 70,700
Capital expenditures 88,600

A minimum cash balance of $250,000 is required to be maintained. The company can borrow in increments of $10,000 as and when required. Assume the company can borrow the needed funds at the end of the period. Calculate the ending cash balance for the budget period.
A) $713,400
B) $254,700
C) $204,700
D) $733,000

B .B)
Budget period
Beginning cash balance $30,400
Cash receipts 683,000
Cash available $713,400
Cash payments:
Capital expenditures 88,600
Purchases of merchandise inventory 349,400
Selling and administrative expenses 70,700
Total cash payments $508,700
Ending cash balance before financing $204,700
Minimum cash balance desired $250,000
Projected cash excess (deficiency) $(45,300 )
Financing:
Borrowing $50,000
Principal repayments 0
Total effects of financing $50,000
Ending cash balance $254,700