Concept explainers
Interpretation of Regression Results: Simple Regression
Your company provides a variety of delivery services. Management wants to know the volume of a particular delivery that would generate $10,000 per month in operating profits before taxes. The company charges $20 per delivery.
The controller’s office has estimated
Monthly overhead = $26,501 + $10.70 per delivery
Your estimate was based on the following data:
The company controller is somewhat surprised that the cost estimates are so different. You have been asked to recheck your work and see if you can figure out the difference between your results and the controller’s results.
Required
- a. Analyze the data and your results and state your reasons for supporting or rejecting your cost equation.
- b. Write a report that informs management about the correct volume that will generate $10,000 per month in operating profits before taxes.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Sales Revenue Approach, Variable Cost Ratio, Contribution Margin Ratio Arberg Companys controller prepared the following budgeted income statement for the coming year: Required: 1. What is Arbergs variable cost ratio? What is its contribution margin ratio? 2. Suppose Arbergs actual revenues are 30,000 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement 3. How much sales revenue must Arberg earn to break even? Prepare a contribution margin income statement to verify the accuracy of your answer. 4. What is Arbergs expected margin of safety? 5. What is Arbergs margin of safety if sales revenue is 380,000?arrow_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardComputing margin of safety Robbie’s Repair Shop has a monthly target profit of $31,000. Variable costs are 20% of Sales, and monthly fixed costs are $19,000. Requirements Compute the monthly margin of Safety in dollars if the shop achieves its income goal. Express Robbie’s margin of safety, as a percentage of margin Sales. Why would Robbie’s management want to know the shop’s margin of safety?arrow_forward
- The management accountant of a company has calculated his firm's breakeven point from the following data: Selling price per unit $20 Variable costs per unit $8 Fixed overheads for next year $79,104 It is expected that next year, the firm will produce and sell 7,500 units. What is the margin of safety? A 12.1% 13.8% 47.3% D 89.6%arrow_forwardThe managing director of a law firm has the monthly data (below) on total overhea labor hours to bill to clients. Develop a simple linear regression model between bi costs. \table [[\table[[Overhead], [Costs]], \table [[Billable], [Hours ]]], [375000, 3000], [425000, 4000], [445000, 5000], [496000, 6000], [580000, 7000], [605000, 8000]] Round the coefficient to two decimal places, do not include the $ symbol. For ea billable hours, the predicted overhead costs are estimated to increase by 109.12arrow_forwardSpruce Enterprises anticipates fixed costs of $25,000. Variable costs and expenses are expected to be 60% of sales. The president has asked you to develop a worksheet to calculate sales needed to break even and sales needed to achieve any desired net income (file name DESNI). Your worksheet should include a Data Section that contains fixed costs, desired net income, and variable costs as a percentage of sales. Assume as initial input for your model that the company wishes to achieve a net income of $10,000.arrow_forward
- Kreter, Inc. earned net income of $300,000 last year. This year it wants to earn net income of $450,000. The company's fixed costs are expected to be $300,000, and variable costs are expected to be 70% of sales. Determine the required sales to meet the target net income of $450,000 using the mathematical equation. Required sales $ Using a CVP income statement format, prove your answer. Fixed costsTarget net income / (Loss)SalesVariable costsContribution margin $ Contribution marginFixed costsTarget net income / (Loss)SalesVariable costs Contribution marginSalesVariable costsFixed costsTarget net income / (Loss) Fixed costsVariable costsSalesTarget net income / (Loss)Contribution margin SalesFixed costsContribution marginVariable costsTarget net income / (Loss) $arrow_forwardBloom Company predicts it will incur fixed costs of $255,000 and earn income of $427,500 in the next period. Its expected contribution margin ratio is 65%. 1. Compute the amount of expected total dollar sales. 2. Compute the amount of expected total variable costs. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the amount of expected total dollar sales. Dollar Sales Numerator: Denominator: Total Dollar Sales %3D Total dollar sales %3D Required 1 Required 2 >arrow_forward= Adam's Repair Shop has a monthly target operating income of $12,500. Variable expenses are 75% of sales, and monthly fixed expenses are $9,500. Hint: The contribution margin ratio= 100% - Variable expenses percentage of sales. Read the requirements. Requirement 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. Begin by identifying the formula to compute the margin of safety. = Margin of safety in dollars (Round intermediate calculations up to the nearest whole dollar and your final answer to the nearest whole dollar.) The margin of safety is Requirement 2. Express Adam's margin of safety as a percentage of target sales. Begin by identifying the formula to compute the margin of safety as a percentage of target sales. (Round the percentage to the nearest whole percent.) The margin of safety percentage is % of target sales. Requirement 3. What is Adam's operating leverage factor at the target level of operating income? Begin by identifying the…arrow_forward
- Bloom Company management predicts that it will incur fixed costs of $267,000 and earn pretax income of $353,100 in the next period. Its expected contribution margin ratio is 53%. Required: 1. Compute the amount of total dollar sales. 2. Compute the amount of total variable costs. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the amount of total dollar sales. Dollar Sales Choose Numerator: / Choose Denominator: = 1 of 5 F8 Next > F9 18 F10 F11 F12 Fn Lock 3:25 PM 6/16/2022 Insertarrow_forwardUse the following data to solve problem #2: - Fixed costs $2,500 - Variable cost per unit $1.00 - Selling price per unit $6.00 - Run a simulation for production runs in increments of 100 (run 15) - At what production level in the company profitable - What is the amount of profit? - What is the maximum profit under these conditions - Show all work on a spreadsheetarrow_forwardHoward Cooper, the president of Vernon Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required A Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Vernon charges customers $83 per hour, the firm can achieve 52,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub