Problem NO: 1

Cost function using high-low and regression; quality of cost estimates Following are sales and administrative cost data for Big Jack Burgers for four

Cost function using high-low and regression; quality of cost estimates

Following are sales and administrative cost data for Big Jack Burgers for four months:

 Administrative cost is a mixed cost, and sales is a potential cost driver.

 

Required

(a)          Using the high-low method, create a cost function for administrative costs.

(b)          In your own words, explain why the high-low method might not be a good method for estimating the cost function.

(c)           Create a scatter plot and add a trend line. After examining the plot, use your judgement to determine whether the cost is fixed, variable, or mixed.

(d)          Perform regression analysis to create a cost function for administrative costs.

(e)           Can we know for certain that the cost function from part (d) provides a good estimate for next month’s administrative costs? Why or why not?

(f)           Discuss whether sales are an economically plausible driver for administration costs for Big Jack Burgers.(a)     Total revenue (TR) instead of quantity (Q) in the cost function because sales is a potential cost driver. Under the high-low method, the cost function is calculated using the highest and lowest values of the cost driver. First, the variable cost is calculated:

($68 333 – $43 333)/($1 132 100 – $632 100)

= $25 000/$500 000

= 0.05  or 5% of sales

 

The fixed cost is determined by substituting the variable cost into one of the high-low data points:

$68 333 = F + 5%×$1 132 100

F = $68 333 – $56 605 = $11 728

 

Thus, the total cost function is:

TC = $11 728 + 5%×Sales

 

(b)        The high-low method uses the most extreme cost driver values, which could

be outliers, that is, not represent the cost most of the time. That means that the cost function might not represent the actual cost, on average. Therefore, this cost function might provide poor estimates of future costs.

(c)     Chart of data with trend line added by Excel; trend line extended to Y-axis (dashed line) using Word:

It appears that the cost is most likely mixed. There is a general downward slope     (variable cost) that appears to meet the intercept enough above zero to suggest a    fixed cost. The upward slope of the line indicates that there are variable costs.

 

(d)     Following is the regression output. A t-statistic greater than 2 is often interpreted as meaning that the coefficient is significantly different from zero. Notice that the t-statistic for the intercept coefficient is 2.172, but the p-value is greater than 10% at 0.162. Based on the p-value, there is a 16% probability that the intercept (fixed cost) is not different from zero. Because this regression has few observations, the p-value result for the t-statistic is atypical. Additional judgement is required to decide whether it is appropriate to include a fixed cost in the cost function.

 

          Analysis at the account level can be used to increase the understanding of this cost. If this cost pool includes items such as salaries and other fixed costs (insurance, etc.), the regression intercept can be used as an estimate of the fixed costs. Then, the cost function would be TC = $16 800 + 4.5% × sales. Alternatively, analysis at the account level might indicate that there are few fixed costs. In that case, fixed costs are likely to be zero and would be excluded from the cost function. Then, the cost function would be: TC = 4.5% × sales

 

(e)     Because of unforeseen changes in cost behaviour, a cost function may not provide a good estimate for the next month’s costs. The past costs used for estimation might not be representative, especially because so few observations were used in the estimation. Sales might not be the activity that drives administrative costs. There might be a change in business operations or in the economy that would cause future costs to be different than in the past. There might be a large discretionary component in administrative costs, causing fluctuations in cost that are unrelated to any cost driver.

                   

(f)      The cons of the high-low method as an estimation technique were discussed in Part B above. If there are only two or three data points, however, the high-low method may be the best option available. This method can be used in cases where there is not enough data to perform regression, and it can be further improved by adopting more representative data points than the highest and lowest values of the cost driver. If there are more data points, regression analysis incorporates all of the observations into the analysis. Therefore, the results rely on more complete information and provide a better estimate, on average. Both methods assume that the cost function is linear and that all data points come from a single relevant range. If these assumptions do not hold, then both methods may be unsuitable for estimating future costs. In addition, both of these methods assume that the data points are representative of future costs. Unusual cost items are assumed to continue in the future, and possible changes in costs such as those described in Part E are ignored.

 

 

0  reviews

Suggestions based on the Question and Answer that you are currently viewing

          Classification of rework costs, uncertainties, critique of rework and scrap policy Fran Markus is in the cost accounting group at Boats Gal

