For 20Y8, 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" Frame 12" x 16" Frame East 30,660 14,522 Central 8,137 4,606 West 7,081 3,672 -   Raphael Frame Co. Sales Budget For the Year Ending December 31, 20Y8       Product and Area   Unit Sales Volume Unit Sales Price Total Sales 8" x 10" Frame:              East   29,200 $26 $759,200      Central   7,900 26 205,400      West   7,300 26 189,800           Total   44,400   $1,154,400           12" x 16" Frame              East   13,700 $27 $369,900      Central   4,700 27 126,900      West   3,600 27 97,200           Total   22,000   $594,000 Total Revenue from sales       $1,748,800 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8"x10" frame is expected to increase to $27 and the unit selling price for the 12"x16" frame is expected to increase to $29, effective January 1, 20Y9. Please see the pictures for the prompts. Theres 3 parts. Thank you!

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 33E: A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent...
icon
Related questions
Question

For 20Y8, 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" Frame 12" x 16" Frame
East 30,660 14,522
Central 8,137 4,606
West 7,081 3,672

-

  Raphael Frame Co.
Sales Budget
For the Year Ending December 31, 20Y8
     
Product and Area   Unit Sales Volume Unit Sales Price Total Sales
8" x 10" Frame:        
     East   29,200 $26 $759,200
     Central   7,900 26 205,400
     West   7,300 26 189,800
          Total   44,400   $1,154,400
         
12" x 16" Frame        
     East   13,700 $27 $369,900
     Central   4,700 27 126,900
     West   3,600 27 97,200
          Total   22,000   $594,000
Total Revenue from sales       $1,748,800

For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8"x10" frame is expected to increase to $27 and the unit selling price for the 12"x16" frame is expected to increase to $29, effective January 1, 20Y9.

Please see the pictures for the prompts. Theres 3 parts. Thank you!

Required:
1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, 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
Actual Over Budget
Budget
Actual Sales
Amount
Percent
8" x 10" Frame:
East
%
Central
%
West
%
12" x 16" Frame:
East
%
Central
%
West
2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending
December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit.
20Υ8
Percentage
20Υ9
Actual
Increase
Budgeted
Units
(Decrease)
Units (rounded)
8" x 10" Frame:
East
%
Central
%
West
%
12" x 16" Frame:
East
%
Central
%
West
%
II I|
II II
II II
Transcribed Image Text:Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, 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 Actual Over Budget Budget Actual Sales Amount Percent 8" x 10" Frame: East % Central % West % 12" x 16" Frame: East % Central % West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. 20Υ8 Percentage 20Υ9 Actual Increase Budgeted Units (Decrease) Units (rounded) 8" x 10" Frame: East % Central % West % 12" x 16" Frame: East % Central % West % II I| II II II II
3. Prepare a sales budget for the year ending December 31, 20Y9.
Raphael Frame Company
Sales Budget
For the Year Ending December 31, 20Y9
Product and Area
Unit Sales Volume
Unit Selling Price
Total Sales
8" x 10" Frame:
East
$
Central
West
Total
12" x 16" Frame:
East
Central
West
Total
Total revenue from sales
Transcribed Image Text:3. Prepare a sales budget for the year ending December 31, 20Y9. Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y9 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" x 10" Frame: East $ Central West Total 12" x 16" Frame: East Central West Total Total revenue from sales
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning