Question

The following data apply to questions 5 to 6. Information pertaining to Brenton Corporations sales revenue is presented in t

Can you show me how to get each answer/the calculations?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer 5

c. $ 431,600

Calculations:

A 1 2 Credit Sales 3 Collected in same month 4 Collected in next month 5 Total credit sales collcted 6 cash sales 7 Total Col

Formulae used

C A 1 February March April 2 Credit Sales 300000 400000 280000 3 Collected in same month =B2*0.95*0.6 =C2*0.95*0.6 =D2*0.95*0

Answer 6

e. None of the above

Calculations:

Opening cash $          20,000
Add: Collections from sale $        492,000
Less: Purchases
March (400000*0.70*0.25) $          70,000
Feb (550000*0.70*0.75) $        288,750
Less: Operating expenses $        120,000
Closing cash $    33,250

In case of any doubt, please comment.

Add a comment
Know the answer?
Add Answer to:
Can you show me how to get each answer/the calculations? The following data apply to questions...
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
  • Can you do this in excel and show what functions you use to get the quarter...

    Can you do this in excel and show what functions you use to get the quarter totals and other totals. Can you also do the sales budget I need to create an entire master budget. 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 $ 8,500 $ 24,000 $ 45, 600 $ 121,200...

  • Can anyone help me with the ones that are wrong? Also explain how you get the...

    Can anyone help me with the ones that are wrong? Also explain how you get the answers nment 6 Help Save 8 c Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid...

  • can you please answer this and show me how you arrived at the answer. thanks Check...

    can you please answer this and show me how you arrived at the answer. thanks Check my work You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting,...

  • Can you please show me what the sales budget for this information would be in excel....

    Can you please show me what the sales budget for this information would be in excel. Thank you 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 $ 8,500 $ 24,000 $ 45, 600 $ 121,200 $ 27,300 $ 150,000 $ 22,000 a. The gross margin is 25% of sales. b. Actual and...

  • Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...

    Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 113,000 $ 142,000 $ 95,000 Credit sales 305,000 467,000 251,000 Total sales $ 418,000 $ 609,000 $ 346,000 Management estimates that 5% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...

  • nformation pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales...

    nformation pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 101,000 $ 130,000 $ 83,000 Credit sales 293,000 455,000 239,000 Total sales $ 394,000 $ 585,000 $ 322,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 150,000 $ 123,000 $ 109,000 Credit sales 150,000 147,600 119,900 Total $ 300,000 $ 270,600 $ 228,900 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  •       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...

  • Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018...

    Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018 (Actual) $ 105,000 270,000 $ 375,000 December 2018 (Budgeted) $ 115,000 395,000 $ 510,000 January 2019 (Budgeted) $ 70,000 200,000 $ 270,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...

  • 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 $ 9,300 Accounts receivable $ 27,200 Inventory $ 50,400 Building and equipment, net $ 102,000 Accounts payable $ 30,300 Common stock $ 150,000 Retained earnings $ 8,600 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 68,000 April $ 84,000 May $ 89,000 June $ 114,000 July $ 65,000 Sales are...

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