Purchase Solution

Experience has shown that 50% percent of the sales of Geragh

Not what you're looking for?

Ask Custom Question

Please help with the following problem regarding sales revenue. Provide step by step calculations.

Experience has shown that 50% percent of the sales of Geraghty Company sales are for cash. Monthly sales are budgeted as follows: $280,000 for October, $240,000 for November, and $320,000 for December. The rest are on credit with 70% of the credit sales are collected in the month of sale, 20% in the month following sale, and 5% in the second month following sale. The remainder is expected to be uncollectible.

Prepare a schedule of expected cash collections for the month of December.

Attachments
Purchase this Solution
Solution Summary

This solution helps with a problem involving sales revenue. It helps prepare a schedule of expected cash collections based on monthly sales and percent of sales. Step by step calculations are given in the solution.

Solution Preview

Problem: Experience has shown that 50% percent of the sales of Geraghty Company sales are for cash. Monthly sales are budgeted as follows: $280,000 for October, $240,000 for November, and $320,000 for ...

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Introduction to Finance

This quiz test introductory finance topics.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • Budgeting and variances

    has shown that 50 percent of a month's sales are collected in the month of sale, 30 percent in the month following sale, and the remaining 20 percent in the second month following sale.

  • Cash projections and schedule of cash receipts

    . . . . . . . . 35,000 December . . . . . . . . . . . . . . . . . 60,000 Experience has shown that 20 percent of sales are collected in the month of sale, 70 percent in the following month, and 10 percent are never collected.

  • Cash Receipt Schedule

    . . . . . . . . . . . . . 55,000 December . . . . . . . . . . . . . . . . . . . . 80,000 Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected

  • Pirate Video Company - Prepare a monthly cash receipts schedule for the firm for March through August.

    Experience has shown that of total sales, 10 percent are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale.

  • Timber's Lodge Shop Cash Receipts Forecast

    Timber's Lodge shop has forecast credit sales for the 4th quarter: September (actual sales)---- $50,000 Fourth quarter October $40,000 November $35,000 December $60,000 Experience has shown that 25% of sales are collected in the

  • Forecasting: Jill's outside capital, Kenney retained earnings

    If sales grow by 50 percent, what will Snowball's current ratio be after it has raised the necessary expansion funds?

  • Developing a Cash Budget

    This solution is comprised of a detailed explanation to compute the cash collections from sales for each quarter. Please note that this has not been completed using Excel, but the computations are clearly shown.

  • Gross profit/ending inventory and Schedule of Cash Receipts

    Experience has shown that 20 percent of sales receipts are collected in the month of sale, 70 percent in the following month, and 10 percent are never collected.

  • Steps of estimating external financing

    Cambridge Prep Shops, a national clothing chain, had sales of $200 million last year. The business has a steady net profit margin of 12 percent and a dividend payout ratio of 40 percent.

View More Related Solutions