Question: how do I calculate cash collections for given month when estimated collections are given? 25% collected in current month 65% collected in month following sales

how do I calculate cash collections for given month when estimated collections are given?

25% collected in current month

65% collected in month following sales

5% in second month following sales

5% uncollectible

The following sales have been budgeted April $120,000 May $100,000 June $110,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

21) Thornton, Inc. has budgeted sales for the months of September and October at $303,000.00 and $272,000.00, respectively. Monthly sales are 20% credit and 80% cash. Of the credit sales, 50% are...

Q:

Gitli Company sells its product for $60 and has variable cost of $35 per unit. The total fixed costs are $26,000. What will be the effect on the breakeven point in units if variable cost increases by...

Q:

Question (1) The following information were taken from B.B, Company ; Sales Revenue (30,000 units) $ 1,200,000 Total Variable costs $ 900,000 Total Fixed Costs $ 100,000 Required : 1- Compute the...

Q:

Thornton, Inc. has budgeted sales for the months of September and October at $308,000.00 and $268,000.00, respectively. Monthly sales are 20% credit and 80% cash. Of the credit sales, 50% are...

Q:

Bruno Industries expects credit sales for January, February, and March to be $209,600, $252,200, and $292,800, respectively. It is expected that 75% of the sales will be collected in the month of...

Q:

Budget Project Group Data Forecasted sales: October 21,250 units; November 43 ,000 units; December 34 ,000; January 22 , 5 00 units; February 2 0,000 units Selling price = $ 21 per unit Raw materials...

Q:

Seasonal Products Corporation expects the following monthly sales: January $20,000, February 15000, March 5000, April 3000, May 1000, June 3000, July 10000, August 14000, September 20000, October...

Q:

HELP WITH CORRECTIONS AND FORMULAS IN EXCEL PLEASE!!! Annual Budget Required: Prepare a comprehensive 6-month budget, including supporting schedules and a report for the period January 1, 2020 to...

Q:

Minimum ending cash balance Selling price $ 10,000 8 Recent and forecast sales (in units): January (actual) February (actual) March (actual) 20,000 24,000 28,000 35,000 45,000 60,000 40,000 36,000...

Q:

F G H 1 3 2 Name Box into an accounting position which requires the application of your budgeting skils. www.ing has not been a priority of the company and that they have been experiencing cash...

Q:

Eliminate the parameter from each pair of equations. Draw the graph of the resulting equation and tell what part of the graph is covered by the parametric equations. y = 2 sin0 20. x = sec0; y = tan0...

Q:

Ski World Magazine Inc. sold 5,200 annual subscriptions of Ski World for $50 each during December 2006. These new subscribers will receive monthly issues, beginning in January 2007. In addition, the...

Q:

1 . How might you respond to an entrepreneur who says, There is so much risk and uncertainty associated with new ventures that forecasting future revenue and cash flows is a waste of time ? 2 ....

Q:

Detailed answer with clear explanation required 4 1 8 . IRP

Q:

=+5. How would you rewrite the copy to make it more effective?

Q:

=+Choose one of the two competing brands, businesses, or agencies. Think about how you would create a distinctive tone of voice with a clear, identifiable personality.

Q:

=+Write a blog that would fit into the range of topics. Write a blog with a catchy title. Later, after you've posted a few comments on this blog, ask if he or she would like to post your article. Be...