close solutoin list

Forecast sales volume and sales budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, 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, 20Y6 Unit Sales Unit Selling Total Product and Area Volume Price Sales 8" × 10" Frame: East 8,500 $16 $136,000 Central 6,200 16 99,200 West 12,600 16 201,600 Total 27,300 $436,800 12" x 16" Frame: East 3,800 $30 5114,000 Central 3,000 30 90,000 West 5,400 30 162,000 Total 12,200 $366,000 Total revenue from sales $802,800 For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for the 8" ×10"frame is expected to increase to $17, and the unit selling price for the 12" ×16" frame is expected to increase to $32, effective January 1, 20Y7. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y6 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 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y6 Percentage 20Y7 Actual Increase Budgeted Units (Decrease! Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y7.

BuyFind

Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094
BuyFind

Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094

Solutions

Chapter
Section
Chapter 22, Problem 22.1APR
Textbook Problem

Forecast sales volume and sales budget

 For 20Y6, Raphael Frame Company prepared the sales budget that follows.

 At the end of December 20Y6, 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, 20Y6
  Unit Sales Unit Selling Total
Product and Area Volume Price Sales
8"×10" Frame:      
East  8,500 $16 $136,000
Central 6,200 16 99,200
West 12,600 16 201,600
Total 27,300   $436,800
12" x 16" Frame:      
East 3,800 $30 5114,000
Central 3,000 30 90,000
West 5,400 30 162,000
Total 12,200   $366,000
Total revenue from sales     $802,800

  For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for the 8" ×10"frame is expected to increase to $17, and the unit selling price for the 12" ×16" frame is expected to increase to $32, effective January 1, 20Y7.

  Instructions

  1. 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Place your answers in a columnar table with the following format:
  Unit Sales, Year Ended 20Y6 Increase (Decrease) Actual Over Budget
  Budget Actual Sales Amount Percent
8" ×10" Frame:    
East    
Central    
West    
12"×16" Frame:    
East    
Central    
West    
  1. 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit.
20Y6 Percentage 20Y7
Actual Increase Budgeted
Units (Decrease! Units (rounded)
  1. 3. Prepare a sales budget for the year ending December 31, 20Y7.

Expert Solution

1.

To determine

Budgeting is a process to prepare the financial statement by the manager to estimate the organization’s future actions. It is also helpful to satisfy the everyday activities.

To Compute: The increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget.

Explanation of Solution

The following table shows the increase or decrease of actual unit sales.

Details Unit sales, Year Ended 20Y6 Increase (Decrease) Actual Over Budget
Budget Actual Amount ($) Percent (%)
(A) (B) (C) = (B) – (A) (D) = (C)/(A) × 100
8” × 10” Frame:
      East
Expert Solution

2.

To determine

To Compute: The unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7.

Expert Solution

3.

To determine

To Prepare: The sales budget for the year ending December 31, 20Y7.

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Chapter 22 Solutions

Accounting
Show all chapter solutions
Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Production budget Daybook Inc. projected sales of...Ch. 22 - Production budget Magnolia Candle Inc. projected...Ch. 22 - Direct materials purchases budget Daybook Inc....Ch. 22 - Direct materials purchases budget Magnolia Candle...Ch. 22 - Direct labor cost budget Daybook Inc. budgeted...Ch. 22 - Direct labor cost budget Magnolia Candle Inc....Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cash budget Daybook Inc. collects 30% of its sales...Ch. 22 - Cash budget Magnolia Candle Inc. pays 10% of its...Ch. 22 - Personal budget At the beginning of the school...Ch. 22 - Flexible budget for selling and administrative...Ch. 22 - Static budget versus flexible budget The...Ch. 22 - Flexible budget for Assembly Department Steelcase...Ch. 22 - Production budget Weightless Inc. produces a small...Ch. 22 - Sales and production budgets Sonic Inc....Ch. 22 - Professional fees earned budget for a service...Ch. 22 - Professional labor cost budget for a service...Ch. 22 - Direct materials purchases budget Lorenzo's Frozen...Ch. 22 - Direct materials purchases budget Coca-Cola...Ch. 22 - Direct materials purchases budget Anticipated...Ch. 22 - Direct labor cost budget MatchPoint Racket Company...Ch. 22 - Direct labor budget for a service business...Ch. 22 - Production and direct labor cost budgets Levi...Ch. 22 - Factory overhead cost budget Sweet Tooth Candy...Ch. 22 - Cost of goods sold budget Wilmington Chemical...Ch. 22 - Cost of goods sold budget The controller of...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Capital expenditures budget On January 1, 20Y2,...Ch. 22 - Forecast sales volume and sales budget For 20Y6,...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Sonoma Housewares...Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Forecast sales volume and sales budget Sentinel...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Mercury Shoes Inc....Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Ethics in Action The director of marketing for...Ch. 22 - Communication The city of Milton has an annual...Ch. 22 - Evaluating budgeting systems in a service company...Ch. 22 - Static budget for a service company A bank manager...Ch. 22 - Objectives of the master budget Dominos Pizza...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions
What are the classes of transcription errors?

Accounting Information Systems

The times interest earned ratio is a measure of (a) liquidity. (b) profitability. (c) leverage.

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

REGRESSION AND INVENTORIES jasper Furnishings has 300 million in sales. The company expects that its sales will...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)