Forecast Sales Volume and Sales Budget 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" 12" x 16" Frame Frame 29,870 East 13,520 Central 7,878 5,498 West 7,008 4,738 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Total Sales Volume Price g"x 10" Frame: $27 East 29,000 $783,000 Central 7,800 27 210,600 Wiest 7.300 27 197,100 44,100 $1,190,700 Total 12" x 16" Frame: $364,000 East 13,000 $28 Central 156,800 5,600 29 West 4,600 28 128,800 $649,600 Total 23,200 $1,840,300 Total revenue from sales 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 B" x 10' frame is expected to increase to $28 and the unit selling price for the 12" x 16" frame is expected to increase to $30, effective January 1, 20Y9, Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, aver budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Increase (Decrease) Actual Over Budget Unit Sales, Year Ended 20Y8 Budget Actual Sales Amount Percent 8 x 10 Frame: Esst Central West 12" x 16" Frame: Esst 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, Percentage 20Y8 20Y9 Increase Actual Budgeted Units (rounded) Units (Decrease) g*x 10 Frame: East Central West 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 Sales Volume Unit Selling Price Total Sales Product and Aren 8x 10 Frame: Fast Central West Total 12 x 16" Frame: East Central West Total Total revenue from sales Q00 00 0odal oodld

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 1PA
icon
Related questions
icon
Concept explainers
Question

Forecast Sales Volume and Sales Budget

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:

 

Forecast Sales Volume and Sales Budget
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"
12" x 16"
Frame
Frame
29,870
East
13,520
Central
7,878
5,498
West
7,008
4,738
Raphael Frame Company
Sales Budget
For the Year Ending December 31, 20Y8
Unit
Unit Sales
Product and Area
Selling
Total Sales
Volume
Price
g"x 10" Frame:
$27
East
29,000
$783,000
Central
7,800
27
210,600
Wiest
7.300
27
197,100
44,100
$1,190,700
Total
12" x 16" Frame:
$364,000
East
13,000
$28
Central
156,800
5,600
29
West
4,600
28
128,800
$649,600
Total
23,200
$1,840,300
Total revenue from sales
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 B" x 10' frame is expected to increase to $28 and the unit selling price for the 12" x 16" frame is expected to increase to $30, effective January
1, 20Y9,
Required:
1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, aver budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent.
Increase (Decrease)
Actual Over Budget
Unit Sales,
Year Ended 20Y8
Budget
Actual Sales
Amount
Percent
8 x 10 Frame:
Esst
Central
West
12" x 16" Frame:
Esst
Central
West
Transcribed Image Text:Forecast Sales Volume and Sales Budget 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" 12" x 16" Frame Frame 29,870 East 13,520 Central 7,878 5,498 West 7,008 4,738 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Total Sales Volume Price g"x 10" Frame: $27 East 29,000 $783,000 Central 7,800 27 210,600 Wiest 7.300 27 197,100 44,100 $1,190,700 Total 12" x 16" Frame: $364,000 East 13,000 $28 Central 156,800 5,600 29 West 4,600 28 128,800 $649,600 Total 23,200 $1,840,300 Total revenue from sales 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 B" x 10' frame is expected to increase to $28 and the unit selling price for the 12" x 16" frame is expected to increase to $30, effective January 1, 20Y9, Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, aver budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Increase (Decrease) Actual Over Budget Unit Sales, Year Ended 20Y8 Budget Actual Sales Amount Percent 8 x 10 Frame: Esst Central West 12" x 16" Frame: Esst 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,
Percentage
20Y8
20Y9
Increase
Actual
Budgeted
Units (rounded)
Units
(Decrease)
g*x 10 Frame:
East
Central
West
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 Sales Volume
Unit Selling Price
Total Sales
Product and Aren
8x 10 Frame:
Fast
Central
West
Total
12 x 16" Frame:
East
Central
West
Total
Total revenue from sales
Q00 00
0odal oodld
Transcribed Image Text: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, Percentage 20Y8 20Y9 Increase Actual Budgeted Units (rounded) Units (Decrease) g*x 10 Frame: East Central West 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 Sales Volume Unit Selling Price Total Sales Product and Aren 8x 10 Frame: Fast Central West Total 12 x 16" Frame: East Central West Total Total revenue from sales Q00 00 0odal oodld
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College