Question
Laura Falk, Swifty & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February March Quarter Budgeted
Laura Falk, Swifty & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter.
January | February | March | Quarter | |||||
---|---|---|---|---|---|---|---|---|
Budgeted revenue | $156,200 | $304,590 | $273,350 | $734,140 |
The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 70% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 4% of sales are uncollectible. The company expects to have an accounts receivable balance of $41,535 on January 1, and this amount represents the remaining receivables from December's sales. Prepare Swifty & Hill's cash receipts budget for the first quarter. (Round answers to 0 decimal places, e.g. 5,275. 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 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 amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | |||
February sales | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | |||
March sales | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | Enter a dollar amountEnter a dollar amount | |||
Totals | $Enter a total amountEnter a total amount | $Enter a total amountEnter a total amount | $Enter a total amountEnter a total amount | $Enter a total amount Enter a total amount | $Enter a total amountEnter 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 the Net Accounts Receivable in dollars Enter the Net Accounts Receivable 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