In: Accounting
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.
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 |