Classification of rework costs, uncertainties, critique of rework and scrap policy Fran Markus is in the cost accounting group at Boats Galore, a large manufacturing company that produces customised boats and yachts. The company sometimes experiences quality problems with its fibreglass raw material, causing flawed areas in boat hulls. The problem is often fixed by reworking the flawed areas. Other times the hull is scrapped because it is too flawed, and a new hull is fabricated. The spoilage policy at Boats Galore is to charge the cost of rework and spoilage to overhead unless it arises because a hull design is particularly complicated. In those cases, the cost is assigned to the job.   Two boats currently under construction require triple the amount of materials and labour time to enhance boat security. The customer wants each hull to be able to withstand the explosion of a small bomb. It is the company’s first order with this hull construction. Because of the new design and fibreglass process, the customer has agreed to a cost-plus contract and will pay cost plus a fixed percentage of cost. This contract assures that Boats Galore does not incur a loss from developing the enhanced security hull. This week, the third layer on one of the boat hulls had a flaw in the fibreglass. The area was reworked, after which it met the security requirements.   Fran receives weekly data on labour and materials for each boat under construction. For regular production, workers estimate the time and materials used to rework flawed fibreglass areas, and Fran adds those costs to overhead instead of recording them as a cost of the particular job. Now she needs to decide how to record the cost of rework for the enhanced security hulls. The production people are not sure whether the flaw was due to poor quality fibreglass or to the triple hull design. If Fran adds the cost to the job order, the customer will pay for the labour and supplies as part of the cost-plus price. If she adds the cost to overhead, the cost will be spread across all jobs and only part of it will be allocated to the job having the enhanced security hulls.   Required (a)     Critique the company’s accounting policy for rework and scrap. (b)     Describe uncertainties about the accounting treatment for the rework costs on the enhanced security hull job. (c)      Discuss the pros and cons of alternative accounting treatments for the rework costs on this job. (d)     Suppose you are an accounting work-experience student at Boats Galore. Fran asks you to recommend an accounting treatment for the rework costs on the enhanced security hull job. i) Write a memo to Fran with your recommendation. As you write the memo,          consider what information Fran will need from you to help her make a final            decision. ii) Write one or two paragraphs explaining how you decided what information to   include in your memo.

(0)
          Effects of robotic equipment on overhead rates 'Our costs are out of control, our accounting system is screwed up, or both!' screamed the s

Effects of robotic equipment on overhead rates 'Our costs are out of control, our accounting system is screwed up, or both!' screamed the sales manager. 'We are simply non-competitive on a great many of the jobs we bid on. Just last week we lost a customer when a competitor underbid us by 25 per cent! And I bid the job at cost because the customer has been with us for years but has been complaining about our prices.'                                 This problem, raised at the weekly management meeting, has been getting worse over the years. The Johnson Tool Company produces parts for specific customer orders. When the entity first became successful, it employed nearly 500 skilled machinists. Over the years the entity has become increasingly automated and now uses a number of different robotic machines. It currently employs only 75 production workers but output has quadrupled.   The problems raised by the sales manager can be seen in the portions of two bid sheets brought to the meeting (as reproduced). The bids are from the cutting department, but the relative size of these three types of manufacturing costs is similar for other departments.   The cutting department charges overhead to products based on direct labour hours. For the current period, the department expects to use 4000 direct labour hours. Departmental overhead, consisting mostly of depreciation on the robotic equipment, is expected to be $1 480 000.   An employee can typically set up any job on the appropriate equipment in about 15 minutes. Once machines are operating, an employee oversees five to eight machines simultaneously. All that is required is to load or unload materials and monitor calibrations. The department’s robotic machines will log a total of 25 000 hours of run time in the current period.   For bid 74683 the entity was substantially underbid by a competitor. The entity did get the job for bid 74687, but the larger jobs are harder to find. Small jobs arise frequently, but the entity is rarely successful in obtaining them.             Required (a)     Critique the cost allocation method used within the current cost accounting system. (b)     Suggest a better approach for allocating overhead. Allocate costs using your approach and compare the costs of both jobs under the two systems. (c)      Discuss the pros and cons of using job costs to determine the price for a job order.

(0)
Accounting for scrap You are helping a friend, Jonah, set up a new accounting system for a small start-up construction company. He specialises in cus

Accounting for scrap You are helping a friend, Jonah, set up a new accounting system for a small start-up construction company. He specialises in custom, energy efficient homes that are built on a cost-plus basis. Cost-plus means that his customers pay a fixed percentage above the sum of direct and overhead costs.   As he goes through the accounts, Jonah asks why you set up a separate account for scrap. He does not believe that scrap should be recorded anywhere in his accounting system because it is worth little, and theft is no problem. He makes weekly trips to a recycling plant where he receives a small sum for the scrap. Most of the time Jonah is working on only one house and the scrap is only for that house. However, once in a while he is working on several houses, and the scrap for all of the houses is recycled at once.   Required (a)     Explain the two ways that scrap can be recorded in a job costing system. (b)     Choose the appropriate method for Jonah and explain your choice. (c)      Suppose you are a prospective homeowner. Explain to Jonah why you believe the revenue from scrap associated with your home should be recorded as a reduction in your costs rather than his overall costs. (d)     Write a brief (and diplomatic) paragraph to convince Jonah that he needs to account for the revenues from scrap.

(0)

The benefits of buying with AnswerDone:

Guaranteed quality through customer reviews

Access to High-Quality Documents

Our platform features a wide range of meticulously curated documents, from solved assignments and research papers to detailed study guides. Each document is reviewed to ensure it meets our high standards, giving you access to reliable and high-quality resources.

Quick and easy check-out

Easy and Secure Transactions

We prioritize your security. Our platform uses advanced encryption technology to protect your personal and financial information. Buying with AnswerDone means you can make transactions with confidence, knowing that your data is secure

Focus on what matters

Instant Access

Once you make a purchase, you’ll have immediate access to your documents. No waiting periods or delays—just instant delivery of the resources you need to succeed.

$1.49  0x  sold
    (0)
  Add to cart