/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 35 Wayne Mueller, financial analyst... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Wayne Mueller, financial analyst at CELL Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters: $$\begin{array}{ccc} \text { Quarter } & \text { Machine-Hours } & \text { Utility costs } \\ \hline 1 & 120,000 & \$ 215,000 \\ 2 & 75,000 & 150,000 \\ 3 & 110,000 & 200,000 \\ 4 & 150,000 & 270,000 \\ 5 & 90,000 & 170,000 \\ 6 & 140,000 & 250,000 \\ 7 & 130,000 & 225,000 \\ 8 & 100,000 & 195,000 \end{array}$$ 1\. Estimate the cost function for the quarterly data using the high-low method. 2\. Plot and comment on the estimated cost function. 3\. Mueller anticipates that CELL will operate machines for 125,000 hours in quarter \(9 .\) Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1.

Short Answer

Expert verified
The estimated cost function using the high-low method is \(C(x) = \$30{,}000 + \$1.6x\), where C(x) represents the utility costs, and x represents the number of machine-hours worked. For quarter 9, with 125,000 machine-hours, the predicted utility cost is \$230,000.

Step by step solution

01

Find the variable cost per machine-hour

To estimate the cost function using the high-low method, we first need to calculate the variable cost per machine-hour. This can be done by selecting the highest and lowest levels of activity and calculating the difference in utility costs divided by the difference in machine-hours. For this data set, the highest level of activity occurred in quarter 4 with 150,000 machine-hours and utility costs of \(270,000. The lowest level of activity occurred in quarter 2 with 75,000 machine-hours and utility costs of \)150,000. Calculate the variable cost per machine-hour: Variable cost per machine-hour = (Cost at high activity level - Cost at low activity level) / (Machine-hours at high activity level - Machine-hours at low activity level) Variable cost per machine-hour = \(\frac{(\$270{,}000 - \$150{,}000)}{(150{,}000 - 75{,}000)}\) Variable cost per machine-hour = \(\frac{\$120{,}000}{75{,}000}\) Variable cost per machine-hour = \$1.6
02

Find the fixed cost

Now that we have found the variable cost per machine-hour, we can calculate the fixed cost. To do this, we can use the data from either the high activity level or the low activity level. Fixed cost = Total cost - (Variable cost per machine-hour × Machine-hours) Using the high activity level data (quarter 4): Fixed cost = \$270,000 - (\$1.6 × 150,000) Fixed cost = \$270,000 - \$240,000 Fixed cost = \$30,000
03

Write the estimated cost function

Now with the variable cost per machine-hour and fixed cost, we can write the estimated cost function. Cost function: \(C(x) = \$30{,}000 + \$1.6x\) Here, C(x) represents the utility costs, and x represents the number of machine-hours worked.
04

Predict utility costs for quarter 9

We are given that CELL will operate machines for 125,000 hours in quarter 9. We can now use the cost function estimated in Step 3 to predict the utility costs for quarter 9. Predicted utility costs in quarter 9 = \(C(125{,}000) = \$30{,}000 + \$1.6 × 125,000\) Predicted utility costs in quarter 9 = \$30,000 + $200,000 Predicted utility costs in quarter 9 = \$230,000 To complete this exercise, you can create a plot of the cost function and comment on its behavior. However, please note that creating the plot and commenting on its behavior is out of scope for this platform.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Understanding the High-Low Method
The high-low method is a form of cost estimation used in accounting to separate fixed and variable costs associated with a process or production. This technique can be particularly useful when a company does not have detailed information for a full-scale cost analysis. Let's explore how it works using a simple approach.

To apply the high-low method, you usually need data on total costs at various levels of activity. In the provided exercise, machine-hours represent the activity, and utility costs signify the total costs. By identifying the periods with the highest and lowest levels of activity, you can determine the variable cost per unit.

After calculating the variable cost, you subtract it from the total cost at either the high or low point to find the fixed cost. Remember that fixed costs remain constant, regardless of activity levels. As such, this method assumes that the relationship between cost and activity is linear, which may not always reflect real-world complexities. Nevertheless, for estimated budgeting purposes like in Mueller's case, the high-low method offers a straightforward and practical solution.
Calculating Variable Costs
Variable costs are expenses that change in proportion to the activity of a business. In the context of the high-low method, determining the variable cost per unit of activity is a critical step. As showcased in the exercise, calculating the variable cost involves finding the difference in total costs associated with the highest and lowest activity levels.

To ensure accuracy, you must choose the periods with the most significant difference in activity, as these will provide the range needed for an effective estimation. In mathematical terms, the variable cost per unit is calculated using the formula:
\[\begin{equation}Variable cost = \frac{\text{Cost at high activity level} - \text{Cost at low activity level}}{\text{Machine-hours at high activity level} - \text{Machine-hours at low activity level}}\end{equation}\]
This result will then be used for predicting future costs, aligning with a company's need to forecast expenses and prepare budgets. It's important to note that variable costs form only one part of the total costs; understanding fixed costs is equally crucial.
Analyzing Fixed Costs
Fixed cost analysis is central to cost function estimation since fixed costs do not vary with the level of production or activity. Unlike variable costs, which fluctuate with output level, fixed costs remain the same regardless of output volumes within a certain range of activity. Using the high-low method, once you have your variable cost per unit, you can isolate the fixed costs.

