What do I do to compute and get the Accounts Receivable at the end of the Quarter (September Sales (Sales revenue) still not collected)? Can you all show me the step by step work as how to compute this, please?

July 600,000 $ August September 910,000 $ 475,000 $ October 385,000 Part 1 Information 45% 20% 1 MOST LIKELY NUMBERS AND ASSUMPTIONS 2 SALES MANAGER PRIVATE INFORMATION 3 Most likely sales 4 5 6 7 PURCHASING MANAGER PRIVATE INFORMATION 8 Most likely cost of merchandise as a % of sales 9 Desired ending inventory as a percentage of next month's cost of sales 10 11 12 OPERATION MANAGER PRIVATE INFORMATION 13 Most likely shipping expenses as a percent of sales 14 Most likely other expenses as a percent of sales 15 Salaries and wages (per month) 16 Most likely advertising costs (per month) 17 Most likely insurance costs (per month) 18 Depreciation expense (per month) 19 20 21 FINANCE MANAGER PRIVATE INFORMATION 22 Percent sales collected in month of sale 23 Percent sales collected in month after sale 24 25 Percent of inventory purchases paid in month of purchase 26 Percent of inventory purchases paid in month after purchase AAAA Part 1 Information 5.0% 8.0% 85,000 50.000 3,000 $ 25,000 Part 1 Information 30% 70% 50% 50% 27 28 100% 0% $ $ 35,000 1,000 1% Percent of operating expenses paid in month of purchase 29 Percent of operating expenses paid in month after purchase 30 31 Desired minimum ending cash balance each month 32 Borrow in increments of 33 Monthly interest rate on borrowings (not compounded) 34 35 36 Other planned outlays of cash 37 Capital expenditures 38 Dividends 39 40 41 42 SRS Educational Supply Company 43 Balance Sheet 44 Previous Year End $ $ July 200,000 $ 50,000 $ August September 90,000 $ $ Assets $ $ $ $ 40,000 340,000 50,000 18,000 $ 448,000 $ 860,000 $ 1,308,000 45 46 Current assets: 47 Cash 48 Accounts receivable 49 Inventory 50 Prepaid insurance 51 Total current assets 52 Buildings and equipment (net) 53 TOTAL ASSETS 54 55 56 Liabilites 57 Accounts payable 58 Notes pay 59 Total liabilities 60 Stockholder's equity 61 Capital stock 62 Retained earnings 63 Total equity 64 TOTAL LIABILITIES AND EQUITY Liabilities and Equity 130,000 $ $ $ 130,000 $ $ 420,000 758,000 $ 1,178,000 $ 1,308,000 A B D F G E Sales Budget View Assumptions 1 2 3 July Quarter August September $910,000 $475,000 5 Sales 6 $600,000 $1,985,000 7 8 Quarter 9 June sales (A/R From Beginning Balance Sheet) 10 July sales - Collected in Current Month 11 July sales - Collected in Following Month 12 August sales - Collected in Current Month 13 August sales - Collected in Following Month 14 September sales - Collected in Current Month 15 Total Expected Cash Collections 16 Schedule of Cash Collections July August September $340,000 $180,000 $420,000 $273,000 $340,000 $180,000 $420,000 $273,000 $637,000 $142,500 $637,000 $142,500 $779,500 $520,000 $693,000 $1,992,500 17 16 17 18 19 Total Sales for the Quarter 20 A/R at the end of the Quarter (September Sales Still not Collected) $ 1,985,000