Business

AccountingManagerial Accounting: The Cornerstone of Business Decision-Making( Appendix 3A) Separating Fixed and Variable Costs, Service Setting Louise McDermott, controller for the Galvin plant of Veromar Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800 in increments of 100) and the total cost of moving materials at those levels of moves: Required: 1. Prepare a scattergraph based on these data. Use cost for the vertical axis and number of moves for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the total cost of moving materials and the number of moves? 2. Compute the cost formula for moving materials by using the high-low method. Calculate the predicted cost for a month with 550 moves by using the high-low formula. ( Note: Round the answer for the variable rate to three decimal places and the answer for total fixed cost and total cost to the nearest dollar.) 3. CONCEPTUAL CONNECTION Compute the cost formula for moving materials using the method of least squares. ( Note: For the method of least squares, round the variable rate to two decimal places and total fixed cost and total cost to the nearest dollar.) Using the regression cost formula, what is the predicted cost for a month with 550 moves? What does the coefficient of determination tell you about the cost formula computed by regression? 4. CONCEPTUAL CONNECTION Evaluate the cost formula using the least squares coefficients. Could it be improved? Try dropping the third data point (300, $3,400), and rerun the regression.BuyFind*arrow_forward*

7th Edition

Maryanne M. Mowen + 2 others

Publisher: Cengage Learning

ISBN: 9781337115773

Chapter 3, Problem 69P

Textbook Problem

323 views

(*Appendix 3A)* Separating Fixed and Variable Costs, Service Setting

Louise McDermott, controller for the Galvin plant of Veromar Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800 in increments of 100) and the total cost of moving materials at those levels of moves:

Required:

- 1. Prepare a scattergraph based on these data. Use cost for the vertical axis and number of moves for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the total cost of moving materials and the number of moves?
- 2. Compute the cost formula for moving materials by using the high-low method. Calculate the predicted cost for a month with 550 moves by using the high-low formula. (
*Note:*Round the answer for the variable rate to three decimal places and the answer for total fixed cost and total cost to the nearest dollar.) - 3. CONCEPTUAL CONNECTION Compute the cost formula for moving materials using the method of least squares. (
*Note:*For the method of least squares, round the variable rate to two decimal places and total fixed cost and total cost to the nearest dollar.) Using the regression cost formula, what is the predicted cost for a month with 550 moves? What does the coefficient of determination tell you about the cost formula computed by regression? - 4. CONCEPTUAL CONNECTION Evaluate the cost formula using the least squares coefficients. Could it be improved? Try dropping the third data point (300, $3,400), and rerun the regression.

Expert Solution

**1.**

To determine

Construct the scatter graph by plotting the number of moves and total cost. Also, identify the relationship between the number of moves and total cost.

**Scatter Graph Method:**

In a scatter graph method, data points are plotted on the graph to visualize the relationship between total cost and output measure.

Expert Solution

**2.**

To determine

Construct the cost formula for moving materials with the help of high-low cost method.

Expert Solution

**3.**

To determine

Construct the cost formula for moving materials with the help of lease square method and determine the values of fixed cost and variable rate with the help of excel.

Expert Solution

**4.**

To determine

Construct the cost formula with the help of least square coefficients.

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 ECONOMIC ORDER QUANTITY Generators R Us (GRU) is a leading manufacturer of partible electric generators used fo...

Accounting Information Systems

How does the balance sheet at the end of an accounting period relate to the other four financial statements?

Intermediate Accounting: Reporting And Analysis

Alert Security Services Co. offers security services to business clients. Complete the following end-of-period ...

Financial Accounting

Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year...

Financial And Managerial Accounting

An increase in accounts receivable is deducted from net income to compute cash from operating activities.

College Accounting, Chapters 1-27

Assume that Brooke Miles, accounts payable clerk for West Coast Design Inc., stole 48,350 by paying fictitious ...

Corporate Financial Accounting

Pacific Gas and Electric: Earnings per share Pacific Gas and Electric Company is a large gas and electric utili...

Financial & Managerial Accounting

The residents of Vegopia spend all of their income on cauliflower, broccoli, and carrots. In 2016, they spend a...

Principles of Macroeconomics (MindTap Course List)

You win 100 in a basketball pool. You have a choice between spending the money now and putting it away for a ye...

Principles of Microeconomics (MindTap Course List)

UNLEVERED BETA Hartman Motors has 18 million in assets, which were financed with 6 million of debt and 12 milli...

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

For each of the following items, circle either (a) or (b). In some cases, both (a) and (b) may apply to you. Yo...

Management, Loose-Leaf Version

Compare and contrast the major styles of leadership.

Foundations of Business (MindTap Course List)

Describe an important trade-off you recently faced. Give an example of some action that has both a monetary an...

Essentials of Economics (MindTap Course List)

