Concept explainers
Using sensitivity analysis
Holly Company prepared the following
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
- 1. 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.
- 2. Which option should Holly choose? Explain your reasoning.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Additional Business Textbook Solutions
Introduction To Managerial Accounting
Principles of Accounting Volume 2
Managerial Accounting (5th Edition)
Principles of Accounting Volume 1
Managerial Accounting: Creating Value in a Dynamic Business Environment
Advanced Financial Accounting
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardReview the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)arrow_forwardHammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows. Required: 1. What is Hammonds variable cost ratio? Its contribution margin ratio? 2. Suppose Hammonds actual revenues are 200,000 greater than budgeted. By how much will before-tax profits increase? Give the answer without preparing a new income statement. 3. How much sales revenue must Hammond earn in order to break even? What is the expected margin of safety? (Round your answers to the nearest dollar.) 4. How much sales revenue must Hammond generate to earn a before-tax profit of 130,000? An after-tax profit of 90,000? (Round your answers to the nearest dollar.) Prepare a contribution margin income statement to verify the accuracy of your last answer.arrow_forward
- Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:arrow_forwardThe Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.arrow_forwardThe Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of 1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. b. Develop a spreadsheet model and solve the problem using Excel Solver.arrow_forward
- 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_forwardUchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?arrow_forwardThe management of Hess, Inc., is developing a flexible budget for the upcoming year. It was not pleased with the small amount of net income the budget showed at all sales levels and Is contemplating using a less expensive material. This action reduces direct material cost by $1 per unit. What would be the effects on financial statements and a flexible budget if management takes this approach? Are there other factors that need to be considered?arrow_forward
- Top managers of Juda Industries predicted 2025 sales of 14,500 units of its product at a unit price of $10.00. Actual sales for the year were 14,300 units at $13.00 each. Variable costs were budgeted at $3.20 per unit, and actual variable costs were $3.30 per unit. Actual fixed costs of $49,000 exceeded budgeted fixed costs by $2,000. Prepare Juda Industries' flexible budget performance report. What variance contributed most to the year's favorable results? What caused this variance? Prepare a flexible budget performance report for the year. First, complete the flexible budget performance report through the contribution margin line, then complete the report through the operating income line. Finally, compute the total variances. (Enter a 0 for any zero balances. Label the variance as favorable (F) or unfavorable (U), in the input field after the amount you enter. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input field blank.) Juda Industries Flexible Budget…arrow_forwardTop managers of Root Industries predicted 2024 sales of 14,700 units of its product at a unit price of $7.50. Actual sales for the year were 14,500 units at $9.50 each. Variable costs were budgeted at $2.70 per unit, and actual variable costs were $2.80 per unit. Actual fixed costs of $49,000 exceeded budgeted fixed costs by $5,000. Prepare Root's flexible budget performance report. What variance contributed most to the year's favorable results? What caused this variance? Prepare a flexible budget performance report for the year. First, complete the flexible budget performance report through the contribution margin line, then complete the report through the operating income line. Finally, compute the total variances. (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank.) Units Sales Revenue Variable Costs Contribution Margin Budget Amounts Per Unit 7.5 2.7 Root Industries Flexible Budget Performance Report For the Year Ended…arrow_forwardTop managers of McKnight Industries predicted 2024 sales of 15,000 units of its product at a unit price of $8.50. Actual sales for the year were 14,200 units at $9.50 each. Variable costs were budgeted at $2.80 per unit, and actual variable costs were $2.90 per unit. Actual fixed costs of $47,000 exceeded budgeted fixed costs by $5,200. Prepare McKnight's flexible budget performance report. What variance contributed most to the year's favorable results? What caused this variance? Prepare a flexible budget performance report for the year. First, complete the flexible budget performance report through the contribution margin line, then complete the report through the operating income line. Finally, compute the total variances. (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank.)arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning