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
forecast Sales Volume and Sales BudgetSentinel Systems Inc. prepared the following sales budget for 20Y8:Sentinel Systems Inc.Sales BudgetFor the Year Ending December 31, 20Y8Product and AreaUnit SalesVolumeUnit SellingPriceTotal SalesHome Alert System:United States1,700$200$ 340,000Europe580200116,000Asia45020090,000Total 2,730$ 546,000Business Alert System:United States980$750$ 735,000Europe350750262,500Asia240750180,000Total 1,570$1,177,500Total revenue from sales$1,723,500At the end of December 20Y8, the following unit sales data were reported for the year:Unit SalesHome AlertSystemBusiness AlertSystemUnited States1,7341,078Europe609329
Asia432252
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 increased to $820, effective January 1,…
PREPARE THE FOOLOWING
1- PRODUCTION BUDGET
2-SALES BUDGET
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
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_forwardProduction budget Healthy Measures Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: The finished goods inventory estimated for March 1, for the Bath and Gym scale models is 11,800 and 8,100 units, respectively. The desired finished goods inventory for March 31 for the Bath and Gym scale models is 15,000 and 7,500 units, respectively. Prepare a production budget for the Bath and Gym scales for the month ended March 31.arrow_forward
- Cash budget Pasadena Candle Inc. pays 40% of its purchases on account in the month of the purchase and 60% in the month following the purchase. If purchases are budgeted to be 40,000 for August and 36,000 for September, what are the budgeted cash payments for purchases on account for September?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_forwardQuestion:How many units of Material X is NUBD planning to purchase during September 2021?arrow_forward
- 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.arrow_forwardExercises 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_forwardCoronado Company estimates that unit sales will be 9,200 in quarter 1, 12,880 in quarter 2, 13,800 in quarter 3, and 16,560 in quarter 4. Using a unit selling price of $70. Prepare the sales budget by quarters for the year ending December 31, 2027. eTextbook and Media $ $ $ $ CORONADO COMPANY Sales Budget 2 Quarter $ $ 3 く $ $arrow_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_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_forwardFrom the following forecast of income and expenditure prepare a Cash Budget for the three months ending on May, 20X8 Month Sales ₹ Purchase ₹ Wages ₹ Misc. ₹ Jan 'X8 2,20,000 1,34,000 30,000 17,000 Feb 'X8 2,30,000 1,50,000 32,000 18,000 Mar 'X8 1,80,000 1,54,000 28,000 16,000 Apr 'X8 2,16,000 1,56,000 30,000 22,000 May 'X8 1,88,000 1,30,000 28,000 16,000 Additional Information: (i) Sales:30% realized in the month of sales, discount allowed 2%, balance realized equally in two subsequent months. (ii) Purchases: These are paid in the month following the month of supply (iii) Wages: 30% paid in arrears following month (iv) Misc. Expenses: Paid a month in arrears (v) Rent: ₹2000 per month paid quarterly in advance due, in March (vi) Income Tax: First Instalment of advance tax, ₹30,000 due on or before 15th May to be paid within the month (vii) Income from Investment: ₹15,000 received quarterly in March,…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