Question: Can I please get help with the highlighted part? I am stuck eptember October Most likely sales 600,000 910,000 475,000 385,000 PURCHASIHG MAHAGER PRIYATE IHFORMATIOH


Can I please get help with the highlighted part? I am stuck
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 Cash Budget August September Quarter Cash Balance: Beginning Add Cash Collections (From Sales Budget) Total cash Available Less Cash Disbursements $ 40,000 35,050 $ 43,405 520,000 560,000 40,000 693,000 779.500 1992.500 725,050822,9052,032,500 For Inventory (From Purchasing Budget) For Operating Expenses (From Selling and Admin Budg216,000256,300199,750 For Equipment For Cash Dividends For Interest (From Previous Month's Borrowing) 280,950 336,125 228,000 905,075 675,050 290,000 50,000 4,440 489.970 1,921,565 (186,950) 43,405332,935110,935 200,000 50,000 90,000 0 0 0 $ 2,220 $ 2,220 Total Cash Disbursements Excess (Deficiency) of Cash Financing 746,950 684,645 Borrowing Repayment 222,000 0 222,000 0 0 43.405110,935110935 0 0 (222,000) (222,000) Total Financing Cash Balance: Ending 222,000 35.050 0 (222,000)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
