1. Prepare a soles budget, including a schedule of expected cash collections. 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? - Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A % Paste BIU- Cell Alignment Number Conditional Format as Formatting Table Styles Cells Editing Clipboard Font Styles A1 V S&P Enterprises needs a cash budget for March. The following information is A B D E 1 & 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 30,000 40,000 $ 26,600 $ 33,750 $ 45,100 7 Total Sales 8 9 Accounts Receivable Collections: 10 Month of sale 15% 11 Month following sale 60% 12 Second month following sale 22% 13 Uncollectible 3% 14 15 Accounts payable for inventory purchases, March 1 balance $10,500 16 Budgeted inventory purchases in March $23,500 17 nventory payments: 18 Month of purchase 60% 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March $12,500 $3,200 22 Budgeted selling & administrative depreciation in March 23 24 Other budgeted cash disbursements in March Budget Data Schedules and Cash Budget