please show all work
Calibri (Body) ce Paste E Mergo & Cortor G26 Cash balance, ending (la)-(b) (d)1 . D 1 2 3 C Lewellen Products Sales, purchase, and other budgets June July 419,000 485.000 August 510,000 September 565,000 206,300 135,000 210,800 42,700 20,000 15,000 108,000 103,000 278,300 56,500 20,000 15,000 83,800 95,000 296,700 63,800 20,000 15,000 0 Schedule of Expected Cash Collections July August September 4 Total sales 5 Purchases of material 6 For cash 7 For credit 8 Selling and admin. expenses 9 Income taxes 10 Dividends 11 Equipment purchase 12 13 14 15 16 17 Accounts receivable, 6/30/2020 18 July sales (S485,000) 19 August sales (5510,000) 20 September sales ($565,000) 1 Total cash collections 2 3 24 5 26 Accounts payable 6/30/2020 8 July purchases 9 August purchases 0 September purchases 1 Total cash disbursement 2 Schedule of Expected Cash Payments August July September Sheet1 Sheet2 Sheet3 LE Formatting as Table Styles la Format Filter Scoot Dato G H Lewellen Products Cash Budget For the Month Ended September 30, 2020 Month July August September $100,000 Cash balance, beginning Add: Receipts: Collections from customers Total cash available (a) Less: Disbursements: Direct materials Selling and admin Equipment purchase Dividends Income tax Total disbursements (b) Minimum cash balance Total cash needed Ic! Cash surplus (deficit) (a)-14) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending Ia-b) + (d)] BORDI Calibri (Body) ce Paste E Mergo & Cortor G26 Cash balance, ending (la)-(b) (d)1 . D 1 2 3 C Lewellen Products Sales, purchase, and other budgets June July 419,000 485.000 August 510,000 September 565,000 206,300 135,000 210,800 42,700 20,000 15,000 108,000 103,000 278,300 56,500 20,000 15,000 83,800 95,000 296,700 63,800 20,000 15,000 0 Schedule of Expected Cash Collections July August September 4 Total sales 5 Purchases of material 6 For cash 7 For credit 8 Selling and admin. expenses 9 Income taxes 10 Dividends 11 Equipment purchase 12 13 14 15 16 17 Accounts receivable, 6/30/2020 18 July sales (S485,000) 19 August sales (5510,000) 20 September sales ($565,000) 1 Total cash collections 2 3 24 5 26 Accounts payable 6/30/2020 8 July purchases 9 August purchases 0 September purchases 1 Total cash disbursement 2 Schedule of Expected Cash Payments August July September Sheet1 Sheet2 Sheet3 LE Formatting as Table Styles la Format Filter Scoot Dato G H Lewellen Products Cash Budget For the Month Ended September 30, 2020 Month July August September $100,000 Cash balance, beginning Add: Receipts: Collections from customers Total cash available (a) Less: Disbursements: Direct materials Selling and admin Equipment purchase Dividends Income tax Total disbursements (b) Minimum cash balance Total cash needed Ic! Cash surplus (deficit) (a)-14) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending Ia-b) + (d)] BORDI
