Purchase Solution

Pioneer Carpet: cash collection budget for March

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

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

Purchase this Solution


Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.