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             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% 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

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 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%...
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...
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...
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...
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
Redding Company has budgeted sales revenues as follows:                                  
Redding Company has budgeted sales revenues as follows:                                                                                     June                   July                 August    Credit sales                                                              $135,000            $145,000            $  90,000 Cash sales                                                                    90,000              255,000              195,000 Total sales                                                                $225,000            $400,000            $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are: June                                       $300,000 July                                          250,000 August                                     105,000 Other cash disbursements budgeted:  (a) selling and administrative...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...