Explore BrainMass

Explore BrainMass

    Pioneer Carpet: cash collection budget for March

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Pioneer square carpet specialties has found that cash collections from customers tend to occur in the following pattern

    Collected within cash discount period in month of sale 50%
    Collected within cash discount period in first month after month of sale 10%
    Collected after cash discount period in first month after month of sale 25
    Collected after cash discount period in second month after month of sale 12
    Never collected 3%
    Total sales in any month (before cash discounts) 100%
    Cash discount allowable as a percentage of invoice price 1%

    Compute the total cash budgeted to be collected in March if sales are predicted as $300,000 for January, $400,000 for February, and $450,000 for March.

    © BrainMass Inc. brainmass.com June 3, 2020, 6:43 pm ad1c9bdddf
    https://brainmass.com/business/cash-budgeting/pioneer-carpet-cash-collection-budget-for-march-72378

    Solution Preview

    Hello!
    What we need to do here is to check how much of January's, February's and March's sales are collected in March. Let's do each month separately.

    - January
    Collections of this month in March will happen in the 2nd month after sale (sale will be in January, cash will be collected in March). We know from the data that 12% of the sales of any month are collected (with no cash discount, since they are made "after cash discount period") in the 2nd month after sale. Therefore, since ...

    Solution Summary

    In narrative form, the solution explains the calculations needed to arrive at March cash collections. There is a definitive answer after the calculations.

    $2.19

    ADVERTISEMENT