1 FILE 86 Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? 17 HOME INSERT Calibri 11 Paste BIU Clipboard Font PAGE LAYOUT FORMULAS DATA REVIEW VIEW 4 A A % M Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Styles C16 x fx A B C D E 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 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 60% 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March $12,500 $3,200 23 24 Other hudanted each dichurcamente in March. Budget Data Schedules and Cash Budget 4 READY Attempt(s) E 6 x Sign In 100%