Question

please show formulas

Worksheet 1 Saved D 7 B С 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 $ 1,600 $ 3,750 $ 5,100 6 Sales on account 25,000 30,000 40,000 Total Sales $ 26,600 $33.750 $ 45,100 8 9 Accounts Receivable Collections: 10 Month of sale 15% 11 Month following sale 60% 12 Second month following sale 22% 13 Uncollectible 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 6096 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March $12,500 22 Budgeted selling & administrative depreciation in March $3,200 23 Score answer