Question

ABC Company’s actual unit sales in the current year for January, February, and March was 15,400, 12,400, and 18,400 units, respectively. Current year selling price is $100. An analysis of general economic trends and specific initiatives at ABC forecasts increases for the coming budget year: sales volume by 10% and sales price by 5%.

Prepare ABC Company’s budgeted unit sales and total sales volume for the first quarter of the coming year.

ABC Company's actual unit sales in the current year for January, February, and March was 15,400, 12,400, and 18,400 units, respectively. Current year selling price is $100. An analysis of general economic trends and specific initiatives at ABC forecasts increases for the coming budget year: sales volume by 10% and sales price by 5%. Required: Prepare ABC Company's budgeted unit sales and total sales volume for the first quarter of the coming year. 8 01:11:53 Total January 15,400 101% February 12,400 10% March 18,400 10% 462,000 eBook ſ 30% Current sales (units) Budgeted volume increase Budgeted sales (units) Budgeted selling price Budgeted total sales | $ 0 $ 0 % 0 % 0

Answer 1

Correct Answer:

		January	Febuary	march	total
A	Current sales (units)	$        15,400.00	$        12,400.00	$        18,400.00	$        46,200.00
B	Budgeted volume increase	10%	10%	10%	10%
C =A*B	Budgeted sales (units)	$        16,940.00	$        13,640.00	$        20,240.00	$        50,820.00
D	Budgeted selling price	$              105.00	$              105.00	$              105.00	$              105.00
E =C*D	Budgeted total sales	$ 1,778,700.00	$ 1,432,200.00	$ 2,125,200.00	$ 5,336,100.00

End of answer.

Please give a thumbs-up, it will be highly appreciated.

Thanks.