# Solution of Managerial Accounting Assignment

Words: 2751

Chapter 5: Cost Behavior: Analysis and Use As we shall see in later chapters, the ability to predict how costs respond to changes in activity is critical for making decisions, controlling operations, and evaluating performance. Three major classifications of costs were discussed in this chapter???variable, fixed, and mixed. Mixed costs consist of variable and fixed elements and can be expressed in equation form as Y = a + bX, where X is the activity, Y is the cost, a is the fixed cost element, and b is the variable cost per unit of activity.

Several methods can be used to estimate the fixed and variable cost components of a mixed cost using past records of cost and activity. If the relation between cost and activity appears to be linear based on a scatter graph plot, then the variable and fixed components of the mixed cost can be estimated using the quick-and-dirty method, the high-low method, or the least-squares regression method. The quick-and-dirty method is based on drawing a straight line and then using the slope and the intercept of the straight line to estimate the variable and fixed cost components of the mixed cost.

order now

The high-low method implicitly draws a straight line through the points of lowest activity and highest activity. In most situations, the least-squares regression method is preferred to both the quick-and-dirty and high-low methods. Computer software is widely available for using the least-squares regression method. These software applications provide a variety of useful statistics along with estimates of the intercept (fixed cost) and slope (variable cost per unit).

Nevertheless, even when least-squares regression is used, the data should be plotted to confirm that the relationship is really a straight line. Managers use costs organized by behavior to help make many decisions. The contribution format income statement can aid decision making because it classifies costs by cost behavior (i. e. , variable versus fixed) rather than by the functions of production, administration, and sales. In this chapter, the following learning objectives will be covered: In this chapter, the following learning objectives will be covered: | |Understand how fixed and variable costs behave and how to use them to predict costs. | |[pic] | |[pic] | |[pic] | | | |Use a scattergraph plot to diagnose cost behavior. |[pic] | |[pic] | |[pic] | | | |Analyze a mixed cost using the high-low method. |[pic] | |[pic] | |[pic] | | | |Prepare an income statement using the contribution format. |[pic] | |[pic] | |[pic] | | | |(Appendix 5A) Analyze a mixed cost using the least-squares regression method. | Key terms: Account analysis???? |A method for analyzing cost behavior in which an account is classified as either variable or fixed based on | | |the analyst’s prior knowledge of how the cost in the account behaves. | |[pic] | |[pic] | |[pic] | |Activity base???? |A measure of whatever causes the incurrence of a variable cost.

For example, the total cost of X-ray film in a| | |hospital will increase as the number of X-rays taken increases. Therefore, the number of X-rays is the | | |activity base that explains the total cost of X-ray film. |[pic] | |[pic] | |[pic] | |Committed fixed costs???? |Investments in facilities, equipment, and basic organizational structure that can’t be significantly reduced | | |even for short periods of time without making fundamental changes. |[pic] | |[pic] | |[pic] | |Contribution approach???? |An income statement format that organizes costs by their behavior.

Costs are separated into variable and fixed| | |categories rather than being separated according to organizational functions. | |[pic] | |[pic] | |[pic] | |Contribution margin???? |The amount remaining from sales revenues after all variable expenses have been deducted. |[pic] | |[pic] | |[pic] | |Cost structure???? |The relative proportion of fixed, variable, and mixed costs in an organization. |[pic] | |[pic] | |[pic] | |Dependent variable???? |A variable that responds to some causal factor; total cost is the dependent variable, as represented by the | | |letter Y, in the equation Y = a + bX. |[pic] | |[pic] | |[pic] | |Discretionary fixed costs???? |Those fixed costs that arise from annual decisions by management to spend on certain fixed cost items, such as| | |advertising and research. |[pic] | |[pic] | |[pic] | |Engineering approach???? |A detailed analysis of cost behavior based on an industrial engineer’s evaluation of the inputs that are | | |required to carry out a particular activity and of the prices of those inputs. |[pic] | |[pic] | |[pic] | |High-low method???? |A method of separating a mixed cost into its fixed and variable elements by analyzing the change in cost | | |between the high and low activity levels. |[pic] | |[pic] | |[pic] | |Independent variable???? |A variable that acts as a causal factor; activity is the independent variable, as represented by the letter X,| | |in the equation Y = a + bX. |[pic] | |[pic] | |[pic] | |Least-squares regression |A method of separating a mixed cost into its fixed and variable elements by fitting a regression line that | |method???? |minimizes the sum of the squared errors. |[pic] | |[pic] | |[pic] | |Linear cost behavior???? |Cost behavior is said to be linear whenever a straight line is a reasonable approximation for the relation | | |between cost and activity. |[pic] | |[pic] | |[pic] | |Mixed cost???? |A cost that contains both variable and fixed cost elements. |[pic] | |[pic] | |[pic] | |Multiple regression???? |An analytical method required when variations in a dependent variable are caused by more than one factor. |[pic] | |[pic] | |[pic] | |R 2???? |A measure of goodness of fit in least-squares regression analysis. It is the percentage of the variation in | | |the dependent variable that is explained by variation in the independent variable. |[pic] | |[pic] | |[pic] | |Relevant range???? |The range of activity within which assumptions about variable and fixed cost behavior are reasonably valid. |[pic] | |[pic] | |[pic] | |Step-variable cost???? |The cost of a resource that is obtainable only in large chunks and that increases and decreases only in | | |response to fairly wide changes in activity. | Review Problem 1: Cost behavior Neptune Rentals offers a boat rental service.

