Question

GGC, Inc. is a business that manufactures and sells a single product, call a Diploma. Their fiscal year end is December 31.Before eloping to Las Vegas to get married by “Elvis” and, then moving to Tahiti, the former senior accountant spent tireless hours working on GGC, Inc.’s Master Budget. But, all we managed to find when cleaning out his office were some notes he was using … but no Master Budget. You’ve have now been hired on as the Senior Accountant, and your first job is to create a Master Budget using the previous accountant’s notes. Their sales forecast consisted of these few lines:For the year ended December 31, 2016: 475,000 units at $10.00 each*For the year ended December 31, 2017: 500,000 units at $10.00 each. For the year ended December 31, 2018: 500,000 units at $10.00 each*Expected sales for the year ended December 31, 2016 are based on actual sales to date and budgeted sales for the duration of the year.1.Peak months for sales correspond with gift-giving holidays. History shows that January, March, May and June are the slowest months with only 1% of sales for each month. Sales pick up over the summer with July, August and September each contributing 2% to the total. Valentines Day in February boosts sales to 5%, and Easter in April accounts for 10%. As Christmas shopping picks up momentum, winter sales start at 15% in October, move to 20% in November and then peak at 40% in December. This pattern of sales is not expected to change in the next two years.

Answer 1

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Sales Budget for Year 2016
		January	February	March	April	May	June	July	August	September	October	November	December	Year
%		1%	5%	1%	10%	1%	1%	2%	2%	2%	15%	20%	40%
Budgeted Units		4,750	23,750	4,750	47,500	4,750	4,750	9,500	9,500	9,500	71,250	95,000	190,000	475,000
Selling price per unit		$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10
Total Budgeted Sale		$         47,500	$       237,500	$         47,500	$       475,000	$         47,500	$         47,500	$         95,000	$         95,000	$         95,000	$       712,500	$       950,000	$   1,900,000	$   4,750,000
Sales Budget for Year 2017
		January	February	March	April	May	June	July	August	September	October	November	December	Year
%		1%	5%	1%	10%	1%	1%	2%	2%	2%	15%	20%	40%
Budgeted Units		5,000	25,000	5,000	50,000	5,000	5,000	10,000	10,000	10,000	75,000	100,000	200,000	500,000
Selling price per unit		$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10
Total Budgeted Sale		$         50,000	$       250,000	$         50,000	$       500,000	$         50,000	$         50,000	$       100,000	$       100,000	$       100,000	$       750,000	$   1,000,000	$   2,000,000	$   5,000,000
Sales Budget for Year 2018
		January	February	March	April	May	June	July	August	September	October	November	December	Year
%		1%	5%	1%	10%	1%	1%	2%	2%	2%	15%	20%	40%
Budgeted Units		5,000	25,000	5,000	50,000	5,000	5,000	10,000	10,000	10,000	75,000	100,000	200,000	500,000
Selling price per unit		$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10	$                  10
Total Budgeted Sale		$         50,000	$       250,000	$         50,000	$       500,000	$         50,000	$         50,000	$       100,000	$       100,000	$       100,000	$       750,000	$   1,000,000	$   2,000,000	$   5,000,000