Accounting
27th Edition
ISBN: 9781337272094
Author: WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 22.1BPR
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 patterns 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.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Netco's sales budget for the coming year is as follows.
Item Volume in Units Sales Price Sales Revenue
1
200,000
2
150,000
300,000
3
Total sales revenue
Select one:
$50
10
30
a. $850,000
b. $1,050,000
c. $550,000
d. $750,000
$10,000,000
1,500,000
Items 1 and 3 are different models of the same product. Item 2 is a complement to Item 1. Past experience indicates that the sales volume of Item 2 relative to the sales volume of Item 1 is fairly constant. Netco is
considering a 10% price increase for the coming year for Item 1, which will cause sales of Item 1 to decline by 20% while simultaneously causing sales of Item 3 to increase by 5%. If Netco institutes the price
increase for Item 1, total sales revenue will decrease by
9,000,000
$20,500,000
XYZ Inc. is preparing its annual budgets for the year ending December 31, 2025.
Product JB 50 Product JB 60
Sales Budget:
Anticipated volume in units 677,000 345,000
Unit Selling Price $23 $45
Production budget:
Desired ending finished goods units 65,000 21,500
Beginning finished good units 54.300 10,750
Prepare the Production Budget 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:
8" x 10"
Unit Sales
12" x 16"
Frame
Frame
East
19,635
11,978
Central
4,635
3,136
West
3,977
2,369
Product and Area
8" x 10" Frame:
East
Central
West
Total
Raphael Frame Company
Sales Budget
For the Year Ending December 31, 20Y8
Unit Sales
Volume
Unit
Selling
Price
Total
Sales
18,700
$14
$261,800
4,500
14
63,000
4,100
14
57,400
27,300
$382,200
12" x 16" Frame:
East
Central
11,300
3,200
$29
$327,700
29
West
Total
Total revenue from sales
2,300
16,800
29
92,800
66,700
$487,200
$869,400
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" x 10" frame is expected to increase to $15 and the unit selling price for the 12"
frame is expected to increase to $31, effective January 1,…
Chapter 22 Solutions
Accounting
Ch. 22 - Prob. 22.1DQCh. 22 - Briefly describe the type of human behavior...Ch. 22 - What behavioral problems are associated with...Ch. 22 - What behavioral problems are associated with...Ch. 22 - Under what circumstances is a static budget...Ch. 22 - How do computerized budgeting systems aid firms in...Ch. 22 - Why should the production requirements set forth...Ch. 22 - Why should the timing of direct materials...Ch. 22 - a. Discuss the purpose of the cash budget. b. If...Ch. 22 - Prob. 22.10DQ
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 - Prob. 22.2BPECh. 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 - Prob. 22.10EXCh. 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 - Prob. 22.1CPCh. 22 - Communication The city of Milton has an annual...Ch. 22 - Prob. 22.4CPCh. 22 - Static budget for a service company A bank manager...Ch. 22 - Objectives of the master budget Dominos Pizza...
Knowledge Booster
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
- Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.arrow_forwardUse the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?arrow_forwardA companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forward
- Exercises 1: Questions for discussion 1. Describe the items reflected in the sales budget. 2. List the items included in the production budget 3. Identify the items that comprise the operating budget Exercises 2: Word Problems Roel Trading Company presents the actual sales for the first three months of year 2019 in its own products as follows: Product B P 540,000 P 567,000 P 595,350 Product A Total Sales Janaury February March P 880,000 P 941,000 P 1,006,750 The business expects that the trends for the past three months will P 340,000 P 374,000 P 411400 continue in April and May 2019. Required: Determined the projected sales for April and May 2019 for the two products. Round the amounts to thousand pesos.arrow_forwardPrepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…arrow_forwardEX.22-06 Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Estimated inventory (units), June 1 Desired inventory (units), June 30 Expected sales volume (units): East Region West Region Unit sales price Rumble 262 301 2,700 5,900 $140 Thunder 66 57 2,400 5,150 $205arrow_forward
- Preparing a Budgeted Income Statement Oliver Company provided the following information for the coming year: Units produced and sold 160,000 Cost of goods sold per unit $6.30 Selling price $13 Variable selling and administrative expenses per unit $1.10 Fixed selling and administrative expenses $423,000 Tax rate 18 % Required: Prepare a budgeted income statement for Oliver Company for the coming year. Round all income statement amounts to the nearest dollar. Oliver Company Budgeted Income Statement For the Coming Year $fill in the blank 2 fill in the blank 4 $fill in the blank 6 fill in the blank 8 fill in the blank 10 $fill in the blank 12 fill in the blank 14 $fill in the blank 16 Check My Work3arrow_forwardProduction Budget Harbour Inc. projected sales of 252,000 personal journals for 20Y6. The estimated January 1, 20Y6, inventory is 13,700 units, and the desired December 31, 20Y6, inventory is 19,700 units. What is the budgeted production (in units) for 20Y6?arrow_forwardQuarterly Sales Budget by Cities Inventories Schedule Estimated sales percentages for the first three month period of the coming year of the Uni-lever Company are: Cities January February March Total Karachi 50% 30% 20% 100% Islamabad 55 30 15 100 Lahore 50 25 25 100 Peshawar 50 25 25 100 Estimated unit sales at Rs. 5 per unit by cities for the three months are: Cities Unit Sales Karachi 20,000 Islamabad 30,000 Lahore 10,000 Peshawar 10,000 Total 100,000 Required An estimate of sales by units and in rupees for each of first three months for each city and in total.arrow_forward
- Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenuearrow_forwardPreparing a Budgeted Income Statement Oliver Company provided the following information for the coming year: Units produced and sold 160,000 Cost of goods sold per unit $6.30 Selling price $12 Variable selling and administrative expenses per unit $1.10 Fixed selling and administrative expenses $423,000 Tax rate 23 % Required: Prepare a budgeted income statement for Oliver Company for the coming year. Round all income statement amounts to the nearest dollar. Oliver Company Budgeted Income Statement For the Coming Year $fill in the blank 2 fill in the blank 4 $fill in the blank 6 fill in the blank 8 fill in the blank 10 $fill in the blank 12 fill in the blank 14 $fill in the blank 16arrow_forwardComputer Assignment The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular. In September 2018, SK Industries Budget Department gathered the following data in order to prepare budgets for 2019: 2019 Projected Sales Units Price Accel Active 45,000s225 Accel Regular 75,000|s155 Product Expected Target Inventories January 1, 2019 December 31, 2019 Product Accel Active 9,000 12,000 Accel Regular 17,000 25,000 The following direct materials are expected to be used in the two products: |Material Used per Unit Direct Material Unit Accel Active Accel Regular pound One 6. Two pound 4 2 Three pound 2 Projected data for 2019 with respect to direct materials are as follows: Direct Material Expected Purchase Price Expected Inventories Target Inventories (January 1, 2019) (December 31, 2019) One SIs 27,000 lb 35,000 lb Two S7 30,000 lb 35,000 lb Three $4 4,000 lb 7,000 lb Projected direct labor requirements and rates for 2019 are as follows: Product Accel Active…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY