3 1. Prepare a sales 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. FILE HOME INSERT Paste Clipboard Calibri BIU- Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel Font PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Sign In M Cells Editing A1 A fx S&P Enterprises needs a cash budget for March. The following information is B 1 S & P Enterprises needs a cash budget for March. The following information is available. 2 D E F 3 Data January February March 4 Actual January and February and expected March sales: 5 Cash sales $ 6 Sales on account 7 Total Sales 8 9 Accounts Receivable Collections: 25,000 1,600 $ 3,750 $ 5,100 30,000 40,000 $ 26,600 $ 33,750 $ 45,100 10 Month of sale 11 Month following sale 12 Second month following sale 13 Uncollectible 15% 60% 22% 3% 14 15 Accounts payable for inventory purchases, March 1 balance $10,500 16 Budgeted inventory purchases in March $23,500 17 Inventory payments: 18 Month of purchase 19 Month following purchase 60% 40% 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March $12,500 $3,200 23 24 Other budgeted cash disbursements in March 25 Equipment purchases $14,000 26 Dividends to be paid $2,000 Budget Data Schedules and Cash Budget READY Attempt(s) < B + 64% Hint Show Me