Question

In: Accounting

ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...

ZZ, Inc. has budgeted sales in units for the next six months as follows:

                  Budgeted Sales in Units
July                    7,700 units                             
August                  8,300 units
September               5,400 units
October                10,200 units
November               ?????? units
December               11,700 units

The selling price is $18 per unit. 30% of the company's sales are cash
sales and 70% of the company's sales are made on account. The sales on
account are collected in the pattern 15% in the month of sale, 20% in
the month following sale, 55% in the second month following sale, and
the final 10% is collected in the third month following sale.

ZZ, Inc. reported a budgeted accounts receivable balance of $194,670
in its pro forma balance sheet at December 31.

Calculate the number of units budgeted to be sold in November. Do not
type the word units after your answer.

Solutions

Expert Solution

Accounts receivable balance 194670
Less: October sales uncollected 12852 =10200*18*70%*10%
Less: December sales uncollected 125307 =11700*18*70%*85%
November sales uncollected 56511
Percentage of November sales uncollected 65% =55%+10%
Credit sales fo November 86940 =56511/65%
Total sales for November 124200 =86940/70%
Number of units budgeted to be sold in November 6900 =124200/18

Related Solutions

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 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 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 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 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%...
The budgeted sales in units for the next four months as follows: July 7,200 units August...
The budgeted sales in units for the next four months as follows: July 7,200 units August 5,400 units September 6,800 units October 7,000 units 1. Prepare the sales budget for the third quarter of the company knowing that each unit is sold for $40. (1.5pt) 2. Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory in the beginning of July was only 600 units....
Company budgeted sales in units for the next four months as follows: July 7,000 units August...
Company budgeted sales in units for the next four months as follows: July 7,000 units August 5,000 units September 6,500 units 1. Prepare the sales budget for the company knowing that each unit is sold for $50. (1 pt) 2. Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory in the beginning of July was only 1,000 units, & the inventory on September 30...
Walnut has forecast sales for the next three months as follows: July 4,700 units, August 6,900...
Walnut has forecast sales for the next three months as follows: July 4,700 units, August 6,900 units, September 8,000 units. Walnut's policy is to have an ending inventory of 50% of the next month's sales needs on hand. July 1 inventory is projected to be 2,100 units. Selling and administrative costs are budgeted to be $16,000 per month plus $14 per unit sold. What are budgeted selling and administrative expenses for July? $143,500 $77,300 $84,700 $81,800
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 $18,000 $ 95,000 February $15,000 $130,000 March $24,000 $ 70,000 April $26,000 $120,000 May $19,000 $ 90,000 June $14,000 $100,000 On average, 45% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 15% are collected in the second month following sale, and the remaining 10% is collected three...
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 $110,000 February $18,000 $125,000 March $26,000 $119,000 April $24,000 $140,000 May $14,000 $ 88,000 June $18,000 $137,000 On average, 25% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 35% are collected in the second month following sale, and the remaining 10% is collected three months after...
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...
Milford Company has the following sales projection (in units) for the next six months: Feb: 2100...
Milford Company has the following sales projection (in units) for the next six months: Feb: 2100 Mar: 2300 Apr: 1900 May: 2600 Jun: 2200 Jul: 1700 Each unit sells for $37 through April and $42 starting in May. Milford has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 1900 2600 2200 6700 Selling price per unit x $37 x $42 x $42 Sales revenue $70300 $109200...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 9000...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 9000 Mar: 10500 Apr: 8000 May: 11500 Jun: 9500 Jul: 7000 Each unit sells for $30. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 8000 11500 9500 29000 Selling price per unit x $30 x $30 x $30 Sales revenue $240000 $345000 $285000 $870000 Spelling's cost of goods sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT