Question

9 The following data relate to the operations of Andros Com Company, a magazine distributor Current assets as of March 31: Cash Accounts receivable S26,000 S90,000 Buildings and equipment (net). S150,000 Accounts payableS102,500 Capital stock... S50,000 $148,000 The gross margin is 25% of sales. a. b. Actual and budgeted sales data: March (actual $200,000 $230,000 May. $240,000 June...$250,000 July260,000 April Sales are 55% for cash and 45% on credit. Credit sales are collected in the month following sale The accounts receivable at March 31 are the result of March credit sales. Each months ending inventory should equal 20% of the following months sales budgeted cost of goods sold. 40% of a months inventory purchases is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable at March 31 are a result of March purchases of inventory Monthly expenses are as follows: commissions, $30,400; rent, $11,000; other expenses (excluding depreciation), 4% of sales. These expenses are paid monthly. Depreciation is $7,000 per month and includes depreciation on new assets. c. d. e, f. g. Equipment costing $10,000 will be purchased for cash in April. j. Management wants to maintain a minimum cash balance of $20,000. The company has arn agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume the interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter
4. Complete the following cash budget: Cash Budget ..S 26,000 242,500 ApMayJuneQuarter Cash balance, beginning Add cash collections10,300_ Total cash available For inventory For expenses For equipment 172,100 50,600 10.000 232,700 9,800 Excess (deficiency) of cash Financing Etc 5. Prepare an absorption costing income statement for the quarter ending June 30 similar to Schedule 9 in the text 6. Prepare a balance sheet as of June 30
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
9 The following data relate to the operations of Andros Com Company, a magazine distributor Current...
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
  • 9 The following data relate to the operations of Andros Com Company, a magazine distributor Current...

    9 The following data relate to the operations of Andros Com Company, a magazine distributor Current assets as of March 31: Cash Accounts receivable S26,000 S90,000 Buildings and equipment (net). S150,000 Accounts payableS102,500 Capital stock... S50,000 $148,000 The gross margin is 25% of sales. a. b. Actual and budgeted sales data: March (actual $200,000 $230,000 May. $240,000 June...$250,000 July260,000 April Sales are 55% for cash and 45% on credit. Credit sales are collected in the month following sale The accounts...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,500 $ 20,00 $ 39,60 $ 127,200 $ 23,550 $ 150, een $ 20,750 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 50,000 $ 66,000 $ 71,00 $ 96, cea...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,200 $ 18,800 $ 37,800 $ 123,600 $ 22,425 $ 150,000 $ 14,975 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ $ $ $ $ 47,000 63,000 68,000 93,000 44,000...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 311 Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings 8,300 $ 23,200 $ 44,400 $ 126,000 $ 26,550 $ 150,000 $ 25,350 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 58,000 $ 74,000 $ 79,000 $ 104,000 $ 55,000 c....

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31 Cash $ 8,000 $ 20,000 36,000 $120,000 21,750 150,000 12,250 Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings a. The gross margin is 25% of sales . b. Actual and budgeted sales data: March (actual) April Мay June July $50,000 60,000 $72,000 90,000 48,000 c. Sales are 60% for cash and 40% on...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 8,400 $ 23,600 $ 45,000 $ 123,600 $ 26,925 $ 150,000 $ 23,675 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) Apr 11 May June July $ 59,000 $ 75,000 $ 80.000 $ 105,000 $ 56,000...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 9, 100 $ 26,400 $ 49,200 $ 106,800 $ 29,550 $ 150,000 $ 11,950 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June Ouly $ 66,000 $ 82,000 $ 87,000 $ 112,000 $...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,200 $ 18,800 $ 37,800 $ 123,600 $ 22,425 $ 150,000 $ 14,975 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 47,000 $ 63,000 $ 68,000 $ 93,000 $ 44,000...

  • The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

    The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31 Cash Accounts receivable Building and equipeent, net Accounts payable Common stock Retained earnings $ 26,408 $49,20e $ 106,880 29,558 $150,000 a. The gross margin is 25% of sales. b. Actual and budgeted sales data March (actual) April $82,a0e $87,8ee une uly Sales are 60% for cash and 40% on credit Credit sales are collected in the month following...

  • The following dala relate to the operations of Stilow Company, a wholesale distributor of consumer goous:...

    The following dala relate to the operations of Stilow Company, a wholesale distributor of consumer goous: $ $ $ Current Assets AS of March 31: Cash Accounts receivable Inventory Ruilding and guipment, net Accounts payable Cornon stock Retained earnings 7,302 19,202 38,482 174,882 22,902 150.000 16,902 $ $ $ a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April $ 48.939 $ 64,900 $ 69, en $ 94,we $ 45,080 June July c....

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