are a sales budget, including a schedule of expected cash collections. are a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. pare a cash budget ? 6 X Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ME Sign In Calculate Now d Formula Auditing Calculation Calculate Sheet Options Calculation v > f fo 3% B D m $26.600 $33.750 $45.100 Receivable Collections: of sale following sale a month following sale ectible 15% 60% 22% 3% $10,500 $23,500 payable for inventory purchases, March 1 balance Inventory purchases in March payments: h of purchase h following purchase 60% 40% geted selling & administrative expenses in March d selling & administrative depreciation in March $12,500 $3,200 udgeted cash disbursements in March pment purchases ends to be paid $14,000 $2,000 m cash balance to be maintained $10,000 X ? - e x Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign In fx Calculate Now Function Defined Formula Calculation Calculate Sheet Library Names" Auditing Options Calculation