Question
i dont know if you can help . but i need the schedule of expected cash flows and help wjth the S & A expenses budget. the values for that budget is in the first picture.
The companys monthly selling and administrative expenses are given below: $ 1 per tie Variable: Sales commissions Fixed: Wag
May 23 Budgeted Sales (units) 24 Add. Desired Ending Inventory 25 Total Needs 26 Less: Beg. Inventory 27 Required Purchases 2

what is the selling and administrative budget per month and for the quarter
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Variable cost varies with number of units whereas fixed remains constant irrespective of number of units produced or sold.

SELLING AND ADMINISTRATIVE EXPENSE BUDGET
APRIL MAY JUNE QTR
Variable expense
commission expense 39000*1=39000 52000*1=52000 63000*1=63000 154000
Fixed expense
wages and salaries expense 31200 31200 31200 93600
Utilities expense 23100 23100 23100 69300
Insurance expense 1100 1100 1100 3300
Depreciation expense 1500 1500 1500 4500
Miscellaneous expense 3400 3400 3400 10200
Total fixed expense 60300 60300 60300 180900
Total selling and administration expense 99300 112300 123300 334900
less:Non cash expense -1500 -1500 -1500 -4500
Cash disbursement for S &A expense 97800 110800 121800 330400

**Only depreciation is a non cash expense

Add a comment
Know the answer?
Add Answer to:
i dont know if you can help . but i need the schedule of expected cash...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • a. jo Sales in April are expected to be $180,000. Vinning forecasts that monthly sales will...

    a. jo Sales in April are expected to be $180,000. Vinning forecasts that monthly sales will increase 2% over April sales in May. June's sales will increase by 4% over April sales. July sales will increase 20% over April sales. Vinning maintains inventory of $13,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of goods sold equal 50% of sales revenue. Monthly salaries amount to $8,000. Sales commissions equal 5% of sales for that...

  •       Hello, these are 3 questions I need help with, if you can show me...

          Hello, these are 3 questions I need help with, if you can show me how to get the answer as well. thank you for your time. 2 Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the...

  • The budget committee of printer office supply has assembled the following data:​​​​​​​ Question 2: The budget...

    The budget committee of printer office supply has assembled the following data:​​​​​​​ Question 2: The budget committee of Printer Office Supply has assembled the following data: Printer Office Supply Balance Sheet March 31, 2014 Liabilities Current Assets Cash Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable S 34,000 15,000 19,500 1,400 16.250 4,725 Salaries and Commissions Payable Total Liabilities $ 20,975 $ 69,900 Stockholders' Equity Prepaid Insurance Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures Common Stock 17,000...

  • Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative...

    Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,600 units quarter 1; 22,100 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,000, office salaries $6,130, depreciation $4,760, insurance $2,010, utilities $820, and repairs expense $610. 4. Unit selling...

  • Chapter 7 CASE You have just been hired as a management trainee by Cravat Sales Company,...

    Chapter 7 CASE You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor of a designer's silk ties. The company has an exclusive franchise on the distribution of the ties, and sales have grown so rapidly over the last few years that it has become necessary to add new members to the management team. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a master budget for...

  • Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February 28....

    Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February 28. Profected selling and administrative expenses for each of the first three months of operations are as follows: March $154,600 April 146,900 May 133,700 Depreciation, insurance, and property taxes represent $33,000 of the estimated.monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 62% of the remainder of the expenses are expected to...

  • 1: Prepare a sales budget, including a schedule of expected cash collections. 2: prepare a merchandise...

    1: Prepare a sales budget, including a schedule of expected cash collections. 2: prepare a merchandise purchase budget, including a schedule of expected cash disbursements for merchandise, and a selling and administrative budget. 3: prepare a cash budget. MOST LIKELY NUMBERS AND ASSUMPTIONS SALES MANAGER PRIVATE INFORMATION October Most likely sales 600,000 910,000 475,000 385,000 PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of...

  • please complete the income statements and balance sheets. I need to conpare with what I’ve done...

    please complete the income statements and balance sheets. I need to conpare with what I’ve done to see if they are correct. Excel fucntions will need to correctly update with any changes to both finacial statements. Thank you!! The income statements and balance sheets need to be completed.sections highlighted in Orange) from the schedules and cash budget pages peovided. Table 6.2 PDC Company Operating Schedules and Cash Budget (A) SALES SCHEDULE APRIL TO AUGUST JULY JULY JUNE MAY MARCH APRIL...

  • Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative...

    Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,200 units quarter 1; 22,200 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,600, office salaries $6,370, depreciation $4,580, insurance $1,630, utilities $840, and repairs expense $650. 4. Unit selling...

  • edule of cash receipts, schedule of cash 40A Preparing a financial budget schedule of cash receipts...

    edule of cash receipts, schedule of cash 40A Preparing a financial budget schedule of cash receipts payments, cash budget 90 Humble Company has provided the following budget information of 2016: ed the following budget information for the first quarter 39 Total sales $ 208,000 Budgeted purchases of direct materials 40,150 Budgeted direct labor cost 37,300 Budgeted manufacturing overhead costs: Variable manufacturing overhead 1,119 Depreciation 1,000 Insurance and property taxes 6,833 Budgeted selling and administrative expenses: Salaries expense 6,000 Rent expense...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT