Question

The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales...

The LaPann Company has obtained the following sales forecast data:

July

August

September

October

Cash Sales

$80,000

$70,000

$50,000

$60,000

Credit Sales

$240,000

$220,000

$180,000

$200,000


The regular pattern of collection of credit sales is 30% in the month of sale and 70% in the month following the month of sale.  There are no bad debts.

The budgeted accounts receivable balance on September 30th is:

  1. $126,000
  2. $154,000
  3. $161,000
  4. $186,000

Homework Answers

Answer #1
Correct Option A i.e. $126,000
July August September October
Cash Sales             80,000           70,000      50,000       60,000
Credit Sales           240,000         220,000    180,000    200,000
accounts receivable balance on September 30th is          126,000
(180000*70%) (70% of september sales)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please answer the following questions & provide supporting calculations: The LaPann Company has obtained the following...
Please answer the following questions & provide supporting calculations: The LaPann Company has obtained the following sales forecast data: July August September October Cash sales.............. $80,000 $70,000 $50,000 $60,000 Credit sales............ $240,000 $220,000 $180,000 $200,000 The regular pattern of collection of credit sales is 20% in the month of sale, 70% in the month following the month of sale, and the remainder in the second month following the month of sale. There are no bad debts. (You may wish to...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales $350,000 $320,000 $400,000 $360,000 Cash Sales $70,000 $90,000 $80,000 $70,000 The regular pattern of collection of credit sales is 30% in the month of sales, 25% in the month following sales, and the remainder in the second month following the month of sale. There are no bad debts. Required: a. Determine budgeted cash receipts for April. b. Determine budgeted accounts receivable balance on March...
Wells Company reports the following sales forecast: September, $46,000; October, $67,000; and November, $78,000. All sales...
Wells Company reports the following sales forecast: September, $46,000; October, $67,000; and November, $78,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November. WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash receipts from November...
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month...
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Credit sales are for the last 6 months are as follows: July $60,000 August $70,000 September $80,000 October $90,000 November $100,000 December $85,000 the estimated total cash collections during october from accounts receivable would be
Lee Company provides the following data for the months of July through October: Month                            
Lee Company provides the following data for the months of July through October: Month                                     Sales                             Purchases July                                         $180,000                      $105,000 August                                    165,000                      120,000 September                             150,000                          90,000 October                                  195,000                      135,000 Collections from customers are normally 70% in the month of sale and 30% in the following month. All purchases are on credit and paid in cash in the following month. November sales are budgeted to be $165,000, and November purchases are forecast to be $150,000. Cash disbursements for expenses in November...
Harrti Corporation has budgeted for the following sales: July $ 447,000 August $ 582,000 September $...
Harrti Corporation has budgeted for the following sales: July $ 447,000 August $ 582,000 September $ 616,000 October $ 891,000 November $ 740,000 December $ 700,000 Sales are collected as follows: 20% in the month of sale; 55% in the month following the sale; and the remaining 25% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?
Harrti Corporation has budgeted for the following sales: July $ 448,400 August $ 583,400 September $...
Harrti Corporation has budgeted for the following sales: July $ 448,400 August $ 583,400 September $ 616,700 October $ 891,700 November $ 747,000 December $ 707,000 Sales are collected as follows: 15% in the month of sale; 65% in the month following the sale; and the remaining 20% in the second month following the sale. In Harrti's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?
Wells Company reports the following sales forecast: September, $46,000; October, $64,000; and November, $73,000. All sales...
Wells Company reports the following sales forecast: September, $46,000; October, $64,000; and November, $73,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November.
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000 Purchases 9,000 13,800 15,000 Payments for purchases are made in the month after purchase. Selling expenses are 16% of sales, administrative expenses are 11% of sales, and both are paid in the month of sale. Rent expense of $2,100 is paid monthly. Depreciation expense is $1,400 per month. Prepare a schedule of budgeted cash payments for August and September. HECTOR COMPANY Budgeted Cash Payments...