Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can i get some help with this selling and admin budget by month and in total? i am also looking for expected cash disbursements for
can i get some help with this selling and admin budget by month and in total? i am also looking for expected cash disbursements for selling and admin by month and in total
Selling and Administrative Budget August 600,000 910,000 475,000 September Quarter 6 Sales 7 Shipping as a Percentage of Sales 8 Other Expenses as a Percentage of Sales 5% 8% 5% 8% 5% 8% 0 1 Variable Expenses 12 Shipping 13 Other Expenses 4 Total Variable Expenses 15 Fixed Expenses 6 Salaries and Wages 7 Advertising 18 Prepaid Insurance 9 Depreciation 0 Total Fixed Expesnes 1Total Selling and Admin Expenses 2 3 Less Noncash Items (Depreciation and Prepaid Ins) 4 Total Cash Disbursements 25 6 30,000 48,000 78,000 45,500 72,800 118,300 23,750 38,000 61,750 85,000 50,000 3,000 25,000 163,000 241,000 85,000 50,000 3,000 25,000 163,000 281,300 85,000 50,000 3,000 25,000 163,000 224,750 268,000 108,000 7 8 Prepaid Insurance That Is Expensed During the Quarter 9 Depreciation Expense Recognized During the Quarter S 18,000 S 25,000 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:sStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started