Question

In: Accounting

Forecast Sales Volume and Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016:...

Forecast Sales Volume and Sales Budget

Guardian Framing Inc. prepared the following sales budget for 2016:

Guardian Framing Inc.
Sales Budget
For the Year Ending December 31, 2016
Product and Area Unit Sales
Volume
Unit Selling
Price
Total Sales
8" × 10" Frame:
East 18,800 $23 $432,400
Central 4,900 23 112,700
West 4,500 23 103,500
Total 28,200 $648,600
12" × 16" Frame:
East 12,500 $24 $300,000
Central 2,900 24 69,600
West 1,900 24 45,600
Total 17,300 $415,200
Total revenue from sales $1,063,800

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

Unit Sales
8" × 10" 12" × 16"
East 19,364 13,000
Central 4,949 2,842
West 4,320 1,938

For the year ending December 31, 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the 8" × 10" frame is expected to increase to $24 and the unit selling price for the 12" × 16" frame is expected to increase to $26, effective January 1, 2017.

Required:

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, 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 2016
Increase (Decrease)
Actual Over Budget
Budget Actual Sales Difference Percent
8" × 10" Frame:
East %
Central %
West %
12" × 16" Frame:
East %
Central %
West %

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

Solutions

Expert Solution

Answer 1.

Unit Sales Year Ended 2016 Increase (Decrease) Actual over Budget
Budget Actual Unit Percent
8" X 10" Frame:
East            18,800               19,364                         564 3%
Central               4,900                 4,949                           49 1%
West               4,500                 4,320                       (180) -4%
12" X 16" Frame:
East            12,500               13,000                         500 4%
Central               2,900                 2,842                         (58) -2%
West               1,900                 1,938                           38 2%
Answer 2.
2016 Actual Units Percentage Increase (Decrease) 2017 Budgeted Units (rounded)
8" X 10" Frame:
East            19,364 3%                   19,945
Central               4,949 1%                     4,998
West               4,320 -4%                     4,147
12" X 16" Frame:
East            13,000 4%                   13,520
Central               2,842 -2%                     2,785
West               1,938 2%                     1,977

Related Solutions

Guardian Framing Inc. prepared the following sales budget for 2016: Guardian Framing Inc. Sales Budget For...
Guardian Framing Inc. prepared the following sales budget for 2016: Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 18,800 $23 $432,400 Central 4,900 23 112,700 West 4,500 23 103,500 Total 28,200 $648,600 12" × 16" Frame: East 12,500 $24 $300,000 Central 2,900 24 69,600 West 1,900 24 45,600 Total 17,300 $415,200 Total revenue from sales $1,063,800 At the end of...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016:...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016: Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 8,500 $16 $136,000 Central 6,200 16 99,200 West 12,600 16 201,600     Total 27,300 $436,800 12" × 16" Frame: East 3,800 $30 $114,000 Central 3,000 30 90,000 West 5,400 30 162,000     Total 12,200 $366,000 Total revenue from...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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 21,012 12,064 Central 5,353 4,802 West 4,704 4,017 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...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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 23,278 14,456 Central 5,757 5,292 West 5,044 4,429 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...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 31,200 9,240 Central 7,956 3,626 West 6,984 3,090 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 26,355 9,010 Central 6,695 3,626 West 5,820 3,060 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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 19,261 13,936 Central 4,747 4,214 West 4,128 3,264 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...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 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...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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 26,460 14,840 Central 6,180 5,390 West 5,280 4,429 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...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that...
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 19,673 15,496 Central 5,050 4,508 West 4,416 3,468 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT