Question

In: Accounting

For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December...

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" × 10" Frame 12" × 16" Frame
East 26,565 15,688
Central 7,004 3,528
West 6,048 2,448
Raphael Frame Company
Sales Budget
For the Year Ending December 31, 20Y8
Product and Area Unit Sales
Volume
Unit Selling
Price
Total Sales
8" × 10" Frame:
East 25,300 $29 $733,700
Central 6,800 29 197,200
West 6,300 29 182,700
    Total 38,400 $1,113,600
12" × 16" Frame:
East 14,800 $30 $444,000
Central 3,600 30 108,000
West 2,400 30 72,000
    Total 20,800 $624,000
Total revenue from sales $1,737,600

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" × 10" frame is expected to increase to $30 and the unit selling price for the 12" × 16" frame is expected to increase to $32, effective January 1, 20Y9.

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,
Year Ended 20Y8
Increase (Decrease)
Actual Over Budget
Budget Actual Sales Amount Percent
8" × 10" Frame:
East %
Central %
West %
12" × 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.

20Y8
Actual
Units
Percentage
Increase
(Decrease)
20Y9
Budgeted
Units (rounded)
8" × 10" Frame:
East %
Central %
West %
12" × 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
Product and Area Unit Sales Volume Unit Selling Price Total Sales
8" × 10" Frame:
East $ $
Central
West
Total $
12" × 16" Frame:
East $ $
Central
West
Total $
Total revenue from sales $

Solutions

Expert Solution

Answer -

1. Answer -

Units sales, Year ended 20Y8 Increase (Decrease) Actual over budget
Budget Actual sales Amount Percent
8" * 10" Frame:
East 25,300 26,565 1,265 5%
Central 6,800 7,004 204 3%
West 6,300 6,048 -252 -4%
12" * 16" Frame:
East 14,800 15,688 888 6%
Central 3,600 3,528 -72 -2%
West 2,400 2,448 48 2%

Calculation:

8" * 10" Frame:

East:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 26,565 - 25,300

= 1,265

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(26,565 - 25,300) / 25,300] * 100

= 5%

Central:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 7,004 - 6,800

= 214

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(7,004 - 6,800) / 6,800] * 100

= 3%

West:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 6,048 - 6,300

= -252

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(6,048 - 6,300) / 6,300] * 100

= -4%

12" * 16" Frame:

East:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 15,688 - 14,800

= 888

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(15,688 - 14,800) / 14,800] * 100

= 6%

Central:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 3,528 - 3,600

= -72

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(3,528 - 3,600) / 3,600] * 100

= -2%

West:

Increase (Decrease) actual over budget (amount) = Actual units sales - Budgeted units sales

= 2,448 - 2,400

= 48

Increase (Decrease) actual over budget (Percent) = [(Actual units sales - Budgeted units sales) / Budgeted units sales] * 100

= [(2,448 - 2,400) / 2,400] * 100

= 2%

2. Answer -

20Y8 Actual units Percentage increase (decrease) 20Y9 Budgeted units (rounded)
8" * 10" Frame:
East 26,565 5% 27,893
Central 7,004 3% 7,214
West 6,048 -4% 5,806
12" * 16" Frame:
East 15,688 6% 16,629
Central 3,528 -2% 3,457
West 2,448 2% 2,497

Calculation:

8" * 10" Frame:

East:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 26,565 + [26,565 * 5%]

= 27,893

Central:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 7,004 + [7,004 * 3%]

= 7,214

West:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 6,048 + [6,048 * -4%]

= 5,806

12" * 16" Frame:

East:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 15,688 + [15,688 * 6%]

= 16,629

Central:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 3,528 + [3,528 * -2%]

= 3,457

West:

20Y9 Budgeted units (rounded) = 20Y8 Actual units + [20Y8 Actual units * Percentage increase (decrease)]

= 2,448 + [2,448 * 2%]

= 2,497

3. Answer -

Raphael Frame Company
Sales Budget
For the Year Ending December 31, 20Y9
Product and Area Unit sales volume Unit selling price Total sales
8" * 10" Frame:
East 27,893 $30 $836,790
Central 7,214 $30 $216,420
West 5,806 $30 $174,180
Total $1,227,390
12" * 16" Frame:
East 16,629 $32 $532,128
Central 3,457 $32 $110,624
West 2,497 $32 $79,904
Total $722,656
Total revenue from sales $1,950,046

Calculation:

8" * 10" Frame:

East:

Sales = Unit sales volume * Unit selling price

= 27,893 * $30 per unit

= $836,790

Central:

Sales = Unit sales volume * Unit selling price

= 7,214 * $30 per unit

= $216,420

West:

Sales = Unit sales volume * Unit selling price

= 5,806 * $30 per unit

= $174,180

Total = East sales + Central sales + West Sales

= $836,790 + $216,420 + $174,180

= $1,227,390

12" * 16" Frame:

East:

Sales = Unit sales volume * Unit selling price

= 16,629 * $32 per unit

= $532,128

Central:

Sales = Unit sales volume * Unit selling price

= 3,457 * $32 per unit

= $110,624

West:

Sales = Unit sales volume * Unit selling price

= 2,497 * $32 per unit

= $79,904

Total = East sales + Central sales + West Sales

= $532,128 + $110,624 + $79,904

= $722,656

Total revenue from sales = $1,227,390 + $722,656

= $1,950,046


Related Solutions

For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December...
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" × 10" Frame 12" × 16" Frame East 21,216 11,025 Central 4,998 3,332 West 4,320 2,575 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 20,400 $16 $326,400 Central 4,900 16...
For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December...
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" × 10" Frame 12" × 16" Frame East 22,660 15,496 Central 5,959 6,272 West 5,280 5,356 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 22,000 $28 $616,000 Central 5,900 28...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 21,012 12,064 Central 5,353 4,802 West 4,704 4,017 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 23,278 14,456 Central 5,757 5,292 West 5,044 4,429 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 19,261 13,936 Central 4,747 4,214 West 4,128 3,264 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 26,460 14,840 Central 6,180 5,390 West 5,280 4,429 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 22,365 15,052 Central 5,253 3,626 West 4,512 2,678 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 30,385 11,960 Central 7,474 4,704 West 6,596 4,017 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget that...
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" × 10" Frame 12" × 16" Frame East 22,365 15,052 Central 5,253 3,626 West 4,512 2,678 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT