Unit Sales B" 10" 12" X 16" Frame Frame East 22,464 9,135 Central 5,916 2,842 West 5,184 2,244 Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Unit Unit Sales Product and Area Selling Volume Price Total Sales 8" x 10" Frame: East 21,600 $12 $367,200 17 98,600 Central West 5,800 5,400 32,800 17 91,800 Total $557,600 12" x 16 Frame: East $18 $156,600 Central 18 8,700 2,900 2,200 13,800 52,200 39,600 West 18 Total $248,400 $806,000 Total revenue from sales Previous Nex For the year ending December 31, 2087, unit sales are expected to follow the patterns established during the year ending December 31, 2006. The unit selling price for the 8" 10" frame is expected to increase to $18 and the unit selling price for the 12" * 16" frame is expected to increase to $20, effective January 1, 2017 Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2076, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Unit Sales, Increase (Decrease) Year Ended 2016 Actual Over Budget Budget Actual Sales Percent Amount 8" x 10" Frame: Central West 12" X 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. 2016 Percentage 2017 Actual Increase Budgeted Units (Decrease) Units (rounded) 8 x 10" Frame: 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, Percentage 2017 Actual Budgeted Units (Decrease) Units (rounded) 8" x 10" Frame: 2016 Increase East Central West 12" X 16" Frame: East Central 10 III West 3. Prepare a sales budget for the year ending December 31, 2017 Raphael Frame Company Sales Budget For the Year Ending December 31, 2017 Product and Area Unit Sales Volume Unit Selling Price 8" x 10" Frame: Total Sales Central West Total