Required:

1. Determine the budgeted cash collections for November;
2. Determine the net income for November;
3. Determine the projected balance in accounts payable on November 30;
4. Determine the projected balance in inventory on November 30;

Kelly Company is a retail sporting goods store. Facts regarding Kelly's operations are as follows: Sales are budgeted at $220,000 for November and $200,000 for December. Collections are expected to be 60% in the month of sale and 38% in the month following the sale. 2% of sales are expected to be uncollectible. The cost of goods sold is 75% of sales. A total of 80% of the merchandise is purchased in the month prior to the month of sale and 20% is purchased in the month of sale. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $22,600. Monthly depreciation is $18,000. Kelly Company Statement of Financial Position October 31 Assets $ 22,000 Cash. Accounts receivable (net of allowance for uncollectible accounts) Inventory 76,000 132,000 Property, plant and equipment 870,000 (net of $680,000 accumulated depreciation). Total assets..... $1,100,000 Liabilities and Stockholders' Equity Accounts payable. $ 162,000 Common stock 800,000 Retained earnings... 138,000 Total liabilities and stockholders' equity $1,100,000