Please show work
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 Total sales Purchases of material 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 ($485,000) 19 August sales ($510,000) 20 September sales ($565,000) 21 Total cash collections 22 23 24 25 26 27 Accounts payable, 6/30/2020 28 July purchases 29 August purchases 30 September purchases 31 Total cash disbursement 32 Cash balance, beginning Add: Receipts: Collections from custom Total cash avallable(a) Less: Disbursements: Direct materials Selling and admin. Equipment purchase Dividends Income tax Total disbursements (b) Minimum cash balance Total cash needed (c) Cash surplus (deficit) (a)-[c] Finance: Borrowing Repayment Interest Total effect of financine (d) Cash balance, ending Ifa(b) + (d Schedule of Expected Cash Payments July August September 9 Sheet To TODO styles Filter Select Dato F 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 (c) Cash surplus (deficit) (0) - (c) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending Ila)(b)+(d A D E F Lewellen Products Sales, purchase, and other budgets July 419,000 485,000 June 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 Total sales 5 Purchases of material 5 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 ($485,000) 19 August sales ($510,000) 20 September sales ($565,000) 21 Total cash collections 22 23 24 25 26 27 Accounts payable, 6/30/2020 28 July purchases 29 August purchases Cash balance, begir Add: Receipts: Collections from Total cash availa Less: Disbursements: Direct materials Selling and admin Equipment purch Dividends Income tax Total disbursements Minimum cash bala Total cash needed to Cash surplus (deficit Finance: Borrowing Repayment Interest Total effect of finan Cash balance, endir Schedule of Expected Cash Payments July August September 10 E G H eptember 565,000 Lewellen Products Cash Budget For the Month Ended September 30, 2020 Month August September $100,000 July 95,000 296,700 63,800 20,000 15,000 0 September 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 (cl Cash surplus (deficit) () - (c) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending IaHb) + (d) 4 . YYY September 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 Total sales Purchases of material 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 ($485,000) 19 August sales ($510,000) 20 September sales ($565,000) 21 Total cash collections 22 23 24 25 26 27 Accounts payable, 6/30/2020 28 July purchases 29 August purchases 30 September purchases 31 Total cash disbursement 32 Cash balance, beginning Add: Receipts: Collections from custom Total cash avallable(a) Less: Disbursements: Direct materials Selling and admin. Equipment purchase Dividends Income tax Total disbursements (b) Minimum cash balance Total cash needed (c) Cash surplus (deficit) (a)-[c] Finance: Borrowing Repayment Interest Total effect of financine (d) Cash balance, ending Ifa(b) + (d Schedule of Expected Cash Payments July August September 9 Sheet To TODO styles Filter Select Dato F 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 (c) Cash surplus (deficit) (0) - (c) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending Ila)(b)+(d A D E F Lewellen Products Sales, purchase, and other budgets July 419,000 485,000 June 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 Total sales 5 Purchases of material 5 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 ($485,000) 19 August sales ($510,000) 20 September sales ($565,000) 21 Total cash collections 22 23 24 25 26 27 Accounts payable, 6/30/2020 28 July purchases 29 August purchases Cash balance, begir Add: Receipts: Collections from Total cash availa Less: Disbursements: Direct materials Selling and admin Equipment purch Dividends Income tax Total disbursements Minimum cash bala Total cash needed to Cash surplus (deficit Finance: Borrowing Repayment Interest Total effect of finan Cash balance, endir Schedule of Expected Cash Payments July August September 10 E G H eptember 565,000 Lewellen Products Cash Budget For the Month Ended September 30, 2020 Month August September $100,000 July 95,000 296,700 63,800 20,000 15,000 0 September 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 (cl Cash surplus (deficit) () - (c) Finance: Borrowing Repayment Interest Total effect of financing (d) Cash balance, ending IaHb) + (d) 4 . YYY September
