22) Unit Sales 8" x 10" Frame 12" X 16" 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 8" x 10" Frame: Total Sales East 21,600 $17 17 $367,200 98,600 Central 5,800 West 5,400 17 91,800 Total 32,800 $557,600 12" X 16" Frame: East 8,700 $18 $156,600 Central 2,900 18 52,200 West 2,200 18 39,600 Total 13,800 $248,400 Total revenue from sales $806,000 me Remaining: 1:44:01 On DOD Total revenue from sales $806,000 For the year ending December 31, 2017, unit sales are expected to follow the patterns established during the year ending December 31, 206. The unit selling price for the 8" x 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 cales for the year ended December 31, 2076, ever 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 2046 Actual Over Budget Budget Actual Sales Amount Percent 8" x 10" Frame: East Central West 12" X 16" Frame: III III 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: East 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" 10" Frame: East Central West 12" X 16" Frame: East Central III II 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 Total Sales 8" x 10" Frame: East Central West Total
