forecast sales volume & sales budget

Forecast Sales Volume and Sales Budget For 20y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 2076, the following unit sates data were reported for the year: Unit Sales 12" X 16" 8" x 10" Frame Frame East 19,425 12,614 Central 4,532 2,646 West 3,936 1,836 Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Unit Unit Sales Selling Product and Area Volume Price Total Sales 8" x 10" Frame East 18,500 $27 Central 4,400 27 $499,500 118,800 110,700 West 4,100 27 Total 27,000 $729,000 12" X 16" Frame: East 11.900 $42 $499,900 113.400 Central 2,700 42 West 1,800 42 75,600 12" X 16" Frame: 42 West 42 East 11,900 $42 $499,800 Central 2,700 113,400 1,800 75,600 Total 16,400 $688,800 Total revenue from sales $1,417,800 For the year ending December 31, 2017, unt 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 $28 and the unit selling price for the 12" X 16" frame is expected to increase to $44, 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 Amount Percent 8" x 10" Frame: East 96 Central 96 West % 12" X 16" Frame: III III lll lll Dal III East 96 Central %6 West % 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: East % Central % West % 12" X 16" Frame: IN DIE CES MOM, DOO UI JUD East Central 5 % West ALLA 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 Increase Budgeted Units (Decrease) Units (rounded) 8" x 10" Frame: 2016 East % Central % West 12" X 16" Frame: III III bi III East 9 Central % 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 W0 Total 12" X 16" Frame: East Central West Total Total revenue from sales