Question
Forecast sales volume and sales budget For 2018, Raphael Frame Company prepared the sales budget that follows. At the end of December 2018, the
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 8" x 10" Unit Sales 12" x 16" Frame Frame East 25,584 15,750 Central 6,528 6,370 West 5,723 5,406 Raphael Frame Company Sales Budget For the Year Ending December 31, 20YS Unit Sales Unit Selling Product and Area Volume Price Total Sales 8" x 10" Frame: East 24,600 $35 $861,000 Central 6,400 35 224,000 West 5,900 35 206,500 Total 36,900 $1,291,500 12" x 16" Frame: East 15,000 Central 6,500 45 West 5,300 45 $45 $675,000 292,500 238,500 Total Total revenue from sales 26,800 $1,206,000 $2,497,500 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 2018. The unit selling price for the 8" x 10" frame is expected to increase to $36 and the unit selling price for the 12" x 16" frame is expected to increase to $47, effective January 1, 2019. Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2018, 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 20Y8 Budget Unit Sales, Year Ended 20Y8 Actual Sales 8" x 10" Frame: Actual Over Increase (Decrease) Actual Over Budget Amount Budget Percent East Central West 12" x 16" Frame: East Central West 111 110 % % % % % % 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 December 31, 2019. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. 20Y8 Actual Units Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded) 8" x 10" Frame: East Central West 12" x 16" Frame: East Central West 100 000 % % % % % % 000 000 12" x 16" Frame: East Central West 3. Prepare a sales budget for the year ending December 31, 20Y9. Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y9 Unit Unit Sales Selling Volume Price Product and Area Total Sales 8" x 10" Frame: East Central West Total 12" x 16" Frame: East Central West Total Total revenue from sales 000 000 Q % % %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started