close solutoin list

Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 20Y8: Sentinel Systems Inc. Sales Budget For the Year Ending December 31, 20 Y8 Unit Sales Unit Selling Total Product and Area Volume Price Sales Home Alert System: United States 1,700 $200 $ 340,000 Europe 580 200 116,000 Asia 450 200 90,000 Total 2,730 $ 546,000 Business Alert System: United States 980 $750 $ 735,000 Europe 350 750 262,500 Asia 240 750 180,000 Total 1,570 $1,177,500 Total revenue from sales $1,723,500 At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the pat­terns established during the year ending December 31, 20Y8. The unit selling price for the Home Alert System is expected to increase to $250, and the unit selling price for the Business Alert System is expected to be decreased to $820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y8 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent Home Alert System: United States Europe Asia Business Alert System: United States Europe Asia 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 lie used for preparing the sales budget for the year ending December 31, 20Y9- 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. 20Y8 Actual Units Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y9.

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.1BPR
Textbook Problem

Forecast sales volume and sales budget

 Sentinel Systems Inc. prepared the following sales budget for 20Y8:

Sentinel Systems Inc.

Sales Budget For the Year Ending December 31, 20 Y8

  Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Home Alert System:      
United States 1,700 $200 $ 340,000
Europe 580 200 116,000
Asia 450 200 90,000
Total 2,730   $ 546,000
Business Alert System:      
United States 980 $750 $ 735,000
Europe 350 750 262,500
Asia 240 750 180,000
Total 1,570   $1,177,500
Total revenue from sales     $1,723,500

  At the end of December 20Y8, the following unit sales data were reported for the year:

    Unit Sales
Home Alert System Business Alert System
United States 1,734 1,078
Europe 609 329
Asia 432 252

 For the year ending December 31, 20Y9, unit sales are expected to follow the pat­terns established during the year ending December 31, 20Y8. The unit selling price for the Home Alert System is expected to increase to $250, and the unit selling price for the Business Alert System is expected to be decreased to $820, effective January 1, 20Y9.

  Instructions

  1. 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Place your answers in a columnar table with the following format:
  Unit Sales, Year Ended 20Y8 Increase (Decrease) Actual Over Budget
  Budget Actual Sales Amount Percent
Home Alert System:
United States    
Europe    
Asia    
Business Alert System:
United States    
Europe    
Asia    
  1. 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 lie used for preparing the sales budget for the year ending December 31, 20Y9- 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.

20Y8 Actual Units

Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded)
  1. 3. Prepare a sales budget for the year ending December 31, 20Y9.

Expert Solution

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
REQUIRED RATE OF RETURN Suppose rRF = 9%, rM = 14% and bi = 13. a. What is ri, the required rate of return on S...

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

Describe CPA WebTrust.

Pkg Acc Infor Systems MS VISIO CD