Forecast Sales Volume and Sales Budget For 2018, Raphael Frame Company prepared the sales budget that follows At the end of December 2018, the following unit sales data were reported for the year Unit Sales *** 10" 12" 16" Frame Frame East 23,999 8,840 Central 5,85 1.960 5.14 1,339 Raphael Frame Company Sales Budget For the Year Ending December 31, 2018 Unit Unit Sales Product and Area Volume Selling Total Sales Price 10 Frame: 23,300 $25 $582,500 Central 5,800 25 145,000 West 5,400 25 135,000 TORNI 34,500 $63.500 1214Prame 6.500 $40 $10,000 Gente 2.000 40 30,000 West 1.300 40 17,000 Tuta 11.300 1472.000 Total revenue from sales $1,3.500 the vending December 1, 2010, una respected to follow the stems what curing the year wy December 3, 20. The inteligence for the expected to 10 wwing for the 116' frame is it to increase to 142, uffective Manuary 1, 20 Red 1. Compute the more of actual units to the yew writes December 31, 207, vert, we the minus on toder in amount and percent. Mund perces to the nearest whole percent For the year ending December 31, 2009, unit sales are expected to follow the patterns established during the year ending December 31, 2018. The unitseling price for the Foreis expected to increase to 125 and the unit selling price for the 12" 16" frame is expected to increase to 342, effective January 1, 2009 Required: 1. Compute the increase or decreme of actual unit sales for the year ended December 31, 2018, over budget. Use the minus sign to indicate decrease in amount and percent. Round percent to the arrest whole percent Unit Sales Increase (Decrease) Year Ended 2018 Actual Over Budget Budget Actual Sales Amount Percent 8' 10" Frame: East Central 12" 16" Frame: III 001 2018 Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) # to continue in 2019, compute the unt sales volume to be used for preparing the sales budget for the year ending December 2016 Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. Percentage 2049 Actual Increase Budgeted Units (Decrease) Units (rounded) 8 x 10 Frame: East % Central West 12 x 16 Frame: East Central III 3. Prepare a sales budget for the year ending December 31, 2019 cal sales to budget indicated in part() is to come in 2019, compute the volume to be ved for grantes budget for the year in December 2015 Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. 2018 Percentage 2015 Actual Increase Budgeted Units (Decrease) Units (rounded) 8' x 10 Frame: Central West 12" X 16" Frame: East III III Central lll West 3. Prepare a sales budget for the year ending December 31, 2010. Raphael Frame Company Sales Budget For the Year Ending December 31, 2019 Product and Area Unit Sales Volume Unit Selling Price Total Sales x 10" Frame: East Centras West Total 12" 16" Frame: East Central Total Total revenue from sales home