Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.27AE
Continuation of E6-25A: Regression analysis (Learning Objective 5)
Refer to the Broadway Floral data in E6-25A. Use Microsoft Excel to do the following:
Requirements
- 1. Run a regression analysis.
- 2. Determine the company’s cost equation (use the output from the Excel regression).
- 3. Determine the R-square (use the output from the Excel regression). What does Broadway Floral’s R-square indicate?
- 4. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should the company rely on this cost estimate? Why or why not?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Jalancu Juviai u
The following are a number of measures associated with the Balanced Scorecard.
Required:
1. Classify each performance measure as belonging to one of the following perspectives: financial, customer, internal business process, or learning and growth.
a. Number of new customers
b. Percentage of customer complaints resolved with one contact
C. Unit product cost
d.
Cost per distribution channel
e. Suggestions per employee
f.
Warranty repair costs
Consumer satisfaction (from surveys)
Cycle time for solving a customer problem
Strategic job coverage ratio
j.
On-time delivery percentage
k. Percentage of revenues from new products
2. Select an additional measure that would be appropriate for each of the four perspectives.
Contribution margin by product ▾
Number of complaints
Number of accidents per month
Hours of continuing education provided per month
g.
h.
i.
Financial
Customer
Customer
Internal business process
Financial
Financial
Learning and growth
Learning and growth…
EVENT PLANNING.XLS
In the following data table taken from the Event planning spreadsheet, the highest Operating
Income value should be in the:
Data table
Patron per Tableà 6
Patron per Tableà
Patron per Tableà
7
8
a. Upper left corner
b. Upper right corner
c. Lower left corner
d. Lower right corner
$1,200
Operating income
($)
Operating
income
($)
Operating income
($)
Fee
$1,100
Operating income
($)
Operating income
Operating income
($)
$1,000
Operating income
($)
Operating income
($)
Operating income
($)
Explain the concept of customer profitability analysis. Give examples of cost drivers used in this analysis.
(500 words)
Chapter 6 Solutions
Managerial Accounting (5th Edition)
Ch. 6 - (Learning Objective 1) A graph of a variable cost...Ch. 6 - (Learning Objective 2) Which of the following is...Ch. 6 - (Learning Objective 2) In the cost equation...Ch. 6 - Prob. 4QCCh. 6 - Prob. 5QCCh. 6 - (Learning Objective 3) Which of the following is...Ch. 6 - Prob. 7QCCh. 6 - (Learning Objective 5) Which of the following is...Ch. 6 - Prob. 9QCCh. 6 - Prob. 10QC
Ch. 6 - Identify cost behavior (Learning Objectives 1 2)...Ch. 6 - Prob. 6.2SECh. 6 - Compute fixed costs per unit (Learning Objective...Ch. 6 - Prob. 6.4SECh. 6 - Predict and graph total mixed costs (Learning...Ch. 6 - Prob. 6.6SECh. 6 - Prepare and analyze a scatterplot (Learning...Ch. 6 - Prob. 6.8SECh. 6 - Use the high-low method (Learning Objective 4)...Ch. 6 - Prob. 6.10SECh. 6 - Prob. 6.11SECh. 6 - Prob. 6.12SECh. 6 - Write a cost equation given regression output...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Identify cost behavior graph (Learning Objectives...Ch. 6 - Prob. 6.18SECh. 6 - Prob. 6.19SECh. 6 - Prob. 6.20AECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Prob. 6.22AECh. 6 - Prob. 6.23AECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatterplot (Learning Objective 3) Melody...Ch. 6 - Continuation of E6-25A: High-low method (Learning...Ch. 6 - Continuation of E6-25A: Regression analysis...Ch. 6 - Regression analysis using Excel output (Learning...Ch. 6 - Prob. 6.29AECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Performing a regression analysis to predict...Ch. 6 - Prob. 6.33AECh. 6 - Prob. 6.34AECh. 6 - Compare absorption and variable costing (Learning...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.40AECh. 6 - Prob. 6.41BECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Use unit cost data to forecast total costs...Ch. 6 - Prob. 6.44BECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatter plot (Learning Objective 3) Tammy...Ch. 6 - Continuation of E6-46B: High-low method (Learning...Ch. 6 - Prob. 6.48BECh. 6 - Prob. 6.49BECh. 6 - Prob. 6.50BECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Prob. 6.53BECh. 6 - Prob. 6.54BECh. 6 - Prob. 6.55BECh. 6 - Prob. 6.56BECh. 6 - Prob. 6.57BECh. 6 - Prob. 6.58BECh. 6 - Prob. 6.59BECh. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.61BECh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prob. 6.64APCh. 6 - Prob. 6.65APCh. 6 - Prob. 6.66APCh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prepare traditional and contribution margin income...Ch. 6 - Prob. 6.70BPCh. 6 - Prob. 6.71BPCh. 6 - Prob. 6.72SCCh. 6 - Cost Behavior in Real Companies Choose a company...Ch. 6 - Ethics of building inventory (Learning Objective...Ch. 6 - Prob. 6.76ACT
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
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forwardThe following if-then statements were taken from a Balanced Scorecard: a. If employee capabilities increase, then process time decreases. b. If process time decreases, then customer retention will increase. c. If customer retention increases, then market share will increase. d. If market share increases, then revenues will increase. Required: 1. Identify the lead and lag variables, and explain your reasoning. 2. Discuss the implications of Requirement 1 for the financial and learning and growth perspectives. 3. Using the first if-then statement, explain the concept of double-loop feedback.arrow_forwardUsing the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.arrow_forward
- Exercises + Suppose that we made an AHP analysis based on the following comparison tables Value R1 R2 R3 R1 1 9. R2 1 R3 1 Cost R1 R2 R3 R1 1 1/7 1/5 R2 1 1/9 R3 1 1) Draw the value cost diagram from these tables 2) From the diagram, rank the requirements according to their priorities starting from the highest priority Dr. Quta Shambour PArt Requirciments Analyarrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the courses. Comment on how your analysis has changed for each course. B. Perform a vertical analysis for each course. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explainarrow_forwardUsing the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?arrow_forward
- Classify each of the following performance measures into the balanced scorecard perspective to which it relates: financial perspective, internal operations perspective, learning and growth perspective, or customer perspective. A. Number of improved products B. Time from packaging to delivery or display C. Production costs D. Number of customer suggestions E. Sales mix revenues F. Number of repeat customersarrow_forward4) Design ABC system for EON and Brothers (discuss steps) 5) What are the Costs per unit of Alfa and Beta under traditional and ABC costing systems?What would be the prices of Alpha and Beta traditional and ABC costing systems? Comparethe costs and prices calculated in the two systems (Calculations should be shown in theappendix) and for analysis 6) Discuss your recommendation on the viability of ABC for EON and Brothers Ltd., given thefinancial director's concerns.arrow_forwardAn analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCostsarrow_forward
- Refer to the pictur ebelow: Find: 1. Total Cost of Product A under ABC System2. Total Cost of Product B under ABC System3. Selling Price per unit of Product B assuming profit margin of 20% above costarrow_forwardCarter Dry Cleaning has developed two regression analyses for cost estimation. The accounting manager has presented statistical measures for both of these regressions. Regression A has an R-squaredvalue of .53 and a t-value of 1.08. Regression B has an R-squared of .89 and a t-value of 2.17. Whatdo these statistical measures indicate about the regressions? Which regression should Carter DryCleaning use for cost estimation?arrow_forwardCourse Objectives: Compute sales units given operating income, selling price and variable cost per unit. Prepare a contribution margin income statement, clearly showing contribution Use CVP analysis to compute breakeven point and margin of safety Analyze the impact which changes in sales volume and total fixed costs will have on the breakeven point, margin of safety and operating income Explain the impact of errors such as the omission of fixed on the decision making process. Darius Manufacturing Company manufactures and sells parts for various musical gadgets. The business earned Operating Income of $420,000 in 2018, when selling price per unit was $200 and the president of Darius is under pressure to increase operating income in 2019 and is therefore considering the implementation of strategies geared at increasing revenues. Data for variable cost per unit and total fixed costs were as follows: Variable expenses per unit: Direct Material $20…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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 Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Relevant Costing Explained; Author: Kaplan UK;https://www.youtube.com/watch?v=hnsh3hlJAkI;License: Standard Youtube License