Mary Smith, Crane & James Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February March Quarter Budgeted revenue $400,000 $460,000 $600,000 $1,460,000 The company makes all sales on credit. Mary recently reviewed the company's collection history and found that 72% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 2% of sales are uncollectible. The company expects to have a net accounts receivable balance of $98,200 on January 1, and this amount represents the remaining receivables from December's sales. Prepare Crane & James's cash receipts budget for the first quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Mary Smith, Crane & James Fabricators'
January
|
February
|
March
|
Quarter
|
|||||
---|---|---|---|---|---|---|---|---|
Budgeted revenue
|
$400,000 | $460,000 | $600,000 | $1,460,000 |
The company makes all sales on credit. Mary recently reviewed the company's collection history and found that 72% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 2% of sales are uncollectible. The company expects to have a net accounts receivable balance of $98,200 on January 1, and this amount represents the remaining receivables from December's sales.
Prepare Crane & James's
![Mary Smith, Crane & James Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter.
January
February
March
Quarter
Budgeted revenue
$400,000
$460.000
$600,000
$1,460,000
The company makes all sales on credit. Mary recently reviewed the company's collection history and found that 72% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 2% of sales are uncollectible. The company expects to have a net accounts receivable balance of
$98.200 on January 1, and this amount represents the remaining receivables from December's sales.
Prepare Crane & James's cash receipts budget for the first quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Cash Receipts Budget
January
February
March
Total Cash Receipts
Uncollectible
December credit sales
2$
2$
January sales
February sales
March sales
Totals
$
$
$
$
$
Determine the Net Accounts Receivable at the end of the quarter. Assume that there are no outstanding accounts receivable and allowance for doubtful accounts balances at the beginning of December for the prior year.
Net Accounts Receivable
$](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdeab9571-4068-4b53-b773-94218c1bf05d%2F02eb69ab-9e11-46af-801f-5f559aa18cff%2F8me4m1m_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)