For practical application, suppose you choose the high activity level to calculate the fixed cost. You would first determine the total variable cost at this level by multiplying the variable cost per unit by the number of units. Afterward, you subtract this from the total cost observed at the high activity level:
\[\begin{equation}Fixed cost = \text{Total cost at high activity level} - (\text{Variable cost per unit} \times \text{Number of units at high activity level})\end{equation}\]
This fixed cost, along with the variable cost per unit, forms the cost function, which can be essential in preparing budgets and making strategic business decisions. In our exercise, understanding these fixed costs helps Mueller anticipate future utility costs under various operating conditions.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

"High correlation between two variables means that one is the cause and the other is the effect." Do you agree? Explain.

The controller of the Javier Company is preparing the budget for 2018 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior two months are: $$\begin{array}{lcc}\text { Month } & \text { Miles Driven } & \text { Delivery costs } \\\\\hline \text { August } & 12,000 & \$ 10,000 \\\\\text { September } & 17,000 & \$ 13,000\end{array}$$ 1\. Estimate the cost function for delivery. 2\. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain.

Relling Corporation manufactures a drink bottle, model CL24. During 2017 , Relling produced 210,000 bottles at a total cost of \(\$ 808,500\). Kraff Corporation has offered to supply as many bottles as Relling wants at a cost of \(\$ 3.75\) per bottle. Relling anticipates needing 225,000 bottles each year for the next few years. 1\. a. What is the average cost of manufacturing a drink bottle in \(2017 ?\) How does it compare to Kraff's offer? b. Can Relling use the answer in requirement 1a to determine the cost of manufacturing 225,000 drink bottles? Explain. 2\. Relling's cost analyst uses annual data from past years to estimate the following regression equation with total manufacturing costs of the drink bottle as the dependent variable and drink bottles produced as the independent variable: $$y=\$ 445,000+\$ 1.75 x$$ During the years used to estimate the regression equation, the production of bottles varied from 200,000 to \(235,000 .\) Using this equation, estimate how much it would cost Relling to manufacture 225,000 drink bottles. How much more or less costly is it to manufacture the bottles than to acquire them from Kraff? 3\. What other information would you need to be confident that the equation in requirement 2 accurately predicts the cost of manufacturing drink bottles?

In regression analysis, the coefficient of determination: a. Is used to determine the proportion of the total variation in the dependent variable ( \(y\) ) explained by the independent variable \((X)\) b. Ranges between negative one and positive one. c. Is used to determine the expected value of the net income based on the regression line. d. Becomes smaller as the fit of the regression line improves.

Spirit Freightways is a leader in transporting agricultural products in the western provinces of Canada. Reese Brown, a financial analyst at Spirit Freightways, is studying the behavior of transportation costs for budgeting purposes. Transportation costs at Spirit are of two types: (a) operating costs (such as labor and fuel) and (b) maintenance costs (primarily overhaul of vehicles). Brown gathers monthly data on each type of cost, as well as the total freight miles traveled by Spirit vehicles in each month. The data collected are shown below (all in thousands): $$\begin{array}{lccc}\text { Month } & \text { 0perating costs } & \text { Maintenance costs } & \text { Freight Miles } \\\\\hline \text { January } & \$ 942 & \$ 974 & 1,710 \\\\\text { February } & 1,008 & 776 & 2,655 \\\\\text { March } & 1,218 & 686 & 2,705 \\\\\text { April } & 1,380 & 694 & 4,220 \\ \text { May } & 1,484 & 588 & 4,660 \\\\\text { June } & 1,548 & 422 & 4,455 \\\ \text { July } & 1,568 & 352 & 4,435 \\\\\text { August } & 1,972 & 420 & 4,990 \\ \text { September } & 1,190 & 564 & 2,990 \\\\\text { October } & 1,302 & 788 & 2,610 \\ \text { November } & 962 & 762 & 2,240 \\\\\text { December } & 772 & 1,028 & 1,490\end{array}$$ 1\. Conduct a regression using the monthly data of operating costs on freight miles. You should obtain the following result: Regression: Operating costs \(=a+(b \times\) Number of freight miles) 2\. Plot the data and regression line for the above estimation. Evaluate the regression using the criteria of economic plausibility, goodness of fit, and slope of the regression line. 3\. Brown expects Spirit to generate, on average, 3,600 freight miles each month next year. How much in operating costs should Brown budget for next year?4. Name three variables, other than freight miles, that Brown might expect to be important cost drivers for Spirit's operating costs. 5\. Brown next conducts a regression using the monthly data of maintenance costs on freight miles. Verify that she obtained the following result: Regression: Maintenance costs \(=a+(b \times\) Number of freight miles) 6\. Provide a reasoned explanation for the observed sign on the cost driver variable in the maintenance cost regression. What alternative data or alternative regression specifications would you like to use to better capture the above relationship?

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.