Forecast Sales Volume and Sales Budget For 2048, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" X 10" 12" X 16" Frame Frame East 29,120 10,500 Central 7,446 4,018 West 6,499 3,366 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Volume Price 8" x 10" Frame: Total Sales East $24 Central 24 28,000 7,300 6,700 42,000 $672,000 175,200 160,800 $1,008,000 West 24 Total 12" X 16" Frame: East 10,000 $34 $340,000 Central 4,100 34 139,400 Total Central 4,100 34 139,400 West 3,300 34 112,200 17.400 5591,600 Total revenue from sales $1,599.000 For the year ending December 31, 2019. unt sales are expected to follow the patterns established during the year ending December 31, 2018. The unit selling price for the 10" frame is expected to increase $25 and the unseling price for the 12" 16" frame is expected to increase to $36, effective January 1, 2019 Required 1. Compute the increase or decrease of actual unitates for the year ended December 31, 2018, over budget. Use the minus sign to indicate decrease in amount and percent. Round percants to the nearest whole percent. Unit Sales, Increase (Decrease) Year Ended 2018 Actual Over Budget Budget Actual Sales Amount Percent 8 x 10" Frame Central West 12" X 16" Frame: East Central West lll 2. 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 Dec 31, 2019. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. 2018 Percentage 2019 2. Asuming that the increase or decrease in actual sales to budget indicated in part (t) is to continue in 2018, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31. 2019. Use the mission to indicate a decrease in percent Round budgeted units to the nearest whole unit 2018 Percentage 2019 Actual Increase Budgeted Units (Decrease) Units (rounded) *** 10 Frame: Central West 12 x 16 Frame East III III Central West All 3. Prepare a sales budget for the year ending December 3, 2019 Raphael Frame Company Sales Budget For the Year Ending December 31, 2019 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8 x 10 Frame: East Central West DO Total Ch. 22 Assignment eBook Filem West 12" 16" Frame East I III II II Central West N 3. Prepare a sales budget for the year ending December 31, 2009. Raphael Frame Company Sales Budget For the Year Ending December 31, 2019 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8*10* Frame Central West Total DUI. Qu 12" 16" Frame East Central West pini Dm Total Total revenue from sales
