Question

In: Accounting

In the coming year, Oriole, Inc. will be introducing its first product, a wrist brace that...

In the coming year, Oriole, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $20 to retailers throughout the country. All sales will be made on account. An expected 75% of sales will be collected within the quarter of the sale, and another 20 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Budgeted sales units 25,200 41,000 52,600 86,000


Prepare Oriole, Inc.'s, cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

Sales Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual
Budgeted units sold
Budgeted sales price $ $ $ $ $
Budgeted sales revenue $ $ $ $ $
Cash Receipts Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Bad Debts
1st quarter sales $ $ $ $ $
2nd quarter sales
3rd quarter sales
4th quarter sales
Totals $ $ $ $ $


Determine the Net Accounts Receivable at the end of the year. Assume that no accounts have been written off during the year.

Net Accounts Receivable $

Solutions

Expert Solution


Prepare Oriole, Inc.'s, cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

Sales Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual
Budgeted units sold 25200 41000 52600 86000 204800
Budgeted sales price $20 $20 $20 $20 $20
Budgeted sales revenue $504000 $820000 $1052000 $1720000 $4096000
Cash Receipts Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Bad Debts
1st quarter sales $378000 $100800 $ $ $25200
2nd quarter sales 615000 164000 41000
3rd quarter sales 789000 210400 52600
4th quarter sales 1290000 86000
Totals $378000 $715800 $953000 $1500400 $204800


Determine the Net Accounts Receivable at the end of the year. Assume that no accounts have been written off during the year.

Net Accounts Receivable 1720000*20% $344000

Related Solutions

In the coming year, Urayse, Inc. will be introducing its first product, a wrist brace that...
In the coming year, Urayse, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $11.25 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget...
Exercise D5-21 In the coming year, Urayse, Inc. will be introducing its first product, a wrist...
Exercise D5-21 In the coming year, Urayse, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $11.25 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The...
Brace, Inc., a regular corporation, owns 90% of West common stock. This year, Brace generated $60,000...
Brace, Inc., a regular corporation, owns 90% of West common stock. This year, Brace generated $60,000 taxable income before the dividend received deduction, including $10,000 dividend income from West. Brace's taxable income after special deductions is: options: A) $53,000 B) $58,000 C) $52,000 D) $50,000
Corporation is preparing its budget for the coming year. The first step is to plan for...
Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price $12 Waterways wants...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 112,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 115,000 Expected unit sales for April 2020 124,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 114,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 111,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 125,000...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Waterways Corporation is preparing its budget for the coming year. The first step is to plan...
Waterways Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price $12 Waterways...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT