Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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:s

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

New Approach To Financial Accounting No Need Of Cramming Formats

Authors: Samuel A. Olowoniyi ACA

1st Edition

148253150X, 978-1482531503

More Books

Students also viewed these Accounting questions