Problem NO: 7

Cost function using multiple regression (appendix 2A) Refer to the data and requirements of Problem 2.23.   Required (a)          Perform multiple re

Cost function using multiple regression (appendix 2A)

Refer to the data and requirements of Problem 2.23.

 

Required

(a)          Perform multiple regression using all three cost drivers. Compare the adjusted R-squares and cost functions for the multiple regression with the results of simple regressions for each potential cost driver.

(b)          Which cost drivers do the best job of explaining manufacturing overhead costs? Explain.

(c)           Select only the cost drivers that do the best job of explaining manufacturing overhead costs. Perform multiple regression analysis for those cost drivers and write the cost function.

(d)          Explain why more than one cost driver is plausible for manufacturing overhead costs.

(a)     Multiple regression with all three potential cost drivers:

 

Regression Statistics

Multiple R

0.9092294

R Square

0.8266982

Adjusted R Square

0.8067018

Standard Error

4832.5558

Observations

30

 

 

Coefficients

Standard Error

t Stat

P-value

Intercept

60988.489

10361.2349

5.886218

3.3E-06

Labour Hours

-0.1959303

3.333162437

-0.05878

0.953575

Machine Hours

48.778501

5.291558412

9.218173

1.12E-09

Raw Materials

82.976635

10.10654585

8.210187

1.08E-08

 

Comparison of simple and multiple regression results:

(b)     Labour hours does not appear to be a cost driver when using either simple regression or multiple regression; its coefficient is not significantly different from zero in either regression. Also, its coefficient is negative rather than positive in the multiple regression. Thus, labour hours can be eliminated as a potential cost driver.

 

Both machine hours and raw materials are positive and significantly different from zero when using simple regression and also when using multiple regression. The adjusted R-Square is far higher in the multiple regression (0.806) than in either of the simple regressions (0.352 and 0.226) for these two cost drivers. A combination of cost drivers does a much better job of explaining the variation in manufacturing overhead costs than either cost driver alone.

 

(c)     Multiple regression using machine hours and raw materials as cost drivers:

 

Regression Statistics

Multiple R

0.90921678

R Square

0.82667515

Adjusted R Square

0.81383627

Standard Error

4742.5348

Observations

30

 

 

Coefficients

Standard Error

t Stat

P-value

Intercept

60677.5902

8743.664851

6.939606

1.86E-07

Machine Hours

48.7422519

5.157604083

9.450561

4.71E-10

Raw Materials

82.925842

9.881964042

8.391636

5.29E-09

 

The cost function is: TC = $60 678 + $48.74×Machine hours + $82.93×Raw materials

 

(d)    Manufacturing can be a complex activity requiring a number of different tasks. Each task includes different activities. Costs for these activities are likely related to specific cost drivers. In this example, machine hours and raw materials explain different activity costs, such as machining work on units, and materials handling for the units. A better understanding of the manufacturing process improves the ability to determine the types and number of cost drivers that can be used in a more complete cost function.

 

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