Consider the following costs of the company over the relevant range of 5,000 to 8,000 hours of operating time for the boats: |Hours of operating time | | |5,000 |6,000 |7,000 |8,000 | |Total costs: | | | | | |Variable costs |\$20,000 |\$ ? \$ ? |\$ ? | |Fixed costs |\$1,68,000 |\$ ? |\$ ? |\$ ? | |Total costs |\$1,88,000 |\$ ? |\$ ? |\$ ? | |Cost per hour: | | | | | |Variable cost |\$ ? |\$ ? |\$ ? |\$ ? | |Fixed cost |\$ ? |\$ ? |\$ ? \$ ? | |Total cost per hour |\$ ? |\$ ? |\$ ? |\$ ? | Required: Compute the missing amount assuring that cost behavior patterns remain same within the relevant range of 5,000 to 8,000 hours. Solution to Review Problem 1: Per Unit Variable Cost = 20,000/5,000= 4. 00 per Unit. |Hours of operating time | | |5,000hr 6,000hr |7,000hr |8,000hr | |Total Costs Variable costs |\$20,000 |\$24,000 |\$28,000 |\$32,000 | |Fixed costs |1,68,000 |1,68,000 |1,68,000 |1,68,000 | |Total costs |\$1,88,000 |\$1,92,000 |\$1,96,000 |\$2,00,000 | |Cost per hour: |\$4. 0 |\$4. 00 |\$4. 00 |\$4. 00 | |Variable cost | | | | | |Fixed cost |33. 60 |28. 00 |24. 00 |21. 00 | |Total cost per hour |\$37. 60 |\$32. 00 |\$28. 00 |\$25. 0 | Review problem 2: High Low Method The administrative of azalea hills hospitals would like a cost formula linking the costs involved in admitting patients to the number of patients admitted during a month. The admitting department’s costs and number of patients admitted during the immediately preceding eight month are given in the following table: |Month |number of patients |admitted dep.

Costs | |May |1,800 |14,700 | |June |1,900 |15,200 | |July |1,700 |13,700 | |August |1,600 |14,000 | |September |1,500 |14,300 | |October |1,300 |13,100 | |Nov |1,100 |12,800 | |Dec |1,500 |14,600 | Required: 1. Use the high low method to establish the fixed and variable components of admitting costs. 2. Express the fixed and variable components of admitting costs as a formula in the linear equation form: Y= a+bx. Solution to Review Problem 2 1. |Number of Patients Admitted |Admitting Department cost | |High activity level (June) |\$1,900 |15,200 | |Low activity level (November) |1,100 |12,800 | |Change |\$800 |\$2,400 | Variable cost per unit of activity: Variable Cost = 2,400 / 800 = 3 Fixed cost = Total cost ??? variable cost = 15,200 ??? (3*1,900) = 9,500 2. The cost formula expressed in the linear equation form is:Y= \$9,500+\$3X Problem 5-12 House of Organs, Inc purchases organs from a well-known manufacturer and sells them at the retail level. The organs sell, on the average, for \$2500 each. The average cost of an organ from the manufacturer is \$1500. House of Organs, Inc has always kept careful records of its costs. The costs that the company incurs in a typical month are presented below in the form of a spreadsheet Costs |Cost Formula | |Selling: | |Advertising |\$950 per month | |Delivery of organs |\$60 per organ sold | |Sales salaries and commissions |\$4,600 per month plus 4% interest | |Utilities |\$650 per month | |Depreciation of sales facilities |\$5,000 per month | |Administrative: | |Executive salaries |\$13,500 per month | |Depreciation of equipment |\$900 per month | |Clinical |\$2,500 per month plus \$40 per organ sold | |Insurance |\$700 per month | During November, the company sold and delivered 60 organs. Required: 1.