Question

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
  Budgeted unit sales 12,500       13,500       15,500       14,500      

The selling price of the company’s product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $73,200.

    The company expects to start the first quarter with 2,500 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,700 units.

Required:

           

1-b.

Complete the schedule of expected cash collections.

           

Jessi Corporation
Schedule of Expected Cash Collections
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Beginning accounts receivable $0
1st Quarter sales 0
2nd Quarter sales 0
3rd Quarter sales 0
4th Quarter sales 0
Total cash collections $0 $0 $0 $0 0
2.

Prepare the company’s production budget for the upcoming fiscal year.

Jessi Corporation
Production Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Budgeted unit sales
Total needs
Required production in units
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Required:

           

1-b.

Complete the schedule of expected cash collections.

           

Jessi Corporation
Schedule of Expected Cash Collections
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Beginning accounts receivable 73200 $73200
1st Quarter sales 225000 60000 285000
2nd Quarter sales 243000 64800 307800
3rd Quarter sales 279000 74400 353400
4th Quarter sales 261000 261000
Total cash collections $298200 $303000 $343800 $335400 1280400
2.

Prepare the company’s production budget for the upcoming fiscal year.

Jessi Corporation
Production Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Budgeted unit sales 12500 13500 15500 14500 56000
Add: Desired ending inventory 2700 3100 2900 2700 2700
Total needs 15200 16600 18400 17200 58700
Less: Beginning inventory -2500 -2700 -3100 -2900 -2500
Required production in units 12700 13900 15300 14300 56200
Add a comment
Know the answer?
Add Answer to:
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 2nd Quarter 3rd Quarter 15,400 4th Quarter 1st Quarter Budgeted unit sales 12,400 13,400 14,400 The selling price of the company's product is $23 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 13,000 2nd Quarter 14,000 3rd Quarter 16,000 4th Quarter 15,000 The selling price of the company's product is $29 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 12.200 2nd Quarter 13,200 3rd Quarter 15.200 4th Quarter 14,200 Budgeted unit sales The selling price sales are expected to be uncollectible. The beginning balance of accounts receivable, all The company expects to start the first quarter with 2,440 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 12,900 2nd Quarter 13,900 3rd Quarter 15,900 4th Quarter 14,900 Budgeted unit sales The selling price of the company's product is $28 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,400 12,400 14,400 13,400 The selling price of the company’s product is $13 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of fiscal year (all sales are on account) Jessi Corporation has submitted the...

    The marketing department of fiscal year (all sales are on account) Jessi Corporation has submitted the following sales forecast for the upcoming 1st Quarter 11,200 2nd Quarter 12,200 3rd Quarter 14,200 4th Quarter 13,200 Budgeted unit sales The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (a...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,800 13,800 15,800 14,800 The selling price of the company’s product is $27 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,300 13,300 1 5,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,800 12,800 14,800 13,800 The selling price of the company’s product is $17 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,200 12,200 14,200 13,200 The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT