At the end of December 2018, the following unit sales data were reported for the year: Unit Sales Unit Sales 8" x 10" 12" x 16" Frame Frame East 32,445 12,168 Central 8,282 4,312 West 7,372 3,570 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Sales Unit Selling Product and Area Volume Price Total Sales 8" x 10" Frame: East 31,500 $26 $819,000 Central 8,200 26 213,200 West 7,600 26 197,600 Total 47,300 $1,229,800 12" x 16" Frame: East 11,700 $36 $421,200 Central 4,400 36 158,400 West 3,500 36 126,000 Raphael Frame Company Sales Budget For the Year Ending December 31, 20 Unit Safes Unit Selling Product and Area 10 Frame Volume Price Total Sales 21,500 126 $819,000 Central 200 26 213,200 West 7,600 26 197,000 Total 47300 $1,229,000 1216" frame txil 11,700 536 1421,200 Central 4,400 36 158,400 3,500 126,000 Tikal 19,600 $705,600 $1,935,400 Jual revenue frim sales For the year ending December 31, 2019, unit sales are expected to follow the patterns established during the year ending December 31, 2018 The und selling price for the 10 bees expected to increase to 327 and the stselling price for the 12" 10ame is expected to messe te $38, effective January 20 Required: L. Compute the arse or decrease of actual una sales for the year ended December 31, 2018, over budget. Use the i Module 5 Exam percent. Usit Sales Year Ended JOY Budget The year ended December 14, 201, over banget. 058 04 mars sags to indicate a decrease in amount and percent. Round percents to the nearest whole Unit Sales, Year Ended 20 Actual Sales Increase (Decrease) Actual Over Increase (Decrease) Actual Over Budget Amount Budget Percent 10 Frame Ent Central West 1216 me East Central West 2. Assuming that the Use the mus up to 000 000 rese or decrease in actual sales to budget indicated in part (1) is to continue 2019, compute the unt sales volume to be used for preparing the sales budget for the year ending December 11, 2019 tole a decrease in percent Round budgeted units to the nearest whole unit. 2018 Actuali Units Percentage Increase (Decrease) 2019 Budgeted Units (rounded) Exome 2 Central DO 00 10 Fame tast Central West 1216 feme Eat Central West Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2019, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2019 Use the minus sign to widicate a decrease in percent Round budgeted units to the nearest whole unit. 2018 Actual Units Percentage Increase (Decrease) 2009 Budgeted Units (rounded) 100 000 3. Prepare a sales Budget for the year ending December 31, 2019 Raphael Frame Company Sales Budget For the Year Ending December 31, 20 Unit Unit Volume Selling Price Total Product and Ares Sales 000 000 000 3. Prepare a sales budget for the year ending December 31, 2019 Raphael Frame Company Sales Budget For the Year Ending December 31, 2019 Unit Sales Volume Unit Selling Price Product and Area 10 frame Central West Total 12-10 Frame East Central West Tutal Total revenue from sales 0000 000 000 00000 0000 FE