Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 6, Problem 42P
Refer to the original data in the preceding problem for Martha’s Vineyard Marine Supply. Required:
- 1. Build a spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the variable- and fixed-cost components in the company’s material-handling department costs.
- 2. Write the least-squares regression equation for the department’s costs.
- 3. Predict the firm’s material-handling department’s costs for a month when 2,300 units of activity are recorded.
- 4. Why do the three cost predictions computed in this and the preceding problem differ? Which method do you recommend? Why?
- 5. Build a spreadsheet: Use your Excel spreadsheet from requirement (1) to compute the R2 value for the regression. Interpret the R2 value.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Refer to the data given below.Required:1. Draw a scatter diagram and graph the company’s energy cost behavior using the visual-fit method.2. Predict the energy cost for a month in which 26,000 pints of applesauce are produced.3. What peculiarity is apparent from the scatter diagram? What should the cost analyst do?
Convert the accompanying database to an Excel table to find:
a.The total cost of all orders.
b. The total quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Convert the accompanying database to an excel table to find:
a. The total cost of all orders
b. The total quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Chapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 6 - Describe the importance of cost behavior patterns...Ch. 6 - Define the following terms, and explain the...Ch. 6 - Suggest an appropriate activity base (or cost...Ch. 6 - Draw a simple graph of each of the following types...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Explain why a manufacturers cost of supervising...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Prob. 8RQCh. 6 - Indicate which of the following descriptions is...Ch. 6 - Prob. 10RQ
Ch. 6 - What is meant by a learning curve? Explain its...Ch. 6 - Suggest an appropriate independent variable to use...Ch. 6 - What is an outlier? List some possible causes of...Ch. 6 - Explain the cost estimation problem caused by...Ch. 6 - Describe the visual-fit method of cost estimation....Ch. 6 - What is the chief drawback of the high-low method...Ch. 6 - Explain the meaning of the term least squares in...Ch. 6 - Prob. 18RQCh. 6 - Prob. 19RQCh. 6 - List several possible cost drivers that could be...Ch. 6 - Prob. 21RQCh. 6 - Prob. 22ECh. 6 - The behavior of the annual maintenance and repair...Ch. 6 - WMEJ is an independent television station run by a...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - The Iowa City Veterinary Laboratory performs a...Ch. 6 - Chillicothe Meat Company produces one of the best...Ch. 6 - Rio Bus Tours has incurred the following bus...Ch. 6 - Prob. 31ECh. 6 - Prob. 32ECh. 6 - Prob. 33ECh. 6 - Gator Beach Marts, a chain of convenience grocery...Ch. 6 - For each of the cost items described below, choose...Ch. 6 - The following selected data were taken from the...Ch. 6 - Antioch Extraction, which mines ore in Montana,...Ch. 6 - Nations Capital Fitness, Inc. operates a chain of...Ch. 6 - The Allegheny School of Music has hired you as a...Ch. 6 - Prob. 40PCh. 6 - (Note: Instructors who wish to cover all three...Ch. 6 - Refer to the original data in the preceding...Ch. 6 - Shortly after being hired as an analyst with...Ch. 6 - The controller of Chittenango Chain Company...Ch. 6 - Dana Rand owns a catering company that prepares...Ch. 6 - Prob. 48PCh. 6 - Earth and Artistry, Inc. provides commercial...Ch. 6 - Prob. 51CCh. 6 - Refer to the data and accompanying information in...
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
- UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. c. Calculate for the total manufacturing cost per unit? d. How much is the total cost for Started and Completed?arrow_forwardConvert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.arrow_forwardNeed some help making a cheet sheet for an up coming test. please provide examples. The exam covers chapters 1 through 13. Here are some suggested study topics: Cost Classifications - variable, fixed and mixed, period and product, direct and indirect, opportunity, sunk, relevant, traceable, common, etc. Calculate the results of changes to cost assumptions (CVP) Calculate net income based on contribution margin values either dollars or % Application of Manufacturing Overhead - calculate predetermined overhead rate or activity rates applied to a product or job - job order using a predetermined overhead rate or rates and activity-based costing calculate over and underapplied overhead calculate adjusted cost of goods sold Job Costing What is the total cost of the job and average cost per unit. Cost of Goods Manufactured and cost of goods sold Calculate break even and target profit Create a contribution format income statement Gross margin calculations - absorption or variable costing…arrow_forward
- Build a spreadsheet: Construct and excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.arrow_forwardUPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. a. Calculate the total units to be accounted for. = b. Calculate the Equivalent Units of Production - Materials. = c. How much is the conversion cost per unit? =arrow_forwardCarolina Yachts builds custom yachts in its production factory in South Carolina. Once complete, these yachts must be shipped to the dealership. They have collected this shipping cost data: Prepare a scatter graph of the shipping data. Plot cost on the vertical axis and yachts shipped on the horizontal axis. Is the relationship between shipping costs and unit shipped approximately linear? Draw a straight line through the scatter graph. Using the high-low method, create the cost formula for Carolina Yachts shipping costs. The least-squares regression method was used and the analysis resulted in this cost equation: Y= 4,000+ 1,275x. Comment on the accuracy of your high-low method estimation. What would you estimate shipping costs to be if Carolina Yachts shipped 10 yachts in a single month? Use the cost formula you obtained in part B. Comment on how accurately this is reflected by the scatter graph you constructed. What factors other than number of yachts shipped do you think could affect Carolina Yachts shipping expense? Explain.arrow_forward
- UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. a. Calculate the Equivalent Units of Production - Conversion Cost. = b. Calculate for the total material cost per unit =arrow_forwardClassifying Costs as Product or Period Costs Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. 1. Depreciation on salespersons’ cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors’ salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9.…arrow_forwardneed answers for 1,2,3 and 4 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.arrow_forward
- What I Know Before we begin this lesson, let us check first your prior knowledge on this module. After taking and checking this short test, take note of the items that you are not able to answer correctly and look for the right answer as you go through this module. Direction: Encircle the letter of the correct answer. 1. What type of cost includes product ingredients and materials? а. fixed b. revenue с. total d. variable 2. What type of cost includes the rental of space? а. fixed b. revenue c. total d. variable 3. What type of cost is the product of the price and the quantity sold? а. fixed b. revenue с. total d. variable 4. What concept is being described when the business will neither earn a profit nor suffer a loss? а. break-even b. loss с. profit d. summit 5. What type of analysis shows equal revenue and total cost? а. break-even b. cost of variable c. profit-loss d. volume of salesarrow_forwardAs a start-up / ‘new’ manufacturer, one of your tasks as the Operations Manager is to identify the behaviour of manufacturing costs to develop a production cost budget. You know three methods can be used to identify cost behaviour from past data, but past data are not available because this is a start-up. Identify and compare the three known methods of measuring cost behaviour.arrow_forwardThe graphs below represent cost behavior patterns that might occur in acompany's cost structure. The vertical axis represents total cost, and thehorizontal axis represents activity output. Required:For each of the following situations, choose the graph from the group a-1 that best illustrates the cost pattern involved. Also, for each situation,identify the driver that measures activity output. 1. The cost of power when a fixed fee of $500 per month is chargedplus an additional charge of $0.12 per kilowatt-hour used2. Commissions paid to sales representatives. Commissions arepaid at the rate of 5 percent of sales made up to total annual salesof $500,000, and 7 percent of sales above $500,000.3. A part purchased from an outside supplier costs $12 per part for the first 3,000 parts and $10 per part for all parts purchased inexcess of 3,000 units.4. The cost of surgical gloves, which are purchased in incrementsof 100 units (gloves come in boxes of 100 pairs).5. The cost of tuition at a…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY