Question

Alex Company has projected sales and production in units for the second quarter of the coming...

Alex Company has projected sales and production in units for the second quarter of the coming year as follows:

April

May

June

Sales units

55,000

45,000

65,000

Production units

65,000

55,000

55,000

All units are sold on account for $16 each. Cash collections from sales are budgeted at 60% in the month of sale, 30% in the month following the month of sale, and the remaining 10% in the second month following the month of sale. Accounts receivable on April 1 totaled $540,000 ($200,000 from February's sales and the remainder from March).

Required:

Prepare a schedule for each month showing budgeted cash receipts for Alex Company.

Cash receipts:

April

May

June

Total receitps

$        (A)

$         (B)

$        (C)

Homework Answers

Answer #1

The answer has been presented in the supporting sheet. For detailed answer refer to the supporting sheet.

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
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 43,000 12,000 12,000 Production 53,000 12,000 12,000 Cash-related production costs are budgeted at $9 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals...
Tyson Inc. has projected sales and production in units for the second quarter of the coming...
Tyson Inc. has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 50,000 40,000 60,000 Production 60,000 50,000 50,000 cash related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $100,000 per month. The accounts payable balance on March 31...
: For the second quarter of the following year Cloaks Company has projected sales and production...
: For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance...
For the second quarter of the following year Cloaks Company has projected sales and production in...
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 49,000 51,000 56,000 Production 53,000 48,000 49,000 Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the next month. $95,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...
Tilson corporation has projected sales and production units for the second quarter of the coming ear...
Tilson corporation has projected sales and production units for the second quarter of the coming ear as fools April May June sales 55000 45000 65000 Production 65000 55000 55000 Cash-related production coss ae budget at 7 per unit produced of this production costs, 40% are paid in the month in which the are incurred and the lance in the following month Selling and administrative expenses will amount to $110000 per month. The accouns payable balance on March 31
in units april may june sales 70000 60000 80000 production 80000 70000 70000 Cash-related production costs...
in units april may june sales 70000 60000 80000 production 80000 70000 70000 Cash-related production costs are budgeted at 8$ per unit produced. Of these production costs, 40% are paid in month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to 150000$ per month. The accounts payable balance on March 31 totals 190000$ which will be paid in April. All units are sold on account for 24$ each. Cash collections...
PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for...
PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for each of the first three months of operations are as follows: March $390,000 April 550,000 May 750,000 The company expects to sell 10% of its merchandise for cash. Of sales on account, 55% are expected to be collected in the month of the sale, 41% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,590 May 3,800 June 4,560 July 4,145 August 3,950 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.60 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
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%...
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%...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT