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 G Calibri BIU F31 a Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel PAGE LAYOUT 11 AA FORMULAS DATA REVIEW VIEW A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font G v x fx Cells January February March 4 al January and February and expected March sales 5 h sales $ 1,600 $ 3,750 $ 5,100 s on account Sales 25,000 30,000 40,000 26.600 $33.750 5 45.200 9 ounts Receivable Collections 10 Month of sale 15% 11 Month following sale 60M 12 Second month following sale 22% 13 Uncollectible 316 14 15 ounts payable for inventory purchases, March 1 balance $10,500 16 ested inventory purchases in March $23,500 17 entory payments Month of purchase Month following purchase a budgeted selling & administrative expenses in March geted selling & administrative depreciation in March $12.500 $1,200 Budget Data Schedules and Cash Budget 2 Sign In