Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 20SE
Using sensitivity analysis in budgeting
Riverbed Sporting Goods Store has the following sales budget:
Suppose June sales are expected to be $81,000 rather than $65,000. Revise Riverbed’s sales budget.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Perform a sensitivity analysis on the budget for values from $5,000 to $35,000 inincrements of $5,000. Construct a graph of percentage reach versus budget. Is theadditional increase in percentage reach monotonically decreasing as the budget allocationincreases? Why or why not? What is your recommended budget? Explain.
PROBLEM 9-15 Production and Direct Materials Budgets [LO3, LO4]
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South
East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of
Supermix, one of the company's products. The company is now planning raw materials needs for
Chapter 9
the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales
moving smoothly, the company has the following inventory requirements:
a. The finished goods inventory on hand at the end of each month must be equal to 3,000 units of
Supermix plus 20% of the next month's sales. The finished goods inventory on June 30 is
budgeted to be 10,000 units.
b. The raw materials inventory on hand at the end of each month must be equal to one-half of the
following month's production needs for raw materials. The raw materials inventory on June
30 is budgeted to be 54,000 cc of solvent H300.
c. The company…
Czarina Café wants to prepare a cash budget for September through December. Using the following information, prepare the cash budget schedule and interpret the results.
Sales were P50,000 in June and P60,000 in July. Sales have been forecasted to be P65,000, P72,000, P63,000, P59,000, and P56,000 for months of August, September, October, November, and December, respectively. Based on the past history and current credit terms offered by the firm, Czarina Café has estimated the following payment schedules for the sales:
10 percent of sales were on cash basis,
50 percent will be collected in the month following the sale,
30 percent will be collected in the second month following the sale,
10 percent of the total sales will be collected in the third month following the sale.
Every four months (three times a year) P500 of dividends from investments are expected. The first dividend payment was received in January.
Purchases are 60 percent of sales, 15 percent of which are paid in…
Chapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. 22 - Managers are required to think about future...Ch. 22 - Prob. 2TICh. 22 - Managers use results to evaluate employees...Ch. 22 - Managers work with managers in other divisions.Ch. 22 - Prob. 5TICh. 22 - Match the budget types to the definitions.Ch. 22 - Prob. 7TICh. 22 - Prob. 8TICh. 22 - Prob. 9TICh. 22 - Prob. 10TI
Ch. 22 - Prob. 11TICh. 22 - Prob. 12TICh. 22 - Prob. 13TICh. 22 - Prob. 14TICh. 22 - Prob. 15TICh. 22 - Prob. 16TICh. 22 - A company can expect to receive which of the...Ch. 22 - A company prepares a five-year budget. This budget...Ch. 22 - Which of the following is the cornerstone of the...Ch. 22 - Prob. 4QCCh. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Prob. 6QCCh. 22 - Use the following information to answer questions...Ch. 22 - The budgeted income statement is part of which...Ch. 22 - Prob. 9QCCh. 22 - Use the following information to answer questions...Ch. 22 - Suppose Mallcentral sells 1,000 hardcover books...Ch. 22 - Prob. 12QCCh. 22 - Information technology has made it easier for...Ch. 22 - Prob. 1RQCh. 22 - Prob. 2RQCh. 22 - Prob. 3RQCh. 22 - What is budgetary slack? Why might managers try to...Ch. 22 - Explain the difference between strategic and...Ch. 22 - Explain the difference between static and flexible...Ch. 22 - What is a master budget?Ch. 22 - In a manufacturing company, what are the three...Ch. 22 - Why is the sales budget considered the cornerstone...Ch. 22 - Prob. 10RQCh. 22 - What is the formula used to determine the amount...Ch. 22 - What are the two types of manufacturing overhead?...Ch. 22 - How is the predetermined overhead allocation rate...Ch. 22 - What is the capital expenditures budget?Ch. 22 - Prob. 15RQCh. 22 - What are the budgeted financial statements? How do...Ch. 22 - How does the master budget for a merchandising...Ch. 22 - What is the formula used to determine the amount...Ch. 22 - What budgets are included in the financial budget...Ch. 22 - What is sensitivity analysis? Why is it important...Ch. 22 - Budgeting benefits List the three key benefits...Ch. 22 - Budgeting types Consider the following budgets and...Ch. 22 - Preparing an operating budgetsales budget Brown...Ch. 22 - Preparing an operating budgetproduction budget...Ch. 22 - Preparing an operating budgetdirect materials...Ch. 22 - Preparing an operating budgetdirect labor budget...Ch. 22 - Preparing an operating budgetmanufacturing...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Berry expects total sales of 359,000 in January...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetcash budget Booth has...Ch. 22 - Prob. 12SECh. 22 - Preparing an operating budgetsales budget Trailers...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Prob. 16SECh. 22 - Preparing a financial budgetcash budget Wilson...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Using sensitivity analysis in budgeting Refer to...Ch. 22 - Using sensitivity analysis in budgeting Riverbed...Ch. 22 - Prob. 21ECh. 22 - Preparing an operating budgetsales budget...Ch. 22 - Preparing an operating budgetsales and production...Ch. 22 - Preparing an operating budgetdirect materials,...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 27ECh. 22 - Preparing the financial budgetcash budget Use the...Ch. 22 - Preparing the financial budgetcash budget Hoppy...Ch. 22 - Preparing the financial budgetbudgeted balance...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Preparing an operating budgetselling and...Ch. 22 - Prob. 33ECh. 22 - Preparing a financial budgetcash budget,...Ch. 22 - Preparing a financial budgetcash budget You...Ch. 22 - Use the following June actual ending balances and...Ch. 22 - Using sensitivity analysis Rucker Company prepared...Ch. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Preparing an financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Preparing an operating budgetsales budget;...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Prob. 45APCh. 22 - Prob. 46APCh. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Prob. 48BPCh. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Prob. 51BPCh. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 53BPCh. 22 - Belton Printing Company of Baltimore has applied...Ch. 22 - Using sensitivity analysis Holly Company prepared...Ch. 22 - Prob. 57PCh. 22 - Before you begin this assignment, read the...Ch. 22 - Prob. 1DCCh. 22 - Patrick works for McGills Computer Repair, owned...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Dave Nelson recently retired at age 48, courtesy of the numerous stock options he had been granted while presid...
Managerial Accounting: Creating Value in a Dynamic Business Environment
This year, Prewer Inc. received a 160,000 dividend on its investment consisting of 16 percent of the outstandin...
PRINCIPLES OF TAXATION F/BUS.+INVEST.
How would the decision to dispose of a segment of operations using a split-off rather than a spin-off impact th...
Advanced Financial Accounting
How would the decision to dispose of a segment of operations using a split-off rather than a spin-off impact th...
Advanced Financial Accounting
Adjusting Journal Entries; Adjusted Trial Balance. Magic Cleaning Services (MCS) has a fiscal year-end of Decem...
Intermediate Accounting (2nd Edition)
Place the letter of the appropriate accounting cost in Column 2 in the blank next to each decision category in ...
Fundamentals Of Cost Accounting (6th Edition)
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
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.arrow_forwardBefore the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.arrow_forwardBefore the year began, the following static budget was developed for the estimated sales of 100,000. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for 80,000 and 90,000 units of sales.arrow_forward
- Using sensitivity analysis Rucker Company prepared the following budgeted income statement for 2019: Requirements Prepare a budgeted income statement with columns for 700 units, 1,300 units, and 1,700 units sold. How might managers use this type of budgeted income statement?arrow_forwardAssume that you manage one store in a chain of sporting goods retailers. Each month, your store is evaluated by comparing actual operating results to budgeted results. During December of the current year, your store's sales were up 25% from sales projected on the budget. As a result of this increase in sales, would you expect any other items to come in over (or under) their budgeted amounts? If so, list the items and describe why they would vary from the budget.arrow_forwardProvide what is being asked. Show your solution; Baston llakad is a financial budgeting| for Makati wet market, has prepared the following sales and cash disbursement estimates for the period of August through December of the current year. Month Sales Disbursement 400 August September 300 500 500 October 500 700 November 600 400 December 700 500 90% of sales are for cash, the remaining 10% are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of P50. The beginning cash balance in September is P25. Required: Prepare a cash budget for the months of October, November, and December, nothing any needed financing or excess cash available.arrow_forward
- 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 byproduct and in total for each time period.2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?arrow_forwardABC Ltd. is preparing a budget for 2018. Following are the information related to budget preparation: Budgeted selling price per unit = SAR 200 per unit Total fixed costs = SAR 250,000 Variable costs = SAR 65 per unit Required: Prepare flexible budget for 2,000, 2,500, 3,000 and 3,500 units .arrow_forwardUsing sensitivity analysis Holly Company prepared the following budgeted income statement for the first quarter of 2018: Holly Company is considering two options. Option 1 is to increase advertising by $700 per month. Option 2 is to use better-quality materials in the manufacturing process. The better materials will increase the cost of goods sold to 45% but will provide a better product at the same sales price. The marketing manager projects either option will result in sales increases of 30% per month rather than 20%. Requirements Prepare budgeted income statements for both options, assuming both options begin in January and January sales remain $8,000. Round all calculations to the nearest dollar. Which option should Holly choose? Explain your reasoning.arrow_forward
- XYZ Enterprises, distributor of external hard disk, is developing its budgeted sales for next year. XYZ has developed the following range of sales estimates and associated probabilities for the year: What is the expected value of XYZ’s budgeted sales?arrow_forwardWestport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement. a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $65? 9750000 b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 11,000 units, how many units should be produced? 155000 c. What dollar amount of materials should be purchased at $5.50 per pound if each unit of product requires 2.5 pounds and beginning and ending materials inventories should be 12,000 and 13,500 pounds, respectively. 2139500 How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an hourly rate of $22? How much manufacturing overhead should be incurred if fixed manufacturing overhead is $45,000 and variable…arrow_forwardEvaluate the following statements related to creating budget: I. In a production budget if the number of units in the finished goods inventory at the end of the period is less than the number of units in the finished goods inventory at the beginning of the period then the expected number of units sold is less than the number of units to be produced during the period Ii. in the merchandise purchases budget, the required purchases in units for a period can be determined by subtracting the beginning merchandise Inventory in units from the total of budgeted sales in unit and desired ending merchandise inventory (unit) III. When preparing a direct materials budget the beginning inventory for raw materials should be added to production needs, and the desired ending inventory should be subtracted to determine the amount of raw materials to be purchased Answer: ???arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
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