Question

1.   Tara’s Treasures is preparing her Budget for 2020 and has ESTIMATED the following data:

SALES:  Sales for 2020 are projected to be 4,300,000 units with 20% in Quarter 1, 35% in Quarter 2, 15% in Quarter 3 and 30% in the 4^th Quarter.  

The Sales Price will be $50 in the 1^st 2 Quarters and $55 in the 4^th Quarter.. Sales in 2021 are expected to be 10% higher than the 1^st Quarter of 2020.

This is all I was given please answer the best you can.

Required:         Prepare the Sales  Budget by Quarter for 2020  

Answer 1

Sales  Budget by Quarter for 2020
	Q1	Q2	Q3	Q4
% of sales	20%	35%	15%	30%
Unit Sales( 4,300,000 x % of sales)	860,000	1,505,000	645,000	1,290,000
Selling price per unit	$50	$50	$55	$55
Sales revenue (Unit Sales x Selling price per unit)	$43,000,000	$75,250,000	$35,475,000	$70,950,000

Kindly comment if you need further assistance. Thanks