A B C D E F 1 S&P Enterprises needs a cash budget for March. The following information is available. 2 3 Data January February March 4 Actual January and February and expected March sales: 5 Cash sales $ 6 Sales on account 1,600 $ 3,750 $ 5,100 25.000 40.000 30.000 $ 26 600 33.750 $45.100 7 Total Sales 8 9 Accounts Receivable Collections: 10 Month of sale 11 Month following sale 12 Second month following sale 13 14 45 Uncollectible 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: 18 19 098 20 Month of purchase Month following purchase 15% 60% 22% 39 $10,500 $23,500 9609 40% 21 Total budgeted selling & administrative expenses in March $12,500 22 Budgeted selling & administrative depreciation in March $3,200 23 24 Other budgeted cash disbursements in March 25 Equipment purchases 26 Dividends to be paid 27 28 Minimum cash balance to be maintained 29 March 1 cash balance 30 March 1 outstanding borrowings 31 March 1 interest due $14,000 $2,000 $10,000 $11,500 50 50 Budget Data Schedules and Cash Budget