CAPITAL BUDGETING CRITERIA A company has an 11% WACC and is considering two mutually exclusive investments (tha...

Fundamentals of Financial Management (MindTap Course List)

Communication Technology E-Malt Social Media: Your instructor wants to know more about you, your motivation for...

Essentials of Business Communication (MindTap Course List)

(Barriers to Entry) Identify the other two barriers to entry and explain how they block new firms from this mar...

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

Give examples, other than those used in this chapter, of situations in which each of the three implementation a...

Accounting Information Systems

The theory of purchasing-power parity says that higher inflation in a nation causes the nations currency to ___...

Brief Principles of Macroeconomics (MindTap Course List)

Analyze the components of the consumer decision-making process

MKTG 12:STUDENT ED.-TEXT

Sofia pays Sam 50 to mow her lawn every week. When the government levies a mowing tax of 10 on Sam, he raises h...

Principles of Economics (MindTap Course List)

Every year, the U.S. Coast Guard collects data and compiles statistics on reported recreational boating acciden...

STATISTICS F/BUSINESS+ECONOMICS-TEXT

Summarize how marketing creates value through the four types of utility.

Contemporary Marketing

News Corporation is one of the worlds largest entertainment companies that includes Twentieth Century Fox films...

Financial Accounting

Which of the following is not a deduction from total earnings? a. Federal income tax b. Union dues c. 2.5 hours...

College Accounting (Book Only): A Career Approach

Direct labor budget for a service business Ambassador Suites Inc. operates a downtown hotel property that has 3...

Financial & Managerial Accounting

BONDS ISSUED AT A PREMIUM, REDEEMED AT A LOSS Blackwell Company issued the following bonds at a premium: REQUIR...

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

Current position analysis The following data were taken from the balance sheet of Gostkowski Company at the end...

Accounting (Text Only)

What would be the net income for Floress Catering? a. 45,500 b. 16,800 c. 19,800 d. 10,800

College Accounting (Book Only): A Career Approach

Your bank account pays an interest rate of 8 percent. You are considering buying a share of stock in XYZ Corpor...

Principles of Macroeconomics (MindTap Course List)

The Commerce Department reported receiving the following applications for the Malcolm Baldrige National Quality...

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

Define the cash conversion cycle (CCC) and explain why, holding other things constant, a firm's profitability w...

Fundamentals of Financial Management (MindTap Course List)

Consider a business that you patronize. Could it operate without automated information systems? Why or why not?

Pkg Acc Infor Systems MS VISIO CD

As womens wages and employment opportunities have expanded over the past 50 years, Americans have purchased mor...

Exploring Economics

FREE CASH FLOW Bailey Corporation's financial statements (dollars and shares are in millions) are provided here...

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

Asset turnover Three major segments of the transportation industry are motor carriers, such as YRC Worldwide; r...

Corporate Financial Accounting

Estimate uncollectible accounts For several years. EquiPrime Co.â€™s sales have been on a â€ścash onlyâ€ť basis. On J...

Survey of Accounting (Accounting I)

What is the purpose of the Age Discrimination in Employment Act (ADEA)?

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

Many individuals learn more about the car they are thinking of buying than about the candidates running for pre...

Macroeconomics

What is the possible role of purchasing in leading sustainability efforts?

Purchasing and Supply Chain Management

Explain how lean manufacturing is able to produce small batches (low-volume products) of differing products (hi...

Cornerstones of Cost Management (Cornerstones Series)

Many individuals learn more about the car they are thinking of buying than about the candidates running for pre...

Microeconomics

Assume that the number of units sold of a product is given by 100 0.5P + 26A, where P is the price (in dollars...

Practical Management Science

What percentage of the U.S. population was living in poverty in 2015?

Economics (MindTap Course List)

Key Concept: Impact of relative price level changes If the Japanese price level falls relative to the price lev...

Economics For Today

Payroll Taxes Hernandez Builders has a gross payroll for January amounting to $500,000. The following amount ha...

Cornerstones of Financial Accounting

Many fast-food restaurant chains, such as MC McDonalds (MCD), will occasionally discontinue restaurants in thei...

Managerial Accounting

In response to security threats in todayâ€™s world, the U.S. government has federalized airport security workers....

Understanding Management (MindTap Course List)

Im for international trade, but not when it takes jobs from Americans. If the American worker can produce the p...

Macroeconomics: Private and Public Choice (MindTap Course List)

Which of the following best describes the three fundamental economic questions? a. What to produce, when to pro...

Micro Economics For Today

*â€śUnions provide the only protection available to working men and women. Without unions, employers would be abl...

Economics: Private and Public Choice (MindTap Course List)

Suppose Americans decide to save more of their in-comes. If banks lend this extra saving to businesses, which u...

Principles of Microeconomics

The future of our industrial strength cannot be left to chance. Somebody has to develop notions about which ind...

Microeconomics: Private and Public Choice (MindTap Course List)