Business

AccountingManagerial Accounting: The Cornerstone of Business Decision-Making( Appendix 3A ) Scattergraph, High-Low Method, Method of Least Squares, Use of Judgment The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed. The costs must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past 8 quarters have been collected: Note: For the following requirements, round the fixed cost to the nearest dollar, round the variable rates to three decimal places, and the R 2 to two decimal places. Required: 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost? 2. Using the high and low points (i.e., the high-low method), compute a power cost formula. ( Note: Round answers to three decimal places.) 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination. 4. CONCEPTUAL CONNECTION Rerun the regression, and drop the point (20,000, $26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?BuyFind*arrow_forward*

7th Edition

Maryanne M. Mowen + 2 others

Publisher: Cengage Learning

ISBN: 9781337115773

Chapter 3, Problem 68P

Textbook Problem

(*Appendix 3A*) Scattergraph, High-Low Method, Method of Least Squares, Use of Judgment

The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed. The costs must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past 8 quarters have been collected:

*Note:* For the following requirements, round the fixed cost to the nearest dollar, round the variable rates to three decimal places, and the R^{2} to two decimal places.

Required:

- 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost?
- 2. Using the high and low points (i.e., the high-low method), compute a power cost formula. (
*Note:*Round answers to three decimal places.) - 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination.
- 4. CONCEPTUAL CONNECTION Rerun the regression, and drop the point (20,000, $26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?

Managerial Accounting: The Cornerstone of Business Decision-Making

Show all chapter solutions

Ch. 3 - Why is knowledge of cost behavior important for...Ch. 3 - What is a driver? Give an example of a cost and...Ch. 3 - Suppose a company finds that shipping cost is...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Explain the difference between committed and...Ch. 3 - Explain why the concept of relevant range is...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Describe the cost formula for a strictly fixed...Ch. 3 - Describe the cost formula for a strictly variable...Ch. 3 - What is the scattergraph method, and why is it...

Ch. 3 - Describe how the scattergraph method breaks out...Ch. 3 - What are the advantages of the scattergraph method...Ch. 3 - Describe the method of least squares. Why is this...Ch. 3 - What is meant by the best-fitting line?Ch. 3 - What is the difference between the unit cost of a...Ch. 3 - If a company produces 10,000 units and sells 8,000...Ch. 3 - (Appendix 3A) Explain the meaning of the...Ch. 3 - A factor that causes or leads to a change in a...Ch. 3 - Which of the following would probably be a...Ch. 3 - Which of the following would probably be a fixed...Ch. 3 - In the cost formula, the term 128,000,000 a. is...Ch. 3 - In the cost formula, the term 12,000 a. is the...Ch. 3 - In the cost formula, the term Number of Patient...Ch. 3 - In the cost formula, the term Total Cost a. is the...Ch. 3 - The following cost formula for total purchasing...Ch. 3 - An advantage of the high-low method is that it a....Ch. 3 - Select the independent and dependent variables.Ch. 3 - Select the correct set of high and low months.Ch. 3 - An advantage of the scattergraph method is that it...Ch. 3 - The total cost for monthly supervisory cost in a...Ch. 3 - Yates Company shows the following unit costs for...Ch. 3 - (Appendix 3A) In the method of least squares, the...Ch. 3 - Creating and Using a Cost Formula Big Thumbs...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Absorption-Costing Income Statement Refer to the...Ch. 3 - Variable-Costing Income Statement Refer to the...Ch. 3 - Creating and Using a Cost Formula Kleenaire Motors...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Brief Exercise 3-28 Using High-Low to Calculate...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Brief Exercise 3-32 Absorption-Costing Income...Ch. 3 - Brief Exercise 3-33 Variable-Costing Income...Ch. 3 - Variable and Fixed Costs What follows are a number...Ch. 3 - Cost Behavior, Classification Smith Concrete...Ch. 3 - Classifying Costs as Fixed and Variable in a...Ch. 3 - Use the following information for Exercises 3-37...Ch. 3 - Use the following information for Exercises 3-37...Ch. 3 - Step Costs, Relevant Range Bellati Inc. produces...Ch. 3 - Matching Cost Behavior Descriptions to Cost...Ch. 3 - Examine the graphs in Exercise 3-40. Required: As...Ch. 3 - Use the following information for Exercises 3-42...Ch. 3 - Use the following information for Exercises 3-42...Ch. 3 - High-Low Method Refer to the information for Luisa...Ch. 3 - Scattergraph Method Refer to the information for...Ch. 3 - Method of Least Squares Refer to the information...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Method of Least Squares, Developing and Using the...Ch. 3 - The method of least squares was used to develop a...Ch. 3 - Identifying the Parts of the Cost Formula;...Ch. 3 - Inventory Valuation under Absorption Costing...Ch. 3 - Inventory Valuation under Variable Costing Lane...Ch. 3 - Income Statements under Absorption and Variable...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - Identifying Fixed, Variable, Mixed, and Step Costs...Ch. 3 - Identifying Use of the High-Low, Scattergraph, and...Ch. 3 - Identifying Variable Costs, Committed Fixed Costs,...Ch. 3 - Scattergraph, High-Low Method, and Predicting Cost...Ch. 3 - Method of Least Squares, Predicting Cost for...Ch. 3 - Cost Behavior, High-Low Method, Pricing Decision...Ch. 3 - Jana Morgan is about to sign up for cellular...Ch. 3 - Variable and Fixed Costs, Cost Formula, High-Low...Ch. 3 - Cost Separation About 8 years ago, Kicker faced...Ch. 3 - Variable-Costing and Absorption-Costing Income...Ch. 3 - Refer to the information for Farnsworth Company...Ch. 3 - (Appendix 3A) Scattergraph, High-Low Method,...Ch. 3 - (Appendix 3A) Separating Fixed and Variable Costs,...Ch. 3 - (Appendix 3A) Cost Formulas, Single and Multiple...Ch. 3 - Suspicious Acquisition of Data, Ethical Issues...

Find more solutions based on key concepts

Show solutions BOND DISCOUNT AMORTI ZATION Zee Company sold an issue of 500,000, 9%, 10-year bonds for 468,845 on April 1. The...

College Accounting, Chapters 1-27

Domino's Pizza: Franchise segment return on investment Domino's Pizza, Inc. is the second-largest pizza chain i...

Financial & Managerial Accounting

Effect of sales discounts Suzi Nomro operates Watercraft Supply Company, an online boat parts distributorship t...

Financial And Managerial Accounting

Compare Comcast, Alphabet, and Wal-Mart The following table shows the sales and average book value of fixed ass...

Corporate Financial Accounting

A business using the retail method of inventory costing determines that merchandise inventory at retail is 1,23...

Financial Accounting

SEPARATION OF DUTIES Human resource management systems necessitate that employees from both the payroll and per...

Accounting Information Systems

Use the following information for P417 and P418: The Hershey Company is one of the worlds leading producers of ...

Intermediate Accounting: Reporting And Analysis

BETA AND REQUIRED RATE OF RETURN A stock has a required return of 9%, the risk-free rate is 4.5%, and the marke...

Fundamentals of Financial Management, Concise Edition (MindTap Course List)

What are two situations in which most economists view a budget deficit as justifiable?

Brief Principles of Macroeconomics (MindTap Course List)

Consider your favorite fast food chain restaurant. How do you think this restaurant might use OLTE to improve i...

Accounting Information Systems

Identify the four major categories of business market customers

MKTG 12:STUDENT ED.-TEXT

Many business Organizations today use teams to accomplish their goals. To help you develop speaking, listening,...

Essentials of Business Communication (MindTap Course List)

In what sense is economics like a science? Draw a production possibilities frontier for a society that produce...

Essentials of Economics (MindTap Course List)

(Utility Maximization) Suppose that a consumer has a choice between two goods, X and Y. If the price of X is $2...

ECON: MICRO4 (New, Engaging Titles from 4LTR Press)

Explain how relation-ship marketing can move customers up the loyalty ladder.

Contemporary Marketing

Jamal has a utility function U = W1/2, where W is his wealth in millions of dollars and U is the utility he obt...

Principles of Macroeconomics (MindTap Course List)

If the price of pasta increases and a consumer buys more pasta, we can infer that a. pasta is a normal good and...

Principles of Economics (MindTap Course List)

DuPONT ANALYSIS Hendersons Hardware has an ROA of 11%, a 6% profit margin, and an ROE of 23%. What is its total...

Fundamentals of Financial Management (MindTap Course List)

In what sense is economics like a science? Draw a production possibilities frontier for a society that produce...

Principles of Microeconomics (MindTap Course List)

Of the various steps in Barcelonaâ€™s employee selection process, the job interview is the briefest. Do you agree...

Management, Loose-Leaf Version

How does the SBA help small-business owners who want to enter the world markets?

Foundations of Business (MindTap Course List)

A seven-year medical research study reported that women whose mothers took the drug DES during pregnancy were t...

STATISTICS F/BUSINESS+ECONOMICS-TEXT

Neptune Company issued a note receivable to Sailfish Company. (a) Who is the payee? (b) What is the title of th...

Financial Accounting

Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, an...

Financial & Managerial Accounting

Use the information presented in Problem C-1 to solve this problem. Required Find the cost of the ending invent...

College Accounting (Book Only): A Career Approach

Ratio of sales to assets The Home Depot reported the following data (in millions) in its recent financial state...

Accounting (Text Only)

On March 11, Rainz Company received a 90-day, 6 percent note for 1,500, dated March 11, from J. Rose, a charge ...

College Accounting (Book Only): A Career Approach

Describe the accounting procedures when using the direct write-off method to account for uncollectible accounts...

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

In the following first list are eight examples of the items described in the second list. Match the two lists b...

Pkg Acc Infor Systems MS VISIO CD

J.D. Power and Associates conducts vehicle quality surveys to provide automobile manufacturers with consumer sa...

Statistics for Business & Economics, Revised (MindTap Course List)

21ST CENTURY EDUCATION PRODUCTS OTHER TOPICS IN CAPITAL BUDGETING 21st Century Educational Products (21st Centu...

Fundamentals of Financial Management (MindTap Course List)

NPV Project K costs 52,125, its expected cash inflows arc 12,000 per year for 8 years, and its WACC is 12%. Wha...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

Using the graph below, answer the following questions. a. What is the shift from D1 to D2 called? b. What is th...

Exploring Economics

How would the following transactions affect U.S. exports, imports, and net exports? a. An American art professo...

Principles of Macroeconomics (MindTap Course List)

Justin Holmes, an ex-employee, is entitled to a taxable fringe benefit during the first part of this year. Beca...

PAYROLL ACCT.,2019 ED.(LL)-TEXT

Writing off accounts receivable Quantum Technologies, a computer consulting firm, has decided to write off the ...

Survey of Accounting (Accounting I)

Periodic inventory by three methods Dymac Appliances uses the periodic inventory system. Details regarding the ...

Corporate Financial Accounting

In general, do you believe the demands and responsibilities placed on project managers are making them more val...

Purchasing and Supply Chain Management

Give an arithmetic example to illustrate the difference between the marginal and average tax rates.

Macroeconomics

Mathematically, the value of the tax multiplier in terms of the marginal propensity to consume (MPC) is given b...

Economics For Today

Mangia Pizza Company makes frozen pizzas that are sold through grocery stores. Mangia developed the following s...

Cornerstones of Cost Management (Cornerstones Series)

What is it that the entrepreneur does?

Microeconomics

In the accompanying figure, PW is the world price and PW + T is the world price plus a tariff. Identify the fol...

Economics (MindTap Course List)

Ewing Natural Gas is a large energy company with headquarters in Dallas, Texas. The company offers a wide varie...

Practical Management Science

ProblemB Preparing a Bond Amortization Table (Straight Line) On January 1, 2020, Peacock Products borrowed $447...

Cornerstones of Financial Accounting

Several items are omitted from the income statement and cost of goods manufactured statement data for two diffe...

Managerial Accounting

*â€śUnlike a marketplace in which pollution is profitable, government control of resources and pollution can take...

Microeconomics: Private and Public Choice (MindTap Course List)

Netflix has successfully adapted to a number of challenges in its industry. What do you see as some emerging op...

Understanding Management (MindTap Course List)

Which of the following is the best definition of economics? a. Economics is the study of how to manage corporat...

MACROECONOMICS FOR TODAY

What determines whether a financial asset is included in the M1 money supply? Why are interest-earning checkabl...

Economics: Private and Public Choice (MindTap Course List)

An industry currently has 100 firms, each of which has fixed cost of 16 and average variable cost as follows: Q...

Principles of Microeconomics

Which of the following is true for the monopolist? a. Marginal revenue is less than the price charged. b. Econo...

Micro Economics For Today

What is the shortsightedness effect? How does it influence the attractiveness of government borrowing? Explain.

Macroeconomics: Private and Public Choice (MindTap Course List)