Question
Laura Hall, Bramble & Kevin Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February March Quarter Budgeted
Laura Hall, Bramble & Kevin 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 | $620,000 | $1,480,000 |
The company makes all sales on credit. Laura 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 an accounts receivable balance of $98,200 on January 1, and this amount represents the remaining receivables from December's sales. Prepare Bramble & Kevin'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 | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||
January sales | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||
February sales | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||
March sales | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||
Totals | $enter a total amount | $enter a total amount | $enter a total amount | $enter a total amount | $enter a total amount |
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 | $enter net accounts receivable amount in dollars |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started