Can i please get some help with the sales budget? i am looking for the expected sales by month end and in total from 7/1 until 9/30

July August SeptemberQuarter Sales Schedule of Cash Collections JulyAugst September Quarter June sales (A/R From Beginning Balance Sheel) 0 July sales- Collected in Current Month 1 July sales - Collected in Following Month 2 August sales Collected in Current Month 3 August sales-Collected in Following Month 4 September sales Collected in Current Month 5 Total Expected Cash Collections 9 Total Sales for the Quarter 0 A/R at the end of the Quarter (September Sales Still not Collected) eptember October Most likely sales 600,000 910,000 475,000 385,000 PURCHASIHG MAHAGER PRIYATE IHFORMATIOH Most likely cost of merchandise as % of sales Desired endinq inventory as percentage of next month's cost of $ales 45% 20% OPERATIOH MAHAGER PRIYATE IHFORMATIOH Most likely shippinq expenes percen Most likely other expense"53 percent of sales Salaries and wages [per month Most likely advertising costs [per monthl Most likely insurance coste [per month Depreciation expense [per month) 5.0% 8,0% 85,000 50,000 3.000 25,000 FIHAHCE MAHAGER PRIYATE IHFORMATIOH Percent sales collected in month of sale Percent sales collected in month after sal 30% 70% Percent of inventory purchases paid in month of purchase Percent of inentory purchaes paid in month after purchase 50% 50% Percent of operating expenses paid in month of purchae Percent of operating expenses paid in m onth after purch Desired minimum ending cash balance each month Borrow in increments of Monthly interest rote on borrowings Inot co 0% 35.000 1% Other planned outlays of cash Copital expenditures Dividends 200,00 90,00 50,000 SRS Edacational Sapply Co pan Balance Sheet Prerious Year End Cash Accounts receivable Inventor Prepaid insurance 40,000 340,000 50,000 Total current assets Buildings and equipment Inet] TOTAL ASSETS $448,000 L 860000 11308000 Accounts payable Notes payable Total liabilities Stockholder's equity Copital stock Retained earnings Total equity $130,000 $420,000 1178000 TOTAL LIABILITIES AND EC Instructions Milestone One Instructions Part Il Assumption:s