Purchase Solution

Building a Cash Budget

Not what you're looking for?

Ask Custom Question

Orion Corporation is preparing a cash budget for the six months beginning January 1. Shown below are the company's expected collection pattern and the budgeted sales for the period.

Expected collection pattern:
65% collected in the month of sale
20% collected in the month after sale
10% collected in the second month after sale
4% collected in the third month after sale
1% uncollectible

Budgeted sales:
January $160,000
February 185,000
March 190,000
April 170,000
May 200,000
June 180,000

The estimated total cash collections during April from sales and accounts receivables would be:

A) $155,900.
B) $167,000.
C) $171,666.
D) $173,400.

Purchase this Solution

Solution Summary

This solution discusses and illustrates how to build a cash budget for a single month if the cash collection and budgeted sales patterns are known for several months before it.

Solution Preview

Before starting the computations, determine the months involved in each category:

Expected collection pattern:
65% collected in the month of sale (April)
20% collected in the ...

Purchase this Solution


Free BrainMass Quizzes
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.

Learning Lean

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

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.