Forecast Sales Volume and Sales Budget Guardian Framing Inc

Forecast Sales Volume and Sales Budget

Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2016 Unit Unit Sales Product and Area Selling Total Sales Price 8 x 10 Frame: 19,000 4,600 4,200 27,800 $35 35 35 665,000 161,000 147,000 $973,000 Total 12 x 16\" Frame: 13,500 5,700 4,600 23,800 $45 607,500 256,500 207,000 $1,071,000 $2,044,000 45 West 45 Total Total revenue from sales At the end of December 2016, the folowing unit sales data were reported for the year Unit Sales 8\" x 10\" 12\" × 16\' 19,950 4,738 4,032 14,310 5,586 4,738 East Central

Solution

Solution 1:

Solution 2:

Solution 3:

	Unit Sales year ended 2016	Increase (Decrease) Actual over budget
	Budget	Actual sales	Difference	Percent
8* x 10* Frame:
East	19000	19950	950	5%
Central	4600	4738	138	3%
West	4200	4032	-168	-4%
12* x 16* Frame:
East	13500	14310	810	6%
Central	5700	5586	-114	-2%
West	4600	4738	138	3%