eBook

Print Item

Question Content Area

Forecast Sales Volume and Sales Budget

For 20Y8, Raphael Frame Company prepared the sales budget that follows.

At the end of December 20Y8, the following unit sales data were reported for the year:

	Unit Sales
	8" 10" Frame		12" 16" Frame
East	25,792		12,075
Central	6,120		2,450
West	5,335		1,648

Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8
Product and Area		Unit Sales Volume		Unit Selling Price		Total Sales
8" 10" Frame:
East		24,800		$30		$744,000
Central		6,000		30		180,000
West		5,500		30		165,000
Total		36,300				$1,089,000
12" 16" Frame:
East		11,500		$45		$517,500
Central		2,500		45		112,500
West		1,600		45		72,000
Total		15,600				$702,000
Total revenue from sales						$1,791,000

For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" frame is expected to increase to $31 and the unit selling price for the 12" 16" frame is expected to increase to $47, effective January 1, 20Y9.

Required:

Question Content Area

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent.

		Unit Sales, Year Ended 20Y8				Increase (Decrease) Actual Over Budget
		Budget		Actual Sales		Amount	Percent
8" 10" Frame:
	East	fill in the blank 21df3109904afdf_1		fill in the blank 21df3109904afdf_2		fill in the blank 21df3109904afdf_3	fill in the blank 21df3109904afdf_4 %
	Central	fill in the blank 21df3109904afdf_5		fill in the blank 21df3109904afdf_6		fill in the blank 21df3109904afdf_7	fill in the blank 21df3109904afdf_8 %
	West	fill in the blank 21df3109904afdf_9		fill in the blank 21df3109904afdf_10		fill in the blank 21df3109904afdf_11	fill in the blank 21df3109904afdf_12 %
12" 16" Frame:
	East	fill in the blank 21df3109904afdf_13		fill in the blank 21df3109904afdf_14		fill in the blank 21df3109904afdf_15	fill in the blank 21df3109904afdf_16 %
	Central	fill in the blank 21df3109904afdf_17		fill in the blank 21df3109904afdf_18		fill in the blank 21df3109904afdf_19	fill in the blank 21df3109904afdf_20 %
	West	fill in the blank 21df3109904afdf_21		fill in the blank 21df3109904afdf_22		fill in the blank 21df3109904afdf_23	fill in the blank 21df3109904afdf_24 %

2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit.

		20Y8 Actual Units		Percentage Increase (Decrease)	20Y9 Budgeted Units (rounded)
8" 10" Frame:
	East	fill in the blank 21df3109904afdf_25		fill in the blank 21df3109904afdf_26 %	fill in the blank 21df3109904afdf_27
	Central	fill in the blank 21df3109904afdf_28		fill in the blank 21df3109904afdf_29 %	fill in the blank 21df3109904afdf_30
	West	fill in the blank 21df3109904afdf_31		fill in the blank 21df3109904afdf_32 %	fill in the blank 21df3109904afdf_33
12" 16" Frame:
	East	fill in the blank 21df3109904afdf_34		fill in the blank 21df3109904afdf_35 %	fill in the blank 21df3109904afdf_36
	Central	fill in the blank 21df3109904afdf_37		fill in the blank 21df3109904afdf_38 %	fill in the blank 21df3109904afdf_39
	West	fill in the blank 21df3109904afdf_40		fill in the blank 21df3109904afdf_41 %	fill in the blank 21df3109904afdf_42

Question Content Area

3. Prepare a sales budget for the year ending December 31, 20Y9.

Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y9

Product and Area	Unit Sales Volume	Unit Selling Price	Total Sales
8" 10" Frame:
East	fill in the blank 0d5c6909a05e07b_1	$fill in the blank 0d5c6909a05e07b_2	$fill in the blank 0d5c6909a05e07b_3
Central	fill in the blank 0d5c6909a05e07b_4	fill in the blank 0d5c6909a05e07b_5	fill in the blank 0d5c6909a05e07b_6
West	fill in the blank 0d5c6909a05e07b_7	fill in the blank 0d5c6909a05e07b_8	fill in the blank 0d5c6909a05e07b_9
Total	fill in the blank 0d5c6909a05e07b_10		$fill in the blank 0d5c6909a05e07b_11
12" 16" Frame:
East	fill in the blank 0d5c6909a05e07b_12	$fill in the blank 0d5c6909a05e07b_13	$fill in the blank 0d5c6909a05e07b_14
Central	fill in the blank 0d5c6909a05e07b_15	fill in the blank 0d5c6909a05e07b_16	fill in the blank 0d5c6909a05e07b_17
West	fill in the blank 0d5c6909a05e07b_18	fill in the blank 0d5c6909a05e07b_19	fill in the blank 0d5c6909a05e07b_20
Total	fill in the blank 0d5c6909a05e07b_21		$fill in the blank 0d5c6909a05e07b_22
Total revenue from sales			$fill in the blank 0d5c6909a05e07b_23