Sign REVIEW VIEW FORMULAS DATA INSERT PAGE LAYOUT ILL HOME Calbri 11 Alignment Number Conditional Format as Cell Formatting Table Styles Editing Cells Paste A BIU- FH- Styles apboard Font S&P Enterprises needs a cash budget for March. The following information is Al x D B C 1S&P Enterpaucs needs a cash budget for March. The following inforrhation is available. 2 February March 3 Data January 4 Actual January and February and expected March sales: 5 Cash sales 1,600 S 3,750 $ 5,100 30,000 6 Sales on account 25.000 40,000 33.750 S 45,100 7 Total Sales S 26,600 S 9 Accounts Receivable Collections: 10 Month of sale 15% 11 Month following sale 60% 12 Second month following sale Uncollectible 22% 13 3% 14 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: $10,500 $23,500 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 hisdaeted cach dichureements.in March Budget Data Schedules and Cash Budget 4 READY Attempt(s) MacBook Air