Question

ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...

ABC Company has budgeted sales for the next six months as follows:

             Budgeted Sales in Units
March             13,000 units                          
April             28,000 units
May               36,000 units
June              12,000 units
July              42,000 units
August            69,000 units

ABC Company sells its inventory to customers for $20 per unit.
30% of the company's sales are cash sales and the other 70% of
sales are made on account. The sales on account are collected
in the pattern:

35% collected in the month of sale
26% collected in the month following sale
19% collected in the second month following sale
12% collected in the third month following sale
8% collected four months after the month of sale

Calculate ABC Company's budgeted cash collections for July.

Homework Answers

Answer #1

Answer:

Total Cash Collection in July is $406840.

Explanation:

Computation of Cash Collection in July:

Cash Received from March Month Sale in July = {(13000 units x $20) x 70%} x 8% = {$260000 x 70%} x 8% = $182000 x 8% = $14560

Cash Received from April Month Sale in July = {(28000 units x $20) x 70%} x 12% = {$560000 x 70%} x 12% = $392000 x 12% = $47040

Cash Received from May Month Sale in July = {(36000 units x $20) x 70%} x 19% = {$720000 x 70%} x 19% = $504000 x 19% = $95760

Cash Received from June Month Sale in July = {(12000 units x $20) x 70%} x 26% = {$240000 x 70%} x 26% = $168000 x 26% = $43680

Cash Received from July Month Sale in July = {(42000 units x $20) x 70%} x 35% = {$840000 x 70%} x 35% = $588000 x 35% = $205800

Total Cash Collection in July = $14560 + $47040 + $95760 + $43680 + $205800 = $406840.

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
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 27,000 units May 34,000 units June 10,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $21 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $27,000 $226,000 February $33,000 $299,000 March $21,000 $273,000 April $24,000 $241,000 May $38,000 $213,000 June $19,000 $201,000 On average, 14% of the sales on account are collected in the month of sale, 38% are collected in the month following sale, 43% are collected in the second month following sale, and the remaining 5% is collected three months after the...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $296,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
11. Honda Company's budgeted sales for the next five months are given below (assume all sales...
11. Honda Company's budgeted sales for the next five months are given below (assume all sales are made on account): Budgeted Sales January $155,000 February $272,000 March $??????? April $180,000 May $235,000 Honda Company's sales are collected in the pattern: 22% collected in the month of sale 35% collected in the month following sale 27% collected in the second month following sale 16% collected in the third month following sale Honda Company's budgeted accounts receivable at April 30 was $330,980....
Judge Company's budgeted sales for the next five months are given below: Budgeted Sales January $149,000...
Judge Company's budgeted sales for the next five months are given below: Budgeted Sales January $149,000 February $274,000 March $373,000 April $167,000 May $232,000 20% of Judge Company's sales are cash sales and the other 80% are sales on account. The sales on account are collected in the pattern: 22% collected in the month of sale 35% collected in the month following sale 27% collected in the second month following sale 11% collected in the third month following sale 5%...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June    ...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June     490,000 July       515,000 August    500,000 Septemeber    475,000 18% percent of the sales are credit sales and the remainder are cash sales. Credit sales are collected 45% in the month of sale, 36% in the month following the sale, and 19% in the second month following the sale. Required: Prepare a schedule of cash collections for June, July, & August
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000...
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000 units October 60,000 units November 40,000 units December 75,000 units The company wishes to have 10% of the next month’s sales on hand at the end of each month. How much is budgeted production for November? A) 43,500 units B) 40,000 units C) 47,500 units D) 36,000 units 2) SalaRita’s sales are 32% cash and 68% credit. Of the credit sales, 40% of credit...
The PM Company has planned the following sales for the next three months: January February March...
The PM Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account (A/R). From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% The following additional information has been provided for March: Inventory purchases (70% paid...