Stabler Co.s projected March 31, 2014, balance sheet follows. Additional information about the company is as follows:

Stabler Co.’s projected March 31, 2014, balance sheet follows.

Additional information about the company is as follows: 
Expected sales for April and May are $ 240,000 and $ 260,000, respectively. All sales are made on account. 
The monthly collection pattern from the month of sale forward is 50 percent, 48 percent, and 2 percent uncollectible. Accounts Receivable and the Allowance for Uncollectibles reflect only accounts for March. 
Cost of goods sold is 65 percent of sales. 
Purchases each month are 60 percent of the current month’s sales and 30 percent of the next month’s projected sales. All purchases are paid for in full in the month following purchase. 
Dividends of $ 20,000 will be declared and paid in April 2014. 
Selling and administrative expenses each month are $ 43,000, of which $ 8,000 is depreciation. 
Investments and borrowings must be made in $ 1,000 amounts.
a. What were March 2014 budgeted sales?
b. What will be budgeted cash collections for April 2014?
c. What will be the Merchandise Inventory balance at April 30, 2014?
d. What will be the projected balance in the Retained Earnings account at April 30, 2014?
e. If the company wishes to maintain a minimum cash balance of $ 16,000, how much will be available for investment, or be borrowed at the end of April2014?

Transcribed Image Text:

Assets Liabilities and Stockholders' Equity s 24,000 Accounts Payable Cash Accounts Receivable (net of $140,400 Allowance for Uncollectibles of $2,880) 69,120 04,800 Common Stock Merchandise Inventory Plant Assets (net of Accumulatecd $50,000 Depreciation of $1 20,000) 72,000 Retained Eamings 79,520 129.520 Total Liabilities and Total Assets $269,920 Stockholders' Equity $269,920